MySQL with temporary high load on shared server
Hi folks, does anybody have with MySQL running on a shared server, which gets temporary high load? My problem is that a friend uses an online-shop on a shared-sytem. No problem with that - but when he uses update-scripts to upload his products/prices/... from scratch the system almost goes down due to heavy load. There are about 10.000 products in the DB - not *so* much I always thought. System performance degrades for other services (mail, ftp, ...) as well as other users trying to access their databases. Has anybody got an idea? Please let me know urgently! Kind regards, Stefan Neufeind
Re: MySQL with temporary high load on shared server
Stefan Neufeind wrote: Hi folks, does anybody have with MySQL running on a shared server, which gets temporary high load? My problem is that a friend uses an online-shop on a shared-sytem. No problem with that - but when he uses update-scripts to upload his products/prices/... from scratch the system almost goes down due to heavy load. There are about 10.000 products in the DB - not *so* much I always thought. System performance degrades for other services (mail, ftp, ...) as well as other users trying to access their databases. Has anybody got an idea? Please let me know urgently! Kind regards, Stefan Neufeind I would suggest looking at using a bulk insert procedure, this should significantly speed up the loading of the data. If memory serves you use LOAD DATA. Check the Mysql manual -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Re: MySQL with temporary high load on shared server [SCANNED]
On 6/30/04 5:23 AM, Stefan Neufeind wrote: Has anybody got an idea? Please let me know urgently! What shopping cart? We had issues with oscommerce for a while blowing up a server almost everyday. Not a Debian though, we ended up moving them to a different machine for the DB/MySQL and also made them correct the image sizes down to a more respectable size, they had some at 1 meg :( {Claimed he was a web developer} Also watch for spiders trying to crawl pages like login and such, they can end up stuck in a loop and cause issues. -- David Thurman The Web Presence Group http://www.the-presence.com Web Development/E-Commerce/CMS/Hosting/Dedicated Servers 800-399-6441/309-679-0774 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Re: MySQL with temporary high load on shared server
Stefan Neufeind wrote: Hi folks, does anybody have with MySQL running on a shared server, which gets temporary high load? My problem is that a friend uses an online-shop on a shared-sytem. No problem with that - but when he uses update-scripts to upload his products/prices/... from scratch the system almost goes down due to heavy load. There are about 10.000 products in the DB - not *so* much I always thought. System performance degrades for other services (mail, ftp, ...) as well as other users trying to access their databases. Has anybody got an idea? Please let me know urgently! Kind regards, Stefan Neufeind I would suggest looking at using a bulk insert procedure, this should significantly speed up the loading of the data. If memory serves you use LOAD DATA. Check the Mysql manual
Re: MySQL with temporary high load on shared server [SCANNED]
On 6/30/04 5:23 AM, Stefan Neufeind wrote: Has anybody got an idea? Please let me know urgently! What shopping cart? We had issues with oscommerce for a while blowing up a server almost everyday. Not a Debian though, we ended up moving them to a different machine for the DB/MySQL and also made them correct the image sizes down to a more respectable size, they had some at 1 meg :( {Claimed he was a web developer} Also watch for spiders trying to crawl pages like login and such, they can end up stuck in a loop and cause issues. -- David Thurman The Web Presence Group http://www.the-presence.com Web Development/E-Commerce/CMS/Hosting/Dedicated Servers 800-399-6441/309-679-0774