Hi... I'm new to configure mysql. I have read all pages on mysql.com ablut the subject, and have figured out that some numbers are a bit to high. As config file Have I used my-huge.cnf. here are some numbers: | Open_tables | 512 | | Open_files | 618 | | Open_streams | 0 | | Opened_tables | 2763 | | Uptime | 175054 |
I dont like that opened_tables are so high after about 2 days of uptime. table_cache = 512. MySQL is running on a i686 with 20GB HD an 1GB RAM. And runs mainly MySQL The load average on the server is between 0.5 and 5. Can someone give me some tips about what I should alter to get the performence better? Anders Gjermshus