Re: Clash of the DBs in eWeek
- Original Message - I have also an other question. Do you you why they did not test postgressql ? I bet they failed to run it on NT (not a trivial task) Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Clash of the DBs in eWeek
Hi, I have also an other question. Do you you why they did not test postgressql ? Regards Henrik -- --- E-mail :[EMAIL PROTECTED] On Thu, 28 Feb 2002, Jesse, Rich wrote: -!-Anybody happen to see the cover story on the 02/25/2002 iss of eWeek titled -!-Database Clash? -!- -!-The pretty graphs say that their tests showed that Oracle and MySQL rocked -!-the other DBs they tested (including MS SQueaL Server). So I investigated. -!-I went to http://www.eweek.com/ and downloaded the Online Exclusive: -!-Download our configuration and tuning scripts. -!- -!-According to the Oracle setup docs in there, they're NOT using MTS and -!-processes in init.ora is 150. So then how did they test for 1000 -!-concurrent Web clients? -!- -!-Anyone have a thought? -!- -!- -!-Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -!- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Clash of the DBs in eWeek
On Thu, Feb 28, 2002 at 02:31:32PM -0800, Fisher, Julie wrote: And if you go to their web site www.mysql.com, they crash me compare against Oracle 8.1.6 and damn, they appear to look good. They gots lots more green stars than Oracle, by george. Of course most of those categories are SQL functions/capabilities. They don't even touch on memory allocation, types of backups/archiving, so on and so forth. And of course the lack of column constraints,table constraints, foreign keys...tsk just noise. Wait!! Dammit Oracle!! Give me the tinyint type! MySQL has it! ...maybe I'm just being fussy Also, FYI, the performance comparisons at www.mysql.com are based on an *out of the box* Oracle configuration. No tuning at all. You can guess how well Oracle performs. They have told me that they'd be happy to accept an updated comparison with a well tuned Oracle installation. Should be easy to do for someone here, they supply all the benchmark script and an automated harness for it. Tim. Julie Fisher Sandia National Laboratories Oracle 8i DBA - OCP8i Solaris 2.6,7/HP-UX 11.0 System Administrator Web Server Administrator -Original Message- Sent: Thursday, February 28, 2002 2:24 PM To: Multiple recipients of list ORACLE-L Also the article did not mention that in a lot of ways, MySQL is not nearly ready for prime time... MOYMMV Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fisher, Julie INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Bunce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Clash of the DBs in eWeek
At first glance it looks like they could have done more to tune Oracle. Certain tables could have been cached (or buffer pools could have been used). They're only using a 4K db block so it would have been nice to see tests with 8K and 16K db blocks. Sort area size may need tuning. I'd like to see some tkprof on the queries and see what the most expensive queries are in terms of CPU, I/O, and number of executions. It would be nice to see database results on Linux... It would be cool to see what some focused tuning efforts could do but who has time for that? Anyone have any other tuning suggestions for eWeek? Time for the tuning DBA guru's to shine. :-) -Original Message- Sent: Thursday, February 28, 2002 9:53 AM To: Multiple recipients of list ORACLE-L Anybody happen to see the cover story on the 02/25/2002 iss of eWeek titled Database Clash? The pretty graphs say that their tests showed that Oracle and MySQL rocked the other DBs they tested (including MS SQueaL Server). So I investigated. I went to http://www.eweek.com/ and downloaded the Online Exclusive: Download our configuration and tuning scripts. According to the Oracle setup docs in there, they're NOT using MTS and processes in init.ora is 150. So then how did they test for 1000 concurrent Web clients? Anyone have a thought? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Clash of the DBs in eWeek
Which docs? I looked at the init.ora file, and it had: processes=530 and MTS enabled. Brian -- -- | Brian McGraw -- Oracle DBA | | Central Alabama Oracle Users Group | -- Rachel Carmichael wrote: they lie? --- Jesse, Rich [EMAIL PROTECTED] wrote: Anybody happen to see the cover story on the 02/25/2002 iss of eWeek titled Database Clash? The pretty graphs say that their tests showed that Oracle and MySQL rocked the other DBs they tested (including MS SQueaL Server). So I investigated. I went to http://www.eweek.com/ and downloaded the Online Exclusive: Download our configuration and tuning scripts. According to the Oracle setup docs in there, they're NOT using MTS and processes in init.ora is 150. So then how did they test for 1000 concurrent Web clients? Anyone have a thought? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Greetings - Send FREE e-cards for every occasion! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian McGraw INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Clash of the DBs in eWeek
I'm guessing JDBC connection pooling within WebLogic. Jesse, Rich wrote: Anybody happen to see the cover story on the 02/25/2002 iss of eWeek titled Database Clash? The pretty graphs say that their tests showed that Oracle and MySQL rocked the other DBs they tested (including MS SQueaL Server). So I investigated. I went to http://www.eweek.com/ and downloaded the Online Exclusive: Download our configuration and tuning scripts. According to the Oracle setup docs in there, they're NOT using MTS and processes in init.ora is 150. So then how did they test for 1000 concurrent Web clients? Anyone have a thought? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Clash of the DBs in eWeek
Interesting, I went to the web page and clicked on the link Putting database performance to the test and got the following message Could not Connect to DB: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. Oh well, maybe they were mad because they lost! John [EMAIL PROTECTED] wrote: At first glance it looks like they could have done more to tune Oracle. Certain tables could have been cached (or buffer pools could have been used). They're only using a 4K db block so it would have been nice to see tests with 8K and 16K db blocks. Sort area size may need tuning. I'd like to see some tkprof on the queries and see what the most expensive queries are in terms of CPU, I/O, and number of executions. It would be nice to see database results on Linux... It would be cool to see what some focused tuning efforts could do but who has time for that? Anyone have any other tuning suggestions for eWeek? Time for the tuning DBA guru's to shine. :-) -Original Message- Sent: Thursday, February 28, 2002 9:53 AM To: Multiple recipients of list ORACLE-L Anybody happen to see the cover story on the 02/25/2002 iss of eWeek titled Database Clash? The pretty graphs say that their tests showed that Oracle and MySQL rocked the other DBs they tested (including MS SQueaL Server). So I investigated. I went to http://www.eweek.com/ and downloaded the Online Exclusive: Download our configuration and tuning scripts. According to the Oracle setup docs in there, they're NOT using MTS and processes in init.ora is 150. So then how did they test for 1000 concurrent Web clients? Anyone have a thought? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Clash of the DBs in eWeek
Do you mean it was SQL Server DBAs tuning Oracle in this test, because that's what they are using for their web-site? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, February 28, 2002 1:58 PM Interesting, I went to the web page and clicked on the link Putting database performance to the test and got the following message Could not Connect to DB: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. Oh well, maybe they were mad because they lost! John [EMAIL PROTECTED] wrote: At first glance it looks like they could have done more to tune Oracle. Certain tables could have been cached (or buffer pools could have been used). They're only using a 4K db block so it would have been nice to see tests with 8K and 16K db blocks. Sort area size may need tuning. I'd like to see some tkprof on the queries and see what the most expensive queries are in terms of CPU, I/O, and number of executions. It would be nice to see database results on Linux... It would be cool to see what some focused tuning efforts could do but who has time for that? Anyone have any other tuning suggestions for eWeek? Time for the tuning DBA guru's to shine. :-) -Original Message- Sent: Thursday, February 28, 2002 9:53 AM To: Multiple recipients of list ORACLE-L Anybody happen to see the cover story on the 02/25/2002 iss of eWeek titled Database Clash? The pretty graphs say that their tests showed that Oracle and MySQL rocked the other DBs they tested (including MS SQueaL Server). So I investigated. I went to http://www.eweek.com/ and downloaded the Online Exclusive: Download our configuration and tuning scripts. According to the Oracle setup docs in there, they're NOT using MTS and processes in init.ora is 150. So then how did they test for 1000 concurrent Web clients? Anyone have a thought? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Clash of the DBs in eWeek
They used weblogic for the webserver. Typically it will keep several connections open, pooling them in essence. The article indicated that *they* did all the Oracle tuning, and that Oracle did not send anyone to help with the tuning process (unlike MySQL), so it's probably amazing that they got the results they did. I don't think they lied, but I don't think they probably realized that they could have possible eeked out some additional performance had they worked it a bit harder with a knowledgeable web DBA. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Thursday, February 28, 2002 1:49 PM To: Multiple recipients of list ORACLE-L they lie? --- Jesse, Rich [EMAIL PROTECTED] wrote: Anybody happen to see the cover story on the 02/25/2002 iss of eWeek titled Database Clash? The pretty graphs say that their tests showed that Oracle and MySQL rocked the other DBs they tested (including MS SQueaL Server). So I investigated. I went to http://www.eweek.com/ and downloaded the Online Exclusive: Download our configuration and tuning scripts. According to the Oracle setup docs in there, they're NOT using MTS and processes in init.ora is 150. So then how did they test for 1000 concurrent Web clients? Anyone have a thought? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Greetings - Send FREE e-cards for every occasion! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Clash of the DBs in eWeek
I was involved in a similar thing a while ago, with a couple of different databases including a new in memory database, which is meant to be 10 times faster than Oracle. And it was, until Oracle was tuned. It was a different story then! Jim -Original Message- Sent: 28 February 2002 19:43 To: Multiple recipients of list ORACLE-L Do you mean it was SQL Server DBAs tuning Oracle in this test, because that's what they are using for their web-site? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, February 28, 2002 1:58 PM Interesting, I went to the web page and clicked on the link Putting database performance to the test and got the following message Could not Connect to DB: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. Oh well, maybe they were mad because they lost! John [EMAIL PROTECTED] wrote: At first glance it looks like they could have done more to tune Oracle. Certain tables could have been cached (or buffer pools could have been used). They're only using a 4K db block so it would have been nice to see tests with 8K and 16K db blocks. Sort area size may need tuning. I'd like to see some tkprof on the queries and see what the most expensive queries are in terms of CPU, I/O, and number of executions. It would be nice to see database results on Linux... It would be cool to see what some focused tuning efforts could do but who has time for that? Anyone have any other tuning suggestions for eWeek? Time for the tuning DBA guru's to shine. :-) -Original Message- Sent: Thursday, February 28, 2002 9:53 AM To: Multiple recipients of list ORACLE-L Anybody happen to see the cover story on the 02/25/2002 iss of eWeek titled Database Clash? The pretty graphs say that their tests showed that Oracle and MySQL rocked the other DBs they tested (including MS SQueaL Server). So I investigated. I went to http://www.eweek.com/ and downloaded the Online Exclusive: Download our configuration and tuning scripts. According to the Oracle setup docs in there, they're NOT using MTS and processes in init.ora is 150. So then how did they test for 1000 concurrent Web clients? Anyone have a thought? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James McCann INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Clash of the DBs in eWeek
In additon.. here's a quote from the article: Microsoft and Oracle both declined to be involved in the test-with their database servers, we did all tuning ourselves with no vendor input. Not at all bad for Oracle to score high without any 'expert' tuning advice. But was this test worth ignoring for Larry?? The on-line poll on the web site was interesiting, though.. (Which server database is most critical to you organization?). Oracle 33.26% MySQL 19.99% SQLServer 15.91% when I voted.. - Kirti -Original Message- Sent: Thursday, February 28, 2002 12:08 PM To: Multiple recipients of list ORACLE-L At first glance it looks like they could have done more to tune Oracle. Certain tables could have been cached (or buffer pools could have been used). They're only using a 4K db block so it would have been nice to see tests with 8K and 16K db blocks. Sort area size may need tuning. I'd like to see some tkprof on the queries and see what the most expensive queries are in terms of CPU, I/O, and number of executions. It would be nice to see database results on Linux... It would be cool to see what some focused tuning efforts could do but who has time for that? Anyone have any other tuning suggestions for eWeek? Time for the tuning DBA guru's to shine. :-) -Original Message- Sent: Thursday, February 28, 2002 9:53 AM To: Multiple recipients of list ORACLE-L Anybody happen to see the cover story on the 02/25/2002 iss of eWeek titled Database Clash? The pretty graphs say that their tests showed that Oracle and MySQL rocked the other DBs they tested (including MS SQueaL Server). So I investigated. I went to http://www.eweek.com/ and downloaded the Online Exclusive: Download our configuration and tuning scripts. According to the Oracle setup docs in there, they're NOT using MTS and processes in init.ora is 150. So then how did they test for 1000 concurrent Web clients? Anyone have a thought? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Clash of the DBs in eWeek
On the MTS part, my faux pas. I saw the first dispatchers commented out along with the other mts% params. Also, on closer inspection, I was looking at create_nile2_database_details.htm in the C - Create Benchmark Database folder in the .zip file when I saw that processes was set to 150. Perhaps they made changes to the init.ora (from the B - Configure Database Server folder) after an initial GUI DB create? Thanks, Brian, and thanks all else that pointed out the JDBC connection pooling. I've been trying to take a look at that stuff, but I've got no time here at work and I can't run Oracle at home on my Linux/Alpha box. sigh Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, February 28, 2002 1:14 PM To: Multiple recipients of list ORACLE-L Which docs? I looked at the init.ora file, and it had: processes=530 and MTS enabled. Brian -- -- | Brian McGraw -- Oracle DBA | | Central Alabama Oracle Users Group | -- Rachel Carmichael wrote: they lie? --- Jesse, Rich [EMAIL PROTECTED] wrote: Anybody happen to see the cover story on the 02/25/2002 iss of eWeek titled Database Clash? The pretty graphs say that their tests showed that Oracle and MySQL rocked the other DBs they tested (including MS SQueaL Server). So I investigated. I went to http://www.eweek.com/ and downloaded the Online Exclusive: Download our configuration and tuning scripts. According to the Oracle setup docs in there, they're NOT using MTS and processes in init.ora is 150. So then how did they test for 1000 concurrent Web clients? Anyone have a thought? Rich Jesse System/Database Administrator -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Clash of the DBs in eWeek
HI Igor, All I meant was that I couldn't get to the article because sql server couldn't except more connections. I have only "browsed" the article but found it interesting that the db that was hard to use "dusted" all the ones that were "easy" when they had no help from "Oracle Experts". John [EMAIL PROTECTED] wrote: Do you mean it was SQL Server DBAs tuning Oracle in this test, becausethat's what they are using for their web-site?Igor Neyman, OCP DBA[EMAIL PROTECTED]- Original Message -To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]Sent: Thursday, February 28, 2002 1:58 PM Interesting, I went to the web page and clicked on the link"Putting database performance to the test" and got the following messageCould not Connect to DB:[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does notexist or access denied.Oh well, maybe they were mad because they lost!John[EMAIL PROTECTED] wrote: At first glance it looks like they could have done more to tune Oracle.Certain tables could have been cached (or buffer pools could have beenused). They're only using a 4K db block so it would have been nice to seetests with 8K and 16K db blocks. Sort area size may need tuning. I'd like to see some tkprof on the queries and see what the most expensive queries are in terms of CPU, I/O, and number of executions. It would be nice to seedatabase results on Linux... It would be cool to see what some focusedtuning efforts could do but who has time for that?Anyone have any other tuning suggestions for eWeek?Time for the tuning DBA guru's to shine. :-)-Original Message-Sent: Thursday, February 28, 2002 9:53 AMTo: Multiple recipients of list ORACLE-LAnybody happen to see the cover story on the 02/25/2002 iss of eWeek titled "Database Clash"?The pretty graphs say that their tests showed that Oracle and MySQL rocked the other DBs they tested (including MS SQueaL Server). So I investigated. I went to http://www.eweek.com/ and downloaded the "Online Exclusive:Download our configuration and tuning scripts".According to the Oracle setup docs in there, they're NOT using MTS andprocesses in init.ora is 150. So then how did they test for 1000"concurrent Web clients"?Anyone have a thought?Rich Jesse System/Database Administrator[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA --Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Ora NT DBA INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051San Diego, California-- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Clash of the DBs in eWeek
Also the article did not mention that in a lot of ways, MySQL is not nearly ready for prime time... MOYMMV Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Clash of the DBs in eWeek
Title: RE: Clash of the DBs in eWeek I agree. I've been following MySQL for a while and it does have it's place, but would not want a data warehouse on it. http://www.eweek.com/article/0,3658,s=708=18266,00.asp Another article on MySQL from same source. Jon -Original Message- From: Freeman, Robert [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 4:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: Clash of the DBs in eWeek Also the article did not mention that in a lot of ways, MySQL is not nearly ready for prime time... MOYMMV Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Clash of the DBs in eWeek
Well there's prime time then there's prime time... i.e. Prime time on the major networks vs. prime time on Nickelodian MySQL is in prime time production on many substantial web sites but it's not a major network or an Amazon.com/Oracle type of prime time. There's a place for Nickelodian too. MySQL 4.X appears to be a substantial upgrade from MySQL 3.X but someone else on the list said MySQL 4.0 isn't supposed to be released until the end of the year. It almost seems like eWeek is trying to put MySQL is a good light but who knows. Steve Orr -Original Message- Sent: Thursday, February 28, 2002 2:24 PM To: Multiple recipients of list ORACLE-L Also the article did not mention that in a lot of ways, MySQL is not nearly ready for prime time... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Clash of the DBs in eWeek
And if you go to their web site www.mysql.com, they crash me compare against Oracle 8.1.6 and damn, they appear to look good. They gots lots more green stars than Oracle, by george. Of course most of those categories are SQL functions/capabilities. They don't even touch on memory allocation, types of backups/archiving, so on and so forth. And of course the lack of column constraints,table constraints, foreign keys...tsk just noise. Wait!! Dammit Oracle!! Give me the tinyint type! MySQL has it! ...maybe I'm just being fussy Julie Fisher Sandia National Laboratories Oracle 8i DBA - OCP8i Solaris 2.6,7/HP-UX 11.0 System Administrator Web Server Administrator -Original Message- Sent: Thursday, February 28, 2002 2:24 PM To: Multiple recipients of list ORACLE-L Also the article did not mention that in a lot of ways, MySQL is not nearly ready for prime time... MOYMMV Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fisher, Julie INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
