View creator host updates

Hello, After a system host name had changed, my organization updated the MySQL user records, changing the old (and now non-existent) host name to the new one. This caused any views that were created by users accessing the MtSQL server from the old host to become invalid as the view's

Re: Concurrent Inserts with merged table

At 08:54 PM 3/5/2009, Baron Schwartz wrote: Is there a way I can restore the concurrent select feature to a working state without having to shut down the server and rebuild the entire data base? Usually when concurrent insert is not permitted, it's because there are holes in the table that

Re: Finding replicated database

Hi, care to elaborate on the pit-falls of binlog-do-db? Thanks, Atle On Wed, 4 Mar 2009, Baron Schwartz wrote: No. But I would recommend removing binlog-do-db and using replicate-wild-do-table=mydb.% on the slave instead. The binlog-do-db approach has many pitfalls anyway, and is likely to

ANNOUNCE: check_mysql_health

Hi list, allow me to announce my Nagios plugin check_mysql_health. It was written to get as many important metrics from a database as possible. Have a look at the screenshot http://people.consol.de/~lausser/nagios/check_mysql_health.png to get an impression how a MySQL database can be monitored

Possible to get better error handling for invalid enum parameter to stored program?

If I define an enum parameter for a stored program, and the calling code sends an invalid value, they get the less than useful data truncated error. Is it possible to define the stored program to produce better error handling for that kind of error? This is probably a FAQ, but in general, it

Re: Possible to get better error handling for invalid enum parameter to stored program?

I'm afraid enums are useless for anything except compressing your data, since they don't reject bad values. If you want to limit a field to a set of values, you need to use a lookup table and a foreign key constraint. - Perrin On Fri, Mar 6, 2009 at 1:35 PM, David Karr

Re: Possible to get better error handling for invalid enum parameter to stored program?

Thanks. I thought that was the case, but I wanted to be sure. On Fri, Mar 6, 2009 at 12:07 PM, Perrin Harkins per...@elem.com wrote: I'm afraid enums are useless for anything except compressing your data, since they don't reject bad values. If you want to limit a field to a set of values,

How expensive is exception handling at end of cursor vs. UNIONing a sentinel?

Although I've been doing lots of work with SQL over the years, I've never done anything with stored procedures. While reading a book on MySQL stored programs, I'm struck by the fact that the common method of iterating through a resultset using a cursor requires doing exception-based branching (a

Re: MySQL Log and Data directories

Thanks Baron... Also, curious question.. as you might have used what is called GOOD hw configurarion with RAID 5/10 .. so whats the typical IO (rnd rw) that you archive/expect on high trafficked sites ? --- On Wed, 3/4/09, Baron Schwartz ba...@xaprb.com wrote: From: Baron Schwartz

Confused About Rows and Skipping On Import with MySQL Migration Toolkit 1.1

Hi folks, I'm trying to use MySQL Migration Toolkit 1.1 with MS SQL server 2005 http://dev.mysql.com/downloads/gui-tools/5.0.html - basically all is working great - some tables import no problem - except... I'm trying to import an address table and in the summary it says that there's a few