On Thu, Nov 15, 2001 at 04:14:58PM -0600, Michael Brunson wrote: > > Has anyone ran any benchmarks as to what affect different number of > RAID_CHUNKS has on speed?
The more chunks, the slower your retrieval speed is likely to be. But how many chunks do you really need? More than a few? > 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) Is there an index on "sld"? It would seem so. If that's the case, the test is relatively meaningless. The index will be used to answer the query, not the raid'ed data files. > mysql> select count(*) from names where sld like > '%sex%'; > +----------+ > | count(*) | > +----------+ > | 151460 | > +----------+ > 1 row in set (2 min 3.70 sec) Same here. If you have a lot of "%foo%" queries, you probably want to look at fulltext indexing. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 71 days, processed 1,557,459,503 queries (253/sec. avg) --------------------------------------------------------------------- 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
