大家好! 把msyql 的全局变量log_queries_not_using_indexes设置之后,可以将没有使用索引的sql写到slow_log上面去。有一个很奇怪的问题出现了,想请教一下大家: 1、如果我开启log_queries_not_using_indexes的话,我的slow log 里面没有任何记录; 2、开启log_queries_not_using_indexes之后,slow log 里面记录了使用了索引的记录; +----+-------------+--------------------+--------+----------------+----------+--------...
Hi, I am trying to perform reorg for some of the tables but its takes very long time to complete 1 table will it because of too many records? The table contain of 1000000+ records. When I try to look at the db2diag.log its only return this msg to me. anyone know what does it means? 2005-05-28-15.51.46.270151 Instance:db2inst Node:000 PID:39932(db2tcpcm) Appid:none common_communication sqlc...
I having a problem when I trying to import data to db. The table only have 600000+ records but it took 1 hr to import. Can I delete all the indexes I created then only do import, after import only create back the indexex? Will it improve the speed? Please advise.
ZT: http://www-128.ibm.com/developerworks/aix/library/au-satslowsys.html?ca=drs - Level: Intermediate Martin Brown ( [email=mc@mcslp.com?subject=Monitoring a slow system]mc@mcslp.com[/email] ), Freelance Writer, Consultant 07 Jun 2006 When your UNIX® system runs slow, it is vital that you discover what the problem is as quickly as possible so you can get your system back into the normal ope...
My current backup/restore procedure is as following: $ pg_dumpall >; db.out $ psql -f db.out template1 The dump file is about 150MB. and the restoration takes more than 4 hours on my server. It's too slow if I want to recover from disaster. Is there any good ways to speed up backup/restoration? Thanks a lot. Sorry, I can't shutdown database and make cold backup very frequently.
mysql慢速(slow log)脚本分析: mysql有一个功能就是可以log下来运行的比较慢的sql语句,默认是没有这个log的,为了开启这个功能, 要修改my.cnf或者在mysql启动的时候加入一些参数。如果在my.cnf里面修改,需增加如下几行: 【需要在该文件的[mysqld]下增加以下几行记录。】 long_query_time = 1 log-slow-queries = /var/youpath/slow.log log-queries-not-using-indexes long_query_time 是指执行超过多久的sql会被log下来,这...
今天把long_query_time的值改为0了,后来发现slow.log的增长速度很快,基本7、8秒就多1M,请问,如果长时间这样下去,slow.log过大会不会导致mysql挂掉?用的是centos5.2 32位,ext3文件系统,是不是在16G内都不会有问题?还是slow.log在大到一定程度后,就会自动切割,谢谢! ps:mysql version为5.1.32
版本:Server version: 5.0.67-log Source distribution 我在/etc/my.cnf的[mysqld]里面指定了 log_slow_queries = /opt/yjsword/mysql/log/mysql_slow_query.txt long_query_time = 1 每次启动mysql日志里都会出现: /opt/yjsword/mysql/libexec/mysqld: File '/var/log/mysql_slow_query.log' not found (Errcode: 13) 090326 11:20:55 [ERROR] Could not use /var/log/mysql_slow_query.log for logging (error 13). Turning lo...