Login or Register to Ask a Question and Join Our Community


MySQL DevZone RSS

Using Partitioning to Manage Satellite Networks

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Web Development MySQL DevZone RSS Using Partitioning to Manage Satellite Networks
# 1  
Old 10-17-2008
Using Partitioning to Manage Satellite Networks
Our product historically used an Oracle backend, and after implementing simple date based range partitioning we got 20-30 time performance increase in our queries. We had used MySQL in other more minor products we had developed, but we couldn't move to it until partitioning was implemented. In Dec 05 we started to test MySQL partitioning, where partitioning syntax was supported but the optimisations were not in place. As soon as the optimisations we put in, we were able to run a side by side comparison against unpartitioned tables and Oracle partitions. Not only did we get in MySQL a 30+ times performance increase, but the MySQL version ran nearly twice as fast as the same Oracle configuration in a like for like test.

More...
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Red Hat

Redhat Offline enviroment with satellite and sync host

Hello, we got a high security network which is completely offline. We want to use a Sync Host like described here in the Redhat documentation for Sattelite 6. I have the following Questions: - We need the complete Repository not only the main one how much space we need for this ? - Can... (2 Replies)
Discussion started by: izual
2 Replies

2. Red Hat

Corresponding Spacewalk/Satellite versions?

Can anyone point me towards a list that shows which Satellite versions roughly align with which Spacewalk versions, in terms of functionality? Thanks in advance, Akbar. (2 Replies)
Discussion started by: akbar
2 Replies

3. Proxy Server

RedHat Satellite server - Setting up HP Repository

Hi all, We have been using Satellite to patch our RedHat servers for a while but up until recently these have only been virtual machines. Now we have a requirement to install a few physicals and I am trying to setup a sync a custom channel for the HP reository. Our setup is that the... (2 Replies)
Discussion started by: wayned
2 Replies

4. Red Hat

Need help Partitioning

I am getting ready to install RHEL6 server. I have to create these partitions: / 10GB SWAP 3GB /opt/kent 10GB /opt/kent/logs /backup 20 GB Will Gparted do this? or whats the easiest way? or even a tutorial?I am so new to this (4 Replies)
Discussion started by: linux4noob
4 Replies

5. What is on Your Mind?

Place Bits & Win Bits!!! - 17th Annual Satellite Awards

Ten movies have been nominated as best motion picture by the International Press Academy, presentation of the 2012 Satellite Awards will be held on 16th December at Los Angeles, CA. Place your bits here on one of the below nominated movie of your choice:- Argo ... (0 Replies)
Discussion started by: Yoda
0 Replies

6. Red Hat

Can you configure Dell KACE to point to a RH Satellite?

Wild shot in the dark as both are exactly ubiquitous technologies, but here it goes: Anybody have any experience using a Dell KACE to PXE boot to a Red Hat Satellite kickstart install? I've set up the kickstart by itself before but I'm not sure there's a way to configure the KACE so that it will... (0 Replies)
Discussion started by: thmnetwork
0 Replies

7. Red Hat

RHN - Proxy, satellite etc. How do you update you servers?

Hi, I'd like to know more about RHN and their RHN PROXY. - If I will buy PROXY, do I need to get licenses for all my RHELs to have them updated? What are benefits of proxy? - If I will buy (doubt it) Satellite, will I be able to connect all my boxes to Satellite and have them upgraded... (5 Replies)
Discussion started by: columb
5 Replies

8. Ubuntu

About partitioning

Hi folks, Ubuntu 10.04-1 64-bit HD - 1T SATA3 I ran graphic installation installing Ubuntu-10.04-1 desktop from Live CD The partition on the new HD is as follow; /root /home /kvm (kvm is for keeping the guests of KVM, the virtualizer) Installion went through without problem abd... (0 Replies)
Discussion started by: satimis
0 Replies

9. SuSE

Touchpad not working - SuSE 8.2 - Toshiba Satellite A30

Hi all, I have a bit of an inexplicable problem.... Up until today, on my Toshiba Satellite A30 Laptop running SuSE 8.2 Professional, I had a dual mouse (USB Mouse / Touchpad) configuration in X and everything was running fine. I booted the laptop today, and for some reason unbeknownst to... (3 Replies)
Discussion started by: zazzybob
3 Replies
Login or Register to Ask a Question

LEARN ABOUT OSF1

networks

networks(4)						     Kernel Interfaces Manual						       networks(4)

NAME

       networks - Contains network name information

SYNOPSIS

       /etc/networks

DESCRIPTION

       The  networks file contains information about the known networks that comprise the DARPA (Defense Advanced Research Projects Agency) Inter-
       net. Each network is represented by a single line in the networks file.	The format for the entries in the networks  file  is  as  follows:
       Name Number Aliases

       The fields contain the following: The official network name.  The network number.  The unofficial names used for the network.

       Items  on  a  line are separated by one or more spaces or tab characters.  Comments begin with a # (number sign).  Routines that search the
       networks file do not interpret characters from the beginning of a comment to the end of that line.  Network numbers are specified  in  dot-
       ted-decimal notation.  A network name can contain any printable character except a field delimiter, newline character, or comment character
       (#).

       The networks file is normally created from the official network database maintained at the Network Information Center (NIC).  The file  may
       need to be modified locally to include unofficial aliases or unknown networks.

RELATED INFORMATION

       Commands: route(8)

       Functions: getnetbyaddr(3), getnetbyname(3), getnetent(3) delim off

																       networks(4)