Re: mysql not using available memory
Posted by: Harrison Fisk
Date: November 22, 2004 04:31PM

Hi,

You have told MySQL to use *a lot* of memory, which most likely is leading to swap and thrashing disks. Keep in mind some variables are only allocated once, whereas some can be allocated once per connection.

The global ones you have above:
set-variable = key_buffer=1024M

These are allocated on startup, so the server should be using at least this much.

The thread ones:
set-variable = join_buffer=128M
set-variable = record_buffer=64M
set-variable = sort_buffer=512M

So each thread can use up to 704MB of ram roughly. You are allowing up to 22048 (max_connections) which gives you up to around 15000 GB of memory allocated (obviously something will fail before that, but just giving you an idea).

I would guess that you are misreading how much RAM is in use and something is going wrong cause of that.

How are you finding out the memory in use?

Harrison Fisk, Trainer and Consultant
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Written By
Posted
November 17, 2004 09:06PM
Re: mysql not using available memory
November 22, 2004 04:31PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.