title: Why split data into multi-tables doesn't improve performance?
body: <p>We are using mysql. We have a huge table which contains 1 billion rows. The engine is InnoDB. And we have 50% SELECT, 30% UPDATE, OTHER 20% per minute. We want to improve the performance, so we split the single table into multi ones. But by splitting, we saw the performance didn't improved a bit. Why? Is it the common sense that split table will improve performance? </p>
  
  <p>The server is 4-core, SCSI RAID 5 Hard Disk, 32GB memory. Just one single server.</p>