Rummaging through some docs on performance and have come up with some questions. Let me preface by saying, we don't have any performance problems. I inherited this monster of a database and am running through the configuration to make sure that it is indeed setup for optimum performance.
For clarity sake, assume the following: Red Hat Linux 7.1 2.4.8 kernel MySQL 3.23.42 MyISAM databases 3GB RAM P3/700 x 4 15GB database spanned across ~200 tables Key_reads / Key_read_request = 0.00059875 Key_write / Key_write_requests = 0.81324723 1) Since the key_buffer variable defines the total amount of indexed data in memory, then the key_buffer size and index size of my tables should be releated. Total index size of all relevant tables is 440MB. Should the key_buffer size be >, <, = or a percentage of this number? 2) How does performance directly relate to the number of open tables? Yes, these open tables take memory, and a FLUSH TABLES would adequately free this memory, but then the tables that are used most frequently would need to be reopened. Am I looking at memory vs. CPU in this case? Provided I have enough RAM, wouldn't it make sense to leave all the tables open? I'm sure I'll think of more later on. By the way, here are the pages I used to ramp up my performance knowledge: http://www.mysql.com/doc/en/SHOW_VARIABLES.html http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:19873 http://www.linux-mag.com/2001-12/mysql_01.html -J --------------------------------------------------------------------- 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
