Planet MariaDB Server
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…
A 3-way join that touches only indexes
Can an execution of 3-way join use only indexes and not touch table rows at all? If we have MyISAM tables it’s just impossible. Yet with InnoDB tables it would…
A 3-way join that touches only indexes
Can an execution of 3-way join use only indexes and not touch table rows at all? If we have MyISAM tables it’s just impossible. Yet with InnoDB tables it would…
[MySQL][Spider][VP]Spider-2.27 VP-0.16 released
I’m pleased to announce the release of Spider storage engine version 2.27(beta) and Vertical Partitioning storage engine version 0.16(beta).Spider is a Storage Engine for database sharding.http://spiderformysql.com/Vertical Partitioning is a Storage…
[MySQL][Spider][VP]Spider-2.27 VP-0.16 released
I’m pleased to announce the release of Spider storage engine version 2.27(beta) and Vertical Partitioning storage engine version 0.16(beta).Spider is a Storage Engine for database sharding.http://spiderformysql.com/Vertical Partitioning is a Storage…