Hi,
I'm a php guy and db system issues are not my thing. My server (linux) is running mysql 4.0.15, and running SLOW, very slow. I did a search for the slow query log file that the docs mention but could not find it.
Also, because I'm moving over to a new server, I have started changing the file types to myisam from innoDB. I'm wondering if the system is screwed up becuase the size of ibdata1 (where innodb data is stored) is 1344274432 bytes (about 1.1 Gš, but as I convert tables from innodb to myisam (lots of them with lots of data), the file size of ibdata1 is not going down. Any ideas why the slowness or why I can't seem to touch ibdata1?
Thank you,
Samuel