I would concur that if you just take the same transaction-oriented
benchmark and apply it to MySQL, you'll find it lacking in
performance. It's not surprising that out of the box, MSSQL has
higher transactions per second, after all they were the TPS race that
was so prominent a few years ago, and that benchmark is a major point
of comparison.
But MySQL is a different animal, and the big issue is how you handle
locking, which influences the table type you choose and how you model
your data and build your app. I'm only familiar with MySQL 4.1 and
below, and only the VERY fast MyISAM tables, which do not support ROW
locking. But by using LAST_INSERT_ID as the foreign key, you can
INSERT into related tables without any locks! It's possible to use
relative updates, depending on how you structure your related tables,
to avoid the need for transaction locking on updates.
The operations are still atomic, but without transaction locks, and
VERY fast. Of course you sacrifice a lot of things you get with a
real Transaction, and I think MySQL still needs improvements in
indexing performance. But I think the decision should be made on
issues other than speed.
Bill
William M. Conlon, P.E., Ph.D.
To the Point
2330 Bryant Street
Palo Alto, CA 94301
vox: 650.327.2175 (direct)
fax: 650.329.8335
mobile: 650.906.9929
e-mail: mailto:[EMAIL PROTECTED]
web: http://www.tothept.com
On Feb 19, 2007, at 8:41 AM, Rick Sanders wrote:
Hi Jason,
I have one client on a dedicated server. They process about 200,000
transactions daily and have 20,000 visitors daily to the website.
We started with MYSQL. As the database grew, the performance
decreased. We then switched over to MSSQL server and the
performance was increased by 35%. We did this as a test.
Because the price for the license is high, we also offered
Pervasive SQL which is considerably less expensive. Again, the
performance increase was about 30 to 35% over MYSQL.
For the price, MYSQL can’t be beat. But, when you’re dealing with a
lot of transactions and large amounts of data I prefer to use MSSQL
if the client can afford it.
<image003.jpg>
Rick Sanders
President
902-401-7689
www.webenergy-sw.com
Shop online for computer systems, accessories, and much, much more!
http://shop.webenergy-sw.com
From: Jason Pamental [mailto:[EMAIL PROTECTED]
Sent: February 19, 2007 12:17 PM
To: [email protected]
Subject: Re: SPAM-MED: RE: Witango-Talk: OT: Witango hosting
Stefan,
Well put. I think that there is enough research out there
supporting the speed and capabilities of both engines to argue
forever. Simply put though, MySQL is in use in enough high-traffic
and mission critical enterprise installations that any blanket
statements should be taken with a grain of salt. Rick - I don't
mean to take away from your own research - we all have to rely in
many cases on our own perceptions and experiences. But we should
all try to refrain from making statements that can so easily
undermine what others in the community are doing. I would think
that if Robert Garcia were to weigh in on this he could spell out a
very convincing case for MySQL given the tremendous load his
projects put it under on a daily basis. Of course, I use SQL Server
(2000 and 2005) as well as MySQL daily, and the ease of management
and use with SQL Server is amazing, so I tend to lean towards SQL
Server simply because I have it - but were I faced with having to
purchase the licenses myself, I'm not sure I'd feel compelled to do
so.
Cheers everyone-
Jason
-----
Jason Pamental
Director of Web Services
North Sails
Office: 401.643.1415
Fax: 401.643.1420
Mobile: 401.743.4406
Email: [EMAIL PROTECTED]
On Feb 19, 2007, at 10:21 AM, Stefan Gonick wrote:
Hi Rick,
Those arguments are a far cry from "yech". My point was just that
Mysql is a reasonable
database and it's free. It doesn't deserve that kind of negative
comment, which indirectly
casts aspersions on With. Obviously, their site doesn't need a
super high performance
database, so a free one is just fine.
Stefan
At 10:13 AM 2/19/2007, you wrote:
Hi Stefan,
I won’t get into a debate, but on Windows in a high-volume
production environment Microsoft SQL server is the fastest hands-
down, followed by Pervasive SQL a close second.
I’ve never bench-marked MSSQL on Windows vs. MYSQL on Linux, but
the research I have done stated that MSSQL is faster.
Also, I’ve done lots of work with MYSQL and in an environment where
the traffic is high, MSSQL doesn’t perform well. Again, my
experience has been on Windows.
<6b2db6b.jpg>
Rick Sanders
President
902-401-7689
www.webenergy-sw.com
Shop online for computer systems, accessories, and much, much more!
http://shop.webenergy-sw.com
From: Stefan Gonick [ mailto:[EMAIL PROTECTED]
Sent: February 19, 2007 10:45 AM
To: [email protected]
Subject: Re: SPAM-MED: RE: Witango-Talk: OT: Witango hosting
What is "yech" about Mysql? Since version 4 it has been a quite
usable database.
Stefan
At 09:37 AM 2/19/2007, you wrote:
I can’t believe they use MYSQL! Yech!
<6b2db7a.jpg>
Rick Sanders
President
902-401-7689
www.webenergy-sw.com
Shop online for computer systems, accessories, and much, much more!
http://shop.webenergy-sw.com
From: Wolf, Gene [ mailto:[EMAIL PROTECTED]
Sent: February 19, 2007 10:31 AM
To: [email protected]
Subject: Witango-Talk: OT: Witango hosting
This is a bit off topic. I'm looking for a hosting service for
my personal use. No, not business related. *laughs* If any of you
offer site hosting and Witango app hosting (and perhaps database
support as well) would you please send me some information
pertaining to costs? Yes, I did try the Witango e-mail search
looking for Hosting in the message title and received the following
error message:
Error
An error occurred while processing your request:
File: searchforum.taf
Position: DirectDBMS
Class: DBMS
Main Error Number: 1064
[MySQL][ODBC 3.51 Driver][mysqld-5.0.22-community-max]You have an
error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near 'ORDER BY
w1.datereceived DESC limit 50' at line 12
23000
File: searchforum.taf
Position: DirectDBMS
Class: Internal
Main Error Number: -101
Gene Wolf
Supervisor, Business Systems
DRS Sensors & Targeting Systems-Optronics
2330 Commerce Park Drive NE
Palm Bay, Florida 32905
Phone: 321-309-0685
321-309-0202 (fax)
Dictionary.com Word of the Day
http://dictionary.reference.com/wordoftheday/
This e-mail, including any attached files, may contain confidential
and privileged information for the sole use of the intended
recipient. Any review, use, distribution, or disclosure by others
is strictly prohibited. If you are not the intended recipient (or
authorized to receive information for the intended recipient),
please contact the sender by reply e-mail and delete all copies of
this message.
"This (document/presentation) may contain technical data as defined
in the International Traffic In Arms Regulations (ITAR) 22 CFR
120.10. Export of this material is restricted by the Arms Export
Control Act (22 U.S.C. 2751 et seq.) and may not be exported to
foreign persons without prior written approval from the U.S.
Department of State."
______________________________________________________________________
__
TO UNSUBSCRIBE: Goto
http://www.witango.com/developer/maillist.taf
______________________________________________________________________
__
TO UNSUBSCRIBE: Goto
http://www.witango.com/developer/maillist.taf
=====================================================
Database WebWorks: Dynamic web sites through database integration
http://www.DatabaseWebWorks.com
CoachVille: For coaches and people taking teleclasses
http :// www.cvcommunity.com?af=69474
______________________________________________________________________
__
TO UNSUBSCRIBE: Go tohttp://www.witango.com/developer/maillist.taf
______________________________________________________________________
__TO UNSUBSCRIBE: Go tohttp://www.witango.com/developer/maillist.taf
=====================================================
Database WebWorks: Dynamic web sites through database integration
http://www.DatabaseWebWorks.com
CoachVille: For coaches and people taking teleclasses
http :// www.cvcommunity.com?af=69474
______________________________________________________________________
__TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
______________________________________________________________________
__TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
______________________________________________________________________
__ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
