quering information_schema.tables appears to lock the database until Sequel Pro closes

[GoogleCodeExporter]

What steps will reproduce the problem?
1. run "SELECT table_schema, table_name, data_length, index_length FROM 
information_schema.tables" in SequelPro
2. try querying the same database server from another process ie webserver. Or 
open mysql from cli

What is the expected output?
Step 2 fails.

What do you see instead?
php: "Mysql server has gone away"
cli: mysql_native_passwordConnection closed by foreign host.

What version of Sequel Pro are you using?
1.0.2 (Build 4096)

What version of OS X are you using?
10.8.4

What version of MySQL are you connecting to on the server?
5.6.13

Original issue reported on code.google.com by cleggm...@gmail.com on 15 Aug 2013 at 10:24

[GoogleCodeExporter]

I am encountering this as well, but only for the PHP process, not for CLI. As 
soon as I open a database in Sequel Pro it becomes unaccessible to PHP PDO with 
the following errors:

Notice: PDO::__construct(): send of 91 bytes failed with errno=32 Broken pipe
PDOException: SQLSTATE[HY000] [2006] MySQL server has gone away

Using:
Sequel Pro 1.0.2 (Build 4096)
OS X 10.9.2
mysql  Ver 15.1 Distrib 5.5.34-MariaDB, for osx10.9 (i386) using readline 5.1

Original comment by dave.r...@lullabot.com on 4 Apr 2014 at 4:01

[GoogleCodeExporter]

Same here for Apache Tomcat Applications. As soon as you view the data of a DB 
Table, the table seems to be locked for the Application. Hibernate throws:

ERROR org.hibernate.util.JDBCExceptionReporter - Lock wait timeout exceeded; 
try restarting transaction

Please avoid any locks on tables / rows, otherwise Sequel Pro is heavily 
invasive.

Original comment by robertos...@gmail.com on 28 Nov 2014 at 10:11