Thought I would throw this out here so I remember it, and it maybe useful for someone else. During a session here at Sun’s CEC conference one of the presenter was talking about setting CPU affinity for hardware interrupts. This made me think of our hack ( workaround ) for innodb scalability on a 16 core machine ( set the mysqld affinity to cpu’s 0-7 or 8-15 ). In order to get the top performance out of a 16 core machine we probably want to ensure everything else goes to the cpu’s not set to be servicing mysql. So a quick google search came up with this article on setting the affinity for IRQ’s in the linux kernel. So with a 16 core box, I could set the affinity for Mysqld to cpu’s 8-15, while setting the affinity of the interrupts to something in the 0-7 range.
Did you see the press release today, called “Sun MySQL Server Solution“?
- That Sun remains committed to MySQL’s cross-platform presence, doing at least as much as before the acquisition on any individual platform or for any individual stack.
- That the acquisition of MySQL through …
As promised, here are the DBT2 results for the Intel SSD drive:
|Raid 5||Raid 10||10K Raptor||Matt’s Mtron||Matt’s Memoright||Intel x-25m|
|8-disks||8-disks||1 disk||1 disk||1 disk||1 disk|
As you see the Intel drive blew away all the competition here… even besting another dbt2 score I got from a nice new shiny 8 disk raid 10 system.
Doing dbt2 tests on on the intel drive today… One of the strange things I ran into last time testing out my memoright drive was running the RPM version of the enterprise binaries -vs- the tarball version seemed significantly faster. I had some other folks try it on other hardware and they could never replicate the performance slowdown,. Basically before I was getting 4407 TPM in DBT2 from the RPM (5.0.60) in Centos 5, while the tarball (5.0.60) was only hitting 2505 TPM. This was consistant. Now I see that my most recent run of dbt2 against the Intel SSD acheived 3600 TPM/s, which is lower then the rpm, but higher then the tarball ( this was achieved via tarball ). As i said this difference has not been verified independently, and it could be any number of odd factors at play on my hardware.
I need to go back and figure this out again… But on a positve note, apples to apples the intel ssd …[Read more]
Seeing my recent love affair with solid state drives I thought I would test drive one of the latest greatest drives out their the 80GB intel x-25m80GB. Like a child on Christmas morning, I felt true excitement as the generic UPS envelop arrived on my porch today.
While it did not show up until late in the day, I can’t just let it sit their without starting to test it can I?
Benchmarks are running as I write this and I will provide the full breakdown of the drives performance as I finish up the tests.
But to wet your appetite, check this out:
50-50 read/write sysbench test: 1899 IO requests per second!!! Thats huge!!!
Thats compare to the 284 IOPS I got on the memoright GT, a performance improvement of 6.6x, with a higher capacity 80GB -vs- 32GB, and a Lower cost $773 -vs- $680… outstanding!!!
Here are the first unverified sysbench test runs:
I presented these at an internal MySQL professional services meeting about a month ago… its mostly a hodge podge of various benchmarks… but enjoy! The big difference in these benchmarks vs the other benchmarks is I am testing on the memoright GT drive, which is supposed to be one of the fastest SLC drives out their currently. Lets get right too it:
Looking at sysbench Random read/write iops:
|R/W||1 Raptor||1 Mtron||1 Memoright|
So Yves knowing my affinity for all things solid state forwarded me this link, http://torvalds-family.blogspot.com/2008/10/so-i-got-one-of-new-intel-ssds.html , it seems Linus Torvalds picked up one of the new Intel SSD drives ( if anyone wants to send me one to test that would be cool ). Whats interesting is he says the thing just rocks. But how will this perfom in a database environment? Not 100% sure, but I think it’s going to perform worse then the mtron or memoright drvies I have tested. Why? Well the drive is MLC not SLC. Anandtech has a great review the Intel SSD, with an awesome explination with accompaning benchmarks on SLC -vs- MLC. Most of these tests are performed in a windows environment, and I …[Read more]
If you are a maintainer of an Open Source project, you currently have plenty of choice when it comes to getting your project hosted for free. One criterion could be your software configuration management system (SCM) of choice.
Some of the hosting services that I am currently aware of and the choice of SCM they offer include:
- BitBucket ( …
Sometimes there are funny communication styles between people who are geographically distributed and working together all the time. Recently one of our team members echoed back to me some answers I gave over a chat session:
Q: Is it OK for me to buy quad-core servers? A: The old man walks slow but carries much, whilst [...]
I picked up what some claim is the fastest of the current SSD drives this week, the Memoright GT. From articles around the net I have seen performance speeds substantially faster then the mtron drive I tested earlier…. so I took the plunge. The first results? luke warm. The random performance ( databases like mysql are all about random performance ) of the drive is better in mixed read/write tests over the mtron, but the mtron blew it away in random read performance. This are are my first pass tests, so I may have something wrong … so take them with a grain of salt:
|Req Per Second|
|rnd read/write||1 Raptor||1 Mtron||1 memoright|