Here is the same data in a little easy format.
Raid Chunks count like % like % %
1 0.00 sec 0.33 sec 2 min 3.70 sec
3 0.00 sec 0.39 sec 14 min 59.83 sec
5 0.00 sec 0.38 sec 6 min 44.92 sec
15 0.00 sec 0.39 sec 6 min 33.72 sec
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
On Thu, 15 Nov 2001 16:14:58 -0600, Michael Brunson
<[EMAIL PROTECTED]> wrote:
| 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.
---------------------------------------------------------------------
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
