API tools faq
paste
Advertisement
Guest User

mysql.query.log

a guest
Sep 21st, 2017
568
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.51 KB | None | 0 0
raw download clone embed print report
  1. 2017-09-21T17:12:04.799779Z 4 Connect root@172.20.0.3 on dotcms using TCP/IP
  2. 2017-09-21T17:12:04.804971Z 4 Query /* mysql-connector-java-5.1.37 ( Revision: 09940f05b4c98150f352e787a2549f11a2e9da93 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout
  3. 2017-09-21T17:12:04.822236Z 4 Query SELECT @@session.autocommit
  4. 2017-09-21T17:12:04.822704Z 4 Query SET NAMES utf8
  5. 2017-09-21T17:12:04.822942Z 4 Query SET character_set_results = NULL
  6. 2017-09-21T17:12:04.823305Z 4 Query SET autocommit=1
  7. 2017-09-21T17:12:04.835251Z 4 Query SELECT 1
  8. 2017-09-21T17:12:04.835921Z 4 Quit
  9. 2017-09-21T17:12:04.849903Z 5 Connect root@172.20.0.3 on dotcms using TCP/IP
  10. 2017-09-21T17:12:04.850605Z 5 Query /* mysql-connector-java-5.1.37 ( Revision: 09940f05b4c98150f352e787a2549f11a2e9da93 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout
  11. 2017-09-21T17:12:04.851278Z 5 Query SELECT @@session.autocommit
  12. 2017-09-21T17:12:04.851527Z 5 Query SET NAMES utf8
  13. 2017-09-21T17:12:04.851680Z 5 Query SET character_set_results = NULL
  14. 2017-09-21T17:12:04.851921Z 5 Query SET autocommit=1
  15. 2017-09-21T17:12:04.853067Z 5 Query SELECT 1
  16. 2017-09-21T17:12:04.971412Z 5 Query SELECT 1
  17. 2017-09-21T17:12:04.975488Z 5 Query select server_id, cluster_id, name, ip_address, host, cache_port, es_transport_tcp_port, es_network_port, es_http_port, key_, (select max(heartbeat) as last_heartbeat from cluster_server_uptime where server_id = s.server_id) as last_heartbeat from cluster_server s where s.server_id = '0b118661-fc3d-4787-82b4-9b648aa53e68'
  18. 2017-09-21T17:12:06.973065Z 5 Query select server_id, cluster_id, name, ip_address, host, cache_port, es_transport_tcp_port, es_network_port, es_http_port, key_, (select max(heartbeat) as last_heartbeat from cluster_server_uptime where server_id = s.server_id) as last_heartbeat from cluster_server s where s.server_id = '0b118661-fc3d-4787-82b4-9b648aa53e68'
  19. 2017-09-21T17:12:08.170484Z 2 Query SHOW /*!50002 FULL*/ TABLES
  20. 2017-09-21T17:12:08.172004Z 2 Query SELECT * FROM information_schema.routines WHERE routine_schema = 'dotcms' ORDER BY routine_name
  21. 2017-09-21T17:12:08.175299Z 3 Query SELECT SPECIFIC_NAME, ROUTINE_TYPE, DTD_IDENTIFIER, IS_DETERMINISTIC, SQL_DATA_ACCESS, SECURITY_TYPE, DEFINER FROM `information_schema`.`ROUTINES` WHERE `ROUTINE_SCHEMA` = 'dotcms'
  22. 2017-09-21T17:12:09.190601Z 2 Query SHOW /*!50002 FULL*/ TABLES
  23. 2017-09-21T17:12:09.192390Z 2 Query SELECT * FROM information_schema.routines WHERE routine_schema = 'dotcms' ORDER BY routine_name
  24. 2017-09-21T17:12:09.196014Z 3 Query SELECT SPECIFIC_NAME, ROUTINE_TYPE, DTD_IDENTIFIER, IS_DETERMINISTIC, SQL_DATA_ACCESS, SECURITY_TYPE, DEFINER FROM `information_schema`.`ROUTINES` WHERE `ROUTINE_SCHEMA` = 'dotcms'
  25. 2017-09-21T17:12:09.368588Z 2 Query SHOW /*!50002 FULL*/ TABLES
  26. 2017-09-21T17:12:09.370108Z 2 Query SELECT * FROM information_schema.routines WHERE routine_schema = 'dotcms' ORDER BY routine_name
  27. 2017-09-21T17:12:09.373358Z 3 Query SELECT SPECIFIC_NAME, ROUTINE_TYPE, DTD_IDENTIFIER, IS_DETERMINISTIC, SQL_DATA_ACCESS, SECURITY_TYPE, DEFINER FROM `information_schema`.`ROUTINES` WHERE `ROUTINE_SCHEMA` = 'dotcms'
  28. 2017-09-21T17:12:09.546013Z 2 Query SHOW /*!50002 FULL*/ TABLES
  29. 2017-09-21T17:12:09.547687Z 2 Query SELECT * FROM information_schema.routines WHERE routine_schema = 'dotcms' ORDER BY routine_name
  30. 2017-09-21T17:12:09.551050Z 3 Query SELECT SPECIFIC_NAME, ROUTINE_TYPE, DTD_IDENTIFIER, IS_DETERMINISTIC, SQL_DATA_ACCESS, SECURITY_TYPE, DEFINER FROM `information_schema`.`ROUTINES` WHERE `ROUTINE_SCHEMA` = 'dotcms'
  31. 2017-09-21T17:12:13.844307Z 6 Connect root@172.20.0.3 on dotcms using TCP/IP
  32. 2017-09-21T17:12:13.845314Z 6 Query /* mysql-connector-java-5.1.37 ( Revision: 09940f05b4c98150f352e787a2549f11a2e9da93 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout
  33. 2017-09-21T17:12:13.846137Z 6 Query SELECT @@session.autocommit
  34. 2017-09-21T17:12:13.846489Z 6 Query SET NAMES utf8
  35. 2017-09-21T17:12:13.846749Z 6 Query SET character_set_results = NULL
  36. 2017-09-21T17:12:13.847001Z 6 Query SET autocommit=1
  37. 2017-09-21T17:12:13.847584Z 6 Query SELECT 1
  38. 2017-09-21T17:12:13.847965Z 6 Query SET autocommit=0
  39. 2017-09-21T17:12:13.848591Z 6 Query select @@session.tx_read_only
  40. 2017-09-21T17:12:13.848935Z 6 Query lock table db_version write
  41. 2017-09-21T17:12:13.850314Z 6 Query rollback
  42. 2017-09-21T17:12:13.850730Z 6 Query SET default_storage_engine=INNODB
  43. 2017-09-21T17:12:13.851078Z 6 Query select @@session.tx_read_only
  44. 2017-09-21T17:12:13.851440Z 6 Query create table `db_version` (`db_version` integer unsigned not null,`date_update` datetime not null, primary key (`db_version`))
  45. 2017-09-21T17:12:13.863663Z 6 Query select @@session.tx_read_only
  46. 2017-09-21T17:12:13.863930Z 6 Query INSERT INTO db_version (db_version,date_update) VALUES (0,'2017-09-21')
  47. 2017-09-21T17:12:13.867969Z 6 Query commit
  48. 2017-09-21T17:12:13.868418Z 6 Query select @@session.tx_read_only
  49. 2017-09-21T17:12:13.868857Z 6 Query lock table db_version write
  50. 2017-09-21T17:12:13.871254Z 6 Query select max(db_version) as db_version from db_version
  51. 2017-09-21T17:12:14.066153Z 5 Query select server_id, cluster_id, name, ip_address, host, cache_port, es_transport_tcp_port, es_network_port, es_http_port, key_, (select max(heartbeat) as last_heartbeat from cluster_server_uptime where server_id = s.server_id) as last_heartbeat from cluster_server s where s.server_id = '0b118661-fc3d-4787-82b4-9b648aa53e68'
  52. 2017-09-21T17:12:14.342476Z 5 Query SELECT 1
  53. 2017-09-21T17:12:15.388877Z 5 Query SELECT 1
  54. 2017-09-21T17:12:15.389513Z 5 Query select companyhbm0_.companyId as companyId0_, companyhbm0_.key_ as key_0_, companyhbm0_.portalURL as portalURL0_, companyhbm0_.homeURL as homeURL0_, companyhbm0_.mx as mx0_, companyhbm0_.name as name0_, companyhbm0_.shortName as shortName0_, companyhbm0_.type_ as type_0_, companyhbm0_.size_ as size_0_, companyhbm0_.street as street0_, companyhbm0_.city as city0_, companyhbm0_.state as state0_, companyhbm0_.zip as zip0_, companyhbm0_.phone as phone0_, companyhbm0_.fax as fax0_, companyhbm0_.emailAddress as emailAd16_0_, companyhbm0_.authType as authType0_, companyhbm0_.autoLogin as autoLogin0_, companyhbm0_.strangers as strangers0_ from company companyhbm0_ where companyhbm0_.companyId='dotcms.org'
  55. 2017-09-21T17:12:15.461485Z 5 Query SELECT 1
  56. 2017-09-21T17:12:15.462111Z 5 Query select * from qrtz_triggers, qrtz_cron_triggers where (qrtz_triggers.job_group='User Job' or qrtz_triggers.job_group='Recurrent Campaign') and qrtz_triggers.job_group<>'PAUSED' and qrtz_triggers.start_time < 1506013935461 and qrtz_triggers.trigger_name=qrtz_cron_triggers.trigger_name and qrtz_triggers.trigger_group=qrtz_cron_triggers.trigger_group
  57. 2017-09-21T17:12:15.478449Z 5 Query SELECT 1
  58. 2017-09-21T17:12:15.479184Z 5 Query select server_id, cluster_id, name, ip_address, host, cache_port, es_transport_tcp_port, es_network_port, es_http_port, key_, (select max(heartbeat) as last_heartbeat from cluster_server_uptime where server_id = s.server_id) as last_heartbeat from cluster_server s where s.server_id = '0b118661-fc3d-4787-82b4-9b648aa53e68'
  59. 2017-09-21T17:12:24.857168Z 2 Query SHOW /*!50002 FULL*/ TABLES
  60. 2017-09-21T17:12:24.860756Z 2 Query SELECT * FROM information_schema.routines WHERE routine_schema = 'dotcms' ORDER BY routine_name
  61. 2017-09-21T17:12:24.863982Z 3 Query SHOW FULL COLUMNS FROM `db_version` FROM `dotcms`
  62. 2017-09-21T17:12:24.866278Z 3 Query SELECT SPECIFIC_NAME, ROUTINE_TYPE, DTD_IDENTIFIER, IS_DETERMINISTIC, SQL_DATA_ACCESS, SECURITY_TYPE, DEFINER FROM `information_schema`.`ROUTINES` WHERE `ROUTINE_SCHEMA` = 'dotcms'
  63. 2017-09-21T17:12:25.669343Z 2 Query SHOW /*!50002 FULL*/ TABLES
  64. 2017-09-21T17:12:25.673707Z 2 Query SELECT * FROM information_schema.routines WHERE routine_schema = 'dotcms' ORDER BY routine_name
  65. 2017-09-21T17:12:25.677184Z 3 Query SHOW FULL COLUMNS FROM `db_version` FROM `dotcms`
  66. 2017-09-21T17:12:25.678932Z 3 Query SELECT SPECIFIC_NAME, ROUTINE_TYPE, DTD_IDENTIFIER, IS_DETERMINISTIC, SQL_DATA_ACCESS, SECURITY_TYPE, DEFINER FROM `information_schema`.`ROUTINES` WHERE `ROUTINE_SCHEMA` = 'dotcms'
  67. 2017-09-21T17:12:25.878414Z 2 Query SHOW /*!50002 FULL*/ TABLES
  68. 2017-09-21T17:12:25.882435Z 2 Query SELECT * FROM information_schema.routines WHERE routine_schema = 'dotcms' ORDER BY routine_name
  69. 2017-09-21T17:12:25.885908Z 3 Query SHOW FULL COLUMNS FROM `db_version` FROM `dotcms`
  70. 2017-09-21T17:12:25.887758Z 3 Query SELECT SPECIFIC_NAME, ROUTINE_TYPE, DTD_IDENTIFIER, IS_DETERMINISTIC, SQL_DATA_ACCESS, SECURITY_TYPE, DEFINER FROM `information_schema`.`ROUTINES` WHERE `ROUTINE_SCHEMA` = 'dotcms'
  71. 2017-09-21T17:12:26.089257Z 2 Query SHOW /*!50002 FULL*/ TABLES
  72. 2017-09-21T17:12:26.093482Z 2 Query SELECT * FROM information_schema.routines WHERE routine_schema = 'dotcms' ORDER BY routine_name
  73. 2017-09-21T17:12:26.096953Z 3 Query SHOW FULL COLUMNS FROM `db_version` FROM `dotcms`
  74. 2017-09-21T17:12:26.098678Z 3 Query SELECT SPECIFIC_NAME, ROUTINE_TYPE, DTD_IDENTIFIER, IS_DETERMINISTIC, SQL_DATA_ACCESS, SECURITY_TYPE, DEFINER FROM `information_schema`.`ROUTINES` WHERE `ROUTINE_SCHEMA` = 'dotcms'
  75. 2017-09-21T17:13:34.861186Z 6 Query rollback
  76. 2017-09-21T17:13:34.861621Z 6 Quit
  77. 2017-09-21T17:13:34.863377Z 5 Quit
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!