mysql-5.1.6-alpha-win32

所属分类:数据库编程
开发工具:SQL
文件大小:26560KB
下载次数:13
上传日期:2014-09-11 21:13:29
上 传 者binghe8888
说明:  mysql 数据库,mysql绿色版数据库,无安装,有安装说明
( this file is used to database,including how to use ,with install file)

文件列表:
mysql-5.1.6-alpha-win32\bin\comp-err.exe (1191936, 2006-02-08)
mysql-5.1.6-alpha-win32\bin\libmySQL.dll (1318912, 2006-02-08)
mysql-5.1.6-alpha-win32\bin\myisamchk.exe (1429504, 2006-02-08)
mysql-5.1.6-alpha-win32\bin\myisamlog.exe (1339392, 2006-02-08)
mysql-5.1.6-alpha-win32\bin\myisampack.exe (1355776, 2006-02-08)
mysql-5.1.6-alpha-win32\bin\myisam_ftdump.exe (1318912, 2006-02-08)
mysql-5.1.6-alpha-win32\bin\mysql.exe (1376256, 2006-02-08)
mysql-5.1.6-alpha-win32\bin\mysqladmin.exe (1286144, 2006-02-08)
mysql-5.1.6-alpha-win32\bin\mysqlbinlog.exe (1314816, 2006-02-08)
mysql-5.1.6-alpha-win32\bin\mysqlcheck.exe (1282048, 2006-02-08)
mysql-5.1.6-alpha-win32\bin\mysqld-debug.exe (6901760, 2006-02-08)
mysql-5.1.6-alpha-win32\bin\mysqld-nt.exe (4882432, 2006-02-08)
mysql-5.1.6-alpha-win32\bin\mysqld.exe (4882432, 2006-02-08)
mysql-5.1.6-alpha-win32\bin\mysqldump.exe (1314816, 2006-02-08)
mysql-5.1.6-alpha-win32\bin\mysqlimport.exe (1282048, 2006-02-08)
mysql-5.1.6-alpha-win32\bin\mysqlmanager.exe (1327104, 2006-02-08)
mysql-5.1.6-alpha-win32\bin\mysqlshow.exe (1282048, 2006-02-08)
mysql-5.1.6-alpha-win32\bin\mysqlslap.exe (1290240, 2006-02-08)
mysql-5.1.6-alpha-win32\bin\mysqltest.exe (1388544, 2006-02-08)
mysql-5.1.6-alpha-win32\bin\mysql_client_test.exe (1613824, 2006-02-08)
mysql-5.1.6-alpha-win32\bin\myTest.exe (40960, 2006-02-08)
mysql-5.1.6-alpha-win32\bin\my_print_defaults.exe (1187840, 2006-02-08)
mysql-5.1.6-alpha-win32\bin\perror.exe (1167360, 2006-02-08)
mysql-5.1.6-alpha-win32\bin\replace.exe (1187840, 2006-02-08)
mysql-5.1.6-alpha-win32\bin\启动mysql.bat (16, 2006-03-06)
mysql-5.1.6-alpha-win32\COPYING (19423, 2006-02-08)
mysql-5.1.6-alpha-win32\data\cluster_replication\binlog_index.frm (8778, 2006-02-08)
mysql-5.1.6-alpha-win32\data\cluster_replication\binlog_index.MYD (0, 2006-02-08)
mysql-5.1.6-alpha-win32\data\cluster_replication\binlog_index.MYI (1024, 2006-02-08)
mysql-5.1.6-alpha-win32\data\cluster_replication\db.opt (65, 2006-02-08)
mysql-5.1.6-alpha-win32\data\dlib\db.opt (65, 2006-04-12)
mysql-5.1.6-alpha-win32\data\dlib\link.frm (8630, 2006-04-12)
mysql-5.1.6-alpha-win32\data\dlib\link.MYD (48, 2006-04-18)
mysql-5.1.6-alpha-win32\data\dlib\link.MYI (2048, 2006-04-18)
mysql-5.1.6-alpha-win32\data\dlib\table_id.frm (8592, 2006-04-12)
mysql-5.1.6-alpha-win32\data\dlib\table_id.MYD (225, 2006-04-18)
mysql-5.1.6-alpha-win32\data\dlib\table_id.MYI (2048, 2006-04-18)
mysql-5.1.6-alpha-win32\data\ibdata1 (10485760, 2007-06-12)
mysql-5.1.6-alpha-win32\data\ibm-cf70912fa10.pid (5, 2008-09-16)
mysql-5.1.6-alpha-win32\data\ib_logfile0 (5242880, 2008-09-16)
... ...

The MySQL Benchmarks These tests require a MySQL version of at least 3.20.28 or 3.21.10. Currently the following servers are supported: MySQL 3.20 and 3.21, PostgreSQL 6.#, mSQL 2.# and Solid Server 2.2 The benchmark directory contains the query files and raw data files used to populate the MySQL benchmark tables. In order to run the benchmarks, you should normally execute a command such as the following: run-all-tests --server=mysql --cmp=mysql,pg,solid --user=test --password=test --log This means that you want to run the benchmarks with MySQL. The limits should be taken from all of MySQL, PostgreSQL, and Solid. The login name and password for connecting to the server both are ``test''. The result should be saved as a RUN file in the output directory. When run-all-tests has finished, will have the individual results and the the total RUN- file in the output directory. If you want to look at some old results, use the compare-results script. For example: compare-results --dir=Results --cmp=mysql,pg,solid compare-results --dir=Results --cmp=mysql,pg,solid --relative compare-results --dir=Results --cmp=msql,mysql,pg,solid compare-results --dir=Results --cmp=msql,mysql,pg,solid --relative compare-results --dir=Results --server=mysql --same-server --cmp=mysql,pg,solid Some of the files in the benchmark directory are: File Description Data/ATIS Contains data for 29 related tables used in the ATIS tests. Data/Wisconsin Contains data for the Wisconsin benchmark. Results Contains old benchmark results. Makefile.am Automake Makefile README This file. test-ATIS.sh Creation of 29 tables and a lot of selects on them. test-connect.sh Test how fast a connection to the server is. test-create.sh Test how fast a table is created. test-insert.sh Test create and fill of a table. test-wisconsin.sh A port of the PostgreSQL version of this benchmark. run-all-tests Use this to run all tests. When all tests are run, use the --log and --use-old options to get a RUN-file. compare-results Generates a comparison table from different RUN files. server-cfg Contains the limits and functions for all supported SQL servers. If you want to add a new server, this should be the only file that neads to be changed. Most of the tests should use portable SQL to make it possible to compare different databases. Sometimes SQL extensions can make things a lot faster. In this case the test may use the extensions if the --fast option is used. Useful options to all test-scripts (and run-all-tests): --host=# Hostname for MySQL server (default: localhost) --db=# Database to use (default: test) --fast Allow use of any non-standard SQL extension to get things done faster. --lock-tables Use table locking to get more speed. From a text at http://www.mgt.ncu.edu.tw/CSIM/Paper/sixth/11.html: The Wisconsin Benchmark The Wisconsin Benchmark described in [Bitton, DeWitt, and Turbyfill 1***3] [Boral and DeWitt 1***4] [Bitton and Turbyfill 1***5] [Bitton and Turbyfill 1***8], and [DeWitt 1993] is the first effort to systematically measure and compare the performance of relational database systems with database machines. The benchmark is a single-user and single-factor experiment using a synthetic database and a controlled workload. It measures the query optimization performance of database systems with 32 query types to exercise the components of the proposed systems. The query suites include selection, join, projection, aggregate, and simple update queries. The test database consists of four generic relations. The tenk relation is the key table and most used. Two data types of small integer numbers and character strings are utilized. Data values are uniformly distributed. The primary metric is the query elapsed time. The main criticisms of the benchmark include the nature of single-user workload, the simplistic database structure, and the unrealistic query tests. A number of efforts have been made to extend the benchmark to incorporate the multi-user test. However, they do not receive the same acceptance as the original Wisconsin benchmark except an extension work called the AS3AP benchmark.

近期下载者

相关文件


收藏者