Any good piece of infrastructure software should be able to pop up little windows on your desktop. :)
Yesterday at LCA in Stewart's Hacking Drizzle talk, it occurred to me that error messages should pop up little windows on my desktop. So I wrote an error message plugin which uses libnotifymm to send Gnome pop-up window messages.
I don't always get to post screenshots, so here you go:
We are proud to announce the 4th public Beta of MySQL Workbench 5.2.
We want to thank all the people who have been testing MySQL
Workbench 5.2 alphas and betas and taking the time to file bugs
and provide valuable feedback. We have fixed many bugs since last
release and worked on some other details as well. Also, there is
new platform included with this beta – CentOS 5.4 Linux Packages
(RPMs)
NOTE: We have a known issue with Centos SSH Tunnel
support that we are working on so avoid that for now.
This build includes fixes for 65 bugs – 7 P1, 26 P2 and 32 P3.
MySQL Workbench 5.2 Beta 3 provides:
If you are a current user of MySQL Query Browser or MySQL Administrator, we look forward to your feedback on all the new capabilities we are delivering in a …
[Read more]
We recently released XtraDB-9, and while we did not highlight it in
announcement, the release-making feature is ability to
save and restore InnoDB buffer pool.
The idea is not new and was originally developed by Jeremy Cole
(sorry, I do not have the link on hands) some time ago, and now
we implemented it in XtraDB.
Why would we need to save and restore content of buffer pool
?
There are several reasons.
First, it's not rate on modern servers to have 32GB+ of RAM, with
allocated InnoDB buffer_pool 26GB or more. When you do restart of
server, it may take long time to populate cache with useful data
before you can bring it back to serve production load. It's not
rare to see
maintenance cycle takes two or more hours,
mainly because the slave need to catchup with master …
After a discussion with my colleague Stephane Varoqui we decided
to see how Gearman and the NDBAPI could be used together. The result of the
POC was a Gearman worker and a couple of clients (clients and
workers use Google Protocol Buffers as the protocol). The
worker can:
(UNSIGNED)
INTEGER, (UNSIGNED) BIGINT, CHAR, VARCHAR/VARBINARY
Some new features in myterm, extensible mysql command line
client:TailEver found yourself running the same query over and
over again to see if a table has got new content, just waiting
for that magic row to appear? The tail command will watch for new
lines in a table, just like you might tail a log file in Linux.
Example:
My talk on 10x performance improvements – A case study has just been approved for the 2010 MySQL Conference. This will be my 5th straight year speaking at the MySQL conferences. For those in Europe wanting a sneak peek I am also speaking at FOSDEM 2010 in Brussels on Feb 7th where I’ll be giving an abridged version.
As an independent MySQL consultant, my work generally covers performance tuning and scalability and sometimes database architecture. Often however my work involves a review of a given problem and recommendations (immediate, short and long term). I’m rarely involved in the full implementation and generally do not see the full fruits of the proposed work.
Recently however I was able to work with a client, first in resolving …
[Read more]In my previous post “InnoDB : Why not use the same isolation level as ORACLE” I suggested that like ORACLE it might now be a good idea to use READ COMMITTED as the default isolation level for InnoDB.
Marc Callaghan made interesting measures that illustrate a case where READ COMMITTED mode degraded performance. (“Repeatable read [...]
On first glance, it looks like TEXT and VARCHAR can store the same information. However, there are fundamental differences between the way TEXT fields and VARCHAR fields work, which are important to take into consideration.
Standard
VARCHAR is actually part of the ISO SQL:2003 standard; The TEXT
data types, including TINYTEXT, are non-standard.
Storage
TEXT data types are stored as separate objects from the tables
and result sets that contain them. This storage is transparent —
there is no difference in how a query involving a TEXT field is
written versus one involving a VARCHAR field. Since TEXT is not
stored as part of a row, retrieval of TEXT fields requires extra
[edited 1/22] memory overhead.
Maximum VARCHAR length
The maximum row length of a VARCHAR is restricted by the maximum
row length of a table. This is 65,535 bytes …
Last month cloud computing and systems management expert John Willis published his best of Cloud Computing for 2009 list he calls the Cloudies. I am not an expert on the latest developments in cloud computing so it was nice to get a list of the best (in his expert opinion) cloud computing tools. I was especially interested in the latest open source software and I did a little research on each of these projects to see if they had active development mailing lists, regular releases and a real community behind …
[Read more]
Following on from the earlier article on running MySQL Cluster on a single Windows
host, this one looks at installing and running over multiple
Windows machines.
Note that MySQL Cluster is still for development use only on Windows – use LINUX or Solaris for live deployments. For the latest status of which platforms are supported for development and deployment, refer to the Supported Platforms matrix.
Target Deployment
In this post, the MySQL Cluster database will be split over 3 Windows machines: …
[Read more]
