I am trying to understand how MySQL uses memory when executing a query on a large table.
The server is running on RedHat 6.0 with pentium III 750 Mhz processor and 2 Gig of RAM. I have my key_buffer_size set to 1600MB. My table cache is set at 512. When I run top, I get the following out put: Mem: 4193280K av, 1275776K used, 2917504K free, 0K shrd, 0k buff Swap: 0K av, 0K used, 0k free 0k cached PID USER PRI NI SIZE RSS SHARE STAT LIB %CPU %MEM TIME COMMAND 5065 mysql 0 0 330M 330M 1608 S 327M 0.0 8.0 0:02 mysqld 5067 mysql 12 0 330M 330M 1608 S 327M 0.0 8.0 0:01 mysqld 5068 mysql 0 0 330M 330M 1608 S 327M 0.0 8.0 0:03 mysqld 4398 mysql 0 0 330M 330M 1608 S 327M 0.0 8.0 0:00 mysqld When I fisrt start mysqld, the SIZE, RSS, and LIB are much smaller and they slowly increase as I run the query on the large table. The table contains 47,000,000 plus records. I have the fields indexed and when I use the EXPLAIN command, it shows that MySQL is using the indexes properly. I am look for suggestions on how to make the query faster. I have read the suggestions in the manual and tried them, but nothing seems to improve the performance. Have I reached the a limitation of MySQL on my hardware setup? Thanks, Jeff --------------------------------------------------------------------- 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
