My MySQL bugs is a list I recently created and intend to keep up to date with issues I have seen.
Percona is glad to announce the release of Percona XtraDB Cluster 5.5.31-23.7.5 on June 25, 2013. Binaries are available from the downloads area or from our software repositories.
New Features:
- Information about the
wsrep sequence numberhas been added toINFORMATION_SCHEMA.INNODB_TRXtable. - Percona XtraDB Cluster can now be bootstrapped with the new bootstrap-pxc option in the init script.
- Percona XtraDB Cluster has implemented parallel copying for rsync …
I’m always switching back-and-forth between the 2 different InnoDB flavors in MariaDB – XtraDB+ and the standard InnoDB plugin, so I thought I’d simply post all of the various combinations in a single place. (And then I cover enabling the InnoDB Plugin in MySQL, since it’s an option in 5.1.) [Addition: Thanks to Andrew and Sergei for the tips on shortening plugin-load=. The changes are reflected below.]
Note: Below is for Windows. For Linux, simply change “.dll” to “.so” where appropriate.
MariaDB 10.0:
Do not add anything, as the standard InnoDB plugin is the current default (as of 10.0.3, although I do anticipate this changing in the near future, and I’ll update the post accordingly when that happens).
MariaDB 5.5:
# Enable the 2 below to disable XtraDB+ and enable the standard InnoDB Plugin ignore_builtin_innodb plugin-load=ha_innodb.dll
…
[Read more]I’ve posted slides for my Velocity talk on VividCortex’s blog. The talk explained how we use exponentially weighted moving statistics to generate a meta-metric of abnormality for the time-series metrics measured from MySQL. That’s kind of a mouthful. Maybe you had to be there :-)
A couple of weeks ago I was interviewed on ZDNET about how to create
successful software company in todays world.
I assume that because the original article also mentioned my
other project, MariaDB, some people jumped to the wrong conclusion about my
intentions or what I was trying to achieve.
For those that want to know more about Business Source, there is
now an
academic article in TIM (Technology Innovation Management
Review) that one can read. The article is written by Linus
Nyman and me.
To clarify some misunderstandings, here is a short list of …
Most of us are familiar with how MySQL handles timezones, and what one must do to keep up with the latest changes, etc. Most of us use the system timezone info, which is great – one less item to update when changes occur (usually because of daylight savings changes). And for those who need more specifics, most everyone (except Windows and HP-UX) can update their timezone info using the zoneinfo database from the OS.
For those few Windows and HP-UX, you have to download the package of pre-built time zone tables that MySQL provides. Per the manual (timezone section):
“If your system is one that has no zoneinfo database (for example, Windows or HP-UX), you can use the package of pre-built time zone tables that is available for download at the MySQL Developer Zone:”
…
[Read more]Based on my own limited experience with the Dojo Toolkit, you either love or hate it. First, I disliked the steep learning curve. After a few days, I began to enjoy it, for example, because of the Dijit interface vodoo: spreadsheet (data grid), auto-completion combobox, effects & animation… Many of these GUI elements can be connected to a dojo store. A store is responsible for accessing and manipulating data.
Needless to say how easy it is to populate a sortable, … data grid using a store. Based on the proxy sketched in the previous post, I’ve prototyped two MySQL stores for dojo. One maps to a MySQL table, the other one maps to JSON stored in a BLOB to make MySQL look a bit …
[Read more]The Board of the MariaDB Foundation thought it would be good to provide an update — hopefully the first of a regular quarterly series — on how we’re progressing with the interim activities around constructing governance, identifying a new representative Board and structuring an engineering council.
- The MariaDB Foundation is now independent of any business interests. With the acquisition of Monty Program Ab by SkySQL Ab, there’s now a clear separation of functions. The Foundation is the home of community activity around MariaDB, dedicated to sustaining and delivering the MariaDB database on behalf of its community independently of the business interests of any member. We are acting as a US 501(c)(6) not-for-profit and intend to follow the advice we have received to formally register with the IRS at the start of 2014.
- Support from commercial backers is steadily flowing; you can see some of them listed on our new …
You spoke: http://bugs.mysql.com/bug.php?id=41706
And we listened:
| Now you can quickly and easily note that a bug or feature request affects you. |
| When you subsequently view the report, you will see that status indicated. |
We highly value user input here at MySQL, and we wish to foster a
vibrant environment of healthy two-way …
The PHP code that I've experienced in China so far is pretty
good. I have been in some environments where the Code
is horrendous-where variables are set in one file yet used
in another file via a require_once. If that magic variable
is not set everything would break with side-effect galore. This
is not the case here for the China Team. This team is really good
not to imply the other-one wasn't just praising the
current one.
The SQL, like many other companies I have been at requires some
more extra effort, but the hunger to learn and improve is
throughout the culture of the team here. Really that is the first
step to improve a system, the willingness by developers and
management in getting things done and fixed-fast.
Entering in the environment, first I read all the code. Then
created a development …