HELP FROM MYSQL DBA EXPERT

MYSQL DBA EXPERT

I have a mysql database that is used by a java aplication that is very slow now.

HERE IS WHAT I NEED:

1) Otimize the database searchs (see the application running and create many index etc).

2) when i write the commands below i can see:

du -h /var/lib/mysql/ = 430M

In this machine I have 4GB RAM . I want to put all database in the RAM, so the aplication will be more fast.

IT IS ALL

ADDITIONAL INFORMATIONS:

1)We will work togheter (at same time) using team viwer and chat.

2) We can work in this project only after 18:00h and before 07:00h BRST

Databaseadministrasjon Databaseprogrammerere MySQL

Prosjekt-ID: #17030222

Om prosjektet