Geetika, > If there are multiple caches in MySQL, I would welcome suggestions > pertaining to all or any of them. Thanks!
SHOW VARIABLES will show you what caches are set for your MySQL installation. E.g., I do: mysql> select version(); show variables like '%cache%'; +-----------------------+ | version() | +-----------------------+ | 4.0.3-beta-max-nt-log | +-----------------------+ 1 row in set (0.02 sec) +-----------------------+------------+ | Variable_name | Value | +-----------------------+------------+ | bdb_cache_size | 8388600 | | binlog_cache_size | 32768 | | have_query_cache | YES | | max_binlog_cache_size | 4294967295 | | query_cache_limit | 1048576 | | query_cache_size | 0 | | query_cache_type | ON | | table_cache | 64 | | thread_cache_size | 0 | +-----------------------+------------+ 9 rows in set (0.00 sec) The best way to set the cache settings (and most of the other settings, too) is to have them set in my.cnf (Unix) / my.ini (Windows). Another way is to start the server with these options on the command line (which will make the command line quite long), and in MySQL 4.0.x / 4.1, you can also change the settings with the SET command on the SQL command line (see http://www.mysql.com/doc/en/SET_OPTION.html). You can find all the possible options for the MySQL server here: http://www.mysql.com/doc/en/Command-line_options.html You can find the default values for caches and other options here: http://www.mysql.com/doc/en/SHOW_VARIABLES.html I wish you and all the others on the list a Merry Christmas! Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: "Geetika Tewari" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, December 24, 2002 7:13 PM Subject: Increase MySQL Cache Size > > Hi: How do you increase the cache size in MySQL? Which parameter should I > tweak, and also how do I find out the current default cache size? > > If there are multiple caches in MySQL, I would welcome suggestions > pertaining to all or any of them. Thanks! > > > Geetika > > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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