MySQL Community Server 5.1.39 has been released

2009-09-21 Thread Jonathan Perkin
Dear MySQL users, MySQL Community Server 5.1.39, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.39 is recommended for use on production systems. As with MySQL 5.1.38, 5.1.39 includes the InnoDB Plugin version 1.0.4. This version of the InnoDB

incremental name search?

2009-09-21 Thread Mike Spreitzer
Suppose I have a table of a few thousand people, with a FirstName field and a LastName field. Sadly, my people are not so regular. Some names have three parts (e.g., due to marriage) crammed into the two fields (Hillary Rodham Clinton). Some even have titles (Dir, gastroent. dept., Fubar

Re: incremental name search?

2009-09-21 Thread Michael Dykman
Perhaps this could help you out.. http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_soundex - michael dykman On Mon, Sep 21, 2009 at 11:51 AM, Mike Spreitzer mspre...@us.ibm.com wrote: Suppose I have a table of a few thousand people, with a FirstName field and a LastName

100% CPU load problem

2009-09-21 Thread Lawrence Robertson
Hi. We have some MySql servers in a circular replication, and one of the servers is having some performance issues for some weeks. I tried with mysqlcheck and nothing is wrong. I'm logging the slow queries and there's nothing wrong. The complete database in this server is like 1GB when it's

RE: incremental name search?

2009-09-21 Thread Martin Gainty
agreed better to know which languages you'll support and load in the correct charset up front retro-fitting an existing DB to another charset can be time consuming and error-prone e.g. # Convert all tables to UTF-8 with binary collation and reset all char columns to correct width ALTER TABLE

RE: incremental name search?

2009-09-21 Thread Mike Spreitzer
Ah, yes, I forgot to describe the server and the load. Suppose my web app and MySQL are done via shared hosting by some common hosting business. I do expect multiple people to be using my web app, but generally only one (usually zero, sometimes one, maybe occasionally a few) at a time. Is

RE: incremental name search?

2009-09-21 Thread Mike Spreitzer
These are namestitles of Americans. This web app and database do not exist now (the current procedure is done with more primitive tech), and so I can make plausible adjustments to the plan. Thanks Mike Spreitzer/Watson/IBM 09/21/09 04:10 PM To Jerry Schwartz jschwa...@the-infoshop.com cc

free ETL tool for files using MySQL, Benetl version 3.1

2009-09-21 Thread benoît carpentier
Dear all, Benetl, a free ETL tool for files now using MySQL is out in version 3.1. You can freely download it at : www.benetl.net You can learn more about ETL tools at: http://en.wikipedia.org/wiki/Extract,_transform,_load Thanks for your interest. Regards, -- Benoît Carpentier

Re: 100% CPU load problem

2009-09-21 Thread Kyong Kim
Is the status information correct? mysql Ver 14.12 Distrib 5.0.27, for Win32 (ia32) Are you using some sort of vm? Kyong On Mon, Sep 21, 2009 at 12:23 PM, Lawrence Robertson lawrobert...@yahoo.com wrote: Hi. We have some MySql servers in a circular replication, and one of the servers is

RE: incremental name search?

2009-09-21 Thread Jerry Schwartz
Approximate things are something humans are very good at, but computers are not. I'll bet a Rolodex would be faster than a web-based application. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341

RE: incremental name search?

2009-09-21 Thread Jerry Schwartz
Beyond being leery of the whole project, I can't really say how well or poorly it would work. You are, after all, talking about at least one query per keystroke. On top of that you're going to be doing some tricky stuff in a PHP (or some such) back-end, to figure out what query to use - again,

how can i bzr the mysql-test-extra branch?

2009-09-21 Thread Wenbin Zhang
Hi all, I'm new to mysql and I'm looking into some bug cases of mysql. I tried to reproduce some bugs and the reports referred to the mysql-test-extra-6.0 branch. I also found that this branch is renamed to mysql-test-extra. The problem is, when I try to use bazaar to get this branch, using:

RE: incremental name search?

2009-09-21 Thread Gavin Towey
Last time I did this for a small app, I just selected all the names and returned them as a javascript array. All the auto-complete as you type logic was just done in the UI. If the list is large-ish you could simply have a cron process that creates a .js file which the web page would include.

Re: 100% CPU load problem

2009-09-21 Thread Lawrence Robertson
Is the status information correct? mysql Ver 14.12 Distrib 5.0.27, for Win32 (ia32) Are you using some sort of vm? I'm not using a VM at all. It's a simple PC with CentOS 4 and MySql. Don't know why is that Ver 14.12 Distrib 5.0.27, for Win32 (ia32). But the | version_compile_os