Re: Solaris 10 performance improvements??

2005-02-26 Thread Dylan Neild
IIRC MySQL is (or was) developed on Solaris, so it's always been very stable and well supported. As for Linux outperforming Solaris .. 10 is very fast. We have it running in production (since 10_72) at over 1000qps on a dual opteron (8GB) and have never had any performance related problems. Dyl

Re: MySQL and x86-64

2004-12-15 Thread Dylan Neild
Hey, 1. We just installed a very large MySQL installation on a dual opteron 2ghz system with 16GB of memory and it -flies-. That's pretty subjective, so check: http://www6.tomshardware.com/cpu/20030422/opteron-17.html http://www.infoworld.com/article/04/09/17/38FE64shootout2_1.html Definately, g

Re: Query Cache slow downs?

2003-08-04 Thread Dylan Neild
r post, but I was curious about the hardware you have MySQL running on. Could you tell me about your setup? thanks, joe On Fri, 2003-08-01 at 23:46, Dylan Neild wrote: Hi everyone, I've been looking everywhere for an answer to this, so please excuse me if it should have been obvious. I have a ve

Query Cache Issues, Continued

2003-08-03 Thread Dylan Neild
OK, I have a MySQL server running 4.0.12 on a 12 CPU Sun U4500 with 12GB of memory. With the query cache running, this machine would noticeably "hiccup" (just stop responding to requests) every so often and wouldn't squeeze more then 1000 queries per second or so as a result (heavily mixed OLT

Re: Allowing remote login

2003-08-02 Thread Dylan Neild
Hi There, Though it's in the manual, you may want to do something like this: GRANT ALL ON database.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password' Of course, you'll want to replace: - ALL with access privelages that are much safer (assuming you don't completely trust the remote user). - databa

Query Cache slow downs?

2003-08-01 Thread Dylan Neild
Hi everyone, I've been looking everywhere for an answer to this, so please excuse me if it should have been obvious. I have a very big MySQL server, under load, serving in the 1500 QPS range. Under times of high concurrenncy (many threads connected issuing queries), I start to see a lot of the