Re: Database optimization
> 1-In what directory and file, on my server, could I check what is the Ram allocated to MySQL ?
That's not what I meant.
If the machine is dedicated to MySQL, then how much RAM is on the machine?
If the machine is loaded with other applications, how much is left over after allowing for them?
The unix command "top" will tell you what is going on with memory.
If you do not have any InnoDB tables, then
key_buffer_size = 704M
innodb_buffer_pool_size=0
Put these in the [mysqld] section of /etc/my.cnf
> Is there any other recommended other actions to shorten again the access time ?
Let's see the slow queries.
Subject
Written By
Posted
Re: Database optimization
June 09, 2014 07:35PM
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.