.
>>
>> Please have the slowlog turned on. There could be extra, useful, info in it.
>>
>>
>>> -Original Message-----
>>> From: spameden [mailto:spame...@gmail.com]
>>> Sent: Tuesday, July 02, 2013 7:28 PM
>>> To: Singer Wang
>>
t; -Original Message-
>> From: spameden [mailto:spame...@gmail.com]
>> Sent: Tuesday, July 02, 2013 7:28 PM
>> To: Singer Wang
>> Cc: Andy Wallace; mysql list
>> Subject: Re: database perfomance worries
>>
>>>
>>>> We are on
have the slowlog turned on. There could be extra, useful, info in it.
> -Original Message-
> From: spameden [mailto:spame...@gmail.com]
> Sent: Tuesday, July 02, 2013 7:28 PM
> To: Singer Wang
> Cc: Andy Wallace; mysql list
> Subject: Re: database perfomance worries
&
We are on a quest to improve the overall performance of our database. It's
generally
working pretty well, but we periodically get big slowdowns for no apparent
reason. A
prime example today - in the command line interface to the DB, I tried to
update one
record, and got:
mysql> update agen
>
> > We are on a quest to improve the overall performance of our database.
> It's
> > generally
> > working pretty well, but we periodically get big slowdowns for no
> apparent
> > reason. A
> > prime example today - in the command line interface to the DB, I tried to
> > update one
> > record, an
Am 03.07.2013 01:25, schrieb Andy Wallace:
> 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
>i
O
On 2013-07-02 5:31 PM, "Andy Wallace" wrote:
> We are on a quest to improve the overall performance of our database. It's
> generally
> working pretty well, but we periodically get big slowdowns for no apparent
> reason. A
> prime example today - in the command line interface to the DB, I tried
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_siz
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
> (ba
