Has anyone ran any benchmarks as to what affect
different number of RAID_CHUNKS has on speed?
Also, what affect does the RAID_CHUNKSIZE have?
Here are a few results I've gotten all with the default
CHUCKSIZE.
-----------------------------
No RAID Tables (yes, fewer rows.. hit the 2G limit)
mysql> select count(*) from names;
+----------+
| count(*) |
+----------+
| 30304640 |
+----------+
1 row in set (0.00 sec)
mysql> select count(*) from names where sld like
'sex%';
+----------+
| count(*) |
+----------+
| 56033 |
+----------+
1 row in set (0.33 sec)
mysql> select count(*) from names where sld like
'%sex%';
+----------+
| count(*) |
+----------+
| 151460 |
+----------+
1 row in set (2 min 3.70 sec)
-----------------------------
RAID_CHUNKS=3
mysql> select count(*) from names;
+----------+
| count(*) |
+----------+
| 30352536 |
+----------+
1 row in set (0.00 sec)
mysql> select count(*) from names where sld like
'sex%';
+----------+
| count(*) |
+----------+
| 55989 |
+----------+
1 row in set (0.39 sec)
mysql> select count(*) from names where sld like
'%sex%';
+----------+
| count(*) |
+----------+
| 151422 |
+----------+
1 row in set (14 min 59.83 sec)
-----------------------------
RAID_CHUNKS=5
mysql> select count(*) from names;
+----------+
| count(*) |
+----------+
| 30352536 |
+----------+
1 row in set (0.00 sec)
mysql> select count(*) from names where sld like
'sex%';
+----------+
| count(*) |
+----------+
| 55989 |
+----------+
1 row in set (0.38 sec)
mysql> select count(*) from names where sld like
'%sex%';
+----------+
| count(*) |
+----------+
| 151422 |
+----------+
1 row in set (6 min 44.92 sec)
-----------------------------
RAID_CHUNKS=15
mysql> select count(*) from names;
+----------+
| count(*) |
+----------+
| 30352536 |
+----------+
1 row in set (0.00 sec)
mysql> select count(*) from names where sld like
'sex%';
+----------+
| count(*) |
+----------+
| 55989 |
+----------+
1 row in set (0.39 sec)
mysql> select count(*) from names where sld like
'%sex%';
+----------+
| count(*) |
+----------+
| 151422 |
+----------+
1 row in set (6 min 33.72 sec)
-----------------------------
This is running on a pretty wimpy box, but all ran
several times so I was able to make sure the server was
fully up. The box is a 750 PIII with 756M of RAM,
running linux and the 3.23.44 version of mysql.
Any suggestions would be great.
Thanks,
Michael
--
Michael Brunson 504.473.6643
[EMAIL PROTECTED] ICQ: 83163789
<? Special Projects Programming Manager ?>
--- Intercosmos Media Group, Inc. ---
www.intercosmos.com www.directnic.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
