求DIRECTADMIN my.cnf 文件配置

soey

求个MYSQL的优化文件，网站流量大了，使用DA的默认配置老是出现数据库连接错误
MYSQL版本是5.5
网上的一些直接复制过来，照着改了一下，用不了，MYSQL直接启动不了了
服务器配置4核
16G内存，求优化
老是提示这个东西：ERROR! The server quit without updating PID file
130626 15:01:45 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130626 15:01:45 [Note] Plugin 'FEDERATED' is disabled.
130626 15:01:45 InnoDB: The InnoDB memory heap is disabled
130626 15:01:45 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130626 15:01:45 InnoDB: Compressed tables use zlib 1.2.3
130626 15:01:45 InnoDB: Using Linux native AIO
130626 15:01:45 InnoDB: Initializing buffer pool, size = 128.0M
130626 15:01:45 InnoDB: Completed initialization of buffer pool
130626 15:01:45 InnoDB: highest supported file format is Barracuda.
130626 15:01:45  InnoDB: Waiting for the background threads to start
130626 15:01:46 InnoDB: 5.5.31 started; log sequence number 825447836
130626 15:01:46 [ERROR] /usr/sbin/mysqld: unknown option '--skip-locking'
130626 15:01:46 [ERROR] Aborting

130626 15:01:46  InnoDB: Starting shutdown...
130626 15:01:47  InnoDB: Shutdown completed; log sequence number 825447836
130626 15:01:47 [Note] /usr/sbin/mysqld: Shutdown complete

看了一下日志，发现这些东西
求高手优化一下

soey

liceen 发表于 2013-6-27 10:46
先把 --skip-locking 这个选项 干掉看看吧
你这个是可以正常运行一会 然后挂 还是直接起不来？ ...

去掉了，还是报错误
130627 01:45:04 mysqld_safe mysqld from pid file /var/lib/mysql/ns.longyp.com.pid ended
130627 01:45:09 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130627  1:45:09 [Note] Plugin 'FEDERATED' is disabled.
130627  1:45:09 InnoDB: The InnoDB memory heap is disabled
130627  1:45:09 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130627  1:45:09 InnoDB: Compressed tables use zlib 1.2.3
130627  1:45:09 InnoDB: Using Linux native AIO
130627  1:45:09 InnoDB: Initializing buffer pool, size = 128.0M
130627  1:45:09 InnoDB: Completed initialization of buffer pool
130627  1:45:09 InnoDB: highest supported file format is Barracuda.
130627  1:45:10  InnoDB: Waiting for the background threads to start
130627  1:45:11 InnoDB: 5.5.31 started; log sequence number 847843485
130627  1:45:11 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130627  1:45:11 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
130627  1:45:11 [Note] Server socket created on IP: '0.0.0.0'.
130627  1:45:11 [Note] Event Scheduler: Loaded 0 events
130627  1:45:11 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.31'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
但是MYSQL在运行

soey

不是的，我把skip-locking 前面加# 还是启动不起来的

liceen

soey 发表于 2013-6-27 10:20
怎么换啊

先把 --skip-locking 这个选项 干掉看看吧
你这个是可以正常运行一会 然后挂 还是直接起不来？

soey

liceen 发表于 2013-6-27 10:15
如果可以 换INNODB引擎试试

怎么换啊

liceen

如果可以 换INNODB引擎试试

soey

继续顶一下

soey

雨宫音羽 发表于 2013-6-27 05:13
从日志看 my.cnf去掉--skip-locking就行

--skip-locking在老版本MYSQL就有提醒会停止支持 ...

有完整的MY.CNF文件吗

雨宫音羽

从日志看 my.cnf去掉--skip-locking就行

--skip-locking在老版本MYSQL就有提醒会停止支持

liceen

soey 发表于 2013-6-27 13:42
去掉了，还是报错误
130627 01:45:04 mysqld_safe mysqld from pid file /var/lib/mysql/ns.longyp.com.p ...

你这个不算错误了 错误都是【ERROR】 这样子的
这些就是运行信息了