title: How to store a vector of time/value data in a database
body: <p>I'm gathering a vector of time/value pairs, in this case I/O latency versus time for a server. I'd like to store them in a MySQL database that is queryable by date, server and other metadata.</p>
  
  <p>Examples:</p>
  
  <ul>
  <li>I want be able to query the I/O latencies from 1:00 PM to 3:00 PM for the server <code>Atriedes</code> on August 19th, 2007.</li>
  <li>I want to also be able to query the times that the I/O latency on server <code>Harkonnen</code> where the I/O latencies are above 40 ms.</li>
  <li>I want to find all the servers that had latencies above 100 ms on August 1st, 2007.</li>
  </ul>
  
  <p>How should I structure my database to easily allow this?</p>