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 DEBIAN

time::piece::mysql

Time::Piece::MySQL(3pm) 				User Contributed Perl Documentation				   Time::Piece::MySQL(3pm)

NAME

       Time::Piece::MySQL - Adds MySQL-specific methods to Time::Piece

SYNOPSIS

	 use Time::Piece::MySQL;

	 my $time = localtime;

	 print $time->mysql_datetime;
	 print $time->mysql_date;
	 print $time->mysql_time;

	 my $time = Time::Piece->from_mysql_datetime( $mysql_datetime );
	 my $time = Time::Piece->from_mysql_date( $mysql_date );
	 my $time = Time::Piece->from_mysql_timestamp( $mysql_timestamp );

DESCRIPTION

       Using this module instead of, or in addition to, "Time::Piece" adds a few MySQL-specific date-time methods to "Time::Piece" objects.

OBJECT METHODS

   mysql_date / mysql_time / mysql_datetime / mysql_timestamp
       Returns the date and/or time in a format suitable for use by MySQL.

CONSTRUCTORS

   from_mysql_date / from_mysql_datetime / from_mysql_timestamp
       Given a date, datetime, or timestamp value as returned from MySQL, these constructors return a new Time::Piece object.  If the value is
       NULL, they will retrun undef.

   CAVEAT
       "Time::Piece" itself only works with times in the Unix epoch, this module has the same limitation.  However, MySQL itself handles date and
       datetime columns from '1000-01-01' to '9999-12-31'.  Feeding in times outside of the Unix epoch to any of the constructors has
       unpredictable results.

       Also, MySQL doesn't validate dates (because your application should); it only checks that dates are in the right format.  So, your database
       might include dates like 2004-00-00 or 2001-02-31.  Passing invalid dates to any of the constructors is a bad idea: on my system the former
       type (with zeros) returns undef (previous version used to die) while the latter returns a date in the following month.

AUTHOR

       Original author: Dave Rolsky <autarch@urth.org>

       Current maintainer: Marty Pauley <marty+perl@kasei.com>

COPYRIGHT

       (c) 2002 Dave Rolsky

       (c) 2004 Marty Pauley

       This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

SEE ALSO

       Time::Piece

perl v5.12.4							    2008-06-07						   Time::Piece::MySQL(3pm)