MySQL spori upiti - profiling status statisticsImam problem sa sporim MySQL upitima na shared serveru. Čak i najjednostavniji upiti postali su jako spori, i zbog toga mi je suspendovan nalog jer sam prekoračio 25% CPU.
Uključio sam profiling u phpmyadminu i video da status statistics izaziva problem. Da li neko zna šta je to tačno i kako da rešim problem?
Probni upit: SELECT * FROM knjige WHERE knjiga_id = '3654' (knjiga_id je primarni ključ, a tabela sadrži oko 5000 redova)
Showing rows 0 - 0 (1 total, Query took 0.4055 sec)
Code:
Profiling
Status Time
starting 0.000055
checking query cache for query 0.000062
checking permissions 0.000008
Opening tables 0.000016
System lock 0.000008
Table lock 0.000029
init 0.000035
optimizing 0.000012
statistics 0.171993
preparing 0.000050
executing 0.000006
Sending data 0.000027
end 0.000008
query end 0.000007
freeing items 0.000293
storing result in query cache 0.000027
logging slow query 0.000005
cleaning up 0.000005
Profiling
Status Time
starting 0.000055
checking query cache for query 0.000062
checking permissions 0.000008
Opening tables 0.000016
System lock 0.000008
Table lock 0.000029
init 0.000035
optimizing 0.000012
statistics 0.171993
preparing 0.000050
executing 0.000006
Sending data 0.000027
end 0.000008
query end 0.000007
freeing items 0.000293
storing result in query cache 0.000027
logging slow query 0.000005
cleaning up 0.000005
Kada nakon ovoga odmah pokrenem isti upit, tek onda je vreme učitavanja kako bi trebalo da bude:
Showing rows 0 - 0 (1 total, Query took 0.0002 sec)
Code:
Status Time
starting 0.000030
checking query cache for query 0.000007
checking privileges on cached 0.000005
checking permissions 0.000006
sending cached result to clien 0.000011
logging slow query 0.000004
cleaning up 0.000005
Status Time
starting 0.000030
checking query cache for query 0.000007
checking privileges on cached 0.000005
checking permissions 0.000006
sending cached result to clien 0.000011
logging slow query 0.000004
cleaning up 0.000005
Ovi iz hostinga su jako nesposobni i govore mi da je problem u mojim php skriptama. Puno bi mi značila pomoć oko ovoga.
Hvala unapred!
