解决方案 »
- mysql administrator登陆问题(请指教)
- mysql 数据库中如何取一组中的最大值?
- MYSQL 中 with rollup 是干什么用的
- 求教关于CLUSTER的性能问题
- 怎样固定形式导出数据
- 谁能给一个struts文件上传到数据库的例子?做了半个月了没进展
- 如何提取2个mysql数据库内相同表相同相同记录并累加?
- 救急!!!(用java在mysql插入系统当前时间,怎么办?
- 已经有一个表tablename,可是现在我发现我还需要一栏string,又不想改动其中的数据,我该怎么作
- mysql语句求助
- mysql的复杂sql(有group by ) 只能建立temptable视图, 查询很慢, 怎么解决?
- mysql远程连接问题!
2 ulimit -a是否足够大
守护进程无法启动,一直返回以上的错误~~~我只能是手动service mysql restart 这样才正常~~ulimit -a 出现以下信息,不知道如何算大~~程序是PHP的~~不太懂!
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 7970
max locked memory (kbytes, -l) 64
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 7970
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
还有这个错误日志~~
150125 5:10:18 InnoDB: The InnoDB memory heap is disabled
150125 5:10:18 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150125 5:10:18 InnoDB: Compressed tables use zlib 1.2.7
150125 5:10:18 InnoDB: Using Linux native AIO
150125 5:10:18 InnoDB: Initializing buffer pool, size = 512.0M
150125 5:10:18 InnoDB: Completed initialization of buffer pool
150125 5:10:18 InnoDB: highest supported file format is Barracuda.
150125 5:10:19 InnoDB: Waiting for the background threads to start
150125 5:10:20 InnoDB: 5.5.40 started; log sequence number 1672204
150125 5:10:20 [ERROR] /usr/sbin/mysqld: unknown variable 'defaults-file=/etc/mysql/my.cnf'
150125 5:10:20 [ERROR] Aborting
我装的是vestacp 面板~~会自动备份数据库~~今早起来,又是挂了。~出现:Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
检查了一下my.cnf,配置文件都对~
[client]
port=3306
socket=/var/run/mysqld/mysqld.sock[mysqld_safe]
socket=/var/run/mysqld/mysqld.sock[mysqld]
user=mysql
pid-file=/var/run/mysqld/mysqld.pid
socket=/var/run/mysqld/mysqld.sock郁闷了。。~~