MySQL Community Server 5.0.81 has been released

Dear MySQL users, MySQL Community Server 5.0.81, a new version of the popular Open Source Database Management System, has been released. This release of the MySQL Community Server is based on the MySQL Enterprise Server 5.0.80 code base. Future releases in the MySQL Community Server 5.0

Re: SELECT of records that have a matching record in a many to many table

If I understand your question correctly (and I'm really not sure about that), you're using a LEFT JOIN where you actually want to use a RIGHT JOIN. Or you need to rewrite your query and set the tables in another order. On Thu, Apr 30, 2009 at 23:01, Nigel Peck nigel.p...@miswebdesign.com wrote:

Slowness connecting to MySQL

Please forgive the crossposting between the two groups. The problem I am having SEEMS to be a mysql and not a MyODBC problem but I cannot be sure so I am opening this question to both lists. If I have violated protocol in doing so, please accept my apologies. I have MySQL running under Ubuntu

MySQL University session on May 7: MySQL replication: new features in MySQL 5.1 and 6.0

MySQL Replication: Walk-through of the new 5.1 and 6.0 features http://forge.mysql.com/wiki/MySQL_Replication:_Walk-through_of_the_new_5.1_and_6.0_features This Thursday (May 7th, 14:00 UTC), Lars Thalmann will give a MySQL University session on MySQL Replication: Walk-through of the new 5.1 and

RE: Slowness connecting to MySQL

It could be slow reverse DNS lookups. Make sure the hostname/IP of the client are in the server's host file. Or try connecting to the server using an IP address instead of hostname. Andrew -Original Message- From: Menachem Bazian [mailto:gro...@bcconsultingservices.com] Sent: 04 May

Re: expired mysql connection ?

There really isn't enough data here for a clear diagnosis. In my experience, having the server 'go away' in the middle of a process is often caused by a bug in MySQL, more often than not triggered my some preposterous thing my client code was trying to do. Question: are you explicitly closing

backup from a slave

I have a master-slave replication that works well (thank you MySQL's team) :D each night I make a backup from my slave; this is my crontab line: mysqldump --opt -Q -u root --master-data -pxyz mydb /var/ mydb_backup.sql even that works well I'd like to use that backup to setup a new slave

configure parameters

Is there a place on the net that has detailed documentation on the possible parameters? I am doing a quick google and can't find it. Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: backup from a slave

MAS! wrote: I'd like to use that backup to setup a new slave (from the same (and unique) master); the problem is I don't know how set-up this new slave, since I don't know the right master binary-log num and position; in the backup I have the slave's binary-log/pos and not the master ones :(

Re: configure parameters

You mean the list you get when you run `./configure --help`? Also check out http://dev.mysql.com/doc/refman/5.0/en/configure-options.html Or do you need more detail? Please be specific in what you need. On Mon, May 4, 2009 at 22:40, michel compu...@videotron.ca wrote: Is there a place on the

Mysql Locked Process Hang

Hi. I am having a problem with a program I am writing. The program reads a file, checks an object file, and if the record doesn't exist, it inserts to a node table (one table per node) and the objects file. I wrote a C program to do this, with multiple processes running at one time. I have 15