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
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
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
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
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
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
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
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
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
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
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,
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:
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.
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
14 matches
Mail list logo