Re: Access speed INNODB VS. MyISAM

2006-06-04 Thread Ware Adams
On Jun 3, 2006, at 7:54 PM, Richard wrote: I have been using a database for several years that uses many 'lookup' style tables. i.e. no updates to these tables. I dumped the whole thing into an INNODB database for simplicity, but I now wonder if I can speed things up if I put only my

myisamchk (was: name 'Szczech' returns more rows then 'Szczec%')

2006-06-04 Thread Chris Sansom
At 14:02 +0300 1/6/06, Remo Tex wrote: If you change the character set when running MySQL, you must run myisamchk -r -q --set-collation=collation_name on all MyISAM tables. Hi My problem isn't quite the same as the original poster's, but I suspect the solution may be the same. However, I'm

World-Wide Attention: Top Language to interface with SQL servers - PostgreSQL, MySQL, FireBird

2006-06-04 Thread Al_Dev
World-Wide public announcement (every human animal on this planet must read this announcement) : The top RDBMS SQL systems are: Number one: PostgreSQL Number two: FireBird and MySQL. Now, which are the top computer languages which you would use to interface with these SQL servers?? You

Broken Mac pref panel

2006-06-04 Thread Marcus Bointon
I'm having trouble with the prefpane in OS X (on a MacBook) with a fresh install of the standard binary 5.0.22 (i686). It's completely broken for me. If the server is running and I click 'stop', it goes into a loop consuming about 70% CPU with no disk activity, and the machine gets very

my.cnf not being found?

2006-06-04 Thread Marcus Bointon
On the same OS X machine that's having prefpanel trouble with 5.0.22, I find that mysql is not loading the values set in /etc/my.cnf. The contents of the file is from another Mac that works just fine with it. The file is world-readable. Should it be somewhere else? Marcus -- Marcus Bointon

Re: myisamchk (was: name 'Szczech' returns more rows then 'Szczec%')

2006-06-04 Thread Chris Sansom
At 18:34 +0100 4/6/06, Chris Sansom wrote: I'm stumped! How exactly do I go about this? It's OK - I sorted it out. Turns out I needed to use upper case for the .MYI. Doh! -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ Old professors never die; they just lose their

Re: myisamchk (was: name 'Szczech' returns more rows then 'Szczec%')

2006-06-04 Thread gclark
At 14:02 +0300 1/6/06, Remo Tex wrote: If you change the character set when running MySQL, you must run myisamchk -r -q --set-collation=collation_name on all MyISAM tables. Hi My problem isn't quite the same as the original poster's, but I suspect the solution may be the same. However, I'm

Re: my.cnf not being found?

2006-06-04 Thread Petr Chardin
On Sun, 2006-06-04 at 23:28 +0100, Marcus Bointon wrote: On the same OS X machine that's having prefpanel trouble with 5.0.22, I find that mysql is not loading the values set in /etc/my.cnf. The contents of the file is from another Mac that works just fine with it. The file is

Re: my.cnf not being found?

2006-06-04 Thread Marcus Bointon
On 5 Jun 2006, at 01:52, Petr Chardin wrote: mysqld --print-defaults. That produces: mysqld would have been started with the following arguments: i.e., it's got no options at all. It is a completely default install. Any other ideas? Marcus -- Marcus Bointon Synchromedia Limited: Putting

Re: my.cnf not being found?

2006-06-04 Thread Marcus Bointon
On 5 Jun 2006, at 03:12, Marcus Bointon wrote: Any other ideas? D'oh! I just fixed the my.cnf problems. Because of the slightly peculiar route that the my.cnf file got onto my MacBook, it had somehow had its line breaks translated to Mac format, and it seems MySQL doesn't like that. I

Re: Broken Mac pref panel

2006-06-04 Thread Marcus Bointon
On 4 Jun 2006, at 23:25, Marcus Bointon wrote: I'm having trouble with the prefpane in OS X It seems I'm not alone - there are several reports of this in the MySQL bug tracker. Looks like a bug in the prefpane: http://bugs.mysql.com/bug.php?id=19577 Marcus -- Marcus Bointon Synchromedia