下面的进程
+------+----------------------+----------------+--------+---------+------+------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+----------------------+----------------+--------+---------+------+------------------+------------------------------------------------------------------------------------------------------+
| 5543 | root | localhost:2239 | cnbaidou | Sleep | 49 | | |
| 5549 | root | localhost:2247 | cnbaidou | Sleep | 13 | | |
| 5550 | root | localhost:2245 | cnbaidou | Sleep | 21 | | |
| 5580 | root | localhost:2269 | cnbaidou | Sleep | 35 | | |
| 5647 | root | localhost:2343 | cnbaidou | Sleep | 11 | | |
| 5666 | root | localhost:2362 | cnbaidou | Sleep | 8 | | |
| 5679 | root | localhost:2375 | cnbaidou | Sleep | 1 | | |
| 5681 | root | localhost:2377 | cnbaidou | Sleep | 2 | | |
| 5685 | root | localhost:2381 | cnbaidou | Sleep | 1 | | |
| 5692 | root | localhost:2389 | cnbaidou | Sleep | 1 | | |
| 5689 | root | localhost:2385 | cnbaidou | Sleep | 1 | | |
| 5699 | root | localhost:2395 | cnbaidou | Sleep | 6 | | |
| 5702 | root | localhost:2396 | cnbaidou | Sleep | 0 | | |
| 5704 | root | localhost:2399 | cnbaidou | Sleep | 0 | | |
| 5703 | root | localhost:2400 | cnbaidou | Sleep | 0 | | |
| 5712 | root | localhost:2409 | cnbaidou | Sleep | 0 | | |
| 5711 | root | localhost:2408 | cnbaidou | Sleep | 1 | | |
| 5715 | root | localhost:2411 | cnbaidou | Sleep | 0 | | |
| 5714 | cnyichun | localhost:2410 | yichun | Sleep | 1 | | |
| 5718 | root | localhost:2414 | cnbaidou | Query | 0 | | select * from company where compID=1159 |
| 5716 | root | localhost:2412 | cnbaidou | Sleep | 0 | | |
| 5720 | root | localhost:2415 | cnbaidou | Sleep | 1 | | |
| 5719 | root | localhost:2416 | cnbaidou | Query | 0 | Sorting result | select * from daycount where menutype = '34' and dc_type like '%p%' order by dc_count desc limit |
| 5722 | root | localhost:2418 | cnbaidou | Query | 0 | freeing items | select count(*) as thecount from daycount where dc_type = 'total' and dc_time = '2007-06-13' and com |
| 5721 | cnyichun | localhost:2417 | yichun | Sleep | 1 | | |
| 5724 | cnyichun | localhost:2420 | | Sleep | 1 | | |
| 5726 | root | localhost:2423 | cnbaidou | Sleep | 1 | | |
| 5725 | root | localhost:2421 | | Sleep | 0 | | |
| 5727 | unauthenticated user | localhost:2424 | | Connect | | Reading from net | |
| 5729 | root | localhost:2422 | cnbaidou | Sleep | 0 | | |
| 5728 | root | localhost:2425 | | Query | 0 | | show processlist |
| 5732 | root | localhost:2430 | cnbaidou | Sleep | 0 | | |
| 5731 | root | localhost:2429 | cnbaidou | Sleep | 0 | | |
| 5730 | unauthenticated user | localhost:2426 | | Connect | | Reading from net | |
+------+----------------------+----------------+--------+---------+------+------------------+------------------------------------------------------------------------------------------------------+
+------+----------------------+----------------+--------+---------+------+------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+----------------------+----------------+--------+---------+------+------------------+------------------------------------------------------------------------------------------------------+
| 5543 | root | localhost:2239 | cnbaidou | Sleep | 49 | | |
| 5549 | root | localhost:2247 | cnbaidou | Sleep | 13 | | |
| 5550 | root | localhost:2245 | cnbaidou | Sleep | 21 | | |
| 5580 | root | localhost:2269 | cnbaidou | Sleep | 35 | | |
| 5647 | root | localhost:2343 | cnbaidou | Sleep | 11 | | |
| 5666 | root | localhost:2362 | cnbaidou | Sleep | 8 | | |
| 5679 | root | localhost:2375 | cnbaidou | Sleep | 1 | | |
| 5681 | root | localhost:2377 | cnbaidou | Sleep | 2 | | |
| 5685 | root | localhost:2381 | cnbaidou | Sleep | 1 | | |
| 5692 | root | localhost:2389 | cnbaidou | Sleep | 1 | | |
| 5689 | root | localhost:2385 | cnbaidou | Sleep | 1 | | |
| 5699 | root | localhost:2395 | cnbaidou | Sleep | 6 | | |
| 5702 | root | localhost:2396 | cnbaidou | Sleep | 0 | | |
| 5704 | root | localhost:2399 | cnbaidou | Sleep | 0 | | |
| 5703 | root | localhost:2400 | cnbaidou | Sleep | 0 | | |
| 5712 | root | localhost:2409 | cnbaidou | Sleep | 0 | | |
| 5711 | root | localhost:2408 | cnbaidou | Sleep | 1 | | |
| 5715 | root | localhost:2411 | cnbaidou | Sleep | 0 | | |
| 5714 | cnyichun | localhost:2410 | yichun | Sleep | 1 | | |
| 5718 | root | localhost:2414 | cnbaidou | Query | 0 | | select * from company where compID=1159 |
| 5716 | root | localhost:2412 | cnbaidou | Sleep | 0 | | |
| 5720 | root | localhost:2415 | cnbaidou | Sleep | 1 | | |
| 5719 | root | localhost:2416 | cnbaidou | Query | 0 | Sorting result | select * from daycount where menutype = '34' and dc_type like '%p%' order by dc_count desc limit |
| 5722 | root | localhost:2418 | cnbaidou | Query | 0 | freeing items | select count(*) as thecount from daycount where dc_type = 'total' and dc_time = '2007-06-13' and com |
| 5721 | cnyichun | localhost:2417 | yichun | Sleep | 1 | | |
| 5724 | cnyichun | localhost:2420 | | Sleep | 1 | | |
| 5726 | root | localhost:2423 | cnbaidou | Sleep | 1 | | |
| 5725 | root | localhost:2421 | | Sleep | 0 | | |
| 5727 | unauthenticated user | localhost:2424 | | Connect | | Reading from net | |
| 5729 | root | localhost:2422 | cnbaidou | Sleep | 0 | | |
| 5728 | root | localhost:2425 | | Query | 0 | | show processlist |
| 5732 | root | localhost:2430 | cnbaidou | Sleep | 0 | | |
| 5731 | root | localhost:2429 | cnbaidou | Sleep | 0 | | |
| 5730 | unauthenticated user | localhost:2426 | | Connect | | Reading from net | |
+------+----------------------+----------------+--------+---------+------+------------------+------------------------------------------------------------------------------------------------------+
解决方案 »
- 锁表操作
- 求救 批量添加字段
- 请教两个表之间的怎样建立条件关系问题
- marked as crashed and should be repaired 错误如何解决呢
- 求sql语句,left join
- 向ACMAIN_CHM请教
- xp 中的dos 命令提示符窗口不能输入中文了?
- 我的MySql事务处理(可以支持事务处理及数据库路径自己定义)与大家共享
- 请问下谁有介绍mysql的ebook
- mysql服务启动怪异的问题!在线等待!!
- 请问mysql中能不能删除unicode约束?如果能的话该如何删除?
- Can't connect to MySQL server on 'localhost' (10048) (附详细说明)
看看单独执行此查询需要多长时间?是否需要优化?新建索引可提高查询速度。分析:
explain select * from daycount where menutype = '34 ' and dc_type like '%p% ' order by dc_count desc