Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

High Volumen Writes to MySQL Innodb

ernesto_vargasernesto_vargas EntrantCurrent User Role Beginner
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.

Comments

  • ernesto_vargasernesto_vargas Entrant Current User Role Beginner
    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
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.