ChinaUnix.net
相关文章推荐:

telnet slow

有谁用过WEBLOGIC吗,这个东西现在反映很慢,而且内存不够呀,请谁帮帮忙。谢了。

by feiaix - Java - 2005-07-19 12:06:30 阅读(903) 回复(1)

相关讨论

slow log太大了 查起来不方便, 有没有什么参数 是到达一定大小就生成另外一个slow log的 请教各位 谢谢啦

by 天下第一菜 - MySQL - 2008-09-18 10:22:49 阅读(1805) 回复(1)

大家好! 把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 里面记录了使用了索引的记录; +----+-------------+--------------------+--------+----------------+----------+--------...

by andrefun - MySQL - 2008-09-17 16:10:05 阅读(2123) 回复(4)

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...

by toms1981 - DB2 - 2005-06-07 08:52:18 阅读(1749) 回复(7)

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.

by toms1981 - DB2 - 2004-08-08 02:20:36 阅读(1793) 回复(10)

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...

by xuefg - HP文档中心 - 2006-07-21 13:18:11 阅读(1782) 回复(0)

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.

by don - PostgreSQL - 2004-11-16 11:58:53 阅读(2248) 回复(8)

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下来,这...

by dengfu234567891 - MySQL文档中心 - 2009-07-22 13:11:09 阅读(1182) 回复(0)

今天把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

by streetboy85 - MySQL - 2009-05-20 11:47:47 阅读(1787) 回复(6)

版本: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...

by yjsword - MySQL - 2009-03-27 09:25:16 阅读(3178) 回复(10)