Jatin Davey SHOW FULL COLUMNS QUERIES hogging my CPU
Jun 02, 2014; 19:05
Jatin Davey
SHOW FULL COLUMNS QUERIES hogging my CPU
Hi All
I am no expert with mysql and databases. Hence seeking out some help on this forum.
Basically i got a query dump of my application during its operation. I had collected the queries for about 4 hours. Ran some scripts on the number of queries being sent to the databases.
The query file was a whopping 4 GB is size. Upon analyzing the queries i found that there were a total of 30 million queries made to the Database out of which 10 million queries were only doing "SHOW FULL COLUMN" queries.
The SHOW FULL COLUMN queries were of the format as below:
SHOW FULL COLUMNS FROM `APIC_PHY_FABRIC_PHYSICAL_INTERFACE` FROM `db_private_admin` LIKE '%'
This is causing considerable cpu usage in %user_time in my system. As a result it is killing my system and i am unable to scale for more load. I looked if there is any code in my app that is doing these queries and found nothing. Could some one let me know how i can get rid of these queries being sent to the DB.
I am using mysql server version: 5.6.10-enterprise-commercial-advanced
Please let me know if any more information is required.
Appreciate your help in this regard.
Thanks Jatin
Jun 02
Reindl Harald Re: SHOW FULL COLUMNS QUERIES hogging my CPU
Jun 02, 2014; 15:48
Reindl Harald
Re: SHOW FULL COLUMNS QUERIES hogging my CPU
Jun 02
Jatin Davey Re: SHOW FULL COLUMNS QUERIES hogging my CPU
Jun 02, 2014; 19:51
Jatin Davey
Re: SHOW FULL COLUMNS QUERIES hogging my CPU
Jun 02
Michael Dykman Re: SHOW FULL COLUMNS QUERIES hogging my CPU
Jun 02, 2014; 10:43
Michael Dykman
Re: SHOW FULL COLUMNS QUERIES hogging my CPU
Jun 02
Singer Wang Re: SHOW FULL COLUMNS QUERIES hogging my CPU
Jun 02, 2014; 10:47
Singer Wang
Re: SHOW FULL COLUMNS QUERIES hogging my CPU
Jun 02
Jatin Davey Re: SHOW FULL COLUMNS QUERIES hogging my CPU
Jun 02, 2014; 20:22
Jatin Davey
Re: SHOW FULL COLUMNS QUERIES hogging my CPU
Jun 02
Jatin Davey Re: SHOW FULL COLUMNS QUERIES hogging my CPU
Jun 02, 2014; 20:25
Jatin Davey
Re: SHOW FULL COLUMNS QUERIES hogging my CPU
Jun 02
Jatin Davey Re: SHOW FULL COLUMNS QUERIES hogging my CPU
Jun 02, 2014; 20:26
Jatin Davey
Re: SHOW FULL COLUMNS QUERIES hogging my CPU
Jun 02
Morgan Tocker Re: SHOW FULL COLUMNS QUERIES hogging my CPU
Jun 02, 2014; 08:40
Morgan Tocker
Re: SHOW FULL COLUMNS QUERIES hogging my CPU
Jun 02
Johan De Meersman Re: SHOW FULL COLUMNS QUERIES hogging my CPU
Jun 02, 2014; 18:00
Johan De Meersman
Re: SHOW FULL COLUMNS QUERIES hogging my CPU
Jun 03
Johan De Meersman Re: SHOW FULL COLUMNS QUERIES hogging my CPU
Jun 03, 2014; 13:17
Johan De Meersman
Re: SHOW FULL COLUMNS QUERIES hogging my CPU
Jun 03
Jatin Davey Re: SHOW FULL COLUMNS QUERIES hogging my CPU
Jun 03, 2014; 17:07
Jatin Davey
Re: SHOW FULL COLUMNS QUERIES hogging my CPU
Jun 03
Jatin Davey Re: SHOW FULL COLUMNS QUERIES hogging my CPU
Jun 03, 2014; 17:21
Jatin Davey
Re: SHOW FULL COLUMNS QUERIES hogging my CPU
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!