The document says it evaluates the 'expr', so I'm guessing it is only
function calls and arithmetic evaluation. Although I have tried selects
without any luck. It could probably be documented a little more clearly,
or event better yet...a supported feature.
Ed
-Original Message-
From:
Hello.
In your query BENCHMARK() doesn't execute the query, it is
passed just like a string to the second argument of the BENCHMARK().
Raimundo Sierra wrote:
It is not clear to me what benchmark really does. Example:
SELECT SQL_NO_CACHE * FROM mytable where myVarcharRow like
Hello.
Usually only benchmarks will show a real picture
for you. Create foreign keys, perform some tests. Then
temporary disable FKs using SET FOREIGN_KEY_CHECKS=0 and
repeat the performance measurement. Super Smack is a good
tool for such kind of analysis. See:
The Mac was HFS+ journaled. Disk: the stock Apple-supplied one. The
Linux machine was a default SuSE 8.0 installation. ext2 as the
filesystem? No idea about journaling. No SCSI or RAID, just an
internal IDE disk. Both machines are really consumer-level machines,
no heavy-duty server hardware.
On Friday, November 7, 2003, at 09:05 AM, David Steinbrunner wrote:
The Mac was HFS+ journaled. Disk: the stock Apple-supplied one. The
Linux machine was a default SuSE 8.0 installation. ext2 as the
filesystem? No idea about journaling. No SCSI or RAID, just an
internal IDE disk. Both machines
On Wed, Nov 05, 2003 at 07:57:00PM +0100, Jan Pieter Kunst wrote:
Hi everyone,
I recently ran the MySQL benchmark suite on a Dual 1 GHz G4 running Mac
OS X Server 10.2.8, and an 800 MHz Intel machine running SuSE Linux 8.0.
Both installations used the same my.cnf file.
The results are
I'd be curious what kind of numbers Panther shows. Once I get my
xServe setup, just arrived, I'll try running some tests myself.
I just installed Panther on my G5 at home. Unfortunately, for some
reason I can't get the Perl module DBD::mysql to install (using CPAN,
had no problems doing this in
I can't imagine a G4 would be disk bound relative to an Intel machine, unless
there is something very wrong with the disk or controller. Also, you might want
to defrag your disk on the Mac.
G4s have much more disk bandwidth than any Intel I've ever seen. Almost as much
as my DEC Alpha. :)
On Thu, Nov 06, 2003 at 09:56:22AM -0700, Van wrote:
I can't imagine a G4 would be disk bound relative to an Intel machine, unless
there is something very wrong with the disk or controller. Also, you might want
to defrag your disk on the Mac.
G4s have much more disk bandwidth than any
Jeremy:
I believe that's what I was attempting to convey. My suggestion was that the
G4 should not be disk bound (limited by disk bandwidth). The CPU on my DEC
Alpha is a meagerly 300, but the disk can stream faster than my PIII true Intel
733MHz. That's why I suggested he look at the disk /
On Thu, Nov 06, 2003 at 10:19:59AM -0700, Van wrote:
Jeremy:
I believe that's what I was attempting to convey. My suggestion was that the
G4 should not be disk bound (limited by disk bandwidth). The CPU on my DEC
Alpha is a meagerly 300, but the disk can stream faster than my PIII true
On Thursday, November 6, 2003, at 11:38 AM, Jan Pieter Kunst wrote:
I'd be curious what kind of numbers Panther shows. Once I get my
xServe setup, just arrived, I'll try running some tests myself.
I just installed Panther on my G5 at home. Unfortunately, for some
reason I can't get the Perl
Jeremy D. Zawodny:
I was wondering if there is something I can do, configuration-wise, to
do something about those very slow 'inserts' (and 'updates') on the Mac?
Thanks in advance for any insight,
Did it appear to be disk or CPU bound?
Sorry, newbie here. I don't know how I can tell. The
I just installed Panther on my G5 at home. Unfortunately, for some
reason I can't get the Perl module DBD::mysql to install (using
CPAN, had no problems doing this in Jaguar) so I can't run the
benchmark suite for now.
JP
I had similar issues, but I was also using a custom build of MySQL,
On Thu, Nov 06, 2003 at 07:36:55PM +0100, Jan Pieter Kunst wrote:
Jeremy D. Zawodny:
I was wondering if there is something I can do, configuration-wise, to
do something about those very slow 'inserts' (and 'updates') on the Mac?
Thanks in advance for any insight,
Did it appear to
I'm not entirely sure what to do about the slow insert results, they
are the slowest part no matter how you configure it, it seems. I've
attached some benchmark results I ran on a dual 2GHz G5 for comparison.
Both MyISAM and InnoDB.
Here are the insert results though:
MyISAM:
insert: Total
I'd be curious what the specs of the hard drives are. Using the stock
drives in the Mac means you are using a drive that's about average (2MB
cache, 7200RPM). I would assume they are both ATA/IDE drives. But I
would guess the bottleneck is the drive. Try running top when you are
running your
FYI, I've found 'iostat' to be quite useful in monitoring the drive
transfer rates while benchmarking in OSX. Then again, in Panther all
you really need to do is pop open Activity Monitor (formerly Process
Viewer) which now has some nifty graphing for system status: cpu, disk,
ram activity and
On Wed, 2002-10-02 at 20:51, mos wrote:
At 09:40 PM 10/2/2002, you wrote:
For science fair I'm doing a project on MySQL. For my introduction, I
need some articles, benchmarks, or anything else credible that I can put
in the bibliography. If anyone can help me out, I'd be extremely
At 09:40 PM 10/2/2002, you wrote:
For science fair I'm doing a project on MySQL. For my introduction, I
need some articles, benchmarks, or anything else credible that I can put
in the bibliography. If anyone can help me out, I'd be extremely
appreciative! Thanks.
SS,
Benchmarks are no
if you have downloaded the src of mysql and installed it you can
find the mysql benchmark in your /usr/local/sql-bench
Else you also have downloads seperately on the mysql site for only
the benchmark (in rpm and others).
Grtz.
Luuk
On 4 Aug 2002, at 1:58, savaidis wrote:
Is there any
Daniel,
Tuesday, July 30, 2002, 4:09:00 PM, you wrote:
DK Where can I find some benchmark test result documentation.
DK First of all, I'm interested in comparing MySQL, Oracle and MSSQL speed in
DK different situations.
Check some links in the manual:
EWeek did a comparison review a few months back comparing MySQL, DB2,
Oracle, MS SQL, and SyBase. Although it compared using a Java front end,
so a lot of performance relied on JDBC support in the databases.
Anyway, here is the URL:
http://www.eweek.com/article2/0,3959,293,00.asp
On Tuesday,
Have you looked at:
http://www.mysql.com/information/benchmarks.html
On Tuesday 19 March 2002 11:50 am, Kathy Reyes wrote:
Hello all its me again
Does any one now of any database benchmarking utility that I can use on
mysql database???
http://www.mysql.com/doc/M/y/MySQL_Benchmarks.html
Duncan
--
Duncan Salada | Titan | www.titan.com/testeval
Email: [EMAIL PROTECTED] | Voice: 301-925-3222x375 | Fax: 301-925-3216
-Original Message-
From: Kathy Reyes [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 1:51 PM
25 matches
Mail list logo