Re: Broken Mac pref panel
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 Limited: Putting you in the picture [EMAIL PROTECTED] | http://www.synchromedia.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: my.cnf not being found?
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 guess I'll report that as a minor bug. It didn't fix the prefpane problem though. Marcus -- Marcus Bointon Synchromedia Limited: Putting you in the picture [EMAIL PROTECTED] | http://www.synchromedia.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: my.cnf not being found?
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 you in the picture [EMAIL PROTECTED] | http://www.synchromedia.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: my.cnf not being found?
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 world-readable. Should it be somewhere else? The location is correct. However mysqld looks for options in several files. For instance, it traverses the datadir, for my.cnf and home directory for .my.cnf. Then it merges defaults from all files read and attempts to start the server. So, it might be that you have another my.cnf, which is also processed. Try checking the option, which are actually read by the server with "mysqld --print-defaults". Petr > Marcus > -- > Marcus Bointon > Synchromedia Limited: Putting you in the picture > [EMAIL PROTECTED] | http://www.synchromedia.co.uk > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: myisamchk (was: name 'Szczech' returns more rows then 'Szczec%')
> 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 having trouble > running the myisamchk command. > > I'm using the Unix Terminal in Mac OS X, with MySQL 5.0.19, and it > won't let me get beyond a certain point in the file structure to find > exactly where the files are. I can 'drill down' as far as the mysql > directory, which has the promisingly-named data directory inside it. > However 'cd data' tells me I don't have permission... but 'sudo cd > data' simply repeats the same directory! I can't seem to get into > data at all. > You must have the server stopped. You must be logged in as root or mysql. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: myisamchk (was: name 'Szczech' returns more rows then 'Szczec%')
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 faculties. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
my.cnf not being found?
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 Synchromedia Limited: Putting you in the picture [EMAIL PROTECTED] | http://www.synchromedia.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Broken Mac pref panel
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 hot! The only way out is to force-quit system
prefs. If it's not running and I click start, I get the same
behaviour. If I start and stop it via the command line ('mysqld_safe'
and 'mysqladmin shutdown'), it all works perfectly. If I reboot, the
startupitem seems to work fine too. Reinstalling the prefpane didn't
help. Anyone else seen this?
Marcus
--
Marcus Bointon
Synchromedia Limited: Putting you in the picture
[EMAIL PROTECTED] | http://www.synchromedia.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
World-Wide Attention: Top Language to interface with SQL servers - PostgreSQL, MySQL, FireBird
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 MUST write your apps in pure object oriented language like - SmartEiffel, OCAML (Camel), Ruby, D-language or Java. I found the best ones to be : Number One: SmartEiffel http://smarteiffel.loria.fr Number Two: Camel (OCAML) http://caml.inria.fr Number Three: Ruby (With ruby virtual machine to speed up) http://www.ruby-lang.org/en Number Four: D-language and Java. http://www.digitalmars.com/d/dcompiler.html All the Banks, Financial Institutions, Governments, Universities, Military, Corporations in the whole world (every country) must take this advice in this announcement. SmartEiffel is found to be very interesting because it's compiler generates "C" language code output! In fact, 3 of the 4 Eiffel compilers actually output "C" code! And you know that "C" is the most portable language. Strongly recommended is the SmartEiffel for all your applications. The output "C" code from Eiffel is compiled. Also SmartEiffel can output to Java JVM bytecodes. See also language shootout at : http://www.geocities.com/alavoor The advice here is multi-billion dollar advice (take it serious)! Al Dev __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
myisamchk (was: name 'Szczech' returns more rows then 'Szczec%')
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 having trouble running the myisamchk command. I'm using the Unix Terminal in Mac OS X, with MySQL 5.0.19, and it won't let me get beyond a certain point in the file structure to find exactly where the files are. I can 'drill down' as far as the mysql directory, which has the promisingly-named data directory inside it. However 'cd data' tells me I don't have permission... but 'sudo cd data' simply repeats the same directory! I can't seem to get into data at all. So... I tried guessing that the file I want - which is for a table called 'attractions' in the database 'aptguserdb' - might be at data/aptguserdb/attractions.myd (and .myi for the index), but when I try the myisamchk command with the full path to there I get 'file does not exist'. I'm stumped! How exactly do I go about this? -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ Despite the high cost of living, it remains very popular. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access speed INNODB VS. MyISAM
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 updatable tables in INNODB (I need row level locking for these) and put all the lookup tables in MyISAM. The benchmarks I have looked at don't seem to reveal either as a clear winner, but I am probably not interpreting them properly. Probably the only real answer is to benchmark your particular application. That said, for any table that has high frequency writes while others are trying to read or write your only option is InnoDB. Similarly, if you want to do a live backup of a large table without shutting off write access you have to use InnoDB. If you are doing simple reads, even at very high volume you'll probably find MyISAM as fast or faster. You can mix and match them in general to get the right performance for each table. There are a few things that InnoDB won't handle (fulltext searches, some others) that will require MyISAM, but in general they are pretty much complete substitutes. InnoDB tables do take up more space than MyISAM in general, but other than that we've found no real downside to making everything InnoDB (other than the fact that the information sources are a little less common for InnoDB). From what you say, it sounds like all InnoDB or InnoDB for the tables with write and MyISAM for the others would work for you. Good luck, Ware Adams -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
