Re: Database optimization
Hi Rick James,
Thank you for your reply.
1-In what directory and file, on my server, could I check what is the Ram allocated to MySQL ?
In my database I have mainly MylSAM tables, but also some InnoDB tables.
2-In what file would I have to add some lines ?
3-Would I have to add any of such lines :
key_buffer_size = 20% ? (or 3520 x 20% = 704M)
innodb_buffer_pool_size=0 ?
innodb_buffer_pool_size = 70% (or 3520 x 70% = 2464M)
key_buffer_size = 10M ?
The features of my server are the following :
- Linux
- Apache/2.2.14 (Ubuntu)
- PHP: 5.3.2-1ubuntu4.24.1
- Memory limit : 128M
- MySQL: 5.1.73-0ubuntu0.10.04.1
- MySQL engine : MyISAM
- RAM : 3520 Mo
- Processor : 3 Core
4- In my original post, I mentioned some actions that I already made on the database with phpMyAdmin, in order to shorten the database access. Such action lead to some improvements.
Is there any other recommended other actions to shorten again the access time ?
Thank you very much in advance for any help.
Patrick?
Subject
Written By
Posted
Re: Database optimization
June 08, 2014 04:57AM
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.