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

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.

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: bzr

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, o

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: 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 wrote: > Hi. > > We have some MySql servers in a circular replication, and one of the servers > is having some performa

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 www.benetl.

RE: incremental name search?

2009-09-21 Thread Mike Spreitzer
These are names&titles 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" cc "'Michael Dykman'" , mysq

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 th

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

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 G

RE: incremental name search?

2009-09-21 Thread Jerry Schwartz
SoundEx doesn't do much for names, or non-English words for that matter. Although you could use AJAX to handle the web part of this, I can't imagine it being able to handle much of a load. I think you'll beat the system to death, to little avail. Regards, Jerry Schwartz The Infoshop by Global

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 wrote: > Suppose I have a table of a few thousand people, with a FirstName field > and a LastName field.  Sadly, my

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

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 P