Re: MySQL benchmarks

On Tue, 2004-01-13 at 01:58, Prasad Budim Ram wrote: > Hi All, > > Is there any AS3AP benchmark suite readily available for MySQL? Ram, Yes but you're asking it in the wrong place :) It is still not published to the public (we plan to publicly open our Benchmark BitKeeper tree later this month)

MySQL benchmarks

Hi All, Is there any AS3AP benchmark suite readily available for MySQL? Thanks in advance, Ram -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL benchmarks on the G5: Jaguar vs. Panther

If you're using only MyISAM tables for your data, then key_buffer should generally have as much RAM as it can have (up to the point where it makes sense, i.e., only has much RAM as is needed to store your index data). myisam_sort_buffer_size ought to be about 1/4 of your RAM. I re-ran the bench

Re: MySQL benchmarks on the G5: Jaguar vs. Panther

This is what I'm currently using on the dual 2GHz w/4GB of RAM: set-variable = query_cache_type=1 set-variable = query_cache_size=1024M set-variable = net_buffer_length=32760 set-variable = bulk_insert_buffer_size=32M set-variable= key_buffer=1024M set-variable= join_buffer_size=128M set-v

Re: MySQL benchmarks on the G5: Jaguar vs. Panther

Look in the support-files directory in the mysql directory. There are a bunch of sample config files that you can look at that named pretty obviously: small,medium,large,huge. Each one has a description on what kind of system these should be used on, based on RAM and usage. For instance, huge is

Re: MySQL benchmarks on the G5: Jaguar vs. Panther

At 13:21 -0500 07-11-2003, Gabriel Ricard wrote: [1.8 GHz G5:] select: Total time: 1428 wallclock secs (67.50 usr 25.18 sys + 0.00 cusr 0.00 csys = 92.68 CPU) [dual 2.0 GHz G5:] select: Total time: 146 wallclock secs (42.52 usr 33.74 sys + 0.00 cusr 0.00 csys = 76.26 CPU) How the select po

Re: MySQL benchmarks on the G5: Jaguar vs. Panther

On Friday, November 7, 2003, at 03:06 AM, Jan Pieter Kunst wrote: Hardware: 1.8 GHz G5 with 1GB RAM Panther (Mac OS X 10.3) doesn't have the sudden slowness in the 'insert' test that Jaguar (Mac OS X 10.2) has. Total time for Panther is faster than total time for Jaguar (5561.00 secs vs. 677

Re: MySQL benchmarks on the G5: Jaguar vs. Panther

I was wondering if you had journaling turned on in Panther and not in Jaguar? I'm not sure if it would have any effect on selects, I would think it would slow down inserts not selects. You notice the CPU breakdown is different. Journaling was turned on in both cases. JP -- MySQL General Mailin

Re: MySQL benchmarks on the G5: Jaguar vs. Panther

Thanks for posting the comparison, it's something I've been meaning to do myself. I was wondering if you had journaling turned on in Panther and not in Jaguar? I'm not sure if it would have any effect on selects, I would think it would slow down inserts not selects. You notice the CPU breakdow

MySQL benchmarks on the G5: Jaguar vs. Panther

Hardware: 1.8 GHz G5 with 1GB RAM Panther (Mac OS X 10.3) doesn't have the sudden slowness in the 'insert' test that Jaguar (Mac OS X 10.2) has. Total time for Panther is faster than total time for Jaguar (5561.00 secs vs. 6770.00 secs). 'Insert' is faster on Panther than on Jaguar (3316 secs v

Access vs Mysql benchmarks

Hello, I just took over and restructured an existing web site running on IIS/PHP/ODBC/MS Access. The site is up and running now (thanks to your help too..), but now the customer is speaking of adding MUCH more content to the database, (~10/50x increase) and to add search capability all over its

my InterBase vs mySQL benchmarks!

Hi, I am considering developing a project on mySQL or InterBase. I tried to find comparisons, benchmarks, etc, but found nothing... Could anyone point me to such documents? If anyone cares, I wrote a small PHP script to benchmark both DB.. it's really simple, but shows mySQL is faster all