Revision [3871]

Last edited on 2010-10-20 08:53:38 by KenFong
Additions:
# 5.1 # slow_query_log = 1

Revision [3706]

Edited on 2010-05-03 18:57:48 by KenFong
Additions:
log-slow-queries=/var/lib/mysql/slow-queries.log
# 5.1 # slow_query_log_file=/var/lib/mysql/slow-queries.log

Revision [3683]

Edited on 2010-04-08 18:36:43 by KenFong
Additions:
innodb_log_file_size=32M
innodb_log_files_in_group=3
innodb_log_buffer_size=8M
# see http://www.mysqlperformanceblog.com/2008/11/21/how-to-calculate-a-good-innodb-log-file-size/

Revision [3677]

Edited on 2010-03-26 00:28:08 by KenFong
Additions:
# default-table-type = innodb

Revision [3604]

Edited on 2010-01-05 21:36:08 by WikiAdmin
Additions:
=== Mysql max_connections ===
It can be adjusted while the database is running.
set global max_connections = 200;

Revision [3526]

Edited on 2009-09-24 02:46:12 by WikiAdmin
Additions:
# innodb_doublewrite = no
Deletions:
# skip-innodb_doublewrite

Revision [3525]

Edited on 2009-09-24 02:18:42 by WikiAdmin
Additions:
# skip-innodb_doublewrite
Deletions:
skip-innodb_doublewrite

Revision [3524]

Edited on 2009-09-24 02:17:45 by WikiAdmin
Additions:
skip-innodb_doublewrite

Revision [3516]

Edited on 2009-09-09 19:11:27 by WikiAdmin
Additions:
==Disk contention==
This option tells innodb to commit to disk every second as oppose to every DML. Brings about TPS improvement, but at the risk of changes not committing to disk in case of server issues.
innodb_flush_log_at_trx_commit = 2

Revision [2818]

Edited on 2009-07-17 09:50:45 by WikiAdmin
Additions:
query_cache_size = 12M
query_cache_limit=2M
skip-bdb
table_cache is related to max_connections. For example, for 200 concurrent running connections, you should have a table cache size of at least 200 × N, where N is the maximum number of tables per join in any of the queries which you execute. You must also reserve some extra file descriptors for temporary tables and files.
Deletions:
query_cache_size = 8M
query_cache_limit=1M
table_cache is related to max_connections. For example, for 200 concurrent running connections, you should have a table cache size of at least 200 × N, where N is the maximum number of tables per join in any of the queries which you execute. You must also reserve some extra file descriptors for temporary tables and files.

Revision [2374]

Edited on 2009-07-09 21:46:22 by WikiAdmin
Additions:
thread_cache=32
query_cache_size = 8M
query_cache_limit=1M
Deletions:
query-cache-size = 8M

Revision [2284]

Edited on 2009-04-19 23:27:59 by WikiAdmin
Additions:
===Baseline config===
open_files_limit=8192
Deletions:
===Starting config===

Revision [2257]

Edited on 2009-03-25 03:12:35 by WikiAdmin
Additions:
==[[MysqlSQLTunningExample1 SQL tunning example 1]]==
Deletions:
==[[MysqlSQLTunningExample1 SQL tunning example 1]]

Revision [2256]

Edited on 2009-03-25 03:12:14 by WikiAdmin
Additions:
==[[http://wiki.mysqltuner.com/MySQLTuner#Downloading_MySQLTuner MYSQLTuner]]==
Deletions:
==[[ http://wiki.mysqltuner.com/MySQLTuner#Downloading_MySQLTuner MYSQLTuner]]==

Revision [2255]

Edited on 2009-03-25 03:11:52 by WikiAdmin
Additions:
==[[ http://wiki.mysqltuner.com/MySQLTuner#Downloading_MySQLTuner MYSQLTuner]]==
Deletions:
==[[ http://wiki.mysqltuner.com/MySQLTuner#Downloading_MySQLTuner MYSQLTuner]]

Revision [2254]

Edited on 2009-03-25 03:11:30 by WikiAdmin
Additions:
==[[ http://wiki.mysqltuner.com/MySQLTuner#Downloading_MySQLTuner MYSQLTuner]]
Deletions:
==[[MYSQLTuner http://wiki.mysqltuner.com/MySQLTuner#Downloading_MySQLTuner]]

Revision [2253]

Edited on 2009-03-25 03:10:55 by WikiAdmin
Additions:
==[[MYSQLTuner http://wiki.mysqltuner.com/MySQLTuner#Downloading_MySQLTuner]]

Revision [2177]

Edited on 2009-01-26 09:37:34 by WikiAdmin
Additions:
By default, innodb stores data in a single datafile. To make innodb stores table in separate files, enable the innodb_file_per_table option then do the following. This will cause mysql rebuild the table. To move it back to single data file, remove that option and repeat the following.
ALTER TABLE ENGINE=InnoDB;

Revision [2159]

Edited on 2009-01-20 01:19:08 by WikiAdmin
Additions:
===Starting config===
[mysqld]
key_buffer = 64M
max_connections = 200
query-cache-size = 8M
long_query_time = 1
innodb_buffer_pool_size = 256M

Revision [2084]

The oldest known version of this page was created on 2008-11-07 02:08:40 by WikiAdmin