sistem üzerinde openlitespeed çalışıyor ve tek site var, mysql tarafında da tek tablo var sadece, slow query log boş gözüküyor.Bir bakabilecek var mı ?
Teşekkürler şimdiden
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 19238 mysql 20 0 1515m 72m 4696 S 246.6 0.9 3:58.49 mysqldİşletim Sistemi:
CentOS 6.5 (Linux version 2.6.32-431.5.1.el6.x86_64 (mockbuild@c6b10.bsys.dev.centos.org) (gcc version 4.4.7 20120313 (Red Hat 4.4.7-4) (GCC) ))Sistem Özellikleri:
Architecture: x86_64 CPU op-mode(s): 32-bit, 64-bit Byte Order: Little Endian CPU(s): 4 On-line CPU(s) list: 0-3 Thread(s) per core: 1 Model name: Intel(R) Xeon(R) CPU E5645 @ 2.40GHz MemTotal: 8061372 kB MemFree: 1128836 kB Buffers: 172644 kB Cached: 4710924 kBmy.cnf:
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=1 bind-address=0.0.0.0 # query_cache_size = 16M tmp_table_size = 32M max_heap_table_size = 32M table_open_cache = 16 thread_cache_size = 4 innodb_buffer_pool_size = 43M # slow-query-log=1 slow-query-log-file=/var/log/mysql-slow.log [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid