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 LINUX

mysql_find_rows

MYSQL_FIND_ROWS 					       MySQL Database System						   MYSQL_FIND_ROWS

NAME

       mysql_find_rows - extract SQL statements from files

SYNOPSIS

       mysql_find_rows [options] [file_name ...]

DESCRIPTION

       mysql_find_rows reads files containing SQL statements and extracts statements that match a given regular expression or that contain USE
       db_name or SET statements. The utility expects statements to be terminated with semicolon (;) characters.

       Invoke mysql_find_rows like this:

	   shell> mysql_find_rows [options] [file_name ...]

       Each file_name argument should be the name of file containing SQL statements. If no file names are given, mysql_find_rows reads the
       standard input.

       Examples:

	   mysql_find_rows --regexp=problem_table --rows=20 < update.log
	   mysql_find_rows --regexp=problem_table  update-log.1 update-log.2

       mysql_find_rows supports the following options:

       o   --help, --Information

	   Display a help message and exit.

       o   --regexp=pattern

	   Display queries that match the pattern.

       o   --rows=N

	   Quit after displaying N queries.

       o   --skip-use-db

	   Do not include USE db_name statements in the output.

       o   --start_row=N

	   Start output from this row.

COPYRIGHT

       Copyright (C) 1997, 2014, Oracle and/or its affiliates. All rights reserved.

       This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
       published by the Free Software Foundation; version 2 of the License.

       This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
       MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

       You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
       Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.

SEE ALSO

       For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
       at http://dev.mysql.com/doc/.

AUTHOR

       Oracle Corporation (http://dev.mysql.com/).

MySQL 5.5							    01/30/2014							   MYSQL_FIND_ROWS