I don’t remember having to do this before, but I had compiled MySQL 5.1.34 recently on my dev box (os x) and I saw a warning on a create table statement. It turns out InnoDB was not enabled (or even listed in the list of storage engines.

Before:

mysql> show engines;
+————+———+———————————————————–+————–+——+————+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+————+———+———————————————————–+————–+——+————+
| CSV | YES | CSV storage engine | NO | NO | NO |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
…

Today marks the official launch of Percona.tv. We'll be uploading technical screencasts, conference video, and anything else cool we can think up. If you've got ideas or requests, let us know and we'll do our best to accommodate!

Entry posted by Ryan Lowe | 7 comments

Add to: | | | …

The PHP BBQ tourcontinues. Come to one of the four remaining barbecues in Berlin (today, 18:00-23:00 CEST, Cafe Schönbrunn, note the prominent attendees listed on the wiki!), Dortmund (Friday), Hamburg (Saturday) and Kiel (Sunday). All three past evenings in Munich, Frankfurt and Karlsruhe have been quite similar in the way that most enjoyed meeting each other at the relaxed athmosphere of a BBQ. At Karlsruhe it has been a true summer night with temperatures beyond 20 degree celsius and glowflies!

I have been most impressed about those who had a travel time of an …

The PHP BBQ tourcontinues. Come to one of the four remaining barbecues in Berlin (today, 18:00-23:00 CEST, Cafe Schönbrunn, note the prominent attendees listed on the wiki!), Dortmund (Friday), Hamburg (Saturday) and Kiel (Sunday). All three past evenings in Munich, Frankfurt and Karlsruhe have been quite similar in the way that most enjoyed meeting each other at the relaxed athmosphere of a BBQ. At Karlsruhe it has been a true summer night with temperatures beyond 20 degree celsius and glowflies!

I have been most impressed about those who had a travel time of an …

Ronald's post regarding multi-row INSERTs with MySQL reminded me of a quick utility I wrote about a year ago. I wanted to test for myself how much performance can be gained over singleton INSERTs. The perl script below just takes the output from mysqldump and produces a file for each table, with the file containing the table DDL and the associated INSERT statements. Thought others may find it useful so here it is

-------- cut here ---------

#!/usr/bin/perl -W
#
##
##------------------------------------------------------------------------
## multi_inserts.pl
## ------------
##
## Take singular INSERT statements and create multi-row INSERT statements.
##------------------------------------------------------------------------
##
# Modification History
# …

The Meetup.com folks have created a lot of unnecessary confusion lately. Their rejection of sponsorship money from Sun and MySQL has caused many of their MySQL user groups to scramble. The North Texas MySQL Meetup became North Texas MySQL Users Group and we though all was done. Well, no. Meetup.com sent out 'do not let this group die' emails that caused a flurry a messages to flood my email.

The next meeting of the North Texas MySQL Users Group will Monday August 3rd (We are taking July off) at 7:00PM in Suite 700, 16000 Dallas Tollway, Dallas TX. The presentation will be MySQL Basics -- how to install, configure, and start using MySQL

So we will meet up without Meetup.com!

Need more confidence in comparing and synchronizing schemas? Find where the secret lies.

Read the updated article “The Basics of Qualitative Schema Comparison” and do it yourself.

In the article:

• Convenient Setting Up of Comparison Parameters
• Easy Handling of Schema Differences
• Safe Schemas Synchronization

Moreover, learn how to compare a schema and a database project, understand the compared results, reduce time ..

In one of my task I wanted to get the count of upper/lower char from a string but noticed that the string function provided in MySQL couldn't get me that.. and also at the moment it seems that the regex function in MySQL can match only and the matched stats cannot be captured nor returned.

I know 2 liner code in any scripting language can perform this tasks very well.


DELIMITER $$

DROP FUNCTION IF EXISTS `test`.`uGetLowerUpperCharCount`$$

CREATE FUNCTION `uGetLowerUpperCharCount`(prm_string varchar(250)) RETURNS varchar(250) CHARSET latin1
BEGIN
DECLARE strPos INT default 1;
DECLARE strUpperLen INT default 0;
DECLARE strLowerLen INT default 0;
DECLARE strNonAlphaLen INT default 0;
WHILE strPos <= LENGTH(prm_string) DO IF ASCII(SUBSTRING(prm_string,strPos ,1)) >= 65 AND ASCII(SUBSTRING(prm_string,strPos ,1)) <=90 THEN SET …

This is what’s happening at the moment. 5.1 tree doesn’t pass the tests, both Sun and Monty Program fix that, and the fixes are different. Here is a Valgrind warning which was fixed twice: my fix my fix (correct link) made the involved mysys function to do what its name implies while Alfranio’s fix changed the replication code not to call that function anymore.

Besides the Valgrind warning, we observe failures for rpl_trigger.test and …