Hi!
My MyISAM database works perfectly for 98% of the cases that we encounter.
However, there are a few cases during our experiment that we know will cause spikes in dataflow. We know both the why and when, so we are trying to plan appropriately for it.
Is there a way that I can mix in memory inserts for that period (maybe using the memory/head engine) directly with another MyISAM table for the rest of the experiment?
I'm looking for a way to buffer the data while still keeping the data available in real-time.
I have access to a RH9 8GB SMP system.
Using INSERT DELAYS seems to kill the server when it hits these data spikes.
I guess what I'm looking for is a way to insert 1,000,000 rows from a HEAP engine table to the beginning of a MyISAM table as a block instead of using something like this:
INSERT INTO hipjoint SELECT * FROM memhipjoint
Any help would be great!
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
