Planet MariaDB Server
MySQL, the strange case of a timestamp field
I discovered a feature (or bug) of MySQL timestamp fields. Maybe is documented in some place what I not read yet: When I add a new timestamp field to a…
MySQL get disk usage of all databases
I was tired to get manually disk space used for all MySQL databases, I just created a stored procedure to get an overview of the database sizes in our MySQL…
Once more about comparison of subquery optimization in MySQL 5.6 and MariaDb 5.5, once more about nothing…
Has it ever happened to you, when attending a party or any other convention, to enter the hall, see a gang of nice people drinking, smiling, laughing, doing small talks,…
Once more about comparison of subquery optimization in MySQL 5.6 and MariaDb 5.5, once more about nothing…
Has it ever happened to you, when attending a party or any other convention, to enter the hall, see a gang of nice people drinking, smiling, laughing, doing small talks,…
Converting MS Access to MySQL with relationships
I have used tools like MySQL Migration Toolkit (*) and Bullzip’s Access To MySQL utility, both do a excellent job but without relationships. We can spend a lot of hours…
MySQL must improve error messages
I just finished a database modification, a new foreign key creation shouldn’t be take more than 5 mins, but I spent 2 hours because MySQL still have some useless error…
Twitter bug found!
Some days ago while I’m looking for what are saying about a mysql.com server down I found a twitter bug: Is not a big deal, to repeat this bug you…
Alias shortcuts to MySQL CLI
Do you get write laziness in the command line everything what you need to connect to a MySQL server every time? It may take less than minute, but sometimes one…
Custom auto increment values
The auto_increment for MySQL fields are very useful but what about if I need a custom auto-increment like a custom format like 001-000033, 001-000034 001-000035 001-000036 … To make it…
Comparing the optimizer features of MariaDB 5.3 and MySQL 5.6
In his comment for Vadim Tkachenko’s post Baron Schwartz writes:”…I speculate that when MySQL 5.6 is GA, the official MySQL fromOracle will have a clear advantage over GA versions of…
Comparing the optimizer features of MariaDB 5.3 and MySQL 5.6
In his comment for Vadim Tkachenko’s post Baron Schwartz writes:”…I speculate that when MySQL 5.6 is GA, the official MySQL fromOracle will have a clear advantage over GA versions of…
A better SHOW TABLE STATUS
From command line we have the entire MySQL server on hands (if we have privileges too of course) but we don’t have a overall overview, at this point the show…
Creating sequences in MySQL
Those who have used PostgresSQL usually gets lazy when write the SQL code to auto-numeric fields, but we miss that feature when we are in a MySQL database. As we…
[MySQL][Spider][VP]Spider-2.28 VP-0.17 released
I’m pleased to announce the release of Spider storage engine version 2.28(beta) and Vertical Partitioning storage engine version 0.17(beta).Spider is a Storage Engine for database sharding.http://spiderformysql.com/Vertical Partitioning is a Storage…
[MySQL][Spider][VP]Spider-2.28 VP-0.17 released
I’m pleased to announce the release of Spider storage engine version 2.28(beta) and Vertical Partitioning storage engine version 0.17(beta).Spider is a Storage Engine for database sharding.http://spiderformysql.com/Vertical Partitioning is a Storage…