config bu şekilde.
innodb_buffer_pool_size=64M
innodb_additional_mem_pool_size=32M
innodb_thread_concurrency=8
innodb_flush_method=O_DIRECT
low_priority_updates=1
sshdan top -c yaptıgımda mysqlün yanında şu yazıyor:
/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/se
acaba ben nerde hata yaptım ? bu konuda yardımcı olabilecek kimse varmı acaba ?
Sunucu özellikleri:
2 GB RAM
2 CPU Cores
48 GB SSD Storage
3 TB Transfer
40 Gbit Network In
250 Mbit Network Out
sunucuda toplam hit 10k. litespeed ve cxs kurulu.
Version: '5.6.17' socket: '/var/lib/mysql/mysql.sock' port: 0 MySQL Community Server (GPL) 140731 16:42:23 mysqld_safe Number of processes running now: 0 140731 16:42:23 mysqld_safe mysqld restarted 2014-07-31 16:42:23 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-31 16:42:24 5066 [Note] Plugin 'FEDERATED' is disabled. 2014-07-31 16:42:24 7fa80c5e3720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2014-07-31 16:42:24 5066 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-31 16:42:24 5066 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-31 16:42:24 5066 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-31 16:42:24 5066 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-31 16:42:24 5066 [Note] InnoDB: Using Linux native AIO 2014-07-31 16:42:24 5066 [Note] InnoDB: Using CPU crc32 instructions 2014-07-31 16:42:24 5066 [Note] InnoDB: Initializing buffer pool, size = 64.0M 2014-07-31 16:42:24 5066 [Note] InnoDB: Completed initialization of buffer pool 2014-07-31 16:42:24 5066 [Note] InnoDB: Highest supported file format is Barracuda. 2014-07-31 16:42:24 5066 [Note] InnoDB: The log sequence numbers 1280623333 and 1280623333 in ibdata files do not match the log sequence number 1447423615 in the ib_logfiles! 2014-07-31 16:42:24 5066 [Note] InnoDB: Database was not shutdown normally! 2014-07-31 16:42:24 5066 [Note] InnoDB: Starting crash recovery. 2014-07-31 16:42:24 5066 [Note] InnoDB: Reading tablespace information from the .ibd files... 2014-07-31 16:42:24 5066 [Note] InnoDB: Restoring possible half-written data pages 2014-07-31 16:42:24 5066 [Note] InnoDB: from the doublewrite buffer... 2014-07-31 16:42:24 5066 [Note] InnoDB: 128 rollback segment(s) are active. 2014-07-31 16:42:24 5066 [Note] InnoDB: Waiting for purge to start 2014-07-31 16:42:24 5066 [Note] InnoDB: 5.6.17 started; log sequence number 1447423615 2014-07-31 16:42:24 5066 [Note] Event Scheduler: Loaded 0 events 2014-07-31 16:42:24 5066 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.17' socket: '/var/lib/mysql/mysql.sock' port: 0 MySQL Community Server (GPL) 140731 18:22:08 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2014-07-31 18:22:08 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-31 18:22:09 2627 [Note] Plugin 'FEDERATED' is disabled. 2014-07-31 18:22:09 7f73b9bae720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2014-07-31 18:22:09 2627 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-31 18:22:09 2627 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-31 18:22:09 2627 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-31 18:22:09 2627 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-31 18:22:09 2627 [Note] InnoDB: Using Linux native AIO 2014-07-31 18:22:09 2627 [Note] InnoDB: Using CPU crc32 instructions 2014-07-31 18:22:09 2627 [Note] InnoDB: Initializing buffer pool, size = 64.0M 2014-07-31 18:22:09 2627 [Note] InnoDB: Completed initialization of buffer pool 2014-07-31 18:22:09 2627 [Note] InnoDB: Highest supported file format is Barracuda. 2014-07-31 18:22:09 2627 [Note] InnoDB: The log sequence numbers 1280623333 and 1280623333 in ibdata files do not match the log sequence number 1449651628 in the ib_logfiles! 2014-07-31 18:22:09 2627 [Note] InnoDB: Database was not shutdown normally! 2014-07-31 18:22:09 2627 [Note] InnoDB: Starting crash recovery. 2014-07-31 18:22:09 2627 [Note] InnoDB: Reading tablespace information from the .ibd files... 2014-07-31 18:22:09 2627 [Note] InnoDB: Restoring possible half-written data pages 2014-07-31 18:22:09 2627 [Note] InnoDB: from the doublewrite buffer... 2014-07-31 18:22:09 2627 [Note] InnoDB: 128 rollback segment(s) are active. 2014-07-31 18:22:09 2627 [Note] InnoDB: Waiting for purge to start 2014-07-31 18:22:09 2627 [Note] InnoDB: 5.6.17 started; log sequence number 1449651628 2014-07-31 18:22:09 2627 [Note] Event Scheduler: Loaded 0 events 2014-07-31 18:22:09 2627 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.17' socket: '/var/lib/mysql/mysql.sock' port: 0 MySQL Community Server (GPL)
