You can now yum (RPM) or apt-get (DEB) MariaDB 5.1.39, courtesy of OurDelta and in close cooperation with Monty Program Ab. Simply follow the info on the CentOS, Debian or Ubuntu pages.
(note: give the mirrors some hours to sync up)
Quick overview
You used to use mk-query-digest to aggregate and report on MySQL’s slow query log. Then it got the ability to grab query events from polling SHOW PROCESSLIST. Next we thought, really, how hard can it be to implement the libmysql wire protocol, so we can sniff TCP packets? … it’s hard, but not that hard as it turns out. But why stop there, why not implement memcached protocol too? I think you can see where this is headed.
So now mk-query-digest is a tool that can understand and “do stuff with” a variety of query/response types of information. The latest is HTTP. HTTP traffic is just a query-response flow of events, perfectly suitable for response-time analysis. Example:
baron@kanga:~$ mk-query-digest sample-http.txt --type http
# 1.6s user time, 100ms system time, 14.20M rss, 17.07M vsz
# Overall: 56 total, 30 unique, 1.27 QPS, 0.06x concurrency ______________
# …[Read more]
Last week I attended the Enterprise LAMP Summit and Camp in Nashville, Tennessee. I enjoyed the event and met or reconnected with a lot of great people. I was glad to be able to spend time with some folks from the Postgres community. My own sessions focused on MySQL.
During the Summit I tried to help people understand how to think about performance, and made the case that the Percona versions of the MySQL server are not only the highest-performance available, but uniquely provide the instrumentation necessary to follow a disciplined performance optimization process such as Method R or Goal-Driven Performance Optimization.
At the Camp the next day, there were several sessions on MySQL. My talk was later in the day, so I elected to skip …
[Read more]We’ve been trying to get the OSX version of Kontrollbase off the ground and running for those of you who run OSX or OSX Server but have run into various issues. As such, we’re looking for a talented PHP and/or Perl coder that knows the internals of OSX so that he/she can maintain a branch [...]
You used to use mk-query-digest to aggregate and report on MySQL’s slow query log. Then it got the ability to grab query events from polling SHOW PROCESSLIST. Next we thought, really, how hard can it be to implement the libmysql wire protocol, so we can sniff TCP packets? … it’s hard, but not that hard as it turns out. But why stop there, why not implement memcached protocol too? I think you can see where this is headed.
Last week I attended the Enterprise LAMP Summit and Camp in Nashville, Tennessee. I enjoyed the event and met or reconnected with a lot of great people. I was glad to be able to spend time with some folks from the Postgres community. My own sessions focused on MySQL. During the Summit I tried to help people understand how to think about performance, and made the case that the Percona versions of the MySQL server are not only the highest-performance available, but uniquely provide the instrumentation necessary to follow a disciplined performance optimization process such as Method R or Goal-Driven Performance Optimization.
Antony is travelling up to Portland for this great event that’s about to start Fri evening and going over the weekend. He’ll be showing other devs and people more about the OQGRAPH engine, and gathering useful feedback.
Open Query is, together with many others (I see Giuseppe, Facebook, Gear6, Google, Infobright, Jeremy Cole, PrimeBase Technologies, Percona, Monty Program, and lots more), sponsoring the event so that it’s accessible for everybody – reducing the key factor to getting there rather than having to worry about high conf fees.
Having acquired the world’s biggest jetlag flying to Charlottesville VA for last year’s OpenSQL Camp, I can confirm from personal experience that it’s a great event. While I can’t be there this time, I’m looking forward to hearing all about it!
Had an issue with $key_blocks_used that should read $Key_blocks_used – so, here’s the diff if you don’t feel like downloading the new release, you can just change those two variables on lines 695 and 697 in bin/kontroll-reporter-5.0.x_linux-x86-2.0.1.pl as follows: 695: $key_buffer_fill = ($key_blocks_used / $key_blocks_total); 607: $key_buffer_ratio = (100 * ($key_blocks_used / $key_blocks_total));
In the last 2 blog posts about High Availability for MySQL we have introduced definitions and provided a list of ( questions that you need to ask yourself before choosing a HA solution. In this new post, we will cover what is the most popular HA solution for MySQL, replication.
High Availability solution for MySQL: Replication
This HA solution is the easiest to implement and to manage. You basically need to setup MySQL replication between a master and one or more slaves. Upon failure of the master, one of the slaves is manually promoted to the master role and replication on the other slaves is re-adjusted to point to the new master. This solution works …
[Read more]
At the next North Texas MySQL Users Group meeting we will be
featuring pizza, soft drinks and beer. We will also have TWO
presenters. Do if you are planning to be in Dallas on December
7th, please drop by!
Sun Microsystems will host the next Dallas MySQL User Group
Meeting
When: Monday, December 7, 2009 | 6:00 to 8:00 pm
Where: Sun Microsystems, 7th Floor, 16000 Dallas Tollway, Dallas,
TX
Map: http://bit.ly/ZnYoS
Are you interested in learning more about MySQL's new server
release cycle and how it impacts the MySQL roadmap? Or are you
looking to get the latest update on storage engines or
development and administration tools? Are you investigating data
warehousing and analytic solutions?
Then come join the North Texas MySQL Users Group, Benjamin Wood,
Senior MySQL Systems Engineer, and Kathy Guzman, …