MySQL Forums
Forum List  »  MyISAM

Re: MyISAM - Large Memory Footprint
Posted by: DBA Lead
Date: September 06, 2010 03:09PM

I'd also like to see the output of what Rick asked for but I'd recommend starting your servers with --skip-innodb to completely skip Innodb (if you don't have Innodb tables).

I also think that its too early to predict the buffer size since we dont know the size of indexes yet.

Please use the following to find the no. of tables in the DB for us. And, also tell us the values of caches (SHOW GLOBAL VARIABLES LIKE %cache%) and buffers (SHOW GLOBAL VARIABLES LIKE %buffer%)

mysql> use information_schema;
mysql> SELECT COUNT(*) FROM TABLES;

You'll also have to monitor your status variables to come up with good numbers since we cannot predict the kind of load you are expecting.

--------------------------------------------------------------------
Geeks Worldwide -- http://www.geeksww.com/keywords/tutorials/mysql/

Options: ReplyQuote


Subject
Views
Written By
Posted
5137
July 30, 2010 06:17PM
2423
July 31, 2010 11:54PM
Re: MyISAM - Large Memory Footprint
2290
September 06, 2010 03:09PM
2129
September 07, 2010 10:53AM
2043
September 07, 2010 08:34PM
1915
September 07, 2010 11:12AM
2043
September 07, 2010 01:20PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.