Re: Disk Space

[jean touzalin]

Hi Cedric,

Well, there is no link between poor performance and this big file.
To shrink your tablespace
1. verifiy you have a good backup.
2. change your innodb tables to MyIsam
alter table xxx engine=MyIsam;
3. verify your config around innodb

Example: show variables like 'inno%';
...
innodb_data_file_path ibdata1:1G:autoextend
in your my.cnf set innodb_data_file_path = ibdata1:1G:autoextend
4. Set also other variables around innodb
5. drop the file ibdata1.*
6. restart the mysql server
7. modify the previous tables to Innodb

That's all

For performance problem, enable slow queries and queries without indexes
long_query_time=2 -- after 2 seconds executing go to slow_query.log
log_slow_queries=ON
log_queries_not_using_indexes

Adjust variables around %buffer%
Verify you system is not swapping (htop show a good insight)
Analyse you slow_query log, verify the execution plan...

regards
Jean-Luc