Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2015
    Posts
    2

    Angry Unanswered: innob DB spikes at 99% I/O

    Our database is spiking at 99% I/O at random times. There are not some "super" queries that are running in these intervals. We are running a vp on digitalocean with 16 GB Ram, 8 CoreProcessor and 160GB SSD Disk. Out databse takes 1BG of data. We suspect there is something wrong with our config- We have 13 GB free memory. Does annybody know whats wring? Do i need to provide more info? Is there annything i should be logging?

    Link to screenshot of spikes:
    http://imgur.com/na000pm
    link to my.conf
    http://paste.bradleygill.com/index.php?paste_id=1346993
    lin to mysql show status:
    http://paste.bradleygill.com/index.php?paste_id=1346995

  2. #2
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    sounds like you need an index on some table that is being queried. either that or you have the worst ever disk farm.
    Dave

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •