Release Notes Changelog What is MariaDB 5.5?
MariaDB APT and YUM Repository Configuration Generator
The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.44. This is a Stable (GA) release.
See the Release Notes and …
[Read more]
ERROR 1146 (42S02): Table ‘information_schema.tables’ doesn’t
exist
Any idea how to do this on mysql server 4.x?
I think you’ve made an error in adding seconds and milliseconds:
> I have to add the 12ms to the 0.002, which will give us 0.122 sec.
12ms = 0.012s
0.002s ( =2ms)
+0.012s (=12ms)
——-
0.014s
that’s nearly 9 times less!
Percona Live is moving from London to Amsterdam this year and the event is also expanding to three full days. Percona Live Europe 2015, September 21-23, will be at the Mövenpick Hotel Amsterdam City Centre. The call for speakers and Super Saver registration are now open. Hurry though because the deadline for submitting a speaking proposal is June 21st and Super Saver registration ends July 5th!
This year’s conference will feature one day of tutorials and two days of keynote talks and breakout …
[Read more]I am turning 38 years old today. I am on my way to Belgium for the funeral of my grandmother. My family, Marta and Tomas, are at home.
I am in Bielefeld, on top of the hill. This is our usual stop from Berlin to Belgium: it’s practically in the middle.
I am sitting at the bar, and I have just finished a great project I have been working for a few months: revamp my homepage and blog, once again.
I tried a few things getting away from (the great) Wordpress. I was trying to make my own again, doing it with Django or Flask, I am a Python guy after all. I tried to do something with my OwnCloud setup, with files, but that was so 1990s, writing HTML.
Giving up, I did a search for “generate static website” and I pretty much hit the first link: “Jekyll”. It is written in Ruby, so I am …
[Read more]#DBHangOps 06/11/15 -- DBA Expectations and Automation
Hello everybody!
Join in #DBHangOps this Thursday, June, 11, 2015 at 11:00am pacific (18:00 GMT), to participate in the discussion about:
What does being a DBA mean to you?
You can check out the event page at https://plus.google.com/events/ctmk6ua93affd01jnfmm73i68fo on Thursday to participate.
As always, you can still watch the #DBHangOps twitter search, the @DBHangOps twitter feed, or this blog post to get a link for the google …
[Read more]
In the past I have written about MySQL's limitations that prevent
you from creating an index over a certain length, or with more than a certain number of columns. I've offered some
solutions for those problems, but many of my solutions hit
another limit further down the line. For example innodb_large_prefix allows you to
create an index on larger columns, but only up to 3072 bytes, and
my workarounds for the 16 column limit per index will also hit
that 3072 byte limit once you add lots of columns or add some
very long columns.
Today I'm going to suggest a …
[Read more]Heterogenous replication involves moving data from one database platform to another. This is a complicated endevour because datatypes, date & time formats, and a whole lot more tend to differ across platforms. In fact it’s so complex many enterprises simply employ a commercial solution to take away the drudgery. Join 31,000 others and follow Sean … Continue reading Replicate MySQL to Amazon Redshift with Tungsten: The good, the bad & the ugly →
“MySQL’s JSON data type is great! But how do you index the JSON data?” I was recently presenting at the CakePHP Cakefest Conference and was asked that very question. And I had to admit I had not been able to play, er, experiment with the JSON datatype to that level. Now I have and it is fairly easy.
1. Create a simple table
mysql> desc colors;
+--------------+----------+------+-----+---------+-------------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+----------+------+-----+---------+-------------------+
| popular_name | char(10) | YES | | NULL | |
| hue | json | YES | | NULL | |
+--------------+----------+------+-----+---------+-------------------+
2 rows in set (0.00 sec)
2. Add in some data
INSERT INTO `colors` VALUES ('red','{\"value\":
\"f00\"}'),('green','{\"value\": …
In this blog entry I’d like to describe how you might be able to improve how MySQL performs on Windows by ensuring that you take advantage of a Windows specific configuration setting.
On Unix systems, MySQL programs treat the localhost host name specially. For connections to localhost, MySQL programs attempt to connect to the local server by using a Unix socket file, which has some performance advantages over a TCP/IP connection. Windows does not support Unix sockets, however, and hence does not benefit from this optimisation.
However, the use of shared memory connections on Windows can offer significant performance improvements over the use of TCP/IP connections. Shared memory connections are obviously only useful when both the MySQL client and server processes are executing on the same machine, but when …
[Read more]