12-03-2007, 07:26 PM
|
#5 (permalink)
|
|
The Visitor
Join Date: Sep 2007
Posts: 4
Thanks: 4
|
Quote:
Originally Posted by bluesaga
I think the key thing should be noted is that large website with a ton of writes, will need an INNODB table for writing, no doubt in that. However, a website that has 100% reads, but writing done in the background, it is best to have an INNODB table for the backend (writing) that is copied to the front end which is a MYISAM table.
Copying to the front end can be done like:
INSERT INTO table SELECT * FROM write_table
|
When should the written data be moved into the active reading table? Should written data be removed from the write table after a certain period of time?
|
|
|
|