So at the moment I am interested in how fast I can make Innodb on a 8-way machine while it keeping durable (aka disk write cache is disabled). This setup is tuned to run without replication.

Here is my changes for the 8-way, sata disk system:

innodb_additional_mem_pool_size = 16M
innodb_buffer_pool_size = 2G
innodb_data_file_path = ibdata1:10000M:autoextend
innodb_log_file_size=512M
innodb_log_buffer_size=8M
innodb_log_files_in_group = 2
innodb_checksums=0
innodb_support_xa=0
innodb_doublewrite=0
innodb_thread_concurrency=36
innodb_locks_unsafe_for_binlog=1innodb_additional_mem_pool_size = 16M
innodb_buffer_pool_size = 2G
innodb_data_file_path = ibdata1:10000M:autoextend
innodb_log_file_size=512M
innodb_log_buffer_size=8M
innodb_log_files_in_group = 2
innodb_checksums=0
innodb_support_xa=0
…

Sheeri just posted a great post putting a different view on recent MySQL Community Announcements.

This however raises very interesting point what MySQL Community really needs ?

I think the problem is there are no single set of needs for Community which can be maintained within single version. I see at least two set of community with very different needs.

First is "Production Community" - these are the guys which want stable MySQL version, do not want to take risks want regular updates. Some of them would like to see certain community contributions in server but not at the expense of stability.
For this group actually Old Time MySQL would work best when user contributions were accepted rather quickly into the mainline and frequent MySQL releases were built.

Second is "Development Community" - these are the guys …

So you have created your standby database using the RMAN DUPLICATE command, you have set the minimum log switch individual using ARCHIVE_LAG_TARGET, and you have sorted out those nasty “datafile missing” errors using automatic file management. Management is now happy with the Mean Time To Recovery (MTTR)… but not really. They review the documentation generated from [...]

Miha Nedok from http://www.izklop.com wrote us a few days ago about their mysqlnd test run:

I wish I had another production box to test. But what we and our users see now, actually the users notified our team that the site is suddenly “always loading fast”.. The only change… you guessed it mysqlnd installed. It wasn’t slow before, but people noticed performance degradation at times that the site is most visited when libmysql was used.

Hick-ups solved

After a little hick-up during the first days the server is now running stable with ext/mysql @ mysqlnd. Immediately after the installation of mysqlnd, Miha noticed that persistent connections got closed because of a low …

Miha Nedok from http://www.izklop.com wrote us a few days ago about their mysqlnd test run:

I wish I had another production box to test. But what we and our users see now, actually the users notified our team that the site is suddenly “always loading fast”.. The only change… you guessed it mysqlnd installed. It wasn’t slow before, but people noticed performance degradation at times that the site is most visited when libmysql was used.

Hick-ups solved

After a little hick-up during the first days the server is now running stable with ext/mysql @ mysqlnd. Immediately after the installation of mysqlnd, Miha noticed that persistent connections got closed because of a low …

I have an install of Windows Server 2003 setup under Virtual Server 2005.  I use this image for continuous integration of my Connector/Net products.  The host machine is running Vista x32 Ultimate. 

I'm not sure if its because it's on Vista but any virtual machines I add would disappear following a reboot.  Not only that but attempting to re-add the machine would give an error indicating that the machines configuration was already present and could not be added again.  Fun.

There's an easy solution though.  Just move your machine images into the default search path for Virtual Server.  On my machine that's C:\Users\Public\Documents\Shared Virtual Machines.  If you've already worked around this by renaming your .vmc file a few times, you can clean out those old configurations by deleting appropriately from C:\ProgramData\Microsoft\Virtual Server\Virtual Machines.

[BTW, I'm using …

I’ll be checking out MySQL’s “DBA Boot Camp” for Oracle DBAs on Thursday. Back next week to report on it.

Then, upcoming posts will discuss further topics from my talk, touching on scaling strategies, backups, and permissions. After that we’ll get to some more technically detailed issues that we encountered when we switched over to MySQL and got things up and running. Keep watching!…

Fedora receives $4.9m grant. MuleSource adopts OSI-approved CPAL license. FiveRuns and BitRock launch Ruby on Rails stack for the enterprise. (and more)

Gordon and Betty Moore Foundation Awards Fedora Commons $4.9M to start non-profit organization and develop open-source software for collaborative communities, Fedora Commons (Press Release)

MuleSource Announces Adoption of CPAL, MuleSource (Press Release)

FiveRuns Releases RM-Install, Powered by BitRock, FiveRuns / BitRock (Press Release)

Oracle CEO Ellison: Open source software is no threat, Haaretz, Guy Grimi …

I?m having a lot of difficulty understanding the debate surrounding MySQL?s decision to make their enterprise binaries and source less available than before. I was hoping that a few days into it I would get a better sense of the debate and why I was seeing the positions that are popping up. I realized, though, that the context of the discussion is deeply entrenched within the traditional software business model. Furthermore, it is complicated by MySQL?s IPO plans. I?ve seen people argue that MySQL is not as open, that MySQL is technically adhering to the GPL, that this is all... READ MORE

Catching up on some articles on the Planet MySQL feed, I just read the post by Dathan on how to promote a slave to be master by using MASTER_POS_WAIT(). The MASTER_POS_WAIT() is an excellent function that allows you to wait until the slave reaches a point at or after the given binlog position. Observe that after the statement issuing a MASTER_POS_WAIT() returns, the slave threads are still running, so this means that even if a STOP SLAVE is issued immediately after the statement with MASTER_POS_WAIT(), it is bound to move a little more before actually stopping. For Dathan's situation, this is not necessary, but wouldn't it be great if you could stop a slave at exactly the position that you want? Well, that …