[2020-10-07 18:05:34.598] [000001] [Local_base] [MYSQL] SHOW VARIABLES LIKE 'lower_case_%' [2020-10-07 18:05:34.601] [000001] [Local_base] [MYSQL] SHOW VARIABLES LIKE 'profiling' [2020-10-07 18:05:34.602] [000001] [Local_base] [MYSQL] SHOW DATABASES [2020-10-07 18:05:38.386] [000002] [Local_base] [MYSQL] SELECT @@character_set_database, @@collation_database [2020-10-07 18:05:38.391] [000002] [Local_base] [MYSQL] SHOW FULL TABLES WHERE Table_type != 'VIEW' [2020-10-07 18:05:43.058] [000003] [Local_base] [MYSQL] SHOW FULL TABLES FROM `pizarra` WHERE Table_type != 'VIEW' [2020-10-07 18:05:43.062] [000003] [Local_base] [MYSQL] SHOW FULL TABLES FROM `pizarra` WHERE Table_type = 'VIEW' [2020-10-07 18:05:43.064] [000003] [Local_base] [MYSQL] SHOW PROCEDURE STATUS WHERE Db='pizarra' [2020-10-07 18:05:43.510] [000003] [Local_base] [MYSQL] SHOW FUNCTION STATUS WHERE Db='pizarra' [2020-10-07 18:05:50.685] [000004] [Local_base] [MYSQL] SET PROFILING=1; [2020-10-07 18:05:50.685] [000004] [Local_base] [MYSQL] SHOW STATUS [2020-10-07 18:05:50.687] [000004] [Local_base] [MYSQL] SHOW STATUS [2020-10-07 18:05:50.715] [000004] [Local_base] [MYSQL] call sp_suerte [2020-10-07 18:07:13.373] [000005] [Local_base] [MYSQL] SHOW FULL TABLES FROM `pizarra` WHERE Table_type != 'VIEW' [2020-10-07 18:07:13.375] [000005] [Local_base] [MYSQL] SHOW FULL TABLES FROM `pizarra` WHERE Table_type = 'VIEW' [2020-10-07 18:07:13.379] [000005] [Local_base] [MYSQL] SHOW PROCEDURE STATUS WHERE Db='pizarra' [2020-10-07 18:07:13.474] [000005] [Local_base] [MYSQL] SHOW FUNCTION STATUS WHERE Db='pizarra' [2020-10-07 18:07:20.953] [000006] [Local_base] [MYSQL] SET PROFILING=1; [2020-10-07 18:07:20.953] [000006] [Local_base] [MYSQL] SHOW STATUS [2020-10-07 18:07:20.955] [000006] [Local_base] [MYSQL] SHOW STATUS [2020-10-07 18:07:20.980] [000006] [Local_base] [MYSQL] select * from numeros [2020-10-07 18:07:20.994] [000006] [Local_base] [MYSQL] SHOW STATUS [2020-10-07 18:07:20.996] [000006] [Local_base] [MYSQL] SELECT QUERY_ID, SUM(DURATION) AS SUM_DURATION FROM INFORMATION_SCHEMA.PROFILING GROUP BY QUERY_ID [2020-10-07 18:07:20.997] [000006] [Local_base] [MYSQL] SELECT STATE AS `State`, ROUND(SUM(DURATION),7) AS `Duration`, CONCAT(ROUND(SUM(DURATION)/0.002724*100,3), '%') AS `Percentage` FROM INFORMATION_SCHEMA.PROFILING WHERE QUERY_ID=3 GROUP BY STATE ORDER BY SEQ [2020-10-07 18:07:22.978] [000006] [Local_base] [MYSQL] SELECT * FROM `pizarra`.`numeros` LIMIT 0 [2020-10-07 18:07:22.979] [000006] [Local_base] [MYSQL] SHOW COLUMNS FROM `pizarra`.`numeros` [2020-10-07 18:10:21.526] [000003] [Local_base] [MYSQL] KILL 4 [2020-10-07 18:10:21.527] [000004] [Local_base] [MYSQL] 2013 - Lost connection to MySQL server during query [2020-10-07 18:10:27.131] [000004] [Local_base] [MYSQL] SET PROFILING=1; [2020-10-07 18:10:27.131] [000004] [Local_base] [MYSQL] 2006 - MySQL server has gone away [2020-10-07 18:10:27.136] [000007] [Local_base] [MYSQL] SET PROFILING=1; [2020-10-07 18:10:27.136] [000007] [Local_base] [MYSQL] SHOW STATUS [2020-10-07 18:10:27.139] [000007] [Local_base] [MYSQL] SHOW STATUS [2020-10-07 18:10:27.153] [000007] [Local_base] [MYSQL] call sp_suerte [2020-10-07 18:10:27.155] [000007] [Local_base] [MYSQL] 1050 - Table 'tmp_num' already exists [2020-10-07 18:10:33.665] [000002] [Local_base] [MYSQL] SHOW PROCEDURE STATUS WHERE Db='pizarra' [2020-10-07 18:10:33.674] [000002] [Local_base] [MYSQL] SHOW FUNCTION STATUS WHERE Db='pizarra' [2020-10-07 18:10:38.939] [000002] [Local_base] [MYSQL] SELECT * FROM information_schema.ROUTINES WHERE ROUTINE_SCHEMA='pizarra' AND ROUTINE_NAME='sp_suerte' AND ROUTINE_TYPE='PROCEDURE' ORDER BY ROUTINE_NAME [2020-10-07 18:10:38.950] [000002] [Local_base] [MYSQL] SHOW CREATE PROCEDURE `sp_suerte` [2020-10-07 18:10:38.964] [000008] [Local_base] [MYSQL] SHOW FULL TABLES FROM `pizarra` WHERE Table_type != 'VIEW' [2020-10-07 18:10:38.966] [000008] [Local_base] [MYSQL] SHOW FULL TABLES FROM `pizarra` WHERE Table_type = 'VIEW' [2020-10-07 18:10:38.968] [000008] [Local_base] [MYSQL] SHOW PROCEDURE STATUS WHERE Db='pizarra' [2020-10-07 18:10:38.977] [000008] [Local_base] [MYSQL] SHOW FUNCTION STATUS WHERE Db='pizarra' [2020-10-07 18:11:00.575] [000006] [Local_base] [MYSQL] SET PROFILING=1; [2020-10-07 18:11:00.576] [000006] [Local_base] [MYSQL] SHOW STATUS [2020-10-07 18:11:00.578] [000006] [Local_base] [MYSQL] SHOW STATUS [2020-10-07 18:11:00.596] [000006] [Local_base] [MYSQL] drop table tmp_num; [2020-10-07 18:11:00.655] [000006] [Local_base] [MYSQL] drop table tmp_result; [2020-10-07 18:11:00.698] [000006] [Local_base] [MYSQL] SHOW STATUS [2020-10-07 18:11:00.700] [000006] [Local_base] [MYSQL] SELECT QUERY_ID, SUM(DURATION) AS SUM_DURATION FROM INFORMATION_SCHEMA.PROFILING GROUP BY QUERY_ID [2020-10-07 18:11:00.700] [000006] [Local_base] [MYSQL] SELECT STATE AS `State`, ROUND(SUM(DURATION),7) AS `Duration`, CONCAT(ROUND(SUM(DURATION)/0.029691*100,3), '%') AS `Percentage` FROM INFORMATION_SCHEMA.PROFILING WHERE QUERY_ID=13 GROUP BY STATE ORDER BY SEQ [2020-10-07 18:11:03.800] [000007] [Local_base] [MYSQL] SET PROFILING=1; [2020-10-07 18:11:03.800] [000007] [Local_base] [MYSQL] SHOW STATUS [2020-10-07 18:11:03.802] [000007] [Local_base] [MYSQL] SHOW STATUS [2020-10-07 18:11:03.821] [000007] [Local_base] [MYSQL] call sp_suerte [2020-10-07 18:14:41.558] [000003] [Local_base] [MYSQL] KILL 7 [2020-10-07 18:14:41.558] [000007] [Local_base] [MYSQL] 2013 - Lost connection to MySQL server during query [2020-10-07 18:14:50.866] [000006] [Local_base] [MYSQL] SET PROFILING=1; [2020-10-07 18:14:50.866] [000006] [Local_base] [MYSQL] SHOW STATUS [2020-10-07 18:14:50.869] [000006] [Local_base] [MYSQL] SHOW STATUS [2020-10-07 18:14:50.892] [000006] [Local_base] [MYSQL] drop table tmp_num; [2020-10-07 18:14:51.022] [000006] [Local_base] [MYSQL] drop table tmp_result; [2020-10-07 18:14:51.093] [000006] [Local_base] [MYSQL] SHOW STATUS [2020-10-07 18:14:51.095] [000006] [Local_base] [MYSQL] SELECT QUERY_ID, SUM(DURATION) AS SUM_DURATION FROM INFORMATION_SCHEMA.PROFILING GROUP BY QUERY_ID [2020-10-07 18:14:51.096] [000006] [Local_base] [MYSQL] SELECT STATE AS `State`, ROUND(SUM(DURATION),7) AS `Duration`, CONCAT(ROUND(SUM(DURATION)/0.057662*100,3), '%') AS `Percentage` FROM INFORMATION_SCHEMA.PROFILING WHERE QUERY_ID=21 GROUP BY STATE ORDER BY SEQ [2020-10-07 18:14:56.737] [000006] [Local_base] [MYSQL] SET PROFILING=1; [2020-10-07 18:14:56.738] [000006] [Local_base] [MYSQL] SHOW STATUS [2020-10-07 18:14:56.741] [000006] [Local_base] [MYSQL] SHOW STATUS [2020-10-07 18:14:56.766] [000006] [Local_base] [MYSQL] select * from numeros [2020-10-07 18:14:56.788] [000006] [Local_base] [MYSQL] SHOW STATUS [2020-10-07 18:14:56.790] [000006] [Local_base] [MYSQL] SELECT QUERY_ID, SUM(DURATION) AS SUM_DURATION FROM INFORMATION_SCHEMA.PROFILING GROUP BY QUERY_ID [2020-10-07 18:14:56.792] [000006] [Local_base] [MYSQL] SELECT STATE AS `State`, ROUND(SUM(DURATION),7) AS `Duration`, CONCAT(ROUND(SUM(DURATION)/0.004879*100,3), '%') AS `Percentage` FROM INFORMATION_SCHEMA.PROFILING WHERE QUERY_ID=28 GROUP BY STATE ORDER BY SEQ [2020-10-07 18:14:56.952] [000006] [Local_base] [MYSQL] SELECT * FROM `pizarra`.`numeros` LIMIT 0 [2020-10-07 18:14:56.953] [000006] [Local_base] [MYSQL] SHOW COLUMNS FROM `pizarra`.`numeros` [2020-10-07 18:14:59.518] [000007] [Local_base] [MYSQL] SET PROFILING=1; [2020-10-07 18:14:59.518] [000007] [Local_base] [MYSQL] 2006 - MySQL server has gone away [2020-10-07 18:14:59.522] [000009] [Local_base] [MYSQL] SET PROFILING=1; [2020-10-07 18:14:59.522] [000009] [Local_base] [MYSQL] SHOW STATUS [2020-10-07 18:14:59.525] [000009] [Local_base] [MYSQL] SHOW STATUS [2020-10-07 18:14:59.540] [000009] [Local_base] [MYSQL] call sp_suerte_uno; [2020-10-07 18:15:18.747] [000009] [Local_base] [MYSQL] SHOW STATUS [2020-10-07 18:15:18.750] [000009] [Local_base] [MYSQL] SELECT QUERY_ID, SUM(DURATION) AS SUM_DURATION FROM INFORMATION_SCHEMA.PROFILING GROUP BY QUERY_ID [2020-10-07 18:15:18.751] [000009] [Local_base] [MYSQL] SELECT STATE AS `State`, ROUND(SUM(DURATION),7) AS `Duration`, CONCAT(ROUND(SUM(DURATION)/0.032661*100,3), '%') AS `Percentage` FROM INFORMATION_SCHEMA.PROFILING WHERE QUERY_ID=323 GROUP BY STATE ORDER BY SEQ [2020-10-07 18:15:31.121] [000009] [Local_base] [MYSQL] SET PROFILING=1; [2020-10-07 18:15:31.121] [000009] [Local_base] [MYSQL] SHOW STATUS [2020-10-07 18:15:31.123] [000009] [Local_base] [MYSQL] SHOW STATUS [2020-10-07 18:15:31.141] [000009] [Local_base] [MYSQL] call sp_suerte; [2020-10-07 18:26:44.576] [000009] [Local_base] [MYSQL] SHOW STATUS [2020-10-07 18:26:44.578] [000009] [Local_base] [MYSQL] SELECT QUERY_ID, SUM(DURATION) AS SUM_DURATION FROM INFORMATION_SCHEMA.PROFILING GROUP BY QUERY_ID [2020-10-07 18:26:44.578] [000009] [Local_base] [MYSQL] SELECT STATE AS `State`, ROUND(SUM(DURATION),7) AS `Duration`, CONCAT(ROUND(SUM(DURATION)/0.088065*100,3), '%') AS `Percentage` FROM INFORMATION_SCHEMA.PROFILING WHERE QUERY_ID=15671 GROUP BY STATE ORDER BY SEQ