We are running Statslab 11 v2.2.0 beta in the GUBA. Recently we switched our ratings from 1-10 to 1-20.
Now I'm getting messages from my hosting service saying that the Development Update is running abnormally slow and causing a high load on the server:
Quote:
# Time: 120125 15:28:46
# User@Host: mikev_statslab[mikev_statslab] @ localhost []
# Thread_id: 8770138 Schema: mikev_statslab
# Query_time: 24.989241 Lock_time: 0.516042 Rows_sent: 22 Rows_examined: 2777961 Rows_affected: 0 Rows_read: 22
use mikev_statslab;
--
# Time: 120125 17:19:05
# User@Host: mikev_statslab[mikev_statslab] @ localhost []
# Thread_id: 8824650 Schema: mikev_statslab
# Query_time: 9.571378 Lock_time: 0.000067 Rows_sent: 22 Rows_examined: 2777961 Rows_affected: 0 Rows_read: 22
use mikev_statslab;
SELECT DISTINCT year FROM players_development ORDER BY year;
# User@Host: mikev_statslab[mikev_statslab] @ localhost []
# Thread_id: 8824238 Schema: mikev_statslab
# Query_time: 67.771235 Lock_time: 0.000045 Rows_sent: 22 Rows_examined: 2777961 Rows_affected: 0 Rows_read: 22
SELECT DISTINCT year FROM players_development ORDER BY year;
--
# Time: 120125 20:30:22
# User@Host: mikev_statslab[mikev_statslab] @ localhost []
# Thread_id: 8913333 Schema: mikev_statslab
# Query_time: 12.640040 Lock_time: 0.035106 Rows_sent: 22 Rows_examined: 2777961 Rows_affected: 0 Rows_read: 22
use mikev_statslab;
--
# Time: 120125 21:01:07
# User@Host: mikev_statslab[mikev_statslab] @ localhost []
# Thread_id: 8928368 Schema: mikev_statslab
# Query_time: 7.101949 Lock_time: 0.000036 Rows_sent: 22 Rows_examined: 2783292 Rows_affected: 0 Rows_read: 22
SELECT DISTINCT year FROM players_development ORDER BY year;
--
# Time: 120125 23:50:02
# User@Host: mikev_statslab[mikev_statslab] @ localhost []
# Thread_id: 9015930 Schema: mikev_statslab
# Query_time: 16.751881 Lock_time: 0.021958 Rows_sent: 22 Rows_examined: 2783292 Rows_affected: 0 Rows_read: 22
use mikev_statslab;
--
# Time: 120126 0:24:42
# User@Host: mikev_statslab[mikev_statslab] @ localhost []
# Thread_id: 9032508 Schema: mikev_statslab
# Query_time: 9.751383 Lock_time: 0.014868 Rows_sent: 22 Rows_examined: 2783292 Rows_affected: 0 Rows_read: 22
use mikev_statslab;
--
# Time: 120126 2:01:13
# User@Host: mikev_statslab[mikev_statslab] @ localhost []
# Thread_id: 9068513 Schema: mikev_statslab
# Query_time: 16.671415 Lock_time: 0.000037 Rows_sent: 22 Rows_examined: 2783292 Rows_affected: 0 Rows_read: 22
use mikev_statslab;
--
# Time: 120126 4:30:05
# User@Host: mikev_statslab[mikev_statslab] @ localhost []
# Thread_id: 9121038 Schema: mikev_statslab
# Query_time: 18.299787 Lock_time: 0.000041 Rows_sent: 22 Rows_examined: 2783292 Rows_affected: 0 Rows_read: 22
use mikev_statslab;
--
# Time: 120126 6:07:16
# User@Host: mikev_statslab[mikev_statslab] @ localhost []
# Thread_id: 9155964 Schema: mikev_statslab
# Query_time: 18.130149 Lock_time: 0.000033 Rows_sent: 22 Rows_examined: 2783292 Rows_affected: 0 Rows_read: 22
use mikev_statslab;
--
# Time: 120126 6:44:21
# User@Host: mikev_statslab[mikev_statslab] @ localhost []
# Thread_id: 9171540 Schema: mikev_statslab
# Query_time: 11.517437 Lock_time: 0.031952 Rows_sent: 22 Rows_examined: 2783292 Rows_affected: 0 Rows_read: 22
use mikev_statslab;
|
What I'm being told is that the dev update is an inefficient SQL query that needs to be optimized -- were any changes made to newer versions or would updating to Statslab12 make a difference?
Thanks