ارور دیتابیس

[secureconfig]

خب مشکل بنده همنه که الان داره 30 در صد سی پی رو استفاده میکنه

درصورت نیاز با کانفیگ mysql میتوان فشار روی cpu را کم کرد ولی مصرفی ram بسیار بالا میرود !

[reza0071]

شات از منابع سرور.



لاگ ارور ها رو هم گذاشتم.

141117 09:32:25 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql141117 9:32:25 [Note] Plugin 'FEDERATED' is disabled.
141117 9:32:25 InnoDB: The InnoDB memory heap is disabled
141117 9:32:25 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141117 9:32:25 InnoDB: Compressed tables use zlib 1.2.3
141117 9:32:25 InnoDB: Using Linux native AIO
141117 9:32:25 InnoDB: Initializing buffer pool, size = 128.0M
141117 9:32:25 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
141117 9:32:25 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
141117 9:32:25 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
141117 9:32:25 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
141117 9:32:26 InnoDB: Waiting for the background threads to start
141117 9:32:27 InnoDB: 5.5.31 started; log sequence number 0
141117 9:32:27 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
141117 9:32:27 [Note] - '0.0.0.0' resolves to '0.0.0.0';
141117 9:32:27 [Note] Server socket created on IP: '0.0.0.0'.
141117 9:32:27 [Note] Event Scheduler: Loaded 0 events
141117 9:32:27 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.31' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
141117 10:30:05 [Note] /usr/sbin/mysqld: Normal shutdown


141117 10:30:05 [Note] Event Scheduler: Purging the queue. 0 events
141117 10:30:05 InnoDB: Starting shutdown...
141117 10:30:06 InnoDB: Shutdown completed; log sequence number 1668492
141117 10:30:06 [Note] /usr/sbin/mysqld: Shutdown complete


141117 10:30:07 mysqld_safe mysqld from pid file /var/lib/mysql/roya.test.org.pid ended
141117 10:30:27 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141117 10:30:27 [Note] Plugin 'FEDERATED' is disabled.
141117 10:30:27 InnoDB: The InnoDB memory heap is disabled
141117 10:30:27 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141117 10:30:27 InnoDB: Compressed tables use zlib 1.2.3
141117 10:30:27 InnoDB: Using Linux native AIO
141117 10:30:27 InnoDB: Initializing buffer pool, size = 128.0M
141117 10:30:27 InnoDB: Completed initialization of buffer pool
141117 10:30:27 InnoDB: highest supported file format is Barracuda.
141117 10:30:27 InnoDB: Waiting for the background threads to start
141117 10:30:28 InnoDB: 5.5.31 started; log sequence number 1668492
141117 10:30:28 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
141117 10:30:28 [Note] - '0.0.0.0' resolves to '0.0.0.0';
141117 10:30:28 [Note] Server socket created on IP: '0.0.0.0'.
141117 10:30:28 [Note] Event Scheduler: Loaded 0 events
141117 10:30:28 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.31' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
141117 14:17:37 [Note] /usr/sbin/mysqld: Normal shutdown


141117 14:17:37 [Note] Event Scheduler: Purging the queue. 0 events
141117 14:17:37 InnoDB: Starting shutdown...
141117 14:17:38 InnoDB: Shutdown completed; log sequence number 1668492
141117 14:17:38 [Note] /usr/sbin/mysqld: Shutdown complete


141117 14:17:38 mysqld_safe mysqld from pid file /var/lib/mysql/roya.test.org.pid ended
141117 14:18:04 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141117 14:18:04 [Note] Plugin 'FEDERATED' is disabled.
141117 14:18:04 InnoDB: The InnoDB memory heap is disabled
141117 14:18:04 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141117 14:18:04 InnoDB: Compressed tables use zlib 1.2.3
141117 14:18:04 InnoDB: Using Linux native AIO
141117 14:18:04 InnoDB: Initializing buffer pool, size = 128.0M
141117 14:18:04 InnoDB: Completed initialization of buffer pool
141117 14:18:04 InnoDB: highest supported file format is Barracuda.
141117 14:18:05 InnoDB: Waiting for the background threads to start
141117 14:18:06 InnoDB: 5.5.31 started; log sequence number 1668492
141117 14:18:06 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
141117 14:18:06 [Note] - '0.0.0.0' resolves to '0.0.0.0';
141117 14:18:06 [Note] Server socket created on IP: '0.0.0.0'.
141117 14:18:06 [Note] Event Scheduler: Loaded 0 events
141117 14:18:06 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.31' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
141125 13:07:28 [Note] /usr/sbin/mysqld: Normal shutdown


141125 13:07:28 [Note] Event Scheduler: Purging the queue. 0 events
141125 13:07:28 InnoDB: Starting shutdown...
141125 13:07:30 InnoDB: Shutdown completed; log sequence number 15845792
141125 13:07:30 [Note] /usr/sbin/mysqld: Shutdown complete


141125 13:07:30 mysqld_safe mysqld from pid file /var/lib/mysql/roya.test.org.pid ended
141125 13:07:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141125 13:07:30 [Note] Plugin 'FEDERATED' is disabled.
141125 13:07:30 InnoDB: The InnoDB memory heap is disabled
141125 13:07:30 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141125 13:07:30 InnoDB: Compressed tables use zlib 1.2.3
141125 13:07:30 InnoDB: Using Linux native AIO
141125 13:07:30 InnoDB: Initializing buffer pool, size = 128.0M
141125 13:07:30 InnoDB: Completed initialization of buffer pool
141125 13:07:30 InnoDB: highest supported file format is Barracuda.
141125 13:07:30 InnoDB: Waiting for the background threads to start
141125 13:07:31 InnoDB: 5.5.31 started; log sequence number 15845792
141125 13:07:31 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
141125 13:07:31 [Note] - '0.0.0.0' resolves to '0.0.0.0';
141125 13:07:31 [Note] Server socket created on IP: '0.0.0.0'.
141125 13:07:32 [Note] Event Scheduler: Loaded 0 events
141125 13:07:32 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.31-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)

کانفیگ my.cnf

[client]#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock


[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-external-locking
key_buffer_size = 256M
max_allowed_packet = 1M
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M


thread_concurrency = 4


log-bin=mysql-bin


binlog_format=mixed


server-id = 1




# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /var/lib/mysql
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 256M
innodb_additional_mem_pool_size = 20M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 64M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50


[mysqldump]
quick
max_allowed_packet = 16M


[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates


[myisamchk]
key_buffer_size = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M


[mysqlhotcopy]
interactive-timeout

- - - Updated - - -

- - - Updated - - -

دوستان مشکل FTP حل شد و مونده مشکل دیتابیس

- - - Updated - - -

دوستان مشکل FTP حل شد و مونده مشکل دیتابیس