Hi! I just wanted to ask if you ever have any problems with hackers?
My last blog (wordpress) was hacked and I ended up losing months of hard work due to no data backup.
Do you have any solutions to protect against hackers?

This week we discuss copyleft, GPL and related licenses. In Ear Candy we discuss INFORMATION_SCHEMA and permissions, and At the Movies is about a columnar database.

Events
DB Hangops - every other Wednesay at noon Pacific time

Oracle is having a MySQL OTN Virtual Developer Day August 31st.

FrOSCon - Aug 24-25th, 2013 in St. Augustin, Germany.

Upcoming MySQL events

read more

We have forums available to help you answer your questions when dealing with our Windows products.  You can post questions, answer other user's questions, and find solutions to your own problems there.   You can find these forums along with many other resources in our Development Zione found at http://dev.mysql.com/.  The forums are located at http://forums.mysql.com/.

 Here are the forum links for our products:

• Connector/Net - http://forums.mysql.com/list.php?38
• MySQL for Visual Studio -http://forums.mysql.com/list.php?174
• MySQL for Excel -  …

If you see the “Waiting for table metadata lock” error, you may be wondering what is the best course of action to prevent it in the future. I have briefly discussed troubleshooting metadata locks before, however, that post more illustrated how easy it is to encounter the “Waiting for table metadata lock” error in both MyISAM and InnoDB. It provides simple examples for reproducing using both storage engines, so one could hopefully more easily identify where the locks are stemming from in their particular case.

Pin-pointing which transaction holds the locks is a different story. There are feature requests filed in MySQL and MariaDB bugs databases to track this information, but they are recent, and no ETA is scheduled for either yet, as far as I know:

http://bugs.mysql.com/bug.php?id=69527 …

Those who deal with big data probably know about Disco – a distributed computing framework aimed to provide a MapReduce platform for big data processing Python applications. We are proud to say that we are one of the largest users of Disco in the Netherlands. As an owner of multiple high-traffic portals with lots of […]

The post Big data processing with Disco appeared first on Spil Games Engineering.

MySQL 5.6 introduces a new feature – microseconds resolution in some temporal types. As of 5.6.4 TIME, TIMESTAMP and DATETIME can have a fractional part. To create a field with subseconds you can specify precision in brackets: TIME(3), DATETIME(6) etc.

Obviously, the new feature requires the format change. All three types may now have a tail with a fractional part. The tail may be one, two or three bytes long and can store up to six digits after the point.

The non-fractional part has changed too. Thus, DATETIME uses only five bytes comparing to eight in previous versions.

As of revision 79 the …

On Thursday, Dr Charles Bell and I will be presenting a webinar on MySQL Utilities; there will be a heavy focus on what you can acheive with them and how you should use them. As well as listening to the presentation, this is a great chance to get your questions answered by the experts (Israel Gomez from the engineering team will also be on-line to help with the questions). As always, the webinar is free but you should register in advance here. If the time isn’t convenient, register anyway and you’ll be sent a link to the replay when it’s available.

Abstract:

MySQL Utilities provide a collection of command-line utilities that are used for maintaining and administering MySQL databases, including:

• Admin …

Run Ubuntu and want to try new features of Percona XtraBackup? Well, now you can. We have a Personal Package Archive (PPA) percona-daily/percona-xtrabackup. Every time code is pushed to our main source code repository, the PPA is updated.

We are currently building for Ubuntu lucid (10.04LTS), Precise (12.04), Quantal (12.10) and Raring (13.04).

To add the repository to your Ubuntu system, simply run:

sudo add-apt-repository ppa:percona-daily/percona-xtrabackup

You will now have daily builds of Percona XtraBackup available to install.

Currently, we are in the process of working on the 2.1.4 release. The daily builds currently include some code that is destined for 2.1.4 including: fixes for bugs: …

I don’t know how common is this problem, but it is good to know from time to time about which tables how many storage space needed in certain time. For example, you can catch an amok running software part which writes your database full. Or, – as you will see soo – you can catch up some code what doesn’t work as excepted.

So, lets start at the beginning. You wanna to know how big are your tables, and you need to know how many data gets there day-by-day (or minute-by-minute. or whatever).

You can query information_schema.tables for table sizes, this is good, but you won’t be happy just with these results, because you won’t find any time based changes, so you have to store the data.

So first, we have to create a table to store this historical data:

CREATE TABLE `test`.`table_sizes` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE …

The MySQL Windows Experience Team is proud to announce the release of MySQL Notifier version 1.1.4, the  latest addition to the MySQL Installer for Windows.

MySQL Notifier 1.1.4 introduces the following features:

• Monitoring of services in remote Windows computers (any service, not only MySQL Server services, similar to the local services monitoring offered in MySQL Notifier 1.0.3) via asynchronous Windows Management Instrumentation. Monitored services are grouped by computer name where the topmost is the Localhost. After a service in the Localhost or a remote computer is added to the monitored list, the MySQL Notifier automatically monitors for MySQL Server services addition (this option can be turned-off by users).
• Monitoring of MySQL Server instances on any platform via a timer configurable by users.  These instances are monitored via MySQL Workbench connections which are automatically …