Planet MySQL
Your blogs, news and opinions.
Your blogs, news and opinions.
Home | FAQ | Submit your blog feed | Feedback | Archive | Aggregate feed 
English 
English Showing entries 1 to 10 of 12421 Next 10 Older Entries
How is the newest browser fairing in technical reviews? READ MORE
We made new patches, improved previous and want to announce new builds for 5.0.62, 5.0.67 and 5.1.26 versions. One of biggest changes we separated releases of 5.0 into two branches.
First, just "-percona" release is more stable and contains only stable and proven on many installation patches. Second is "-percona-highperf" release, which contains experimental patches that can improve performance significantly. On this stage "percona-highperf" contains patches from Yasufumi Kinoshita (more info on Maximum performance of OLTP benchmark is not so scalable on multi-cpu.
Most important patch "split_buf_pool_mutex" to separate InnoDB buffer->pool mutex into several, and it allows to get 1.5x - 2.5x improvements in DBT2 benchmarks on 8cores boxes (benchmark results is coming and will be published)
For all three
[Read More...]
I must admit, I was very surprised to read rumors of Monty quitting Sun. I haven't heard from him personally but I think it is sad but a decision that he has thoroughly thought about since Sun's acquisition of MySQL earlier this year.
I had expected him to stay longer though: Perhaps mostly because when I chatted with him a couple of months ago, I had the impression that he intended to stay at least a year or until the Maria storage engine hit the v1.5 milestone.
My sense of foreboding I had in Orlando was not completely unfounded. I did try to be an optimist though - just see my blog posts from that time.
I had expected him to stay longer though: Perhaps mostly because when I chatted with him a couple of months ago, I had the impression that he intended to stay at least a year or until the Maria storage engine hit the v1.5 milestone.
My sense of foreboding I had in Orlando was not completely unfounded. I did try to be an optimist though - just see my blog posts from that time.
Slave delay can be a nightmare. I battle it every day and know plenty of people who curse the serialization problem of replication. For those who are not familiar with it, replication on MySQL slaves runs commands in series - one by one, while the master may run them in parallel. This fact usually causes bottlenecks. Consider these 2 examples:
Between 1 and 100 UPDATE queries are constantly running on the master in parallel. If the slave IO is only fast enough to handle 50 of them without lagging, as soon as 51 start running, the slaves starts to lag.
[Read More...]This is the 113th edition of Log Buffer, the weekly review of database blogs.
Sheeri Cabral gets things going this week with her coverage of this rumour: Monty Widenius Leaves Sun/MySQL. If it turns out to be true, that seems like bad–or at least sad–news for MySQL, but Sheeri’s take is mostly an optimistic one.
MySQL’s Kaj Arno responds to the rumours on Monty resigning: “First, it?s a rumour. . . . Second, Monty?s resignation has been a possible outcome
[Read More...]
Active/active fail over cluster with MySQL ReplicationElecting a slave as new master and aligning the other slaves to the new master
[Read More...]
In a simple MySQL Replication set-up you have high-availability (HA) on the read side (r). But for the master which covers all the writes (w) and the time critical read (rt) there is no HA implemented. For some situations this can be OK. For example if you have rarely writes or if you can wait until a new Master is set up.
But in other cases you need a fast fail-over to a new master.
In the following article it is shown how to implement the election of a new
[Read More...]
Some weeks ago there was a request about adding a feature that keeps (or gets) datatypes of colums, which are connected via foreign keys, in sync. While we have added this to our ToDo list, I thought of doing some simple LUA exercises to give the user at least a funtion to check if the FKs in the model all have columns with matching datatypes.
As it turned out such tasks can be done quite easily using our GRT-shell. And by writing some functions you can add features to Workbenchs interface.
To get in touch with the shell/GRT environment inside Workbench click the tiny black prompt-window-icon in the top right area of workbench (or choose ‘View->Advanced->GRT Shell’ from the main menu). Some items in the UI are swapped/added: the sidebar on the right side gets a new tab named ‘GRT Shell’ featuring some more tool-panes (GRT Tree, Modules, Inspector) and on the
[Read More...]
As you may have noticed we’re going for a major milestone on our Workbench 5.1 roadmap. So our resources are pretty much concentrated on this task at the moment. But it’s just as important to keep improving our 5.0 GA version, so we will reserve the first days next week to make progress here as well. We will publish the next release of 5.0 mid-next-week. So stay tuned for a better 5.0 next week and the upcoming 5.1 alpha later this month.
Valleywag reports that Monty Widenius has quit Sun. The Pythian Group reckons its true. Kaj Arno’s non-denial denial would appear to confirm it despite his protestations otherwise.
“Technically there is no resignation letter. However, I spoke to Monty yesterday, and yes, resignation is an option he considers,” writes Kaj before expanding on some of the reasons that Monty might consider leaving
[Read More...]We have a rumour of MySQL co-founder Michael “Monty” Widenius resigning, as posted by Valleywag and expanded by Sheeri Kritzer Cabral.
Usually, I wouldn’t comment on rumours. But as I’ve been asked copious amounts of questions, let me make an exception today.
First, it’s a rumour. Technically there is no resignation letter. However, I spoke to Monty yesterday, and yes, resignation is an option he considers.
Second, Monty’s resignation has been a possible outcome already since years before the Sun
[Read More...]Showing entries 1 to 10 of 12421 Next 10 Older Entries
You are viewing a mobilized version of this site...
View original page here
