MySQL Forums
Forum List  »  Newbie

Re: Database optimization
Posted by: Patrick Espenan
Date: June 08, 2014 04:57AM

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?

Options: ReplyQuote


Subject
Written By
Posted
June 06, 2014 01:50AM
June 07, 2014 05:52PM
Re: Database optimization
June 08, 2014 04:57AM
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.