mysql crashing on osx 10.3.9

I'm running a dual G5 xserve with OSXS 10.3.9. Mysql version 4.0.24 (the version that ships with the OS). For many months now mysql has been stopping/crashing about twice a week. It's primary purpose in life is to provide the database for a minimally used Horde webmail setup. I've looked at

load balacing in a replicated environment

I am considering setting up replication for a loaded database that has to perform thousands of heavy selects every day. I want to have a master with one way replication to multiple slaves. But I also want to be able to load balance connections across the multiple slaves. What options exist t

Re: processes and threads question

as well. On Tue, 2005-01-18 at 13:15 -0500, Eben Goodman wrote: I used to run mysql 3.x on Redhat, and would on any given day have anywhere from 5 to 30 mysqld process/threads going depending on traffic. I upgraded to mysql 4.0.17 on a dedicated redhat box, and now it only ever shows 1 mysqld

processes and threads question

I used to run mysql 3.x on Redhat, and would on any given day have anywhere from 5 to 30 mysqld process/threads going depending on traffic. I upgraded to mysql 4.0.17 on a dedicated redhat box, and now it only ever shows 1 mysqld process/thread that uses max cpu and consumes a good deal of mem

lots of connections and RAM

for a server that is configured for 500 to 1000 max_connections, how much RAM is recommended to support this? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: storing large integers properly

yes, some do end in 'x' as I just discovered. Thanks to everyone for the input, I have decided to convert to varchar and re-index. Keith C. Ivey wrote: On 5 Aug 2003 at 9:49, Eben Goodman wrote: The data type of the field I am storing this info in is a bigint(16) unsigned.

storing large integers properly

I am storing book isbn numbers in a table. isbn numbers are 10 digit numbers and many start with 0. The data type of the field I am storing this info in is a bigint(16) unsigned. It appears that isbns that start with 0 are going in as 9 digit numbers, the 0 is being ignored or stripped. I h

Re: too many connection error driving me nutz, need advice

tually open multiple connections to the same database.. Add this file into php.ini under the script_prepend part (gets run after all other scripts are done) .. Perhaps something is getting left open/not closing properly? On Thu, 17 Jul 2003, Eben Goodman wrote: I run a site that gets a fair amount o

too many connection error driving me nutz, need advice

I run a site that gets a fair amount of traffic throughout the day. For days at a time the site runs smoothly, and then, at seemingly random intervals I get the mysql error "Too many connections". The only solution for this is to stop the mysql service and restart it. I changed the max_conne

too many connections error

I have been getting the following error consistently every few days: Warning: Too many connections in /path/to/connection.php I altered the max_connections in my.cnf to allow for 300 connections. I am not using persistent connections with php. I used to use them but got this too many connecti