MySQL Cluster

2004-04-15 Thread Troy Hakala
MySQL just announced their MySQL Cluster product. But the minimum requirements for it include a Xeon/Itanium/Opteron CPU and a SCSI drive with a RAID1 controller. Why is that? Seems strange. http://www.mysql.com/products/cluster/faq.html -- MySQL General Mailing List For list archives: http://l

Limiting query time

2003-07-18 Thread Troy Hakala
Is it possible to limit the query time in MySQL (3.x or 4.0)? For example, I'd like to have any query that takes more than a specified number of seconds just quit automatically. Seems dumb, but on a web site, nobody is going to wait minutes for a query to return so they refresh anyway. So on a

Connections always max out

2002-10-12 Thread Troy Hakala
Ok, I've been having this problem every so often and it's happening more and more these days and I still can't figure out a solution. I know this sounds vague, but maybe you can help me make it less so... I'm running version 3.23.44 and after a while, the maximum number of connections is reac

max_connect_errors & wait_timeout problem?

2002-07-31 Thread Troy Hakala
I decreased wait_timeout (from 28,800 to 300) to kill off sleeping threads. This morning, the server stopped accepting connections and gave me this error: ERROR 1129: Host 'hostname' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' flush-hosts worked and I

Re: Speed issues...

2002-07-31 Thread Troy Hakala
are there indexes on the right fields? do a "describe" on the query and let us know what you get. On Wednesday, July 31, 2002, at 02:17 AM, Richard Baskett wrote: > This is my first post here.. So be nice! ;) > > I have a database with a little over 60,000 records and when I do a > search > on

Re: max_connections recovery

2002-07-27 Thread Troy Hakala
The language is English (same as server) and the client is PHP. I've never seen this problem even when maxing out the connections at the default 100. On Thursday, July 25, 2002, at 02:55 PM, Georg Richter wrote: > On Thursday, 25. July 2002 18:48, Troy Hakala wrote: > Hello, >

Re: max_connections recovery

2002-07-26 Thread Troy Hakala
; Pada Thu, 25 Jul 2002 09:48:40 -0700 > Troy Hakala <[EMAIL PROTECTED]> menulis : > >> I've been running MySQL for 2 years with no problems. Yesterday, I >> increased the max_connections because I was getting "too many >> connections" >> error. Th

max_connections recovery

2002-07-25 Thread Troy Hakala
I've been running MySQL for 2 years with no problems. Yesterday, I increased the max_connections because I was getting "too many connections" error. This morning, the server again reached its limit but it never seemed to recover from it and constantly gave the "too many connections" error. I