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 server.

MySQL don’t have a command that allows us an overall summary of the databases, something like SHOW TABLE STATUS for databases. The “SHOW DATABASES” command lists only the current databases without any other information like how many space are using or how many tables there are, etc.

The procedure that I wrote this based on INFORMATION_SCHEMA database, which contains rich information of all existing databases.

I suggest, in a previous post, place all these procedures in a database called tools, but you can still choose different location.

So when call the procedure will have a global view of information that will be useful for maintenance tasks.

mysql> call tools.sp_overview(); …

Connectors now available to the MySQL®community as part of the MariaDB open source project

So ... We (Monty Program & SkySQL) have just announced the immediate availability of the connectors, ‘MariaDB Client Library for C and MariaDB Client Library for Java Applications’, to the wider MySQL® database community in the permissive LGPL licence.

With this announcement, the connectors become part of the wider MariaDB open source project, to which users will be able to contribute via relevant online resources.

read more

Now that the thanksgiving holiday is over, it seems like the perfect time to have another #DBHangOps. If you’re interested, check this twitter search or check back on my blog here for a link to the google hangout.

Items currently on our agenda for today:
* Data corruption!
* Monitoring — what do you monitor, why, etc.
* Query killing — do you kill queries in production regularly, or in emergencies?
* Fun or useful configurations

Looking forward to chatting about MySQL stuff today!
Fun time hitting these topics this week. Check out the recording:

This Week in Website Performance is a weekly feature of the Monitis.com blog. It summarizes recent articles about website performance. Why? Because your friends at Monitis.com care.

Full table scan vs full index scan performance

Author: Stephane Combaudon.

Using full index scans are not always faster than a full table scan. Stephane explores the situations in which a sequential read through of a full table performs better than using randomly-read full index.

Big Data …

First 10 to register this week will benefit from a 40% discount

The Percona Live MySQL Conference: London 2012 is just around the corner and we’ll be present both with talks as well as in the exhibition hall alongside other sponsors of the conference.

Talks & Hot Topics

Our very own Ivan Zoratti has the following two talks on Tuesday December 4th:

read more

Ashisuto greatly expands support services for Enterprise users of MySQL & MariaDB open source database software

So, this is exciting news and something that my colleague Daniel Saito had been working on for years: enterprise-ready, 24/365 Japanese support for the MySQL and MariaDB databases!

read more

Une soirée de conférence et networking intitulée: "MySQL, le Cloud et MariaDB" Invitation - Meetup SkySQL

Mercredi 12 décembre 2012 de 19h à 22h30

SkySQL Ab vous invite à une soirée de conférence et networking intitulée :

« MySQL, le Cloud et MariaDB »

read more

SkySQL’s live in the UK – come and check us out at Oxford University - devfest

There will be a nice contrast in the air as the ancient institution of Oxford University plays home to the latest trends in open source software at the All Your Base conference, taking place at the Said Business School on the 23rd November. And we are prepared to show off our new Cloud and Enterprise products, allowing developers to get hands-on with the solutions.

read more

If you're planning to attend UKOUG in Birmingham on Dec 3-5, here's your guide to know more about Oracle's MySQL.

There's a MySQL stream on Monday 5th and we've a great list of sessions, including:

• Rich Mason's keynote on how to Deploy, Scale and Save with Linux, Virtualization and MySQL
• Keith Hollman on stage to discuss how to Embrace Database Diversity
• Mark Swarbrick's lecture on Tips & Tricks for MySQL …

SkySQL™ Cloud Data Suite now comes with 4 nodes system on AWS Plus: AWS tips & tricks, updated administration console, new video tour & more

As with all new open source software products, updates are a continuous process and we’ve been busy since the launch of the SkySQL™ Cloud Data Suitelast September! Here is a snapshot of the latest developments with our Cloud Data Suite, a collection of software components that provides a highly available database solution in a cloud environment, based on MySQL & MariaDB, deployable in the Amazon Cloud, i.e. AWS.

read more