What is new in MySQL 4.0 • MySQL 4.0 implemented a query cache that can give a major speed boost to applications w ith repetitive queries. See Section 7.5.3, “The MySQL Query Cache”. 4/94
What is new in MySQL 4.0 • MySQL 4.0 further increased the speed of MySQL Server in a number of areas, such as bu lk INSERT statements, searching on packed indexes, full-text searching (using FULLTEXT in dexes), and COUNT(DISTINCT) 7/94
What is new in MySQL 4.0 • InnoDB storage engine as standard • The InnoDB storage engine began to be offered as a standard feature of the MySQL serv er. This provided full support for ACID transactions, foreign keys with cascading UPDAT E and DELETE, and row-level locking as standard features. See Section 13.2, “The InnoD B Storage Engine” 8/94
What is new in MySQL 4.0 Starting with version 4.0, MySQL runs natively on Novell NetWare 6.0 and higher. See Sec tion 2.7, “Installing MySQL on NetWare” 10/94
What is new in MySQL 4.0 Features to simplify migration from other database systems to MySQL Server include TRUN CATE TABLE (as in Oracle) and identity as a synonym for automatically incremented keys (a s in Sybase). 12/94
What is new in MySQL 4.0 German-speaking users should note that MySQL 4.0 added support for a new character set, l atin1_de, which ensures that words with umlauts are sorted in the same order as in Germ an telephone books. 15/94
What is new in MySQL 4.0 As of version 4.0, most mysqld parameters (startup options) can be set without taking do wn the server. This is a convenient feature for database administrators. See Section 12. 4.4, “SET Syntax”. 16/94
What is new in MySQL 4.0 On Windows, symbolic link handling at the database level was enabled by default. On Uni x, the MyISAM storage engine added support for symbolic linking at the table level (and n ot just the database level as before). 20/94
What is new in MySQL 4.0 • The addition of the SQL_CALC_FOUND_ROWS and FOUND_ROWS() [815] functions made it poss ible to find out the number of rows a SELECT query that includes a LIMIT clause would ha ve returned without that clause. 21/94
What is new in MySQL 8.0 The SQL_CALC_FOUND_ROWS query modifier and accompanying FOUND_ROWS() function are depre cated. See the FOUND_ROWS() description for information about an alternative strategy. 23/94
What is new in MySQL 4.0 The embedded server library added in this release can easily be used to create standalo ne and embedded applications. The embedded server provides an alternative to using MySQ L in a client/server environment. 24/94
2022年のMySQLerが20年前のMySQL 4.0に触ると MySQL 4.0のInnoDBはMyISAMよりタチが悪い側面がある… 「MyISAM、ぐわあ」は今まで何度もあったけど、「InnoDB、ぐわあ」は初めて遭遇した ‐ Fast Index CreationもOnline ALTER TABLEも、pt-online-schema-changeも使 えないとInnoDBはなかなか運用がつらい 91/94