List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:October 18 1999 12:57am
Subject:bad performance for certain settings
View as plain text  
>>>>> "root" == root  <root@stripped> writes:

>> Description:
root> The performance of MySQL is fine when run without and arguments, ie by just
root> executing libexec/mysqld directly.
root> When given certain arguments to increase buffers and memory usage,
root> performance drops noticably when doing a lot of insert, update and selects.

root> Again this happens with the binary distribution and the source distribution.
>> How-To-Repeat:
root> Start mysqld without arguments and make it sweat.
root> Then start safe_mysqld with the following arguments:
root> -O table_cache=256
root> -O key_buffer_size=96M
root> -O record_buffer=8M
root> -O join_buffer=8M
root> -O sort_buffer=8M
root> -O wait_timeout=120
root> At least this works for _me_. This probably depends on how much memory you
root> have.
>> Fix:
root> Unknown

Fix:

Don't increase the following if you don't know what they really mean :)
(They are documented in the MySQL manual)

record_buffer=8M
join_buffer=8M
sort_buffer=8M

Regards,
Monty
Thread
bad performance for certain settingsroot15 Oct
  • Re: bad performance for certain settingsThomas van Gulick15 Oct
  • bad performance for certain settingsMichael Widenius18 Oct
    • Off-topic sorta: mysql/email archiveMichael Cunningham18 Oct
      • RE: Off-topic sorta: mysql/email archiveBill Gerrard18 Oct
      • Re: Off-topic sorta: mysql/email archiveDavor Cengija18 Oct