GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

High Volumen Writes to MySQL Innodb

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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.

  • #2
    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

    Comment

    Working...
    X