We will share some MySQL results of our BigBoy SSD Slim. The hardware is the same as our previous post. This time the test is based on MySQL queries.

We did a simple sql select query like that:
SELECT * FROM `table` WHERE `field` LIKE '%keyword%';

Executed this query on the same table for keywords at different long. The table contains about 100.000 rows and it's size is about 500 MB.

Test	SSD	HDD
Query 1	0.0261 sec	0.0410 sec
Query 2	16.2090 sec	28.2846 sec
Query 3	21.1690 sec	34.0826 sec

Conclusion:
For the hardware and software we use, our SSD is better about 60% of the HDD. Please not that, our SSD is designed for personal use like laptops/desktops. Although that, it's also good for average servers. It's performance is better than HDD. You can see the difference with various tests.

The bad thing about this SSDs is cost/performance rate. Today the cost of this 16 GB SSD equals a 1 TB HDD. The cost is very expensive, if your priority is storage.

But if you want to speed up your operating system or database server, and your database is not bigger than 16 GB, you can buy a SSD for your workstation. Because our priority is performance rather than storage.

If you want to raise your performance more, you can connect your SSDs in raid. This will give you more performance.

We have bought 16 GB BigBoy (Samsung Chips) Slim MLC SSD last week. In physical size, it's really so slim, thin, small. It's about 1 inch in size. The size advantage of solid state drives really matters.

What about the performance?
First of all, we didn't test the drive with for various factors. We only did simple copy and read tests.

The platform is FreeBSD unix. We formatted the SSD as UFS file system. The motherboard supports Sata 1. So the results are based on Sata 1 only.

We wrote a shell script, that copies a 35 byte file 10.000 times and then randomly reads this files.

We use a Seagate 320 GB 7200 RPM HDD to compare with our SSD.

The results:
SSD:
Write: 44.8106 seconds
Read: 1.9424 seconds

HDD:
Write: 49.6177 seconds
Read: 2.7077 seconds

We see that, this SSD is a little better than the HDD we use. There is no big difference for this models. However, we have to say that, we have tested the drives with a simple script which we coded ourselve, and the connection was Sata 1. Of course you can get different result with different platforms.

We will use this SSD in one of our servers for operating system or database (e.g. mysql). We didn't decide yet. We will do some more tests.

In near future, we will buy and test other SSD models and share the results in SSDAge.com

• 1

• 2