High Volumen Writes to MySQL Innodb

We are currently generating a high volumes of writes against our Dell 2950 database server from our ads application.

The Ads application runs a Maintenance process every hour and is at this time that we see a queuing of raw insert. Few of the insert finish after 40-60 seconds then the rest finish at once when the Maintenance finish. Sometime we see 200-500 processes after the Maintenance finish.

On normal operation we don’t see those inserts since they are processed very fast but we need to expedite these inserts.

Our servers use a SaaS battery backup controller with 256 MB cache and 15K RPM SCSI hard drive.

I found the cause of those pending insert…InnoDB locks.

This info comes from Innotpo

____________________________________________________________ .InnoDB.Locks.__________________________________________ __________________
CXN…ID…Type…Waiting…Wait…Active…Mode…DB. …Table…Index…Ins.Inte nt…Special…
grievous…2335789…RECORD…1…00:58…00:58…X…max db…data_raw_ad_click…data_raw_ad_click_viewer_id… .1…gap.before.rec
grievous…2336304…RECORD…1…00:19…00:19…X…max db…data_raw_ad_click…data_raw_ad_click_viewer_id… .1…gap.before.rec
grievous…2336428…RECORD…1…00:08…00:08…X…max db…data_raw_ad_click…data_raw_ad_click_viewer_id… .1…gap.before.rec
grievous…2336476…RECORD…1…00:05…00:05…X…max db…data_raw_ad_click…data_raw_ad_click_viewer_id… .1…gap.before.rec