The ONLY slow query is
Code:
SELECT * FROM video WHERE username = 'XXXXX';
I need that query because i need to count the rows, therefore be able to count how many videos a user uploaded.
the member XXXXX has 117738 videos in total...
Any help?
PS:
The server is a private server..
512 MB RAM and 1GHZ CPU
Here is the slow queries log
Code:
# Time: 091129 19:37:34
# User@Host: lucky_fb[lucky_fb] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 117733 Rows_examined: 117738
use lucky_XXXXX;
SELECT * FROM video WHERE username = 'XXXXX';
# Time: 091129 19:37:45
# User@Host: lucky_fb[lucky_fb] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 117733 Rows_examined: 117738
SELECT * FROM video WHERE username = 'XXXXX';
# Time: 091129 19:38:06
# User@Host: lucky_fb[lucky_fb] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 117733 Rows_examined: 117738
SELECT * FROM video WHERE username = 'XXXXX';
# Time: 091129 19:38:42
# User@Host: lucky_fb[lucky_fb] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 117733 Rows_examined: 117738
SELECT * FROM video WHERE username = 'XXXXX';
# Time: 091129 19:39:00
# User@Host: lucky_fb[lucky_fb] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 117733 Rows_examined: 117738
SELECT * FROM video WHERE username = 'XXXXX';
# Time: 091129 19:39:04
# User@Host: lucky_fb[lucky_fb] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 117733 Rows_examined: 117738
SELECT * FROM video WHERE username = 'XXXXX';
# Time: 091129 19:39:25
# User@Host: lucky_fb[lucky_fb] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 117733 Rows_examined: 117738
SELECT * FROM video WHERE username = 'XXXXX';
# Time: 091129 19:39:34
# User@Host: lucky_fb[lucky_fb] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 117733 Rows_examined: 117738
SELECT * FROM video WHERE username = 'XXXXX';
# Time: 091129 19:39:55
# User@Host: lucky_fb[lucky_fb] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 117733 Rows_examined: 117738
SELECT * FROM video WHERE username = 'XXXXX';
# Time: 091129 19:40:20
# User@Host: lucky_fb[lucky_fb] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 117733 Rows_examined: 117738
SELECT * FROM video WHERE username = 'XXXXX';
# Time: 091129 19:40:51
# User@Host: lucky_fb[lucky_fb] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 117733 Rows_examined: 117738
SELECT * FROM video WHERE username = 'XXXXX';
# Time: 091129 19:41:29
# User@Host: lucky_fb[lucky_fb] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 117733 Rows_examined: 117738
SELECT * FROM video WHERE username = 'XXXXX';
# Time: 091129 19:43:14
# User@Host: lucky_fb[lucky_fb] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 117733 Rows_examined: 117738
SELECT * FROM video WHERE username = 'XXXXX';
# Time: 091129 19:43:25
# User@Host: lucky_fb[lucky_fb] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 117733 Rows_examined: 117738
SELECT * FROM video WHERE username = 'XXXXX';
# Time: 091129 19:43:50
# User@Host: lucky_fb[lucky_fb] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 117733 Rows_examined: 117738
SELECT * FROM video WHERE username = 'XXXXX';
# Time: 091129 19:44:00
# User@Host: lucky_fb[lucky_fb] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 117733 Rows_examined: 117738
SELECT * FROM video WHERE username = 'XXXXX';
dBforums
>
Slow queries.. Cant think of a solution
11-29-09, 22:48
Linear Mode
