MySQL na Windows 2000

[Tom Z. Meinlschmidt]

mrknete semka:

http://www.mysql.com/information/benchmarks.html

myslim, ze tam toho je docela hodne.

tm

On Tue, Jun 18, 2002 at 02:23:33PM +0200 Jakub Rovný [jakub.rovny na jmeno.cz] wrote:
> 
> "Honza Pazdziora" <adelton na informatics.muni.cz> píše v diskusním příspěvku
> news:20020618131400.O227 na anxur.fi.muni.cz...
> > On Tue, Jun 18, 2002 at 11:53:04AM +0200, Jakub Rovný wrote:
> > >
> > > Proc je tedy SELECT o tolik pomalejsi, nemuze byt chyba v konfiguraci
> MySQL.
> >
> > Muze. Pro podrobnejsi analyzu by asi bylo vhodne poslat, jaka ta
> > konfigurace je.
> >
> > --
> > ------------------------------------------------------------------------
> >  Honza Pazdziora | adelton na fi.muni.cz | http://www.fi.muni.cz/~adelton/
> >       ... all of these signs saying sorry but we're closed ...
> > ------------------------------------------------------------------------
> 
> 
> 
> Zdravim,
> 
> zde je mé   my.ini
> 
> (pc ma 512 MB RAM)
> 
> **************************
> 
> 
> # Example mysql config file.
> # Copy this file to c:\my.cnf to set global options
> #
> # One can use all long options that the program supports.
> # Run the program with --help to get a list of available options
> 
> # This will be passed to all mysql clients
> [client]
> #password=my_password
> port=3306
> #socket=MySQL
> 
> # Here is entries for some specific programs
> # The following values assume you have at least 32M ram
> 
> # The MySQL server
> [mysqld]
> port=3306
> language=C:/mysql/share/czech
> default-character-set=win1250
> #socket=MySQL
> skip-locking
> set-variable = key_buffer=256M
> set-variable = max_allowed_packet=1M
> set-variable = table_cache=256
> set-variable = sort_buffer=1M
> set-variable = record_buffer=1M
> set-variable = myisam_sort_buffer_size=64M
> set-variable = thread_cache=8
> # Try number of CPU's*2 for thread_concurrency
> set-variable = thread_concurrency=8
> log-bin
> server-id = 1
> 
> # Uncomment the following rows if you move the MySQL distribution to another
> # location
> basedir = c:/mysql/
> datadir = c:/mysql/data/
> 
> # Uncomment the following if you are using BDB tables
> #set-variable = bdb_cache_size=64M
> #set-variable = bdb_max_lock=100000
> 
> # Uncomment the following if you are using Innobase tables
> #innodb_data_file_path = ibdata1:1000M
> #innodb_data_home_dir = c:\ibdata
> #innodb_log_group_home_dir = c:\iblogs
> #innodb_log_arch_dir = c:\iblogs
> #set-variable = innodb_mirrored_log_groups=1
> #set-variable = innodb_log_files_in_group=3
> #set-variable = innodb_log_file_size=5M
> #set-variable = innodb_log_buffer_size=8M
> #innodb_flush_log_at_trx_commit=1
> #innodb_log_archive=0
> #set-variable = innodb_buffer_pool_size=16M
> #set-variable = innodb_additional_mem_pool_size=2M
> #set-variable = innodb_file_io_threads=4
> #set-variable = innodb_lock_wait_timeout=50
> 
> [mysqldump]
> quick
> set-variable = max_allowed_packet=16M
> 
> [mysql]
> no-auto-rehash
> # Remove the next comment character if you are not familiar with SQL
> #safe-updates
> 
> [isamchk]
> set-variable = key_buffer=128M
> set-variable = sort_buffer=128M
> set-variable = read_buffer=2M
> set-variable = write_buffer=2M
> 
> [myisamchk]
> set-variable = key_buffer=128M
> set-variable = sort_buffer=128M
> set-variable = read_buffer=2M
> set-variable = write_buffer=2M
> 
> [mysqlhotcopy]
> interactive-timeout
> 
> [WinMySQLadmin]
> Server=C:/mysql/bin/mysqld-nt.exe
> user=root
> password=root
> 
> 
> ***************
> 
> SQL dotaz na kterem jsem to zkousel je:
> 
> tabulka mela 100000 radku /2 sloupce - id(int) a text(varchar(10))
> 
> 
> Pro MySQL:
> 
> set objConn=server.CreateObject("ADODB.Connection")
> objConn.Open
> "server=127.0.0.1;db=sqltest;driver=MySQL;uid=iismysql;pwd=123456;"
> 
> For  i = 1 To 1000
> 
> set objRst=server.CreateObject("ADODB.RecordSet")
> with objRst
>    .Source = "SELECT * FROM test"
>   .ActiveConnection = objConn
>    .CursorType = adOpenForwardOnly
>    .LockType = adLockReadOnly
>    .PageSize = 10
>    .Open
>  end with
> 
> Next
> 
> Doba:  7.45 min
> 
> 
> ********
> 
> Pro MSSQL:
> 
> 
> set objConn=server.CreateObject("ADODB.Connection")
> objConn.Open
> "Provider=sqloledb;Network=DBMSSOCN;Server=localhost;Database=test;UID=iisus
> er;PWD=123456;"
> 
> For  i = 1 To 1000
> 
> set objRst=server.CreateObject("ADODB.RecordSet")
> with objRst
>    .Source = "SELECT * FROM test"
>   .ActiveConnection = objConn
>    .CursorType = adOpenForwardOnly
>    .LockType = adLockReadOnly
>    .PageSize = 10
>    .Open
>  end with
> 
> Next
> 
> 
> Doba:  2.53 min.
> 
> 
> **********
> 
> 
> 
> Diky, Jakub
> 
> 
> 

-- 
===============================================================================
Tomas Meinlschmidt, SBN3, MCP, MCP+I, MCSE, NetApp Filer & NetCache
Datron s.r.o., Vachkova 3008, 470 01 Ceska Lipa, 0425/834 421, f: 834 425
GCS d-(?) s: a-- C++ ULHSC++++$ P+++>++++ L+++$>++++ E--- W+++$ N++(+) !o
    !K w(---) !O !M V PS+ PE Y+ PGP++ t+@ !5 X? R tv b+ !DI D+ G e>+++
    h---- r+++ z+++@
===============================================================================