Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

X-Cart 4.7.10 released
 
Reply
   X-Cart forums > News and Announcements
 
Thread Tools
  #21  
Old 10-29-2018, 12:32 AM
 
aim aim is online now
Advanced Staff Users
 

X-Cart team
  
Join Date: Dec 2008
Posts: 843
 

Default Re: X-Cart 4.7.10 released

Quote:
Originally Posted by Sembroidery
On a store updated from older versions some (a few) tables show InnoDB while others are MyISAM. Would it be recommended to switch all tables to InnoDB?

Hello,

It is definitely recommended in 3 cases.

1) You are using the newest MySQL/MariaDB version.

or
2) You are experiencing the loss of productivity due to the Meltdown Fix.
https://forums.mysql.com/read.php?21,664350,664350#msg-664350

or
3) You are experiencing the MySQL error 'MySQL table is marked as crashed and should be repaired'
https://confluence.atlassian.com/confkb/mysql-table-is-marked-as-crashed-and-should-be-repaired-151519802.html

In other cases, it is recommended to measure the BEFORE/AFTER performance on a dev server.

Thank you.
__________________
Sincerely yours,
Ildar Amankulov
Head of Maintenance group
Reply With Quote

The following 2 users thank aim for this useful post:
cherie (10-29-2018), kevfromwiganinlancashire (11-06-2018)
  #22  
Old 10-29-2018, 01:30 AM
 
Sembroidery Sembroidery is offline
 

eXpert
  
Join Date: Oct 2003
Posts: 330
 

Default Re: X-Cart 4.7.10 released

For the past few days we're experiencing periodical site outages. Host support staff claim the reason most probably was very high bot activity with bots hitting the site and tying up MySQL queries.
As one of the measures they suggest switching from MyISAM to InnoDB.

Are there any changes in 4.7.10 as compared to 4.7.9 that would cause issues if x-cart is subjected to high bot activity?
__________________
X-Cart 4.7.10 Live
OS: Linux
Reply With Quote
  #23  
Old 10-29-2018, 02:22 AM
 
aim aim is online now
Advanced Staff Users
 

X-Cart team
  
Join Date: Dec 2008
Posts: 843
 

Default Re: X-Cart 4.7.10 released

Quote:
Originally Posted by Sembroidery
For the past few days we're experiencing periodical site outages. Host support staff claim the reason most probably was very high bot activity with bots hitting the site and tying up MySQL queries.
As one of the measures they suggest switching from MyISAM to InnoDB.

Are there any changes in 4.7.10 as compared to 4.7.9 that would cause issues if x-cart is subjected to high bot activity?


Maybe your SEO position has been improved due to some of these changes.

Code:
[*] 25 Sep 2018, aim - Improvement (Y:148652): [SEO] Google PageSpeed Insights improvement. CSS Delivery Optimization. Prioritization of visible content. Reduction in the size of the above-the-fold content. [*] 23 Jul 2018, aim - Improvement (Y:148676, Y:148675): Optimization for product's widgets like New Arrivals/Bestsellers/Upselling products and so on. [SEO] Google PageSpeed Insights improvement. [*] 03 Jul 2018, aim - Improvement (Y:148675, Y:148676): [Advanced_Customer_Reviews] Huge optimization for customer reviews menu. [SEO] Google PageSpeed Insights improvement. [*] 22 Mar 2018, aim - Improvement (Y:148619): [SEO] Google PageSpeed Insights improvement. Added minification for CSS + JavaScript resources.[ Minify Resources] [*] 22 Aug 2018, aim - Improvement (Y:148687, B:0049702): Cookies are now secure and satisfy the PCI Compliance requirement. Only for stores with configured HTTPS. Thanks to Joe Funderburg (Cherie). https://help.x-cart.com/index.php?title=X-Cart:Configuring_HTTPS


It seems you are in the green zone
there
https://developers.google.com/speed/pagespeed/insights/

Could you ask your hosting for the bot's HTTP_USER_AGENT?
Maybe our XCRobots::getRobotsSignatures() method has to be corrected.
It should help to reduce the amount of MySQL queries.


Thank you.
__________________
Sincerely yours,
Ildar Amankulov
Head of Maintenance group
Reply With Quote
  #24  
Old 10-29-2018, 07:39 AM
 
Dougrun Dougrun is online now
 

X-Adept
  
Join Date: Apr 2012
Posts: 632
 

Default Re: X-Cart 4.7.10 released

I'v been having sql errors ever since this update. Today i was locked out of admin after a xcart_sessions_data sql error. Repairing the tables fixed it.



Not sure if it matters but its a InnoDB table. Most of my tables are MyISAM. I'm running 10.2.18-MariaDB



It should be noted that I also updated to the latest MariaDB just before the update
__________________
4.7.x xcart store
Business 5.3xx
Reply With Quote
  #25  
Old 10-29-2018, 07:50 AM
 
Sembroidery Sembroidery is offline
 

eXpert
  
Join Date: Oct 2003
Posts: 330
 

Default Re: X-Cart 4.7.10 released

Quote:
Originally Posted by aim
Maybe your SEO position has been improved due to some of these changes.


It seems you are in the green zone
there
https://developers.google.com/speed/pagespeed/insights/

Could you ask your hosting for the bot's HTTP_USER_AGENT?
Maybe our XCRobots::getRobotsSignatures() method has to be corrected.
It should help to reduce the amount of MySQL queries.


Thank you.

Google page speed insight results have in fact improved drastically both for mobile and desktop. Thanks for that!

The most heavily active bots for the past few days were MJ12bot (200K+ hits & 4.8+ gigs), Semrushbot, Baidu, and some others. There are a couple of Unknown bots as well.
__________________
X-Cart 4.7.10 Live
OS: Linux
Reply With Quote

The following user thanks Sembroidery for this useful post:
aim (10-29-2018)
  #26  
Old 10-29-2018, 08:29 AM
 
Dougrun Dougrun is online now
 

X-Adept
  
Join Date: Apr 2012
Posts: 632
 

Default Re: X-Cart 4.7.10 released

Quote:
Originally Posted by aim
Hello,

It is definitely recommended in 3 cases.

1) You are using the newest MySQL/MariaDB version.

or
2) You are experiencing the loss of productivity due to the Meltdown Fix.
https://forums.mysql.com/read.php?21,664350,664350#msg-664350

or
3) You are experiencing the MySQL error 'MySQL table is marked as crashed and should be repaired'
https://confluence.atlassian.com/confkb/mysql-table-is-marked-as-crashed-and-should-be-repaired-151519802.html

In other cases, it is recommended to measure the BEFORE/AFTER performance on a dev server.

Thank you.




is it safe to run

Code:
ALTER TABLE table_name ENGINE=InnoDB;


on a live shop (assuming I close the shop)
__________________
4.7.x xcart store
Business 5.3xx
Reply With Quote

The following user thanks Dougrun for this useful post:
aim (10-29-2018)
  #27  
Old 10-29-2018, 01:33 PM
  cherie's Avatar 
cherie cherie is online now
 

X-Wizard
  
Join Date: May 2003
Location: USA
Posts: 1,532
 

Default Re: X-Cart 4.7.10 released

Quote:
Originally Posted by Dougrun
is it safe to run

Code:
ALTER TABLE table_name ENGINE=InnoDB;
on a live shop (assuming I close the shop)
Yep, that looks right. Just make sure the table is backed up first.

Here is more info on InnoDB: https://dev.mysql.com/doc/refman/5.5/en/innodb-introduction.html
__________________
redli.me | xcarthelp.com
custom mods and design integration
4.7 linux
Reply With Quote

The following user thanks cherie for this useful post:
aim (10-29-2018)
  #28  
Old 10-30-2018, 12:05 AM
 
aim aim is online now
Advanced Staff Users
 

X-Cart team
  
Join Date: Dec 2008
Posts: 843
 

Default Re: X-Cart 4.7.10 released

Quote:
Originally Posted by Dougrun
I'v been having sql errors ever since this update. Today i was locked out of admin after a xcart_sessions_data sql error. Repairing the tables fixed it.

Not sure if it matters but its a InnoDB table. Most of my tables are MyISAM. I'm running 10.2.18-MariaDB

It should be noted that I also updated to the latest MariaDB just before the update


Quote:
Originally Posted by Sembroidery
Google page speed insight results have in fact improved drastically both for mobile and desktop. Thanks for that!

The most heavily active bots for the past few days were MJ12bot (200K+ hits & 4.8+ gigs), Semrushbot, Baidu, and some others. There are a couple of Unknown bots as well.

Hello,

I have uploaded a patch to update the bot signatures.

It will prevent xcart_sessions_data table overload.

Thank you.
__________________
Sincerely yours,
Ildar Amankulov
Head of Maintenance group
Reply With Quote

The following 5 users thank aim for this useful post:
cherie (10-30-2018), Dougrun (10-30-2018), elmirage001 (10-30-2018), PhilJ (11-01-2018), Sembroidery (10-30-2018)
  #29  
Old 10-30-2018, 01:33 AM
 
Sembroidery Sembroidery is offline
 

eXpert
  
Join Date: Oct 2003
Posts: 330
 

Default Re: X-Cart 4.7.10 released

Thank you very much for the patch!

Quote:
Originally Posted by aim
Hello,

It is definitely recommended in 3 cases.

1) You are using the newest MySQL/MariaDB version.

or
2) You are experiencing the loss of productivity due to the Meltdown Fix.
https://forums.mysql.com/read.php?21,664350,664350#msg-664350

or
3) You are experiencing the MySQL error 'MySQL table is marked as crashed and should be repaired'
https://confluence.atlassian.com/confkb/mysql-table-is-marked-as-crashed-and-should-be-repaired-151519802.html

In other cases, it is recommended to measure the BEFORE/AFTER performance on a dev server.

Thank you.

The MySQL version is 5.5.61-cll. Host support did not report problems as per 2) and 3). I don't think that we can do dev server testing, because in order to have realistic results to compare, we'll have to duplicate our site on the Internet which does not sound like a good idea to me.

We could eventually switch our site to use an InnoDB copy of the database for a while to see what happens. Wonder would it be wise to do it?
__________________
X-Cart 4.7.10 Live
OS: Linux
Reply With Quote
  #30  
Old 10-30-2018, 02:19 AM
 
aim aim is online now
Advanced Staff Users
 

X-Cart team
  
Join Date: Dec 2008
Posts: 843
 

Default Re: X-Cart 4.7.10 released

Quote:
Originally Posted by Sembroidery
The MySQL version is 5.5.61-cll. Host support did not report problems as per 2) and 3). I don't think that we can do dev server testing, because in order to have realistic results to compare, we'll have to duplicate our site on the Internet which does not sound like a good idea to me.


We could eventually switch our site to use an InnoDB copy of the database for a while to see what happens. Wonder would it be wise to do it?

InnoDB in MySQL 5.5 has some limitations which have to be checked by technical staff.
https://stackoverflow.com/questions/15678406/when-to-use-myisam-and-innodb
https://dba.stackexchange.com/questions/22678/when-to-switch-from-myisam-to-innodb

Please contact our support staff at https://secure.x-cart.com/ - I'm not sure if this is something that can be solved via a forum discussion, unfortunately.

Thank you.
__________________
Sincerely yours,
Ildar Amankulov
Head of Maintenance group
Reply With Quote

The following user thanks aim for this useful post:
cherie (10-30-2018)
Reply
   X-Cart forums > News and Announcements


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 09:57 PM.

   

 
X-Cart forums © 2001-2018