Re: best-performing CPU + platform for MySQL now? Opteron? OpenBSD? SuSE?

2004-09-24 Thread JG
uggested to be a problem for the -threads list, thren -kernel, then -threads again. At that point I had ran out of time. I love FreeBSD myself... so having to use Linux to get this kind of performance out of the MySQL server kind of sucks for us as well. Maybe the FreeBSD team has made improvement

Super-smack compile errors

2004-05-17 Thread JG
On Intel - FreeBSD 4.9 STABLE - using MySQL Ver 11.18 Distrib 3.23.55, for portbld-freebsd4.7 (i386) On AMD64 - FreeBSD 5.2 CURRENT - using Mysql Ver 14.3 Distrib 4.1.1-alpha, for portbld-freebsd5.2.1 (amd64) I get the same compile error: # make make all-recursive Making all in src c++ -DHAVE_C

super-smack on FreeBSD?

2004-05-17 Thread JG
Has ANYONE been able to get super-smack-1.2 to compile as-is on FreeBSD? ./configure --with-mysql make make install Without errors? Anyone? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

super-smack: aborting on failed query

2004-05-17 Thread JG
[EMAIL PROTECTED] > super-smack update-select.smack 30 100 Table 'http_auth' does not meet condtions, will be dropped Creating table 'http_auth' Loading data from file '/var/smack-data/words.dat' into table 'http_auth' Error running query load data infile '/var/smack-data/words.dat' into table htt

Re: Super-smack compile errors

2004-05-18 Thread JG
At 03:59 AM 5/17/2004 -0700, you wrote: On Intel - FreeBSD 4.9 STABLE - using MySQL Ver 11.18 Distrib 3.23.55, for portbld-freebsd4.7 (i386) On AMD64 - FreeBSD 5.2 CURRENT - using Mysql Ver 14.3 Distrib 4.1.1-alpha, for portbld-freebsd5.2.1 (amd64) I get the same compile error: # make make all-

Re: super-smack on FreeBSD?

2004-05-18 Thread JG
At 11:31 AM 5/18/2004 +0100, you wrote: On Mon, May 17, 2004 at 08:43:44PM -0700, JG wrote: > > Has ANYONE been able to get super-smack-1.2 to compile as-is on FreeBSD? > > ./configure --with-mysql > make > make install > > Without errors? No, it required various code chan

Re: super-smack: aborting on failed query

2004-05-18 Thread JG
At 09:15 AM 5/18/2004 -0700, you wrote: does the myslqd user (probably mysql) have permissions to read the /var/smack-data directory? Cheers, Trevor JG wrote: Trevor, Yes & No. I am doing a remote smack and super-smack is not installed on the remote server. (Should it be?) On the local se

run-all-tests errors: Warning Can't execute create.

2004-05-22 Thread JG
amd64f# ./run-all-tests --server=mysql --cmp=mysql --user=root --password=theword --log Warning: Can't execute create. Check the file 'output/create-mysql-FreeBSD_5.2_CURRENT_amd64-cmp-mysql' ^CWarning: Can't execute insert. Check the file 'output/insert-mysql-FreeBSD_5.2_CURRENT_amd64-cmp-mys

Re: MySQL Benchmark.

2004-05-27 Thread JG
Facing this new scenario, I am going to give Linux a shot -- definitively, this one is going to outperform OpenBSD. Using the same hardware, and the same options (as possible). Does anyone have a hint for this? Again, thanks a lot! Best regards, RV Tec I am a FreeBSD user, but after

Re: MySQL Benchmark.

2004-05-27 Thread JG
At 11:02 AM 5/27/2004 -0700, you wrote: Hi, I am sure all FreeBSD users are sick and tired of saying this. USE 4.10 Lots of people blindly follow version numbers but 5.x is a lot different than 4.x in ways I don't yet feel comfortable with using on production machines. Only one of those issue

Re: MySQL Benchmark.

2004-05-29 Thread JG
At 11:57 AM 5/27/2004 -0700, you wrote: At 11:02 AM 5/27/2004 -0700, you wrote: Hi, I am sure all FreeBSD users are sick and tired of saying this. USE 4.10 Lots of people blindly follow version numbers but 5.x is a lot different than 4.x in ways I don't yet feel comfortable with using on produ

RE: MySQL Benchmark.

2004-05-29 Thread JG
At 05:12 PM 5/29/2004 -0500, you wrote: Now the fun part becomes which linux distro do you use? Which is faster? Because trust me, each distro will benchmark differently. Let the games begin! Donny I've seen benchmarks from people who did different linux distros, and they were all pretty much with