مصرف بالای مموری توسط mysql

[Yas-Host]

دسترسی روت ارسال کنید کامل بررسی خواهم کرد (بدون دریافت هزینه)

[motahhari]

متاسفانه دسترسی رو نمیتونم بدم.

این فایلی که معرفی کردید رو من به این شکل گذاشتم تو فایل کاملا :

[mysqld]

port= 3306
socket= /var/run/mysqld/mysqld.sock
skip-locking
key_buffer=384M
max_allowed_packet=1M
table_cache=512
sort_buffer=2M
record_buffer=2M
thread_cache=8

thread_concurrency=4
myisam_sort_buffer_size=64M
log-bin
server-id= 1

tmpdir=/tmp/
log-update=/tmp


innodb_data_file_path = ibdata1:2000M;ibdata2:2000M
innodb_data_home_dir = /var/lib/mysql/
innodb_log_group_home_dir = /var/lib/mysql/
innodb_log_arch_dir = /var/lib/mysql/
innodb_mirrored_log_groups=1
innodb_log_files_in_group=3
innodb_log_file_size=5M
innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_log_archive=0
innodb_buffer_pool_size=16M
innodb_additional_mem_pool_size=2M
innodb_file_io_threads=4
innodb_lock_wait_timeout=50

slow_query_log=1
slow_query_log_file="/var/log/mysql_slow_queries.log"
long_query_time = 2


[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
safe-updates


[isamchk]
key_buffer=256M
sort_buffer=256M
read_buffer=2M
write_buffer=2M

[myisamchk]
key_buffer=256M
sort_buffer=256M
read_buffer=2M
write_buffer=2M

[mysqlhotcopy]
interactive-timeout

اما ارور زیر رو گرفتم :

 Waiting for “mysql” to start ………Unrecognized configuration options may have caused the MySQL startup errors. The system has attempted to auto-update your MySQL configuration file for your MySQL version. This should resolve any errors that stem from an outdated MySQL configuration file. …Unrecognized configuration options may have caused the MySQL startup errors. The system has attempted to auto-update your MySQL configuration file for your MySQL version. This should resolve any errors that stem from an outdated MySQL configuration file.
…failed.

Service Error
The “mysql” service failed to start.

Startup Log
Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/farshadi.pid).

Log Messages
150413 15:01:07 mysqld_safe mysqld from pid file /var/lib/mysql/farshadi.pid ended
2015-04-13 15:01:06 16733 [Note] /usr/sbin/mysqld: Shutdown complete
2015-04-13 15:01:06 16733 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_log_arch_dir=/var/lib/mysql/'
150413 15:01:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150413 15:01:00 mysqld_safe mysqld from pid file /var/lib/mysql/farshadi.pid ended
2015-04-13 15:01:00 16149 [Note] /usr/sbin/mysqld: Shutdown complete

mysql has failed. Please contact your system administrator if the service does not automagically recover.