I am looking at the source tree for Percona 5.5.
Anybody have ideas on how to make changes to trx so that commits for a given database or table are NOT written to ibdata0 and ibdata1, just written directly to the database.
I am looking to have one INNODB database execute on fast RAMDISK while another operates on RAID10 long term storage. Since speed is paramount and transaction integrity is not needed for ramdisk tables, I want to disable logging for those tables on ramdisk.
I would love to leave normal logging in place for ibdata0 and ibdata1 but selectively disable it for a given database or tables (maybe based on table name).