sql - mysql performance -


I am testing MySQL as a replacement for SEL server and I'm really talking something funny. I am testing and reading both inserts, and maximizing 50 questions on each side.

My exam table looks like this:

  If empty tab 'webanalytics' .`test`; Table 'webanalytics` .` Test` (`ID` int (10) unsigned filtered etensement,` name' varchar (45) null, primary key (`id`)) engine = InnoDB autentrate = 1001 default charge = UTF 8;  

and my C # exam program looks like this:

  using the system; Using System.Collections.Generic; Using System.Linq; Using System.Text; Using MySql.Data.MySqlClient; Using System.Diagnostics; Namespace Console Application 1 {class program {const int QUERY_COUNT = 1000; Const string CONNECTION_STRING = "server = localhost; database = web analytics; uid = root; pwd = root"; Static zero main (string [] args) {(var db = new MySqlConnection (CONNECTION_STRING)} {db.Open (); (Var cmd = db.CreateCommand ()) by using {cmd.CommandText = "test (name) values ​​(? Name);"; Cmd.Parameters.AddWithValue ("name", ""); Var timer = new stopwatch (); Timer.start (); (Var i = 0; i & lt; QUERY_COUNT; i ++) for {cm d. Parameter ["name"]. Value = "test" + i; Cmd.ExecuteNonQuery (); } Timer.Stop (); Var Rate = QUERY_COUNT / (timer.Ellepeded millisecond / 1000); Console.lightline ("query rate: {0} / s", rate); }}}}}  

It seems that there is not a simple test case on install for MySQL, I'm running 32bit with the default OLTP standard server settings, To adjust the buffer pool of inbound to 1G, I did not find the place where the obstacle is the MySQL data connector? The following shows in a dotage profile session:

I do not know the inner details of the MySQL connector, but calls to mysqldatareader.nextresult makes me confuse. Why is this reading when I am performing an assembly?

You are using Inodb tables so that you should pay attention to several settings very carefully that your MySQL Perform or break on the database. MySQLPerformanceBlog has something really good that you should read.


Comments

Popular posts from this blog

asp.net - Javascript/DOM Why is does my form not support submit()? -

sockets - Delphi: TTcpServer, connection reset when reading -

javascript - Classic ASP "ExecuteGlobal" statement acting differently on two servers -