Question Concerning (innodb_buffer_pool_size)

I'm currently running RHEL4.1 64-bit, mysql 4.0.26 w/ 4GB RAM and have my innodb_buffer_pool_size set to 2GB, My question is, can I increase my ram to 8GB and set innodb_buffer_pool_size to 4GB or even 6? Thanks

INNODB Questions and Optimization help

I currently have a customer who we switched over to INNODB from MyISM. It's a Dell Server with 4GB or Memory and RHEL4 64-bit. It's a fairly big database the size of the MyISM folders (before we converted to INNODB) was about 2-3Gigs. Questions: 1. The ibdata1 file size is 10GB. Does tha

Need help configuring INNODB (Customer is ready to sue)

I have a customer who has been in production for a few weeks now having converted from MyISM to INNODB. We have been experiencing a few problems with our application. With that said, could you take a look at the info below from my "show INNODB status" and let me know if you see any problems based

Cleaning Bin-Log Files

Does anyone know of a method or script that will automatically delete bin-log files after x days? I've got a few customers, all utilizing a master and slave server... my problem is that the harddrives often get filled to capacity if they go unchecked over a few months. Most of this is attributed

How Can I Auto Delete my Binary Files?

I'm running a RHEL 4.1 and MySQL 4.0.26 so a lot or the more recent commands available in 5.0.x aren't available to me. Does anyone know of any scripts or anything I can use to delete files that arent being used or run by my slave servers? It's pretty safe to say that I can delete log files o

Need Help Migrating DB from MySQL 5.0.x to MySQL 4.0.x

When I perform a dump in mysql5 to mysql 4 DB, I get the error (below). Does anyone know how I can resolve this? QUERY (windows server from the cmd prompt) mysqldump --lock-tables --user=root [SOURCE DB] | mysql --user=[USERNAME] --password=[PASSWORD] --host=[HOST] [TARGET DB] ERROR MESS