Mysql 4 and or Partitions.

--001636417c1fcfde55048b6ef9f4
Content-Type: text/plain; charset=ISO-8859-1

Ok... I solved my mistery of the slow 22G table.... rebuild the kernel to
support memory and now things are working.

But still quite slow.

I do sum() operations over the 22G table. I'm using the latest version of
mysql 4... (I WILL migrate soon, I promise), one thing I have notice, is
that operations over that 22G table, seasuring the I/O with iostat never
surpass the 23mb/s for reading... even if I test the IO of the array, it can
easily give me 300mb/s for reads... and like 150 for random reads...

first of all, is there any way to squeeze more speed out from mysql 4?
No... I imagined that...

So, my next step is migate to a newer version of mysql ( YEY ^_^ )... I
have read a few about partitions.

The specific query I'm making is a query which do a sum filtered over a date
field.

What would be the best approach to partition this table?

Can I mix innodb with partioned tables and still have acid compliance?

The split in several partitions creates more lecture threads or how
parelelization over partitions works?

And last, does mysql 4 support partitions? XD





tia.

--001636417c1fcfde55048b6ef9f4--

RE: Mysql 4 and or Partitions.

Use indexes before thinking about partitions.

-----Original Message-----
From: Andr=E9s Tello [mailto:mr.criptos@gmail.com]
Sent: Thursday, July 15, 2010 8:44 AM
To: mysql
Subject: Mysql 4 and or Partitions.

Ok... I solved my mistery of the slow 22G table.... rebuild the kernel to
support memory and now things are working.

But still quite slow.

I do sum() operations over the 22G table. I'm using the latest version of
mysql 4... (I WILL migrate soon, I promise), one thing I have notice, is
that operations over that 22G table, seasuring the I/O with iostat never
surpass the 23mb/s for reading... even if I test the IO of the array, it ca=
n
easily give me 300mb/s for reads... and like 150 for random reads...

first of all, is there any way to squeeze more speed out from mysql 4?
No... I imagined that...

So, my next step is migate to a newer version of mysql ( YEY ^_^ )... I
have read a few about partitions.

The specific query I'm making is a query which do a sum filtered over a dat=
e
field.

What would be the best approach to partition this table?

Can I mix innodb with partioned tables and still have acid compliance?

The split in several partitions creates more lecture threads or how
parelelization over partitions works?

And last, does mysql 4 support partitions? XD





tia.

This message contains confidential information and is intended only for the=
individual named. If you are not the named addressee, you are notified th=
at reviewing, disseminating, disclosing, copying or distributing this e-mai=
l is strictly prohibited. Please notify the sender immediately by e-mail i=
f you have received this e-mail by mistake and delete this e-mail from your=
system. E-mail transmission cannot be guaranteed to be secure or error-fre=
e as information could be intercepted, corrupted, lost, destroyed, arrive l=
ate or incomplete, or contain viruses. The sender therefore does not accept=
liability for any loss or damage caused by viruses or errors or omissions =
in the contents of this message, which arise as a result of e-mail transmis=
sion. [FriendFinder Networks, Inc., 220 Humbolt court, Sunnyvale, CA 94089,=
USA, FriendFinder.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg