Huge number of files being generated on mysql

9 Dec 2010, 12:32 PM

#1

New Zenner

Join Date:: Oct 2007
Posts:: 43
Plugin Contributions:: 0

Huge number of files being generated on mysql

I have a site https://www.easy-wellies.co.uk that has been running fine for 2 years. Recently we have had problems with the site crashing and an error message concerning the sql database

The server company say that there are a very large number of files being generated and that we need to address this. I have pasted below one of their replies

Can anyone get a handle on this it is abusy site

Hi James,

It's the same issue, somehow you're server has generated another half a million files in the last week. I've increased the limits to 3,000,000 now but I think you need to find out what is going on and which process is generating the files. The site is back up. The rate at which files are being generated is increasing.

Jimmy6Bellies

9 Dec 2010, 12:59 PM

#2

kobra

Black Belt

Join Date:: Aug 2005
Location:: Arizona
Posts:: 31,500
Plugin Contributions:: 4

Re: Huge number of files being generated on mysql

You have not provided any information about the server
Shared or dedicated
No information about the files
File name
What process is generating them - the server or ZenCart

Any other pertinent information

Zen-Venom Get Bitten

9 Dec 2010, 2:13 PM

#3

james_o

New Zenner

Join Date:: Oct 2007
Posts:: 43
Plugin Contributions:: 0

Re: Huge number of files being generated on mysql

Hi Kobra

Can I submit the ticket in the commercial help section so that you can pick this up. It is just that the server company are being very unhelpfull and this goes well beyond my knowledge. Plus we have one of our bussiest weekend due and do not want the site to crash again

James

Jimmy6Bellies

9 Dec 2010, 2:45 PM

#4

james_o

New Zenner

Join Date:: Oct 2007
Posts:: 43
Plugin Contributions:: 0

Re: Huge number of files being generated on mysql

I think it fixed with no help from the server company. It appears that it has nothing to do with the sql server it is the cache folder on the server that is storing erro logs I have asked the server company to delete the file as I seem unable to open it or do anything with it. I think this will sort the problem

Jimmy6Bellies

9 Dec 2010, 9:51 PM

#5

kobra

Black Belt

Join Date:: Aug 2005
Location:: Arizona
Posts:: 31,500
Plugin Contributions:: 4

Re: Huge number of files being generated on mysql

has been running fine for 2 years. Recently we have had problems with the site crashing

it is the cache folder on the server that is storing erro logs
Something changed to cause errors to be logged

Really need to track down the root cause of the errors and correct

Zen-Venom Get Bitten

12 Dec 2010, 12:47 AM

#6

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,511
Plugin Contributions:: 176

Re: Huge number of files being generated on mysql

Admin->Tools->Store Manager->Cleanup Debug Log Files ... will let you purge the logs that have been generated.
Then you need to review the new logs that get generated so you can fix whatever problems are causing them to appear.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.