不同操作平台上mysql的性能对比实验

Home

Database

Mysql Tutorial

不同操作平台上mysql的性能对比实验_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 01, 2016 pm 01:53 PM

　　这个文件中包含了不同基准测试的结果。

　　测试结果后（）中的数字表示精确测试中执行的SQL命令的数目。一个测试可以有很多不同的参数，这里只给出一个大致的样子。请查看源码以获得更多的信息。

　　注意，使用不同--cmp选项的测试结果不能进行对比。--cmp选项根据测试中全部服务器的最差的限制进行设置。

　　标记了‘+’的数字是根据上一次的运行结果进行估计得出的，因为查询语句的执行超出了给定的时间限制。这个估计和预想中的真实的结果不会相差很远。

　　标记了‘？’的数字是一个糟糕的结果。它只能用来说明服务器产生这个糟糕结果所花的时间：）

　　希望这能使你对每种数据库的运行情况有一些认识....

　　第一列是用秒记数的。其他列都是与第一列相关的。1.00表示相同。更大的数字表示速度更慢。

　　这是不同平台上mysql的对比的测试结果。测试环境为：

　　1 mysql-Linux_2.2.1_i686 MySQL 3.22.18

　　pentiumpro 400mz x2, 256M, SCSI, gcc 2.9 compiled, key_buffer=16M

　　2 mysql_fast-Linux_2.2.1_i686 MySQL 3.22.18 --fast

　　pentiumpro 400mz x2, 256M, SCSI, gcc 2.9 compiled, key_buffer=16M

　　3 mysql-win98 MySQL 3.22.19a

　　"AMD-K6 350 MHz, 256M memory, key_buffer=16M"

　　4 mysql_odbc-win98 MySQL 3.22.19a --odbc

　　5 mysql-NT_4.0 MySQL 3.22.18 gamma

　　"AMD-K6 350 MHz, 256M memory, key_buffer=16M"

　　6 mysql-SunOS_5.5.1_sun4u MySQL 3.22.19

　　UltraSPARC, 2 CPU 200 MHz, 1G mem, key_buffer=8M

　　7 mysql-SunOS_5.6_sun4m MySQL 3.22.6 alpha

　　Sparc sun4m, 196M memory

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Reduce the use of MySQL memory in DockerMar 04, 2025 pm 03:52 PM

This article explores optimizing MySQL memory usage in Docker. It discusses monitoring techniques (Docker stats, Performance Schema, external tools) and configuration strategies. These include Docker memory limits, swapping, and cgroups, alongside

How to solve the problem of mysql cannot open shared libraryMar 04, 2025 pm 04:01 PM

This article addresses MySQL's "unable to open shared library" error. The issue stems from MySQL's inability to locate necessary shared libraries (.so/.dll files). Solutions involve verifying library installation via the system's package m

How do you alter a table in MySQL using the ALTER TABLE statement?Mar 19, 2025 pm 03:51 PM

The article discusses using MySQL's ALTER TABLE statement to modify tables, including adding/dropping columns, renaming tables/columns, and changing column data types.

Run MySQl in Linux (with/without podman container with phpmyadmin)Mar 04, 2025 pm 03:54 PM

This article compares installing MySQL on Linux directly versus using Podman containers, with/without phpMyAdmin. It details installation steps for each method, emphasizing Podman's advantages in isolation, portability, and reproducibility, but also

What is SQLite? Comprehensive overviewMar 04, 2025 pm 03:55 PM

This article provides a comprehensive overview of SQLite, a self-contained, serverless relational database. It details SQLite's advantages (simplicity, portability, ease of use) and disadvantages (concurrency limitations, scalability challenges). C

Running multiple MySQL versions on MacOS: A step-by-step guideMar 04, 2025 pm 03:49 PM

This guide demonstrates installing and managing multiple MySQL versions on macOS using Homebrew. It emphasizes using Homebrew to isolate installations, preventing conflicts. The article details installation, starting/stopping services, and best pra

How do I configure SSL/TLS encryption for MySQL connections?Mar 18, 2025 pm 12:01 PM

Article discusses configuring SSL/TLS encryption for MySQL, including certificate generation and verification. Main issue is using self-signed certificates' security implications.[Character count: 159]

What are some popular MySQL GUI tools (e.g., MySQL Workbench, phpMyAdmin)?Mar 21, 2025 pm 06:28 PM

Article discusses popular MySQL GUI tools like MySQL Workbench and phpMyAdmin, comparing their features and suitability for beginners and advanced users.[159 characters]

See all articles