Miclebrick
11/08/2018, 3:06 AMSHOW PROCESSLIST
& SHOW ENGINE INNODB STATUS
output via CLI this time: https://gist.github.com/Miclebrick/8622e4542a7f246bb1f3a8dcda951ba7 Can anyone help me out?tapac
11/08/2018, 5:46 AMMiclebrick
11/08/2018, 11:09 PMcommit()
cause this?tapac
11/09/2018, 9:09 AMSHOW ENGINE INNODB STATUS
under test
user while most of queries made by root
user.
Could you show result of show variables like 'max_connections'
?Miclebrick
11/13/2018, 11:37 AMtapac
11/16/2018, 6:23 AMSHOW PROCESSLIST
output?
2. Could you connect as root
user and make SHOW ENGINE INNODB STATUS
3. Do you use only test
user connections in your app or also root
users?Miclebrick
11/17/2018, 3:10 AMtapac
11/21/2018, 9:01 AMuuid
fields?Miclebrick
11/21/2018, 7:07 PMtapac
11/22/2018, 11:02 AMSHOW CREATE TABLE _table_name_
to see full table creation script with all indices/keys.
Could you tell me,
INSERT INTO plan_ping (user_id, server_id, date, min_ping, max_ping, avg_ping) VALUES ((SELECT plan_users.id FROM plan_users WHERE (uuid='aced95a8-422a-483c-99ed-611759f0dcad') LIMIT 1), (SELECT plan_servers.id FROM plan_servers WHERE (plan_servers.uuid='7db4c4e5-248e-37a8-a3e1-1d6f88840218') LIMIT 1), 1542424198514, 86, 87, 86.0)
is written on Exposed?Miclebrick
11/23/2018, 3:24 AM