Using Partitioning to Manage Satellite Networks


 
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
TIMED(8)						      System Manager's Manual							  TIMED(8)

NAME
timed - time server daemon SYNOPSIS
timed [ -t ] [ -M ] [ -n network ] [ -i network ] DESCRIPTION
Timed is the time server daemon and is normally invoked at boot time from the rc(8) file. It synchronizes the host's time with the time of other machines in a local area network running timed(8). These time servers will slow down the clocks of some machines and speed up the clocks of others to bring them to the average network time. The average network time is computed from measurements of clock differences using the ICMP timestamp request message. The service provided by timed is based on a master-slave scheme. When timed(8) is started on a machine, it asks the master for the net- work time and sets the host's clock to that time. After that, it accepts synchronization messages periodically sent by the master and calls adjtime(2) to perform the needed corrections on the host's clock. It also communicates with date(1) in order to set the date globally, and with timedc(8), a timed control program. If the machine running the master crashes, then the slaves will elect a new master from among slaves running with the -M flag. A timed running without the -M flag will remain a slave. The -t flag enables timed to trace the messages it receives in the file /usr/adm/timed.log. Tracing can be turned on or off by the program timedc(8). Timed normally checks for a master time server on each network to which it is connected, except as modified by the options described below. It will request synchronization service from the first master server located. If permitted by the -M flag, it will provide synchronization service on any attached networks on which no current master server was detected. Such a server propagates the time computed by the top-level master. The -n flag, followed by the name of a network which the host is connected to (see networks(5)), overrides the default choice of the network addresses made by the program. Each time the -n flag appears, that network name is added to a list of valid networks. All other networks are ignored. The -i flag, followed by the name of a network to which the host is connected (see networks(5)), overrides the default choice of the network addresses made by the program. Each time the -i flag appears, that network name is added to a list of networks to ignore. All other networks are used by the time daemon. The -n and -i flags are meaningless if used together. FILES
/usr/adm/timed.log tracing file for timed /usr/adm/timed.masterlog log file for master timed SEE ALSO
date(1), adjtime(2), gettimeofday(2), icmp(4P), timedc(8), TSP: The Time Synchronization Protocol for UNIX 4.3BSD, R. Gusella and S. Zatti 4.3 Berkeley Distribution November 17, 1996 TIMED(8)