I have a MySQL database I will be launching soon which has a search engine
database accesable over DBI/mod_perl/Apace. It has about 2M records, and is
a 4GB table with 1GB index.
Every day I insert 76k records all at once and delete about another 76k.
While these inserts are happening, the select performance is obviously
What I want to do is to have two copies of the database, copying the updated
version to the publicly-accessable one, i.e.:
rm -rf /mysql/data/publicdbdir
copy -r mysql/data//insertdbdir mysql/data/publicdbdir
My question is this:
Is this enough to prevent me from experiencing slow inserts and queries
during insert, or should I be firing up two seperate servers?
Also - if I create the MyISM tables on 3.23, can copy them to a 4.0.10
server's data directory? (the reason i ask is that I have a 3.23 server
available on that box)