Re: gcc 3.4

2004-11-16 Thread Daniel Kasak
Dathan Vance Pattishall wrote:
Has anyone does any benchmarks with mysql, AMD and gcc 3.4? Gcc 3.4 is
suppose to support AMD specific instructions giving a boost in performance. 
 

I haven't done any benchmarking, no.
I have compiled MySQL with gcc-3.4.2 and gcc-3.4.3 on some desktop 
machines here ( purely to get the client libraries installed ) and I can 
say that it at least compiles. I also played around with MySQL-4.1.7 on 
one of these systems to see how MyODBC-3.51.10 works connecting to it - 
I loaded up a server database backup into it and did about an hour of 
testing. Everything seemed to work OK.

I would avoid gcc-3.4.x for now on server systems though. I'm pretty 
sure many people here would consider me a fool for using Gentoo on a 
production server, but I at least use the 'stable' branch, and the 
compiler that the stable profile uses is gcc-3.3.4. I agree with this 
choice. If you use gcc-3.4.x on a server system you are asking for 
trouble. Any performance gain you will gain will be quite small. I would 
be surprised if you got more than a 5% increase in performance, but I'm 
just guessing. If you're after performance, you're better off checking 
out the performance tuning guides available on the MySQL website. The 
query cache is particularly effective for us.

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

gcc 3.4

2004-11-16 Thread Dathan Vance Pattishall
Has anyone does any benchmarks with mysql, AMD and gcc 3.4? Gcc 3.4 is
suppose to support AMD specific instructions giving a boost in performance. 

 

 

 

 

DVP



Dathan Vance Pattishall http://www.friendster.com