hh_elfman Posted June 26, 2012 Posted June 26, 2012 a. Username : elfmanb. Server : steviec. Main domain : elfman.heliohost.org I definately have been doing occasional (probably once a day) large surges of database inserts that I can try to avoid. Is there any information about whether the load surge was in mysql or if it was in php? I don't see how the issue could be related to the internet traffic as there really shouldn't be that much volume of http requests generated here. I suspect that when I upload database rows that I need to either throttle down the rate I insert into my database and insert some pauses or add some transaction to insert multiple rows at the same time to reduce database load. Probably some combination of the two. Thx,
cl58 Posted June 26, 2012 Posted June 26, 2012 You were suspended for causing high MySQL load. Please do try to limit your large surges of db inserts. Thanks.
hh_elfman Posted June 26, 2012 Author Posted June 26, 2012 Certainly. I'll throttle the DB surge back and try to find more efficient transaction to use. Thanks!
Recommended Posts