Slow Query Log

This area is devoted to Multiple Wishlists. Please ask questions, report bugs and share ideas here.

Slow Query Log

Postby khutchings » Fri Nov 20, 2015 10:08 pm

Since our upgrade to Magento 1.9.2, a Slow Query log occurs whenever a customer uses their wishlist.
This is the query that causes the Slow Query log:

CREATE TABLE IF NOT EXISTS `itoris_installer_licenses` (
`pid` INT NOT NULL ,
`host` VARCHAR( 255 ) NOT NULL ,
`secret` VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( `pid` , `host` ) )
ENGINE = InnoDB

Can you please find a solution or provide an unencrypted version of the relevant files?
khutchings
 
Posts: 1
Joined: Fri Nov 20, 2015 9:58 pm

Re: Slow Query Log

Postby tstoffel » Mon Nov 23, 2015 9:54 pm

"CREATE TABLE IF NOT EXISTS itoris_installer_licenses" is running WAY TOO FREQUENTLY. It's taking WAY TOO LONG to complete and it's consuming WAY TOO MANY resources. Can this be addressed please?
tstoffel
 
Posts: 4
Joined: Tue Apr 15, 2014 5:02 am

Re: Slow Query Log

Postby IToris team » Tue Nov 24, 2015 12:50 am

Hi khutchings/tstoffel

The query is executed once per URL call. There is no "frequent" execution like you said.
We checked it on Multiple Wishlists. The SQL query was executed once when product added to wishlist. And once when wishlist viewed.
Though "CREATE TABLE IF NOT EXISTS" can be replaced with "SHOW TABLES" and parsed to check if the table exists. But the query won't be lighter or faster.

Best regards,
ITORIS team
IToris team
Site Admin
 
Posts: 1685
Joined: Mon Jan 19, 2009 12:33 pm

Re: Slow Query Log

Postby tstoffel » Sun Nov 29, 2015 4:30 am

The CREATE TABLE syntax is causing the MySQL to choke on the "checking permissions" state. This is the only extension or query on our server that causes this. The frequency of the query is determined by the popularity of the feature and the number of visitors to the site. So in our case, yes, it is frequent.
tstoffel
 
Posts: 4
Joined: Tue Apr 15, 2014 5:02 am

Re: Slow Query Log

Postby IToris team » Mon Nov 30, 2015 9:51 pm

Hi tstoffel,

We have released v2.3.1 of the installer. The "CREATE TABLE IF NOT EXISTS" query replaced with "SHOW TABLES". The check is performed once per PHP session creation.
Please update the extension in Magento backend at System -> IToris Extensions -> IToris Store.

Best regards,
Roman
http://www.itoris.com
IToris team
Site Admin
 
Posts: 1685
Joined: Mon Jan 19, 2009 12:33 pm


Return to Multiple Wishlists

Who is online

Users browsing this forum: No registered users and 1 guest

cron