Thanks for the response:
> how large is your database?
about 33GB, and growing
> how large is innodb_ubber?
from my.cnf:
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size=2048M
innodb_additional_mem_pool_size = 20M
> how large is the table?
about 60MB, 95K rows
> for innodb innodb_buffer should be a large as the whole databases
> not only the one, all of them, dumb but fact
Yeah, to do that we'll have to throw a lot more memory in the machine.
Thanks for the info.
On 7/2/13 3:50 PM, Reindl Harald wrote:
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
--
Andy Wallace
iHOUSEweb, Inc.
awall...@ihouseweb.com
(866) 645-7700 ext 219
--
"Sometimes it pays to stay in bed on Monday, rather than spending the rest of the
week debugging Monday's code."
- Christopher Thompson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql