Aylardır %30-40 larda cpu kullandığım linode serverımda dün gece %194 görmüşüm ve kapanmış sunucu.
/var/lib/mysql/server.yourserver.com.err a baktığımda mysqlde sıknıtı gözükmüyor. innodb falan gayet düzgün çalışmış.
140720 02:51:56 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2014-07-20 02:51:56 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-20 02:51:56 2623 [Note] Plugin 'FEDERATED' is disabled. 2014-07-20 02:51:56 7f0f2c958720 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-20 02:51:56 2623 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-20 02:51:56 2623 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-20 02:51:56 2623 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-20 02:51:56 2623 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-20 02:51:56 2623 [Note] InnoDB: Using Linux native AIO 2014-07-20 02:51:56 2623 [Note] InnoDB: Using CPU crc32 instructions 2014-07-20 02:51:56 2623 [Note] InnoDB: Initializing buffer pool, size = 64.0M 2014-07-20 02:51:56 2623 [Note] InnoDB: Completed initialization of buffer pool 2014-07-20 02:51:56 2623 [Note] InnoDB: Highest supported file format is Barracuda. 2014-07-20 02:51:56 2623 [Note] InnoDB: The log sequence numbers 1280623333 and 1280623333 in ibdata files do not match the log sequence number 1298060561 in the ib_logfiles! 2014-07-20 02:51:56 2623 [Note] InnoDB: Database was not shutdown normally! 2014-07-20 02:51:56 2623 [Note] InnoDB: Starting crash recovery. 2014-07-20 02:51:56 2623 [Note] InnoDB: Reading tablespace information from the .ibd files... 2014-07-20 02:51:56 2623 [Note] InnoDB: Restoring possible half-written data pages 2014-07-20 02:51:56 2623 [Note] InnoDB: from the doublewrite buffer... 2014-07-20 02:51:56 2623 [Note] InnoDB: 128 rollback segment(s) are active. 2014-07-20 02:51:56 2623 [Note] InnoDB: Waiting for purge to start 2014-07-20 02:51:57 2623 [Note] InnoDB: 5.6.17 started; log sequence number 1298060561 2014-07-20 02:51:57 2623 [Note] Event Scheduler: Loaded 0 events 2014-07-20 02:51:57 2623 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.17' socket: '/var/lib/mysql/mysql.sock' port: 0 MySQL Community Server (GPL)
Hangi access logga bakmalıyım bu sorunu bulabilmek için. Neler yapabilirim ? bu konuda fikirleriniz benim için çok önemli.