Re: Innodb Questions (was: Mac OS X Table Corruption)

2005-07-23 Thread Ware Adams
. Then I don't know what to say about the MyISAM error, though I'd watch InnoDB pretty carefully as I think MyISAM is pretty robust on OS X too. We did also see these when a disk is failing, but I assume you've run disk utility. I guess it could be failing and not showing up in disk utility

Re: Innodb Questions (was: Mac OS X Table Corruption)

2005-07-23 Thread Dan Tappin
On Jul 23, 2005, at 12:49 PM, Ware Adams wrote: Then I don't know what to say about the MyISAM error, though I'd watch InnoDB pretty carefully as I think MyISAM is pretty robust on OS X too. We did also see these when a disk is failing, but I assume you've run disk utility. I guess

Re: Innodb Questions (was: Mac OS X Table Corruption)

2005-07-23 Thread Dan Tappin
So I've been poking around my system and I found /usr/lib/mysql/ /usr/share/mysql/ The mod dates on these are really old. Can I delete these safely? I'm guessing the are from the Apple install. These files seem to be in the /usr/local/mysql/ path also. Hmmm... I looked at my old Mac OS

4.1.13 OS X MAJOR I/O Degredation

2005-07-22 Thread Bruce Dembecki
this exact same thing with another server... times don't change much here, so it doesn;t seem to be specific to this one machine. This is all on Mac OS X 10.4.2 Best Regards, Bruce [data-admin:/var/mysql] root# tail -f mysql.err 050722 13:51:08 mysqld started InnoDB: The first specified data file

Re: Won't launch after uninstall and install on OS X

2005-07-21 Thread Michael Stassen
[EMAIL PROTECTED] wrote: Michael, here are some snippets from the error log that look relevant, from three times I tried to start: 050719 20:29:41 mysqld started 050719 20:29:46 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive

Won't launch after uninstall and install on OS X

2005-07-19 Thread sunblockster
Hi all, After deleting and reinstalling mysql on my Powebook G4 12, it starts and then quits immediate. I had to reinstall because my users seemed to not be working on. These are the steps I am taking after reinstalling and the errors I get: cd /usr/local/mysql sudo echo sudo

Re: Won't launch after uninstall and install on OS X

2005-07-19 Thread Michael Stassen
[EMAIL PROTECTED] wrote: Hi all, After deleting and reinstalling mysql on my Powebook G4 12, it starts and then quits immediate. I had to reinstall because my users seemed to not be working on. These are the steps I am taking after reinstalling and the errors I get: cd /usr/local/mysql

Re: Won't launch after uninstall and install on OS X

2005-07-19 Thread sunblockster
Michael, here are some snippets from the error log that look relevant, from three times I tried to start: 050719 20:29:41 mysqld started 050719 20:29:46 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive 050719 20:29:58 InnoDB:

Mac OS X Table Corruption

2005-07-06 Thread Dan Tappin
I am running into repeatable table corruption with MySQL 4.x on Mac OS X 10.x. I previously had a MySQL install on 10.2 Client under 3.x and never had an issue or any major problems at all. I upgraded to MySQL 4.x and have subsequently installed MySQL 4.x (from the supplied pkg's) on my

Re: Mac OS X Table Corruption

2005-07-06 Thread Dan Tappin
I had someone on the mac-osx server admin list point this out to me: http://docs.info.apple.com/article.html?artnum=107852#sql which is regarding a byte-ordering issue resolved in an upgrade from OS X 10.3.2 to 10.3.3. Now in my case I could have upgraded with out performing this procedure

Re: Mac OS X Table Corruption

2005-07-06 Thread SGreen
Dan Tappin [EMAIL PROTECTED] wrote on 07/06/2005 11:26:13 AM: I am running into repeatable table corruption with MySQL 4.x on Mac OS X 10.x. I previously had a MySQL install on 10.2 Client under 3.x and never had an issue or any major problems at all. I upgraded to MySQL 4.x and have

Re: Mac OS X Table Corruption

2005-07-06 Thread Dan Tappin
On Jul 6, 2005, at 10:26 AM, [EMAIL PROTECTED] wrote: I'm not a Mac guru but what you describe sounds like file system corruption. Can you do a diagnostic scan of your hard drives looking for bad sectors? You can move your data to another portion of the disk if you run an ALTER TABLE to

Re: MAC OS X backup after crash

2005-06-29 Thread Alla-amin
Michael, You are very correct - I renamed those fields and boom - it started working like magic, thank you so much. I have another question - the database in question that got crashed had mysql root password but the guys I took over from forgot the password and didn't do any mysql dump. So, I

Re: MAC OS X backup after crash

2005-06-29 Thread Michael Stassen
Alla-amin wrote: Michael, You are very correct - I renamed those fields and boom - it started working like magic, thank you so much. I have another question - the database in question that got crashed had mysql root password but the guys I took over from forgot the password and didn't do any

Re: MAC OS X backup after crash

2005-06-25 Thread Alla-amin
So far this was what I did, Took all files i.e frm, MYI and MYD files from the new server. Created a database like on another box running the version of mysql the old server was running and pasted them in the data folder of the database I created and viola - they all showed up, so i think it was

Re: MAC OS X backup after crash

2005-06-25 Thread Michael Stassen
Alla-amin wrote: So far this was what I did, Took all files i.e frm, MYI and MYD files from the new server. Created a database like on another box running the version of mysql the old server was running and pasted them in the data folder of the database I created and viola - they all showed up,

Re: MAC OS X backup after crash

2005-06-24 Thread Brent Baisley
I have to ask, are you using the same version of MySQL? I think 10.1 came with v3 and 10.3 come with v4.0. You may need to setup 10.1.5 on an old machine to dump the database for importing. On Jun 23, 2005, at 4:53 PM, Alla-amin wrote: Hi everyone, I just subscribed to the list and some

Re: MAC OS X backup after crash

2005-06-24 Thread Alla-amin
Yes, 10.1.5 runs mysqk version 3, it was actually running 3.23.51 and 10.3 runs 4.0.14 I think. Ok - the database in question have been backedup with files such as table1.frm.gz table1.MYD.gz table1.MYI.gz and so on.gz When I create a new database on the new server and copy these files to the the

Re: MAC OS X backup after crash

2005-06-24 Thread gerald_clark
Alla-amin wrote: Yes, 10.1.5 runs mysqk version 3, it was actually running 3.23.51 and 10.3 runs 4.0.14 I think. Ok - the database in question have been backedup with files such as table1.frm.gz table1.MYD.gz table1.MYI.gz and so on.gz When I create a new database on the new server and copy

Re: MAC OS X backup after crash

2005-06-24 Thread Brent Baisley
You can't transfer database files directly between versions. The file format is different. You need to dump the data to a text file and import it. This isn't like FileMaker, Word or Excel where it will realize it's an older version and convert it. On Jun 24, 2005, at 9:42 AM, Alla-amin

Re: MAC OS X backup after crash

2005-06-24 Thread Gleb Paharenko
Hello. What is in MySQL error log? Did you use InnoDB tables? Alla-amin [EMAIL PROTECTED] wrote: Hi everyone, I just subscribed to the list and some of the articles are very helpful. I'm facing some problem on my mysql database server. One of our Raid drives crashed and

MAC OS X backup after crash

2005-06-23 Thread Alla-amin
Hi everyone, I just subscribed to the list and some of the articles are very helpful. I'm facing some problem on my mysql database server. One of our Raid drives crashed and we had to backup the whole data to another drive (only files), we did no mysqldump. Now I want to restore a certain

5.0.7 Upgrade (from 4.1) on OS X doesn't recognize datadir

2005-06-17 Thread Bruce Dembecki
So I am attempting a 5.0 upgrade from 4.1 on one of our OS X servers... When attempting to launch mysqld it quits, with this error (showing two from the log files, happens with our build or the MySQL binary): 050617 14:03:46 mysqld started /usr/local/mysql-standard-5.0.7-beta-osx10.3

Problem connecting to MySQL 4.0.23 with MySQL Administrator 1.0.21 (Mac OS X)

2005-06-14 Thread Jan Pieter Kunst
Dear all, I have a MySQL 4.0.23 server running on an OpenBSD machine. When I try to connect to it with MySQL Administrator 1.0.21 from my Mac OS X machine, I get this error: Connection error Could not connect to MySQL instance at hostname. Error: unknown system variable 'sql_mode' (code 1193) I

Mac OS X - Query Browser 1.0.2-alpha Crash on Launch

2005-06-07 Thread Kieran Kelleher
Just feedback to the MySQL team... Query Browser will not launch on OS X 10.3.7 Here is console log output... console.log dyld: /Applications/MySQL Query Browser.app/Contents/MacOS/MySQL Query Browser can't open library: /usr/lib/libstdc++.6.dylib (No such file or directory

Re: OS X binary

2005-05-22 Thread Jan Pieter Kunst
2005/5/22, Dan [EMAIL PROTECTED]: I just installed the 5.0.4 binary for OS X. Where's the client? Most likely in /usr/local/mysql/bin/. Just add that to your $PATH. JP -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

OS X binary

2005-05-21 Thread Dan
I just installed the 5.0.4 binary for OS X. Where's the client? It's not in my PATH. Surely I don't have to now download the source and compile the client myself? Dan BEGIN-ANTISPAM-VOTING-LINKS -- If you are not the CanIt administrator

Compiling for 64 Bit on OS X 10.4

2005-05-03 Thread Bruce Dembecki
Hi! Can anyone help me with a 64 Bit OS X 10.4 binary? I've tried to compile it myself but get errors in the make process that I have no idea what to do with. Apple ships a MySQL 4.1.10a binary with Tiger, but it's not 64 bit. MySQL doesn't have a 64 Bit OS X 10.4 binary yet. Maybe my question

Re: OS X and MySQL table corruption...

2005-04-14 Thread Bruce Dembecki
We have a large OS X MySQL deployment on multiple servers and we have experienced a range of weirdness with table corruption that I was never able to fully determine the cause for. Moving to G5 Xserves (from G5 Towers and G4 Xserves) has seen all the problems go away as if a switch were thrown. I

Re: mysqld_multi at startup on Mac OS X not working

2005-04-14 Thread Bruce Dembecki
to be configured... Let's look at those... What version of OS X are you working on? Mine is running on 10.3.8, has been running on the previous versions of 10.3 also. The major difference I see is the test on if to start or not... This will be important. You have: if [ ${MYSQL:=-YES-} = -YES

Re: 4.1.11 and 5.0.3 on Mac OS X 10.3

2005-04-08 Thread Joerg Bruehe
is caused by Apple using different strings both internally and externally: 'uname -sr' yields Darwin 7.8.0 whereas customers call it Mac OS X 10.3. I fear such events will happen again as long as internal ('uname -a') and external (customer / marketing use) names are different: We use 'uname

mysqld_multi at startup on Mac OS X not working

2005-04-08 Thread Jan Pieter Kunst
Greetings, I have successfully configured mysqld_multi to have mysql 4.1.11 and 5.0.3 beta running on the same machine: # mysqld_multi start # exit % mysqld_multi report Reporting MySQL servers MySQL server from group: mysqld4 is running MySQL server from group: mysqld5 is running % However, I

4.1.11 and 5.0.3 on Mac OS X 10.3

2005-04-07 Thread Jan Pieter Kunst
Greetings, Is there a problem with MySQL 4.1.11 and 5.0.3 on Mac OS X 10.3? The 10.3 versions on the download pages are still at 4.1.10a and 5.0.2. Thanks, Jan Pieter Kunst -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: OS X Gui?

2005-04-07 Thread Scott Franks
I haven't used Maestro, but I like SQL Grinder. It gives you a reasonable GUI. www.advenio.com/sqlgrinder The WebObjects EOF package has better Entity modelling, but you have to buy it! : } --s On Apr 6, 2005, at 10:44 PM, Vic Cekvenich wrote: I am looking for a nice OS X GUI client, can

Re: OS X Gui?

2005-04-07 Thread Andreas Ahlenstorf
Vic Cekvenich schrieb: I am looking for a nice OS X GUI client, can be java for osx that works w/ mysql 5.x. (these don't work MacSQL, CocaMySQL, YouSQL. MySQK admin does work, but I want a bit more, like Maestro for OS X). AFAIK is the stuff from Navicat available for OS X. Regards

Re: OS X Gui?

2005-04-07 Thread NetSQL
Franks wrote: I haven't used Maestro, but I like SQL Grinder. It gives you a reasonable GUI. www.advenio.com/sqlgrinder The WebObjects EOF package has better Entity modelling, but you have to buy it! : } --s On Apr 6, 2005, at 10:44 PM, Vic Cekvenich wrote: I am looking for a nice OS X GUI client

Re: OS X Gui?

2005-04-07 Thread Brent Baisley
If you are looking for a GUI admin, MySQL has released a beta of MySQL Administrator for OSX. MySQL Query Browser is not available on OSX yet. Not sure which you may be looking for. On Apr 6, 2005, at 10:44 PM, Vic Cekvenich wrote: I am looking for a nice OS X GUI client, can be java for osx

Re: OS X Gui?

2005-04-07 Thread Jeff Justice
Query Browser is not available on OSX yet. Not sure which you may be looking for. On Apr 6, 2005, at 10:44 PM, Vic Cekvenich wrote: I am looking for a nice OS X GUI client, can be java for osx that works w/ mysql 5.x. (these don't work MacSQL, CocaMySQL, YouSQL. MySQK admin does work, but I want

Re: OS X Gui?

2005-04-07 Thread Eric Gorr
Jeff Justice wrote: Yes, there is a MySQL beta version of the administrator, but be warned, it has many bugs that I personally believe makes it unusable. I would have to agree. I just tried it out and within a few seconds had it crash on me. Hopefully they'll get it fixed up. -- == Eric Gorr

Re: 4.1.11 and 5.0.3 on Mac OS X 10.3

2005-04-07 Thread Joerg Bruehe
Hi Jan Pieter! Am Do, den 07.04.2005 schrieb Jan Pieter Kunst um 9:03: Greetings, Is there a problem with MySQL 4.1.11 and 5.0.3 on Mac OS X 10.3? The 10.3 versions on the download pages are still at 4.1.10a and 5.0.2. The problem is with the HTML generation, as the binaries for MySQL

OS X Gui?

2005-04-06 Thread Vic Cekvenich
I am looking for a nice OS X GUI client, can be java for osx that works w/ mysql 5.x. (these don't work MacSQL, CocaMySQL, YouSQL. MySQK admin does work, but I want a bit more, like Maestro for OS X). what should I use? tia, .V -- MySQL General Mailing List For list archives: http

5.x client for os x (navicat does not work) what to use?

2005-04-06 Thread NetSQL
I am looking for a nice OS X GUI client, can be java for osx that works w/ mysql 5.x. (these don't work MacSQL, CocaMySQL, YouSQL. MySQK admin does work, but I want a bit more, like Maestro for OS X). what should I use? tia, .V -- MySQL General Mailing List For list archives: http

OS X and MySQL table corruption...

2005-04-04 Thread Dan Tappin
I have been running into issues with MySQL table corruption issues on a couple of OS X systems. I end up with tables that need repair every day and some times multiples times per day. It's so bad now that I have a script that runs the mysql 'REPAIR TABLE...' command and then the myisamck

Re: OS X and MySQL table corruption...

2005-04-04 Thread Brent Baisley
I've been running on OS X for a while, although I haven't had any really heavy usage sites. I also haven't had a single corruption problem on a live database in the 2+ years I've been running MySQL. Now, I say on a live database. For the first time I tried upgrading the MySQL that comes

Re: OS X and MySQL table corruption...

2005-04-04 Thread Rahul S. Johari
Ave, I run MySQL 4.x on my Power Mac G5 with Mac OS X 10.3.8 with PHP5. I have been running Apache Web Server and my websites on this machine for almost 6 months now. And twice I have faced table corruption which I had to fix using REPAIR TABLE. Twice in 6 months isn't bad at all, yet, I wonder

Re: OS X and MySQL table corruption...

2005-04-04 Thread Jan Pieter Kunst
Hello, We have been running MySQL (about 50 databases, some medium-sized, some small, mix of MyISAM and InnoDB) on Mac OS X Client for more than a year (currently 10.3.8 with MySQL 4.1.10) and I have never seen any corrupt tables. We use only the MySQL-provided packages for our binaries. Maybe

Installation Instructions for MySQL for Mac OS X Panther

2005-02-16 Thread Asad Habib
Does anyone know where I can find in-depth, precise instructions to install MySQL on Mac OS X Panther client? - Asad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Installation Instructions for MySQL for Mac OS X Panther

2005-02-16 Thread Brent Baisley
in-depth, precise instructions to install MySQL on Mac OS X Panther client? - Asad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory

Re: Installation Instructions for MySQL for Mac OS X Panther

2005-02-16 Thread daniel
Does anyone know where I can find in-depth, precise instructions to install MySQL on Mac OS X Panther client? - Asad Just get the binary for OSX and follow the readme its simple. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: mysql on OS X

2005-01-10 Thread Scott Wilson
Hi Brent, thanks for your comments! An unbiased outside pov always helps! On Thu, 6 Jan 2005 14:32:16 -0500, Brent Baisley [EMAIL PROTECTED] wrote: While part of the problem may be OS X, Apple is still optimizing parts of the OS, I would say the problem is that you are comparing

Re: mysql on OS X

2005-01-10 Thread Scott Wilson
! scott On Thu, 06 Jan 2005 17:45:52 -0800, Bruce Dembecki [EMAIL PROTECTED] wrote: Hi Scott! We use MySQL on 9 Mac OS X machines. While we are looking at moving some of that back to big Sun boxes, that's a memory access/64 bit issue, not (directly) a performance issue. Looking at the live

mysql on OS X

2005-01-06 Thread Scott Wilson
Hello, I'm interested to hear peoples' experiences running mysql on OS X. I've moved the database for a fairly heaily used website (~ 2M queries a day) over to a new dual 2GHz XServe running OS X Server 10.3.7. This database has run smoothly on an aging dual PIII machine running freebsd

Re: mysql on OS X

2005-01-06 Thread Brent Baisley
While part of the problem may be OS X, Apple is still optimizing parts of the OS, I would say the problem is that you are comparing it to an aging PIII. Some people have gotten better performance from a PIII than a P4. The reason is cache. The PIII has a larger cache, MySQL loves cache. The G5

Re: mysql on OS X

2005-01-06 Thread Bruce Dembecki
Hi Scott! We use MySQL on 9 Mac OS X machines. While we are looking at moving some of that back to big Sun boxes, that's a memory access/64 bit issue, not (directly) a performance issue. Looking at the live stats one of the machines has an uptime of 55 days and has averaged 405.78 queries per

MySQL configuration file on Mac OS X

2004-11-29 Thread Andre Matos
Hi List, I installed the MySQL 4.1.7 on my Windows XP and for that I have used the my.ini to set the startup configuration for using a different language and to use the old_password. Now I am installing on my Mac and I am wondering if there is any my.ini or my.cnf on Mac OS X. Does anyone knows

Re: MySQL configuration file on Mac OS X

2004-11-29 Thread Michael Stassen
Mac OS X is Unix, so you follow the directions for Unix, which means you use my.cnf. See the manual for details http://dev.mysql.com/doc/mysql/en/Option_files.html. Michael Andre Matos wrote: Hi List, I installed the MySQL 4.1.7 on my Windows XP and for that I have used the my.ini to set

Re: MySQL configuration file on Mac OS X

2004-11-29 Thread Andre Matos
On 11/29/04 1:55 PM, Michael Stassen [EMAIL PROTECTED] wrote: Mac OS X is Unix, so you follow the directions for Unix, which means you use my.cnf. See the manual for details http://dev.mysql.com/doc/mysql/en/Option_files.html. Michael Andre Matos wrote: Hi List, I installed the MySQL

Re: MySQL configuration file on Mac OS X

2004-11-29 Thread Paul DuBois
is suppose to do the job? You create it according to the configuration you want. Thanks. Andre On 11/29/04 1:55 PM, Michael Stassen [EMAIL PROTECTED] wrote: Mac OS X is Unix, so you follow the directions for Unix, which means you use my.cnf. See the manual for details http://dev.mysql.com/doc/mysql

Re: MySQL configuration file on Mac OS X

2004-11-29 Thread Santino
below and I couldn't find the file my.cnf as described on the like that you gave me: /etc/my.cnf DATADIR/my.cnf ~/.my.cnf Do I need to create it or MySQL is suppose to do the job? Thanks. Andre On 11/29/04 1:55 PM, Michael Stassen [EMAIL PROTECTED] wrote: Mac OS X is Unix, so you follow

Re: libmysqlclient.so.12 client libraries for OS X

2004-11-01 Thread Rob Kudyba
--enable-thread-safe-client \ --enable-local-infile --enable-shared NOTE: This is a MySQL binary distribution. It's ready to run, you don't need to configure it! Michael Stassen wrote: MySQL does not come in pieces for Mac OS X. The whole thing comes in one Mac OS X binary package in PKG format

Re: libmysqlclient.so.12 client libraries for OS X

2004-11-01 Thread Michael Stassen
That's right, it's a precompiled binary. If you want a different configuration, you have to download the source and build your own http://dev.mysql.com/downloads/. I haven't tried --enable-shared on Mac OS X, so I can't promise it will work, but I'm not aware of any reason it wouldn't

Re: libmysqlclient.so.12 client libraries for OS X

2004-11-01 Thread Rob Kudyba
OK using the source and adding '--enable-shared' to the configure line works on OS X. I then had to create 3 links in order for our app to find the client library: ln -s /usr/local/mysql/lib/mysql/libmysqlclient.12.0.0.dylib /usr/lib/libmysqlclient.12.0.0.dylib ln -s /usr/lib/libmysqlclient

libmysqlclient.so.12 client libraries for OS X

2004-10-31 Thread Rob Kudyba
Where is there an OS X equivalent of: MySQL-client-VERSION.i386.rpm The standard MySQL client programs. You probably always want to install this package. which is referred to here: http://dev.mysql.com/doc/mysql/en/Linux-RPM.html Specifically, I am looking for libmysqlclient.so.12 since you

Re: libmysqlclient.so.12 client libraries for OS X

2004-10-31 Thread Michael Stassen
MySQL does not come in pieces for Mac OS X. The whole thing comes in one Mac OS X binary package in PKG format, downloaded as a disk image (.dmg) file http://dev.mysql.com/doc/mysql/en/Mac_OS_X_installation.html. The installer puts everything in /usr/local/mysql-VERSION, with a symbolic link

Mac OS X 3-4x slower reading rows than x86?!

2004-10-11 Thread Alex
I have some queries that return around 75,000 rows, and I've been trying to figure out how to speed them up a little. In the course of looking for the bottleneck, I discovered that simply getting a large result was considerably slower on OS X. I tested on a number of machines, with MySQL versions

Re: bad too many connections error (os x)

2004-09-06 Thread Egor Egorov
Michael Winston [EMAIL PROTECTED] wrote: Okay, so the first thing to try is obviously enlarge the max_connections. Have you tried this? Yes. It's set to 400 (a number we will never reach unless there's some sort of logjam). max_connect_errors is set to 200. Is it a webserver backend

Re: OS X Embedded Server

2004-09-03 Thread Paul DuBois
At 10:57 -0700 8/16/04, John Mistler wrote: I have written an application for MAC OS X.3 that interfaces with MySQL through the Client/Server approach. I would like to simplify the installation process of the application by using the embedded MySQL server instead. However, I am having trouble

Re: bad too many connections error (os x)

2004-09-02 Thread Egor Egorov
Michael Winston [EMAIL PROTECTED] wrote: Okay, so the first thing to try is obviously enlarge the max_connections. Have you tried this? Is it a webserver backend database? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net

Re: bad too many connections error (os x)

2004-09-02 Thread Michael Winston
On Sep 2, 2004, at 6:04 AM, Egor Egorov wrote: Michael Winston [EMAIL PROTECTED] wrote: Okay, so the first thing to try is obviously enlarge the max_connections. Have you tried this? Yes. It's set to 400 (a number we will never reach unless there's some sort of logjam). max_connect_errors is

bad too many connections error (os x)

2004-09-01 Thread Michael Winston
Hi- We've been running into a pretty serious problem for the past several versions of mysql 4.0 running on OS X (both client and server). Every once in a while we wake up to find the too many connections error coming up. There really aren't too many connections (we have our max set to 99

RE: bad too many connections error (os x)

2004-09-01 Thread Victor Pendleton
(os x) Hi- We've been running into a pretty serious problem for the past several versions of mysql 4.0 running on OS X (both client and server). Every once in a while we wake up to find the too many connections error coming up. There really aren't too many connections (we have our max set

Re: bad too many connections error (os x)

2004-09-01 Thread V. M. Brasseur
Michael Winston wrote: Hi- We've been running into a pretty serious problem for the past several versions of mysql 4.0 running on OS X (both client and server). Every once in a while we wake up to find the too many connections error coming up. There really aren't too many connections (we

Re: bad too many connections error (os x)

2004-09-01 Thread Santino
for the past several versions of mysql 4.0 running on OS X (both client and server). Every once in a while we wake up to find the too many connections error coming up. There really aren't too many connections (we have our max set to 99) - it's the type of message that appears when a wrong password

Re: bad too many connections error (os x)

2004-09-01 Thread Michael Winston
On Sep 1, 2004, at 9:10 AM, V. M. Brasseur wrote: Michael Winston wrote: Hi- We've been running into a pretty serious problem for the past several versions of mysql 4.0 running on OS X (both client and server). Every once in a while we wake up to find the too many connections error coming up

Re: bad quot;too many connectionsquot; error (os x)

2004-09-01 Thread William R. Mussatto
Michael Winston said: On Sep 1, 2004, at 9:10 AM, V. M. Brasseur wrote: Michael Winston wrote: Hi- We've been running into a pretty serious problem for the past several versions of mysql 4.0 running on OS X (both client and server). Every once in a while we wake up to find the too many

Re: bad too many connections error (os x)

2004-09-01 Thread Alex Greg
Michael Winston wrote: On Sep 1, 2004, at 9:10 AM, V. M. Brasseur wrote: Michael Winston wrote: Hi- We've been running into a pretty serious problem for the past several versions of mysql 4.0 running on OS X (both client and server). Every once in a while we wake up to find the too many

RE: bad too many connections error (os x)

2004-09-01 Thread Victor Pendleton
Not if the host that is blocked is `localhost`. -Original Message- From: Michael Winston To: Victor Pendleton Cc: '[EMAIL PROTECTED] ' Sent: 9/1/04 11:24 AM Subject: Re: bad too many connections error (os x) This would make sense since they all the connections are coming from the same

Re: bad too many connections error (os x)

2004-09-01 Thread Michael Winston
or Host blocked because of many connection erros? If it is the later you have reached max_connect_errors and need to issue flush-hosts. -Original Message- From: Michael Winston To: [EMAIL PROTECTED] Sent: 9/1/04 11:02 AM Subject: bad too many connections error (os x) Hi- We've been running

Re: bad too many connections error (os x)

2004-09-01 Thread Aftab Jahan Subedar
PROTECTED] - Directly to my notebook Alex Greg wrote: Michael Winston wrote: On Sep 1, 2004, at 9:10 AM, V. M. Brasseur wrote: Michael Winston wrote: Hi- We've been running into a pretty serious problem for the past several versions of mysql 4.0 running on OS X (both client and server). Every once

MySQL 4.1.3 won't autostart on Mac OS X?

2004-08-23 Thread Robert Kuhar
I've installed mysql-max-4.1.3-beta-apple-darwin7.4.0-powerpc to my PowerBook and have executed the MySQLStartupItem.pkg. The /Library/StartupItems/MySQLCOM exists and the /etc/hostconfig file includes the string MYSQLCOM=-YES-. However, the only way I can get MySQL to start after boot up is to

OS X Embedded Server

2004-08-16 Thread John Mistler
I have written an application for MAC OS X.3 that interfaces with MySQL through the Client/Server approach. I would like to simplify the installation process of the application by using the embedded MySQL server instead. However, I am having trouble figuring out how to: 1. Include the MySQL

Re: mysql-4.0.20 configure fails mac os x 10.3.1 client

2004-08-05 Thread Ron Phelps
I now have mysql running on my Mac OS X 10.3.4 box. The socket file is now being created correctly in my /usr/local/mysql/run directory. Thank you for all your help. Regards, Ron Phelps --- Ron Phelps [EMAIL PROTECTED] wrote: 1. I re-examined the error messages in config.log. I couldn't

Re: mysql-4.0.20 configure fails mac os x 10.3.1 client

2004-08-04 Thread Ron Phelps
this far. Ron --- Ron Phelps [EMAIL PROTECTED] wrote: I executed the following preparation work: 1. Upgraded Mac OS X 10.3.1 to 10.3.4 2. Installed two additional security updates 3. Examined the status of the Xcode packages pre-installed on the box Documentation states it is Xcode 1.0

Re: mysql-4.0.20 configure fails mac os x 10.3.1 client

2004-07-26 Thread Ron Phelps
I executed the following preparation work: 1. Upgraded Mac OS X 10.3.1 to 10.3.4 2. Installed two additional security updates 3. Examined the status of the Xcode packages pre-installed on the box Documentation states it is Xcode 1.0 for Mac OS 10.3 Panther 4. I ran all installers except, CHUD

mysql-4.0.20 configure fails mac os x 10.3.1 client

2004-07-25 Thread Ron Phelps
Environment: OS: Mac OS X 10.3.1, client mysql: 4.0.20 compiler: gcc version 3.3 20030304 (Apple Computer, Inc. build 1495) Symptom: Small section of configure log showing first errors shown below. There is a lot more of this, too much to post here. I've chopped the beginning and the end. I'm

Re: mysql-4.0.20 configure fails mac os x 10.3.1 client

2004-07-25 Thread Michael Stassen
First, I should point out that the simplest course would be to download the precompiled binary from mysql. That said, I admit I like to build from source, largely because whenever things go wrong, I always learn something. On first glance, I see a few problems: 1) You are running OS X 10.3.1

InnoDB my.cnf settings on OS X 10.3 Server?

2004-07-19 Thread Kieran Kelleher
I am trying to figure out the best innodb paramaters in the my.cnf file. Server is XServe, single CPU, G4 1 GHz, OS X Panther 10.3.4 with 2 GB RAM and 180GB hard drive, MySQL version 4.0.20. Right now I am running on default params. Does anyone out there have a suggested innodb parameters

Re: InnoDB my.cnf settings on OS X 10.3 Server?

2004-07-19 Thread Ware Adams
Kieran Kelleher wrote: Does anyone out there have a suggested innodb parameters or even a working set of params that I could start with. The InnoDB manual gives good suggestion. Some minor comments (none particularly OS X specific, but InnoDB works fine on it) innodb_buffer_pool_size is very

RE: InnoDB my.cnf settings on OS X 10.3 Server?

2004-07-19 Thread Lachlan Mulcahy
: InnoDB my.cnf settings on OS X 10.3 Server? I am trying to figure out the best innodb paramaters in the my.cnf file. Server is XServe, single CPU, G4 1 GHz, OS X Panther 10.3.4 with 2 GB RAM and 180GB hard drive, MySQL version 4.0.20. Right now I am running on default params. Does anyone out

Reset lost password on Server Logistics Mac OS X install

2004-07-06 Thread Eve Atley
I'm attempting to follow instructions at the MySQL AB site: http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html ...in order to reset a lost root password. I am using the Complete MySQL package from Server Logistics (www.serverlogistics.com) for Mac OS X Panther. I've read

OS X Version 4.1 Multithreaded?

2004-06-11 Thread John May
I've heard some recent rumblings that MySQL before 4.1 wasn't multithreaded on OS X. However, in actual usage I see every indication that is IS. Does anyone have a definitive answer either way? Thanks! - John -- --- John

Linking Embedded MySQL on Mac OS X

2004-06-09 Thread Eric Sword
I am having the same problem that someone else posted about back in December and I didn't see any responses for: http://lists.mysql.com/mysql/156346 Specifically, I am trying to link with libmysqld.a on Mac OS X and am getting 16 undefined link errors such as fixsfdi, floatdisf, udivdi3, moddi3

Bug? MySQL 4.1.2 and OS X 10.3.4

2004-06-01 Thread Greg Willits
This was New 4.1.2 Startup Trouble. The new title seemed more appropriate given my testing. Having installation problems with 4.1.2 on OS X 10.3.4. From previous thread: I've installed mysql 3 4 a dozen times or more, but I'm having trouble with 4.1.2 on OS X Server (10.3.4). Maybe it's

Re: Bug? MySQL 4.1.2 and OS X 10.3.4

2004-06-01 Thread Greg Willits
On Jun 1, 2004, at 5:04 PM, Greg Willits wrote: So, - G4/OS X Server: 4.0.20 installs fine, but 4.2.1 does not on 10.3.4 - G3/OS X Standard: 4.2.1 installs fine on 10.3.2, but after 10.3.4 Standard was installed, 4.2.1 did not work, yet 4.0.20 continues to install fine The fact that 4.0.20

Installing on OS X without installer

2004-05-23 Thread Chris Curnow
Hi, I've just downloaded the latest version of MySQL (4.0.20) for OS X. They seem to have omitted the installer - there's no .dmg file to download. The manual only covers installing from the .dmg for OS X. Can anyone help me on how to install without the installer. best regards

Re: Installing on OS X without installer

2004-05-23 Thread Greg Willits
On May 23, 2004, at 3:30 PM, Chris Curnow wrote: I've just downloaded the latest version of MySQL (4.0.20) for OS X. They seem to have omitted the installer - there's no .dmg file to download. The manual only covers installing from the .dmg for OS X. I think you must have just missed it. There's

Re: Installing on OS X without installer

2004-05-23 Thread Robert A. Rosenberg
At 08:30 +1000 on 05/24/2004, Chris Curnow wrote about Installing on OS X without installer: Hi, I've just downloaded the latest version of MySQL (4.0.20) for OS X. They seem to have omitted the installer - there's no .dmg file to download. The manual only covers installing from the .dmg for OS

HELP mysql.sock is missing in Mac OS X

2004-05-12 Thread Jose Manuel Islas Romero
I start MySQL and it seems to start the server normally TrentCioran:/usr/local/mysql TrentCioran$ sudo ./bin/mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 040512 21:27:05 mysqld ended but when i try to open the mysql console it sends me the message:

Re: HELP mysql.sock is missing in Mac OS X

2004-05-12 Thread Ware Adams
to start and then died. It seems like lots of people starting mysqld on OS X for the first time have a permission error on the data directory. It should be owned by mysql (the user already exists in both 10.2 and 10.3) and the group should be mysql. This problem is error number 13, but other error

Re: HELP mysql.sock is missing in Mac OS X

2004-05-12 Thread MTA-Traffic
iH doesn't look as tho mysqld is running -- mysqld ended did you install the standard database files? what about the permissions? can mysqld read those files check the error log in the data directory - hcir On May 12, 2004, at 6:53 PM, Jose Manuel Islas Romero wrote: I start MySQL and it

<    1   2   3   4   5   6   7   >