mysql慢查询记录！

我用mysql的慢查询记录功能记录了以下内容：

1. C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.81-community-nt-log (MySQL Community Edition (GPL)). started with:
   
2. TCP Port: 3306, Named Pipe: (null)
   
3. Time Id Command Argument
   
4. # Time: 091207 11:56:14
   
5. # User@Host: [wxl] @ [127.0.0.1]
   
6. # Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 24301
   
7. use sqllovelovel;
   
8. SELECT p.pid, p.tid, p.subject, p.message
   
9. FROM cdb_posts p
   
10. WHERE p.invisible='0' AND p.bbcodeoff<>'1' AND p.message LIKE '%[img%[/img]%' AND p.first='1'
    
11. ORDER BY p.dateline DESC
    
12. LIMIT 0, 10;
    
13. # Time: 091207 13:03:44
    
14. # User@Host: [wxl] @ [127.0.0.1]
    
15. # Query_time: 5 Lock_time: 0 Rows_sent: 10 Rows_examined: 24372
    
16. SELECT p.pid, p.tid, p.subject, p.message
    
17. FROM cdb_posts p
    
18. WHERE p.invisible='0' AND p.bbcodeoff<>'1' AND p.message LIKE '%[img%[/img]%' AND p.first='1'
    
19. ORDER BY p.dateline DESC
    
20. LIMIT 0, 10;
    
21. # Time: 091207 14:05:13
    
22. # User@Host: [wxl] @ [127.0.0.1]
    
23. # Query_time: 5 Lock_time: 0 Rows_sent: 10 Rows_examined: 24416
    
24. SELECT p.pid, p.tid, p.subject, p.message
    
25. FROM cdb_posts p
    
26. WHERE p.invisible='0' AND p.bbcodeoff<>'1' AND p.message LIKE '%[img%[/img]%' AND p.first='1'
    
27. ORDER BY p.dateline DESC
    
28. LIMIT 0, 10;
    
29. # Time: 091207 16:22:43
    
30. # User@Host: [wxl] @ [127.0.0.1]
    
31. # Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 24436
    
32. SELECT p.pid, p.tid, p.subject, p.message
    
33. FROM cdb_posts p
    
34. WHERE p.invisible='0' AND p.bbcodeoff<>'1' AND p.message LIKE '%[img%[/img]%' AND p.first='1'
    
35. ORDER BY p.dateline DESC
    
36. LIMIT 0, 10;
    
37. # Time: 091207 18:28:03
    
38. # User@Host: [wxl] @ [127.0.0.1]
    
39. # Query_time: 4 Lock_time: 0 Rows_sent: 10 Rows_examined: 24444
    
40. SELECT p.pid, p.tid, p.subject, p.message
    
41. FROM cdb_posts p
    
42. WHERE p.invisible='0' AND p.bbcodeoff<>'1' AND p.message LIKE '%[img%[/img]%' AND p.first='1'
    
43. ORDER BY p.dateline DESC
    
44. LIMIT 0, 10;
    
45. # Time: 091207 18:44:07
    
46. # User@Host: [wxl] @ [127.0.0.1]
    
47. # Query_time: 5 Lock_time: 0 Rows_sent: 117 Rows_examined: 117
    
48. SHOW TABLE STATUS LIKE 'cdb_%';
    

复制代码

谁能给我下解决方法？

不知道啊~~~~~~