当前位置: 首页 > 图文教程 > 数据库 > MYSQL > MySQL性能调整之my.cnf文件的配置方法

MYSQL
MYSQL初学者扫盲
PHP+MYSQL网站开发基础知识
网站主机教程(7):网站主机的数据库技术
PHP基础教程(2):PHP安装
PHP+MySQL教程(1):MYSQL简介
PHP+MySQL教程(2):连接MYSQL数据库
PHP+MySQL教程(3):创建数据库和表
PHP+MySQL教程(4):MySQL Insert Into
PHP+MySQL教程(5):MySQL Select
PHP+MySQL教程(6):MySQL Where子句
PHP+MySQL教程(7):MySQL Order By关键词
PHP+MySQL教程(8):MySQL Update
PHP+MySQL教程(9):MySQL Delete From
PHP+MySQL教程(10):Database ODBC
PHP+AJAX教程(5):AJAX MySQL数据库实例
32位的MySQL数据库迁移到64位的MySQL数据库
MYSQL教程:MYSQL数据值类型(data type)
MYSQL教程:MYSQL列类型(column type)
MYSQL数据库教程:唯一编号
MYSQL教程:MYSQL字符集支持

MYSQL 中的 MySQL性能调整之my.cnf文件的配置方法


出处:互联网   整理: 软晨网(RuanChen.com)   发布: 2009-10-17   浏览: 78 ::
收藏到网摘: n/a

MySQL性能调整之my.cnf文件的配置方法:

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

skip-locking

set-variable = key_buffer=16M

set-variable = max_allowed_packet=1M

set-variable = thread_stack=64K

set-variable = record_buffer=1M

set-variable = table_cache=1024

set-variable = sort_buffer=4M

set-variable = net_buffer_length=8K

set-variable = max_connect_errors=100

set-variable = max_connections=1024

server-id = 1

[mysqldump]

quick

set-variable = max_allowed_packet=16M


[mysql]

no-auto-rehash

# Remove the next comment character if you are not familiar with SQL

#safe-updates


[isamchk]

set-variable = key_buffer=20M

set-variable = sort_buffer=20M


[myisamchk]

set-variable = key_buffer=20M

set-variable = sort_buffer=20M


[mysqlhotcopy]

interactive-timeout


[mysql.server]

user=mysql

basedir=/var/lib


[safe_mysqld]

err-log=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid