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

    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:
    link to my.conf
    lin to mysql show status:

  2. #2
    Join Date
    Dec 2007
    Richmond, VA
    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.

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