… bit varieties. Due to memory requirements, the InnoDB versions are only available on 64 bit instances. MySQL will fail to start on…,14.573 InnoDB my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
…engines, which was before most of us remember. And at a minimum, most servers these days need to consider the added memory…! I set my max_allowed_packet bigger and ran the following on my laptop: mysql> set @a := …memory usage over time and see how it varies. When I’m initially setting up a my.cnf…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
…variables depend on hardware and mix of storage engines, while per session variables are typically workload …_size even if you have 64GB of memory to waste. Furthermore doing so may decrease performance… workload. P.S Note MySQL distribution contains bunch of sample my.cnf files which may be great …
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…memory…mysql –mysql-host=localhost –mysql-table-engine=innodb –mysql-db=test –oltp-table-name=md_cache_test_small –oltp-table-size=1100000 –mysql-user=msandbox –mysql…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 27 Comments
… really big and forget it. If you have enough memory, who cares. The memory isn’t allocated until it’s used — if… of storage engines (some InnoDB, some MyISAM, which is more important to you, etc) and choose an amount of memory based on… is a shame. When you are new to MySQL, trying to configure my.cnf, and you have heard guidance that seems so definite…
Post: MySQL: what read_buffer_size value is optimal ?
September 17, 2007 By 25 Comments
… my.cnf values on large memory sizes recommend 1M settings and MySQL built-in default is 128K. Some people having a lot of memory and…` int(10) unsigned NOT NULL, `slack` varchar(50) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 1 row in set (0.00… fits in OS cache): read_buffer_size impace on in memory tableread_buffer_sizeTime (sec)82004.1516K4.1532K4.1264K4.11128K4.11256K4…
Comment: The ultimate tool for generating optimal my.cnf files for MySQL
August 20, 2008 By 34 Comments
… tool for generating optimal my.cnf files for MySQL” ? 
The meaning of tuning my.cnf is not do to …memory (mainly due to lack of any form of autotuning). Not to mention that a very bad my.cnf…myisam files (since today MySQL let the operating system use its diskcache before the MySQL engine access …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…mysql processes drops rapidly when you increase the amount of system memory. We just deployed a new Linux/Mysql…=O_DIRECT in my.cnf, to prevent double buffering. Configure as much memory as possible to InnoDB’…I have assigned Inaam as the InnoDB scalability engineer. We do not have much resources for …
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
…my server can’t load all indexes in memory and this is slowing it down. I can tell because when I launch my…this is my.cnf: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql max_connections…default-character-set=utf8 default-storage-engine=InnoDB bulk_insert_buffer_size=8M # …
Comment: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
… have problem with mysql server. here of my server detail : DELL R710, Memory :16GB, OS : Ubuntu server 11.04. I use Mysql server version 5.5. some table using engine… user active. here of my.cnf setting : [client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld] user = mysql port = 3306 socket = /var…
