Error while sending QUERY packet when SHOW TABLES LIKE

Question

since few weeks sometimes I got the following mysql error in the application logs.

Error while sending QUERY packet

My first idea is increasing the max_allow_packet Variable in the configuration of our percona mysql server which returns the error. I have done this now and no idea if it helps, but, what's strange: the error occurs only when querying as follow (and only sometimes):

SHOW TABLES LIKE "rk_temp_a7401345"

Strange because the database has round about 950 tables, but how could this be related to max_allowed_packet?

Any suggestions?

Best Marc

score 1 · Answer 1 · edited Mar 13 '18 at 21:19

1

See this link to find out how big the output would be.

Show Databases/Tables INTO OUTFILE

In your SESSION, SET @max_allowed_packet=(size+10%); then your SHOW TABLES rather than using this size in your my.cnf/ini which is a PER CONNECTION RAM possible requirement.

edited Mar 13 '18 at 21:19

rollstuhlfahrer

3,988
9
25
38

answered Mar 13 '18 at 21:15

Wilson Hauck

2,094
1
11
19

The output is empty since the Tablet does not exist. – proxi Mar 21 '18 at 15:16
@proxi the word Tablet is not in any information posted that I can see. Everything is tables oriented. – Wilson Hauck Mar 21 '18 at 15:28
@WilsonHauck with over "30 years experience" you couldn't discern that he meant "table" and not "Tablet"? – Mike Kormendy May 26 '18 at 15:00

Error while sending QUERY packet when SHOW TABLES LIKE

1 Answers1