Comments on: Made good on my MySQL patch promise to make things better for everyone!!

By: Roman

Roman — Tue, 26 Aug 2008 15:51:53 +0000

New version MySQL is available – 5.0.67
Will this patch be adopted for it?

By: Roman

Roman — Mon, 04 Aug 2008 18:05:54 +0000

mysqld crashes with this patch on query
create table bbb SELECT * FROM aaa;
when table aaa does not exists

# mysql -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2817 to server version: 5.0.51b-log

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

mysql> create database foobar;
Query OK, 1 row affected (0.00 sec)

mysql> use foobar
Database changed
mysql> create table bbb SELECT * FROM aaa;
ERROR 2013 (HY000): Lost connection to MySQL server during query

By: Roman

Roman — Sun, 29 Jun 2008 13:33:56 +0000

mysqld crashes with this patch on query
create table bbb SELECT * FROM aaa;
when table aaa does not exists

# mysql -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2817 to server version: 5.0.51b-log

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

mysql> create database foobar;
Query OK, 1 row affected (0.00 sec)

mysql> use foobar
Database changed
mysql> create table bbb SELECT * FROM aaa;
ERROR 2013 (HY000): Lost connection to MySQL server during query

By: Ronald Bradford

Ronald Bradford — Thu, 24 Apr 2008 21:44:56 +0000

Great work in giving this back to the community.

We just need a build farm/repository of key patches that can be applied together and pre-built for more community members to get access,uptake,testing and feature improvement.

By: rusty_angel

rusty_angel — Tue, 08 Apr 2008 00:24:34 +0000

Here is a patch for mysql-5.0.51a, the latest at the moment. It works at my company's servers for 4 days already. It fails to pass the tests (make test-bt) when you try no build rpm from src.rpm, but works just fine. (And vanilla mysql fails all the tests, too)

By: Alastair Dallas

Alastair Dallas — Sun, 06 Apr 2008 04:10:51 +0000

Well, I’m feeling mollified. Before leaving my previous comment (15 min. ago), I filed a support ticket. It’s Saturday night, and Bluehost support (Gordon) just emailed to say they looked at my account and performed an unspecified fix. I didn’t expect a response before Monday. So, thanks. I don’t mind a brief outage in the interest of progress, but things got disastrous all of a sudden with this latest change.

By: Alastair Dallas

Alastair Dallas — Sun, 06 Apr 2008 03:47:45 +0000

I am an extremely unhappy customer. I am running an online newspaper and MySQL was out for 7 hours on Apr. 3. I know because I log SQL query errors and I got hundreds of “MySQL server has gone away” errors, followed by hundreds of “Incorrect key file for table . Try to repair it.” I ended up repairing each table manually.

No warning; no support; no apology (apparently no awareness). I really don’t appreciate having to play CSI to figure out why my site went down. When I find out it wasn’t my developers and it wasn’t my customers…I’m angry. My site is on box162; I’m not sure where MySQL is. I see, digging around, that my MySQL has been up 6 hours–it’s 9:47 p.m. 4/5 now, so that means it went down around 3:30 Saturday. I’ll just tell my subscribers that they can’t access the site sometimes for no reason. They’ll understand.

By: Mario Alberto Garza Diaz

Mario Alberto Garza Diaz — Fri, 04 Apr 2008 15:07:06 +0000

hola:

es un placer conocerte aunque sea por este medio. me gustaria comentar lo siguiente:

se que te sorprendera que esto no este en ingles. pero bueno, esto hara que te des cuenta que!! no cuentas con personal bilingue que nos ayude a los que no hablamos ingles medianamente comprensible.

asi que decidi saludarte y comentar al respecto, hay mucha gente en mexico y en otros paises de habla hispana, que probablemente les interese estar en tu web hosting.
pero los problemas tecnicos o preguntas podrian ser un problema mayor al no poder comunicarnos apropiadamente.

me despido de ti y de tus lectores del blog.

I born to fishing.

By: Dave

Dave — Fri, 04 Apr 2008 14:39:21 +0000

Looks great Matt! I don’t think it’s been rolled out to my box yet. Here are some issues you might consider addressing in the FAQ: Will normal users have the ability to run this command, or will it only be allowed as root or another administrator account, to be accessed by BH admins? Is there any performance overhead from tracking these stats? How long will it take for the stats to reset? For example, if you imported large database, or had a daily cron that exported the db, would that make your daily stats go off the chart? Is account suspension automated, like CPU quota, or do you get an email warning, or what?

Thanks!

By: rusty_angel

rusty_angel — Fri, 04 Apr 2008 08:36:14 +0000

I managed to update patch for 5.0.51a and make in compile (looks like your diff did something wrong and simply put some code into another function. Will build rpm, test it and release if it’s working.