mardi 3 mars 2015

MySQL Workbench secretly running SHOW INDEX after every query


A few days ago, I revised some innodb_stats_* parameters and ran mysqlcheck --analyze --all-databases on some Percona 5.5.38 servers. Now, whenever I execute any simple query in MySQL Workbench, it seems to execute a background query of SHOW INDEX ON t1; Needless to say, this caused some issues when it blocked updates to the table on production servers.


I have ascertained these things: 1) it happens with any account with sufficient priviledges 2) it doesn't happen from the command line 3) it happens for other users 4) it happens even after I upgrade to 6.2.4 and delete all the settings 5) it DOESN'T happen against my Percona 5.6 database 6) SHOW INDEX starts about 5 seconds AFTER my query


I haven't been able to find any explanation for this behavior on the net, so wanted to see if any experienced DBA's have run into this.


Current stats related settings:


innodb_stats_auto_update 0 innodb_stats_method nulls_equal innodb_stats_on_metadata ON innodb_stats_sample_pages 8 innodb_stats_update_need_lock 1 innodb_use_sys_stats_table OFF


Thanks for any pointers anyone can provide.





Aucun commentaire:

Enregistrer un commentaire