I have 1 table with 2.5 billion records(2.5 Cr.) and I am trying to get count of records based on indexed column. it takes 115 seconds to execute same.
Select count(1) from table1 where column=code
- 2 billion (2 Cr.)
- code gets resultset from DB with 1 to 10k rows,
- Column is indexed.
- Intel Xeon 3.10ghz
- 8 GB RAM
- MySQL server 5.1
- MySQL Connector 5.0.6
- Default Engine =InnoDB
Also take too much time for Update query also please suggest how do i tune mysql.