…can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-… for the first time (even unsuccessfully, for example # if you mistyped the password in… #innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash # Remove…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
… internal structures for the query plan, for example, and keeps it around until the query… than max_allowed_packet). And keys for user locks! I set my max_allowed_packet bigger and ran the following on my …my.cnf for a server, I usually calculate the Big Ones like the buffer pool, query cache etc…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…in /etc/my.cnf (included in FDA) [mysqld] sql-mode = IGNORE_SPACE transaction-isolation = READ-COMMITTED max_allowed_packet = 1M max_connections=300 max_connect_…O_DIRECT First the options are somethat benchmark optimized – for example doublewrite is disabled; checksums are disabled; binary log …
