Showing entries 61 to 70 of 79
« 10 Newer Entries | 9 Older Entries »
Displaying posts with tag: Hardware (reset)
CPU Affinity for Interrupts

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.

Cross-platform MySQL Runs Best On Sun

Did you see the press release today, called “Sun MySQL Server Solution“?

What it means is that we start seeing the fruits of what we’ve been talking about all along since the acquisition, such as when launching MySQL this week in Argentina and in Uruguay:

  • 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 …
[Read more]
Intel x-25m80GB SSD DBT2/MySQL Benchmarks

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
4579 6139 625 4900 4156 6558
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.

Hmmmm… dbt2 ubuntu -vs- centos -vs- tarball -vs- packaged

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]
Intel x-25m80GB in the house…. woot!

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:

[Read more]
Been too long in coming, more MySQL SSD benchmarks!!!

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
5000/5000 172 200 284
6670/3330 164 282 412
7500/2500 159 388 512
[Read more]
Intel SSD

So Yves knowing my affinity for all things solid state forwarded me this link, , 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]
Project Kenai: looking at the technology behind it

While Colin beat me in blogging about Project Kenai, I think I can still provide some additional background information about this new project hosting service from Sun.

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:

[Read more]
Life as a consultant: my crooked arm for a pillow

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 [...]

Prelim Memoright SSD Tests

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
5000/5000 172 200
[Read more]
Showing entries 61 to 70 of 79
« 10 Newer Entries | 9 Older Entries »