Hello Heikki, I have read up on checkpoint activity and innodb and there are still a few points I don't understand:
-what is the chronological sequence of events for a write into the innodb tablespace? -Is it: 1. An insert sql statement is issued from a mysql client. 2. The record is stored in the log buffer. (no disk access here) 3. The record is stored in the innodb log and in the buffer pool simultaneously. (1st disk accesss) (checkpoint) 4. The record finally makes it to the innodb tablespace and is saved to disk. (2nd disk access) Can you please correct the above if it is wrong. Thanks in advance, Balteo. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
