Thanks very much, Stefan. Merry Christmas! :-) Geetika
On Tue, 24 Dec 2002, Stefan Hinz, iConnect (Berlin) wrote: > 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