MySQL is the 2011 Readers Choice Award for Best Database.
It may not be the most-exciting topic around, but databases make the world go round. MySQL with its dolphin mascot takes first place again this year, with more than twice as many votes as its closest competition, PostgreSQL.
However, I do take issue with the It may not be the most-exciting topic around quip. MySQL is very exciting!
[Read more]
CREATE FUNCTION MidPoint(ls LINESTRING)
RETURNS POINT
DETERMINISTIC
BEGIN
DECLARE len double;
DECLARE workLength double DEFAULT 0;
DECLARE workPoint int DEFAULT 1;
DECLARE point0 POINT;
DECLARE point1 POINT;
DECLARE distanceOver double;
DECLARE segmentLength double;
IF (NumPoints(ls) = 1) THEN return PointN(ls, 1); END IF;
-- find half the length of the linestring
SET len := GLength(ls) / 2;
-- walk the linestring until we exceed the distance
WHILE (workLength < len) DO
SET point0 = PointN(ls, workPoint);
SET workPoint := workPoint + 1;
SET point1 = PointN(ls, workPoint);
SET segmentLength = GLength(LineString(point0, point1));
SET workLength := workLength + segmentLength;
END WHILE;
-- distance to backup
SET distanceOver = workLength - len;
-- midpoint is …
[Read more]
On the download page you will find the executable for
each SVN commit in the HeidiSQL repository. The executables are
processed in conjunction with a SVN post commit hook. I just
extended this process so it also creates the installer with that
executable, using a InnoSetup command line. This way, users who need a
full installer and also want to use the latest build can do that
in one download.
Thanks to Jordan Russell for that excellent, free InnoSetup.
Or, better say, I have not blogged for so long…
What happened? Well, it has been a crazy year, probably the
busiest year in my whole working life. When you are in your late
twenties/early thirties, you can dedicate all your energy to
something, work, hobby, charity, sport, study, you name it. You work hard, and
every now and then you have time to lie down and recharge your
batteries. In one or two days, if you can sleep 9/10 hours per
day, all the tiredness you have accumulated goes away. I have
felt that feeling, but in your late forties, there is no such
thing anymore.
When you are forty and you have a family, your priorities change.
You try to accommodate work, family and friends. You remove most,
if not all, …
I recently wrote an article on dealing with an assertion failure in log/log0recv.c, specifically !page || (ibool)!!page_is_comp(page) == dict_table_is_comp(index->table).
I mention it because this occurred after a system outage, and I just encountered another system outage (either HDD power outage or some other serious HDD event), with a completely different assertion failure and error message. Similar to the one above, it’s also kind of obscure, so I wanted to post this so people searching for it will find this.
For reference, the first outage assertion failure was this:
InnoDB: Assertion failure in thread 139838283589376 in file log/log0recv.c line 1094 InnoDB: Failing assertion: !page || (ibool)!!page_is_comp(page) == dict_table_is_comp(index->table)
Here is the new assertion failure:
111201 16:45:00 InnoDB: Assertion failure in …[Read more]
It is truly amazing the amount of knowledge and talent that work
with and support MySQL and the MySQL community. Thanks to all of
you.
Over the last month the MySQL ACE list has grown even more:
George J. Trujillo is now an Oracle ACE and a
MySQL Oracle ACE.
Wagner Bianchi became a MySQL Oracle ACE
not long ago.
Roland Bouman is the latest addition as a
MySQL Oracle ACE.
Congrats to all of them !
Recently I was working on a MySQL Cluster that is replicated to a
MySQL server. I will create a few blog posts to show how all of
this can be done. This is of course not the only way to do this..
Any feedback or other options are welcomed in comments for the
community to use.
Part one: the install
First the MySQL Documentation about MySQL Cluster is very good I
will make references to it for your convenience.
You can go about this a few different ways but this is a simple
RPM install:
Download all the related rpms from http://dev.mysql.com/downloads/cluster/ and
install.
MySQL Documentation (http://dev.mysql.com/doc/refman/5.5/en/mysql-cluster-install-linux-rpm.html)
is here to help you with the installs …
In this episode we talk about the MySQL Master High Availability Agent, aka MHA.
News
There will be a "MySQL and Friends" devroom at FOSDEM 2012. The dev room is scheduled for Sunday 5th February 2012, whole day. If you are interested to give a talk, please submit it before December 26th through the submission form. You can read the original announcement by Frédéric Descamps.
Funding for BlazeMeter and Digital Reasoning. Red Hat goes unstructured. And more.
# BlazeMeter announced $1.2m in Series A funding and launched the a cloud service for load and performance testing.
# Digital Reasoning announced a second round of funding to help develop its Hadoop-based analytics offering.
# Red Hat announced the availability of Red Hat Storage Software Appliance, based on its recent acquisition of Gluster.
# Red Hat also …
[Read more]Why did you start blogging? If you haven’t why aren’t you blogging? In either case, the answer can be as short or long as you wish, but if you are reading this, this means that you are interested in blogging no matter whether you are blogging or not. Log Buffer is there to not only [...]