I’ve been running on CS-Cart for about 6 months now… We have about 10,000 products, about 50 categories, and get about 10-30 orders a day out of some 1000 or so visitors. I’m on a dual quad core system (eg 8 cpus)… Plus I have 8 GIGs of memory in the machine now.
The system ran fine to start, then a month down the road things started to get slower… I did some tuning and things were ok. Another month or two and things starting going nuts, just one day the amount of CPU (not mysql) usage that cs-cart was responsible skyrocketed. At the request of the support staff I removed all extra languages and features/add-ons I didn’t have to have. Things were a tad better, but still real bad. I fooled around with some of the configuration/admin setup stuff and for some reason later that day it started running again at normal speed. I don’t really remember what I last tweaked when it started working better again, but I was happy and moved on.
Now, I haven’t touched the server in yet another month or so and 3 days ago the server again started going into huge CPU lag. We again checked if it was some bot or other abuse with no real sign of such.
Finally I was told I need to update to lightspeed httpd which is much faster, so I did and though it helped, the site/cart is till running very slow. In fact many minutes to load things into my cart and the like.
I know it’s this application bringing my server down cause when I CHMOD the directory of the cart to 000 the load goes away. When I put it back the load comes back…
Does anyone have any ideas what’s going on? Any suggestions? I’ve rebuilt and optimized the database already. Besides mysql isn’t the heaviest load which it normally always is with all other carts/applications.
In short, I think cs-cart has some flaw that is making it spin it’s wheels. Maybe on calculating previous purchasers also bought, or best sellers or the filters- which have to have some load impact… but again, things did at time run fine. Now it’s not.
Is there some database table that’s overloaded or need purging or something?
I welcome any input.
http://www.RPGShop.com
James
P.S. This is so serious I’ve gotten no orders for 3 days now and if it can’t be solved I’ll be forced back to magento and to leave CS-CART negative feedback/reviews.
Didn’t you launch your store using magento commerce a few months back?
I’m remember reading it on magento commerce’s forum.
[quote name=‘hykit’]Didn’t you launch your store using magento commerce a few months back?
I’m remember reading it on magento commerce’s forum.[/quote]
He mentioned it in PS.
[QUOTE]Apache 2 Test Page
powered by CentOS[/QUOTE]
This is what is now being displayed
Turn off CS-Cart statistics. and clean out the statistics tables.
```php
```
Statistics have been off since day one as has any logging. There is data in the cscart_stat_* tables but I’m not sure those are the statistics or not. What specific table were you suggesting truncating?
I’ve been messing with the server a bit and so maybe you bumpped into the site when it was offline. Sorry. It’s up and running now and still slow as **** 
The sys admins from my hosting service can’t find anything wrong with the server and have been also pointing the finger at cs-cart.
Is there a way to clear/clean/reset the var/cache directory? Maybe it has some bad code saved or something? I tried just deleting it all and that caused the site to fail so I put it back.
All optional features are off. Hardly anyone is using the cart/shopping and I have a mega-huge server for this job. Why is it that I have 50+ load and CPU? My guess was that maybe something is throwing an error and just writing to a log a ton… but I haven’t found much there.
I am at the point now that I’d like to just export all data and restart from a new installation. If that fails find a new cart system. This is the 3rd time cs-cart has blown up. Anyone know what the best procedures to load data into an new install would be? Is there a full export for the configuration and skins that I’ve done?
James
http://www.rpgshop.com
[quote name=‘hykit’]Didn’t you launch your store using magento commerce a few months back?
I’m remember reading it on magento commerce’s forum.[/QUOTE]
Well it was about a year ago, but yes. After constant headaches after every patch and the system running slow, I moved to cscart. Which went ok for a while, but now I get this kind of **** popping up once a month.
James
http://www.rpgshop.com
I just checked your site again and its faster, but I also notices your now missing the Stats code, which means you had Statistics running and now its not.
The code i pasted above was viewable in your page source, it no longer is.
Your site loaded much, much faster for me.
Yep, 2-1/2 seconds for initial home page load time, about 150 times faster than when I visited yesterday evening! 
what version of CS-Cart are you running?
I have yet to see a post of what version. As the CS-cart team claims to have fixed many server load problems in 2.07
See their blog post here: [url]http://blog.cs-cart.com/2009/08/28/increased-performance-for-high-capacity-stores-how-we-achieved-it/[/url]
index.php?version
he is running 2.0.8
We are faced with the same problem. We updated the server, the server is now 3 time more powerful , but the problem is the Cs-cart. After the upgrade to the new version 2.08 shop started working slower and slower, we began to lose orders and customers. Everyday we get complaints of customers, but we can not do anything. Thank you CS-Cart :mad:
Yeah, the stats addon is a load on the server and database.
Well I had to do a full reinstall and then restore of the whole database, tweak a few things in the admin and a couple small code hacks… now I’m back to where I was.
But still doesn’t explain what made the CS-CART software blow up. If it keeps doing this I will have to switch for sure.
James
http://www.rpgshop.com
[quote name=‘gamegoblin’]Well I had to do a full reinstall and then restore of the whole database, tweak a few things in the admin and a couple small code hacks… now I’m back to where I was.
But still doesn’t explain what made the CS-CART software blow up. If it keeps doing this I will have to switch for sure.
James
http://www.rpgshop.com[/QUOTE]
I have same isue Huge load on server.
Where do i disable stats ?
Use 1.3.5 latest
Here is a screenie from Server remote on iPhone, this is NOT good wit 1 wisitor online.
Ohh Turned off the Stats now.
Not any bether.
However made a new tread where it should be.
[url]http://forum.cs-cart.com/showthread.php?goto=newpost&t=13905[/url]
Anybody has solution to fix this ? We meet the same problem, huge cpu loading for mysql.
We have more than 30000 products, 2000 categories.
[quote name=‘michael’]Anybody has solution to fix this ? We meet the same problem, huge cpu loading for mysql.
We have more than 30000 products, 2000 categories.[/quote]
2000 categories will kill the store per page load. Use “dynamic” or “static” category menu style and it’ll fly.
[quote name=‘JesseLeeStringer’]2000 categories will kill the store per page load. Use “dynamic” or “static” category menu style and it’ll fly.[/QUOTE]
Thanks for your suggestion, we will give a try.
scuse my ignorance but how to change to static/dynamic menu system?