Showing entries 1 to 2
Displaying posts with tag: big databases (reset)
Apr
06
2013
Speedup mysql index using ssd disk
Posted by Yuli on Sat 06 Apr 2013 20:40 UTC
Tags:

You probably ask yourself sometimes how you can boost MySQL indexes when you are working with BIG databases/tables.

Really the solution is here for a long time already. You can use SSD disks (also known as flash disks). These disks are not that big that traditional SATA hard drives but they provide a superior performance. If your database is rather big to be placed on SSD disk you can still

Feb
25
2013
Optimize MySQL COUNT (*) query
Posted by Yuli on Mon 25 Feb 2013 11:33 UTC
Tags:

There is not magic solution to count table contents especially if you have a client that has a table with 40+ million records and you need to do the filtering using the 'OR' SQL statement.

Original query was the following:

SELECT COUNT(*) from table1 WHERE field1 IN ('val1','val2') OR field2 IN ('val3','val4');

First benchmark before doing optimization showed me results after 4 minutes.

My

Showing entries 1 to 2