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

X-cart 4.1.9 suddenly super slow on all functions
 
Reply
   X-Cart forums > General > General talk
 
Thread Tools
  #1  
Old 01-30-2019, 11:59 AM
  neonrider's Avatar 
neonrider neonrider is offline
 

X-Adept
  
Join Date: Oct 2005
Location: Europe
Posts: 603
 

Default X-cart 4.1.9 suddenly super slow on all functions

X-cart 4.1.9 suddenly super slow on all functions. I tried to do all I can and know to do, clear all stats (OK), use Tools menu to Optimize tables, to Check Database integrity (Result: success, but 100 consistency errors have been found, with non-existing product ids), Force Cache Generation (Result: Content Encoding Error), Clear Templates Cache (OK) etc.

I also used tools.pingdom.com and the home page of the X-cart loads in 32 seconds.

The unnecessary (unused) modules were already disabled a long time ago. Disabled maximum modules. Still the same horrible slowness as never before. In both admin and customer sides of the X-cart. No one would wait this long.

The slow down started happening between 2 to 7 days ago instead 2-3 sec. ewaiting for every step now it takes 7 to 15, sometimes 20 seconds to turn any page, any functionality.

Even when I close the shop for maintenance, the page that appears there when the shop is closed is loading slowly, in 7 to 15 seconds.

4.7.8 cart separately hosted on the same servers is NOT that slow.

For the past 7 days search queries are some kind of injection code and someone with a weird id anonymous such as GRLpGpAG_GRLpGpAG (using: sample@email.tst) ordering large quantity or amount, but not sure if this is the reason. Once I close the shop the "USERS ONLINE" number slowly comes down to zero, but once reopened the USERS ONLINE number comes to over a thousand or more, with sinister ids being registered multiple times and anonymous logins. Could the be the reason of the slow down? In the past these kind of things did not cause slow downs.

What could the problem be? Is this so easy to attack an online shop and to slow it to a halt for days etc?

(below is the one of the issues under the Tools)

Tools >>> Check database integrity

This tool allows you to improve the consistency and quality of data structures in your MySQL database. more...

List of tables in which unrelated data has been found
Click to close xcart_ge_products -> xcart_products
Relationships are missing between the following records and fields:
Records in xcart_ge_products Fields in xcart_products
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16155
productid: 16155
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16180
productid: 16180
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16197
productid: 16197
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16198
productid: 16198
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16206
productid: 16206
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16210
productid: 16210
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16218
productid: 16218
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16225
productid: 16225
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16226
productid: 16226
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16228
productid: 16228
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16232
productid: 16232
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16233
productid: 16233
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16243
productid: 16243
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16251
productid: 16251
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16264
productid: 16264
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16265
productid: 16265
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16266
productid: 16266
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16267
productid: 16267
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16276
productid: 16276
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16277
productid: 16277
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16279
productid: 16279
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16282
productid: 16282
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16283
productid: 16283
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16284
productid: 16284
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16291
productid: 16291
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16294
productid: 16294
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16301
productid: 16301
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16302
productid: 16302
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16306
productid: 16306
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16315
productid: 16315
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16316
productid: 16316
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16318
productid: 16318
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16323
productid: 16323
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16324
productid: 16324
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16326
productid: 16326
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16329
productid: 16329
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16332
productid: 16332
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16335
productid: 16335
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16357
productid: 16357
geid: 4e43c3d5002323cf4c22ed0d1d3aaa99
productid: 16360
productid: 16360

etc.

=========== ALSO THE BELOW HAPPENED ONLY TODAY ============================

[30-Jan-2019 00:46:16] (shop: 30-Jan-2019 05:46:16) SQL error:
Site : https://shop.domain.net
Remote IP : 116.110.54.91
Logged as : anonymous-2309
SQL query : INSERT INTO xcart_newslist_subscription (listid, email, since_date) VALUES ('1','sample@email.tst', '1548809176')
Error code : 1062
Description : Duplicate entry '1-sample@email.tst' for key 'PRIMARY'
Request URI: /register.php?amp;keep_https=yes&js=n
Backtrace:
/home/shop123/public_html/include/func/func.db.php:180
/home/shop123/public_html/include/func/func.db.php:106
/home/shop123/public_html/include/register.php:344
/home/shop123/public_html/register.php:67
[30-Jan-2019 00:51:11] (shop: 30-Jan-2019 05:51:11) SQL error:
Site : https://shop.domain.net
Remote IP : 116.110.54.91
Logged as : anonymous-2309
SQL query : INSERT INTO xcart_newslist_subscription (listid, email, since_date) VALUES ('1','sample@email.tst', '1548809471')
Error code : 1062
Description : Duplicate entry '1-sample@email.tst' for key 'PRIMARY'
Request URI: /register.php?amp;keep_https=yes&js=n
Backtrace:
/home/shop123/public_html/include/func/func.db.php:180
/home/shop123/public_html/include/func/func.db.php:106
/home/shop123/public_html/include/register.php:344
/home/shop123/public_html/register.php:67
[30-Jan-2019 01:05:37] (shop: 30-Jan-2019 06:05:37) SQL error:
Site : https://shop.domain.net
Remote IP : 116.110.54.91
Logged as : anonymous-2309
SQL query : INSERT INTO xcart_newslist_subscription (listid, email, since_date) VALUES ('1','sample@email.tst', '1548810337')
Error code : 1062
Description : Duplicate entry '1-sample@email.tst' for key 'PRIMARY'
Request URI: /register.php?amp;keep_https=yes&js=n
Backtrace:
/home/shop123/public_html/include/func/func.db.php:180
/home/shop123/public_html/include/func/func.db.php:106
/home/shop123/public_html/include/register.php:344
/home/shop123/public_html/register.php:67

================================================== ==========================

Also, my 4.7.8 has an equivalent "GB" size of approximately 7 units and holds about 45% of goods of the 4.1.9 while 4.1.9 has size of over 200 "GB" and holds about 2x amount of goods than the 4.7.8. So 30 times larger MB size and only 2 times amount of listed for sale goods. What could be the issue here?

Also, is LiquidWeb (hosting) good for X-cart?

UPDATE: My host (LiquidWeb) writes: "Restarted MySQL, noticed a lot of tables marked as crashed"

My host (LiquidWeb) writes: Looking over the server configuration noticing a couple of things that can be improved right away.
- Server is running CloudLinux, but is not using LSAPI.
- Server is running an older version of MariaDB.
- A significant portion of MySQL data is still on MyISAM
- One Site is on PHP 5.3
- Server has high Swap usage
- Swap is primarily from Clamd and MySQL. Updates to MariaDB 10.2 and InnoDB should help with this.
I have reviewed your server configuration and I have several suggestions in order to get your server running better. It seems that most of the issue is with unoptimal settings causing the server to start using swap. I am recommending the following.

1) Update MySQL. Currently the server is running an older version of MySQL and upgrading to MariaDB 10.2 will provide both better security and performance. MariaDB 10.2 introduces thread-pooling which allows the server to better handle simultaneous queries to the database. During this upgrade the tables using the out of date storage engine MyISAM will be updated to the more modern and efficient InnoDB. InnoDB unlike MyISAM does not require row locking which can severely bottleneck queries. It can also leverage buffer_pools and keep commonly accessed information in memory which is significantly faster than reading information from the disk.

2) Your server is currently running CloudLinux but it is not using LSAPI as it's PHP handler. LSAPI is much more efficient and easier to configure than PHP-FPM or SuPHP. I recommend that we upgrade the PHP handlers on your server to LSAPI which will help with the server load and php execution.

My note: I hope all of the above will resolve the 15+ second load issue and hopefully this is not something broke or infected in the 4.1.9 X-cart itself.

I welcome opinions, suggestions and help. Also welcome price quotes to absolutely resolve this issue if you think it is beyond hosting.

Thanks.
__________________
X-Cart Gold - 4.1.9
X-Cart Gold - 4.7.8 (U/C)
Windows 8.1 (ignored W10)
Reply With Quote
  #2  
Old 01-31-2019, 05:53 AM
  qualiteam's Avatar 
qualiteam qualiteam is offline
 

X-Guru
  
Join Date: Dec 2010
Posts: 6,373
 

Default Re: X-cart 4.1.9 suddenly super slow on all functions

Hello.
First of all I would suggest to try the embedded benchmark tool to figure out what exactly piece of code (or SQL) is working slow.
* https://help.x-cart.com/X-Cart:X-Cart_Benchmark_report_tool


This helps a lot usually.
__________________
Alex Solovev,
Qualiteam

---

User manual Video tutorials X-Cart FAQ

You are welcome to press "Thanks" button
if you find this post useful

Click here to learn how to apply patches

X-Cart Extensions
Reply With Quote

The following user thanks qualiteam for this useful post:
neonrider (01-31-2019)
  #3  
Old 01-31-2019, 07:42 AM
  neonrider's Avatar 
neonrider neonrider is offline
 

X-Adept
  
Join Date: Oct 2005
Location: Europe
Posts: 603
 

Default Re: X-cart 4.1.9 suddenly super slow on all functions

Hi Alex,

Thank you for the link to the tool, yet I have no idea how to use it correctly.

Also my host (LiquidWeb) magically made all those upgrades mentioned above in the bottom of my OP and magically my both X-carts including the 4.1.9 that previously loaded in 15-20 sec. now loads lightningly fast. So I guess and suppose it was a hosting/server (or whatever it was) issue, but I would STILL like to use the tool you provided, but can't because of limitation of my knowledge. Can you please advise further how to correctly use the tool or can you check it for myself out of your curiosity and let me know the results? Thanks.

roger
__________________
X-Cart Gold - 4.1.9
X-Cart Gold - 4.7.8 (U/C)
Windows 8.1 (ignored W10)
Reply With Quote
  #4  
Old 01-31-2019, 11:00 AM
  bigredseo's Avatar 
bigredseo bigredseo is offline
 

X-Man
  
Join Date: Oct 2002
Location: Omaha, NE, USA
Posts: 2,367
 

Default Re: X-cart 4.1.9 suddenly super slow on all functions

Hey Roger,

Yeah, the swap to the later MariaDB can make a huge difference, and if the server is already running CloudLinux, you definitely want to take advantage of the extra speed.

The only item in the list I'd be overly worried about is the move from PHP 5.3 to 7.x and making sure software and plugins are compatible.

I used to enjoy LiquidWeb when I was with them many years ago and they were always a great resource for server support.

Happy to see that they made some updates and you're back to lightning fast speeds again. Always plus!
__________________
Conor Treacy - Big Red SEO - @bigredseo
Search Engine Optimization & Internet Marketing - We Bring Your Website Out Of Hiding!
If you can't be found on Google, Bing or Yahoo, you pretty much don't exist on the Internet.
Omaha SEO Office with National & Local SEO Services
Hourly Consulting - great for SEO Disaster Recovery, Audits and DIY Guidance
Reply With Quote

The following user thanks bigredseo for this useful post:
neonrider (01-31-2019)
  #5  
Old 02-01-2019, 06:33 AM
  qualiteam's Avatar 
qualiteam qualiteam is offline
 

X-Guru
  
Join Date: Dec 2010
Posts: 6,373
 

Default Re: X-cart 4.1.9 suddenly super slow on all functions

Quote:
Originally Posted by neonrider
Hi Alex,

Thank you for the link to the tool, yet I have no idea how to use it correctly.

Also my host (LiquidWeb) magically made all those upgrades mentioned above in the bottom of my OP and magically my both X-carts including the 4.1.9 that previously loaded in 15-20 sec. now loads lightningly fast. So I guess and suppose it was a hosting/server (or whatever it was) issue, but I would STILL like to use the tool you provided, but can't because of limitation of my knowledge. Can you please advise further how to correctly use the tool or can you check it for myself out of your curiosity and let me know the results? Thanks.

roger


I am glad to hear the speed issue has been resolved


As for the benchmarking tool X-Cart provides, the article I referred to explains it pretty well. I learned it myself using that article.

Please have a closer look at it.
__________________
Alex Solovev,
Qualiteam

---

User manual Video tutorials X-Cart FAQ

You are welcome to press "Thanks" button
if you find this post useful

Click here to learn how to apply patches

X-Cart Extensions
Reply With Quote
Reply
   X-Cart forums > General > General talk


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 11:42 PM.

   

 
X-Cart forums © 2001-2018