SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-24-2008, 06:08 PM
| ||||
| ||||
 UPDATEs against one db affecting others Is there any way to prevent UPDATEs on one database on one mysql instance from affecting SELECTs on other databases in the same instance? I'm noticing a whole bunch of backed up connections on other databases when I run massive UPDATEs on one. Thanks!      |
|
04-24-2008, 06:08 PM
| |||
| |||
| Re: UPDATEs against one db affecting others On Mon, April 21, 2008 07:28, Waynn Lue wrote: > Is there any way to prevent UPDATEs on one database on one mysql > instance from affecting SELECTs on other databases in the same > instance? I'm noticing a whole bunch of backed up connections on > other databases when I run massive UPDATEs on one. > > Thanks! > Are there any I/O or CPU load issues? If you don't have any stored procedures that work between them, I'd check server level limits. MySQL is supposed to be multi-threaded to avoid just this sort of problem, but if your disk and/or CPU are maxed out (or for that matter you are out of memory) the whole system may be tied up. Just my thoughts <warning its a Monday here>. ------ William R. Mussatto Systems Engineer http://www.csz.com 909-920-9154 |
|
05-02-2008, 05:04 AM
| ||||
| ||||
| Re: UPDATEs against one db affecting others I'll do that, thanks. (Sorry for the long response time, I was in Dublin this past week...). On Mon, Apr 21, 2008 at 3:16 PM, Wm Mussatto <mussatto@csz.com> wrote: > > On Mon, April 21, 2008 07:28, Waynn Lue wrote: > > Is there any way to prevent UPDATEs on one database on one mysql > > instance from affecting SELECTs on other databases in the same > > instance? I'm noticing a whole bunch of backed up connections on > > other databases when I run massive UPDATEs on one. > > > > Thanks! > > > Are there any I/O or CPU load issues? > If you don't have any stored procedures that work between them, I'd check > server level limits. MySQL is supposed to be multi-threaded to avoid just > this sort of problem, but if your disk and/or CPU are maxed out (or for > that matter you are out of memory) the whole system may be tied up. > > Just my thoughts <warning its a Monday here>. > > ------ > William R. Mussatto > Systems Engineer > http://www.csz.com > 909-920-9154 > > > -- > > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=waynnlue@gmail.com > > |
Linear Mode
