List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:July 2 2013 10:50pm
Subject:Re: database perfomance worries
View as plain text  

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


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
Thread
database perfomance worriesAndy Wallace2 Jul
  • Re: database perfomance worriesReindl Harald2 Jul
    • Re: database perfomance worriesAndy Wallace2 Jul
      • Re: database perfomance worriesReindl Harald2 Jul
  • Re: database perfomance worriesSinger Wang3 Jul
    • Re: database perfomance worriesspameden3 Jul
      • RE: database perfomance worriesRick James3 Jul
        • Re: database perfomance worriesDivesh Kamra5 Jul
          • Re: database perfomance worriesReindl Harald5 Jul