Here is my My.ini. I have tweeked it per many sources but would love some comments on it.
Thanks
Larry
[mysqld] basedir=C:/MySql datadir=D:/MySqlData language=C:/MySql/share/english port=3306 key_buffer_size=512M table_cache=64 net_buffer_length=1M max_allowed_packet=3M query_cache_limit = 1M query_cache_size = 32M query_cache_type = 1 read_buffer_size=2M read_rnd_buffer_size=8M skip-innodb
----- Original Message ----- From: "Peter J Milanese" <[EMAIL PROTECTED]>
To: "Larry Lowry" <[EMAIL PROTECTED]>; "mysql" <mysql@lists.mysql.com>
Sent: Friday, January 21, 2005 12:57 PM
Subject: Re: Connection performance, suggestions?
A single transaction logs into the db several times?
I assume its a browser based transaction, no?
Are you limiting connections (in my.conf)? Have you tuned the config, if yes how so?
------Original Message------ From: Larry Lowry To: mysql Sent: Jan 21, 2005 12:49 PM Subject: Connection performance, suggestions?
Before I ask this question I must state I love mySql and want to use it more. But I work in a shop were we mostly use SQL Server 2000. In trying to use mySql (4.12 and 4.19) we are seeing some performance issues. I hope someone can help me with this. I am in a Windows 2003 server environment and running mostly asp.net applications.
I have narrowed the problem down to the speed at which the database
connections
open and close. The following code opens a mySql database 100 times.
This takes 21 to 23 seconds. I know I should only open the connection once
but this represents the asp environment where we are using a cluster of web
servers. MySQL is running on an Athlon 64 3500+ with 2 gigs of memory. It
is the
only process on the server.
The SQL server code below does the same thing except to Sql Server 2000. This only takes .1 to .4 seconds. Sql Server is running on a PIII at 1.2ghz with 1gb memory. It's a crappy old box for testing.
I am using the stock Framework 1.1 SqlClient and MySql.Data.MySqlClient version 1.0.3.31712. All test boxes are on the same network switch.
Can anyone help explain this difference? Is it the database engines or the
data connectors? Any help would be appreciated.
Thanks
Larry Lowry
'MySql Code Dim sDBCS As String = "Server=DB;UserId=userid;Password=pass;Database=images" Dim i As Long Dim ti As Long = Microsoft.VisualBasic.Timer()
Dim db As MySqlConnection db = New MySqlConnection(sDBCS) For i = 1 To 100 db.Open() db.Close() Next db.Dispose() tbEnd.Text = Microsoft.VisualBasic.Timer() - ti
'SQL Server Dim sDBCS As String = "Data Source=db;User Id=userid;Password=pass;Initial Catalog=images" Dim i As Long Dim ti As Long = Microsoft.VisualBasic.Timer()
Dim db As SqlConnection db = New SqlConnection(sDBCS) For i = 1 To 100 db.Open() db.Close() Next db.Dispose() tbEnd.Text = Microsoft.VisualBasic.Timer() - ti
----------------- Sent from my NYPL BlackBerry Handheld.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]