Logge slow_queries i mysql[Løst]

[Thomas.]

Hei, har litt problemer med logging av slow queries/not using index.

Jeg har opprettet filen /var/log/mysql/mysql-slow.log, og har 4362 slow queries, og den øker stadig..

Bruker MySQL Activity Report til å logge mysql-aktivitet.

 

Men problemet er at det ikke logges noe til filen jeg har angitt (slow query log).. Har restartet mysqld service, testet med root og mysql som eier av fil/mappe. Men ting blir fortsatt ikke logget.

 

Config-filen:

[mysqld]
datadir=/var/lib/mysql
safe-show-database
skip-innodb
skip-bdb
back_log = 50
max_connections = 70
key_buffer_size = 80M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 384
wait_timeout = 20
connect_timeout = 10
tmp_table_size = 128M
max_heap_table_size = 64M
max_allowed_packet = 64M
net_buffer_length = 16384
max_connect_errors = 100000
thread_concurrency = 16
concurrent_insert = 2
table_lock_wait_timeout = 30
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 2M
query_cache_size = 64M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM
max_write_lock_count = 4
max_allowed_packet = 100M
log-slow-queries = /var/log/mysql/mysql-slow.log
long_query_time = 1
log-long-format
log_queries_not_using_indexes

[mysqld_safe]
nice = -19
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M

 

Noen forslag?

 

 

Fikk opp dette når jeg prøvde kjøre mysqldumpslow:

 

-bash-3.2# mysqldumpslow
Can't determine basedir from 'my_print_defaults mysqld' output: --datadir=/var/lib/mysql
--safe-show-database
--skip-innodb
--skip-bdb
--back_log=50
--max_connections=70
--key_buffer_size=80M
--myisam_sort_buffer_size=64M
--join_buffer_size=1M
--read_buffer_size=1M
--sort_buffer_size=2M
--table_cache=1024
--thread_cache_size=384
--wait_timeout=20
--connect_timeout=10
--tmp_table_size=128M
--max_heap_table_size=64M
--max_allowed_packet=64M
--net_buffer_length=16384
--max_connect_errors=100000
--thread_concurrency=16
--concurrent_insert=2
--table_lock_wait_timeout=30
--read_rnd_buffer_size=786432
--bulk_insert_buffer_size=8M
--query_cache_limit=2M
--query_cache_size=64M
--query_cache_type=1
--query_prealloc_size=262144
--query_alloc_block_size=65536
--transaction_alloc_block_size=8192
--transaction_prealloc_size=4096
--default-storage-engine=MyISAM
--max_write_lock_count=4
--max_allowed_packet=100M
--log-slow-queries=/var/log/mysql/mysql-slow.log
--long_query_time=1
--log-long-format
--log_queries_not_using_indexes

 

 

 

Løst

 

Satt tillatelser til -rw-r-----.

Endret 16. april 2011 av Thomas.