USE mysql;

SHOW FULL TABLES WHERE table_type = ‘base table’;
/* returns
…
innodb_index_stats BASE TABLE
innodb_table_stats BASE TABLE
…
*/

SELECT * from innodb_table_stats;
/* returns
Error CODE: 1146
TABLE ‘mysql.innodb_table_stats’ doesn’t exist
*/

SHOW CREATE TABLE innodb_table_stats;
/* returns
Error CODE: 1146
TABLE ‘mysql.innodb_table_stats’ doesn’t exist
*/

Well .. the table exists and also does not exist at the same time. There is a free choice from the shelf! But what is happening?  I am not sure yet.  It was reported to this bug report by a Linux user, and it is reproducible for me on Windows. Miguel (the MySQL supporter, who is on it) cannot reproduce  - not yet at least.

First of all this …

 One of those exciting Bugs that hang up your database and leave you stranded.  At 6:30 and the workload hang up on the databases, every query local or remote hangs up with no outcome. 

Examination of MySQL error log reveled the following cool error messages:

InnoDB: Warning: a long semaphore wait:
--Thread 140178284349184 has waited at dict0dict.c line 747 for 262.00 seconds the semaphore:
Mutex at 0x2c6dc9e8 '&dict_sys->mutex', lock var 1
waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140178284054272 has waited at dict0dict.c line 747 for 257.00 seconds the semaphore:
Mutex at 0x2c6dc9e8 '&dict_sys->mutex', lock var 1
waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140178283759360 has waited at dict0dict.c line 747 for 256.00 seconds the semaphore:
Mutex at 0x2c6dc9e8 …

Virtual Hosting With vsftpd And MySQL On Ubuntu 12.04

Vsftpd is one of the most secure and fastest FTP servers for Linux. Usually vsftpd is configured to work with system users. This document describes how to install a vsftpd server that uses virtual users from a MySQL database instead of real system users. This is much more performant and allows to have thousands of ftp users on a single machine.

There’s a lot happening in the world of MySQL and it’s really vital to be up-to-date with the latest advancements in this field to stay ahead of the game. Reminds me of this quote by Albert Einstein “Once you stop learning, you start dying.” The easiest way to stay updated is by reading blogs. There are loads of blogs talking about MySQL, and even more for databases in general, so which of these really matter and are worth your time and attention?

We’ve handpicked the best MySQL community/ experts blogs and grouped them into various categories. You can also add these great blogs to your RSS reader to get all industry news, tips that you will ever need all in one place. If you prefer the micro blogging platform twitter for real time updates/ news can subscribe to all of them on our twitter list.

…

If you haven’t submitted your proposals for April’s Percona Live MySQL conference (the big annual one in Santa Clara California), now’s the time: the CFP closes in a couple of days!

Further Reading:

• One-day Percona Live conference in San Francisco
• Speaking at Percona Live in London this October
• Percona Live from a community insider’s perspective
• …

Verizon Wireless, the #1 mobile carrier in the United States, operates the nation’s largest 3G and 4G LTE network, with the most subscribers (109 millions) and the highest revenue ($70.2 Billion in 2011). Verizon Wireless built the first wide-area wireless broadband network and delivered the first wireless consumer 3G multimedia service in the US, and offers global voice and data services in more than 200 destinations around the world. To support 4.2 million daily wireless transactions and 493,000 calls and emails transactions produced by 94.2 million retail customers, Verizon Wireless employs over 78,000 employees with area headquarters across the United States.

The Business Challenge

Seeing the stupendous rise in social media, video streaming, live broadcasting…etc which redefined the scope of technology, Verizon Wireless, as a technology savvy …

If you haven’t submitted your proposals for April’s Percona Live MySQL conference (the big annual one in Santa Clara California), now’s the time: the CFP closes in a couple of days!

This post shows the construction process of the Syslog Audit plugin that was presented at MySQL Connect 2012. It is based on an environment that has the appropriate development tools enabled including gcc,g++ and cmake. It also assumes you have downloaded the MySQL source code (5.5.16 or higher) and have compiled and installed the system into the /usr/local/mysql directory ready for use. 

The information provided below is designed to show the different components that make up a plugin, and specifically an audit type plugin, and how it comes together to be used within the MySQL service. The MySQL Reference Manual contains information regarding the plugin API and how it can be used, so please refer there for more detailed information. The code in this post is designed to …

La haute disponibilité, c’est garantir aux applications un accès permanent aux données, même en cas de panne. Permanent ? Même lorsque vous mettez à jour le schéma de vos bases ? Que vous ajoutez de la RAM sur un serveur ? Que vous reconfigurez ou redémarrez MySQL ?   

Comment lire les données depuis un nœud esclave avec une garantie que les données sont à jour, sans changement applicatif ?

Not much to add really to the bug I’ve filed here: bug#67159.

Again this GTID stuff looks good, but seems to prevent changes in the configuration of performance_schema, which I think is not appropriate, especially as P_S now has lots of extra goodies and after 5.6 will surely have even more.