I have a question about InnoDB and how it would handle updates on the order of about 3,000-5,000 a second. The UPDATEs update a single record on a primary key. In MySQL, it does a table lock thus serializing the updates. There are a few selects, though on a couple of orders of magnitude less often. The table locks have the potential to cause problems at this volume.
So to avoid the table locks, I have considered using InnoDB. However, it syncs to disk after every UPDATE and I don't think that will work. The disk is a RAID 10 array of 6 15K drives (3x2). Any suggestions? --steve- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
