Am 02.07.2013 23:28, schrieb Andy Wallace: > mysql> update agent set number_of_emails = 5 where acnt = 'AR287416'; > Query OK, 1 row affected (36.35 sec) > Rows matched: 1 Changed: 1 Warnings: 0 > > 36 seconds to update one table? The primary key is `acnt`. If I run the same > (basic) > command again a few seconds later, I get: > > mysql> update agent set number_of_emails = 15 where acnt = 'AR287416'; > Query OK, 1 row affected (0.00 sec) > Rows matched: 1 Changed: 1 Warnings: 0 > > Why would we be getting such huge variations? We're running Solaris 10 on > i386, with > 4 processors and 16GB of memory, MySQL 5.1.46-log. We are working out a plan > to upgrade > to MySQL 5.6, but I certainly don't want to depend on that upgrade to solve > all performance > problems
how large is your database? how large is innodb_ubber? how large is the table? for innodb innodb_buffer should be a large as the whole databases not only the one, all of them, dumb but fact
signature.asc
Description: OpenPGP digital signature
