MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 481 to 490 of 499 total results

https://dev.mysql.com/doc/refman/5.7/en/table-locking.html

InnoDB tables use row-level locking so that multiple sessions and applications can read from and write to the same table simultaneously, without making each other wait or producing inconsistent results. For this storage engine, avoid using the LOCK ...

8.4.6 Limits on Table Size

https://dev.mysql.com/doc/refman/5.7/en/table-size-limit.html

If the pointer size is too small for an existing table, you can change the options with ALTER TABLE to increase a table's maximum permissible size. The effective maximum table size for MySQL databases is usually determined by operating system ...

B.3.6.2 TEMPORARY Table Problems

https://dev.mysql.com/doc/refman/5.7/en/temporary-table-problems.html

If a TEMPORARY is created with the same name as an existing non-TEMPORARY table, the non-TEMPORARY table is hidden until the TEMPORARY table is dropped, even if the tables use different storage engines. Temporary tables created with CREATE ...

2.9.3 Testing the Server

https://dev.mysql.com/doc/refman/5.7/en/testing-server.html

Use mysqlshow to see what databases exist: $> bin/mysqlshow +--------------------+ | Databases | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | +--------------------+ The list of installed databases may vary, ... After the data directory is initialized and you have started the server, perform some simple tests to make sure that it works ...

5.1.13 MySQL Server Time Zone Support

https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html

Otherwise, use of a named time zone results in an error: mysql> SET time_zone = 'UTC'; ERROR 1298 (HY000): Unknown or incorrect time zone: 'UTC' Populating the Time Zone Tables Several tables in the mysql system database exist to store time zone ...

8.15.11 Trace General Structure

https://dev.mysql.com/doc/refman/5.7/en/trace-general-structure.html

Query transformations (IN to EXISTS, outer join to inner join, and so on), simplifications (elimination of clauses), and equality propagation are shown in subobjects. A trace follows the actual execution path very closely; for each join, there is a ...

Chapter 3 Tutorial

https://dev.mysql.com/doc/refman/5.7/en/tutorial.html

If you are interested only in accessing an existing database, you may want to skip the sections that describe how to create the database and the tables it contains. This chapter provides a tutorial introduction to MySQL by showing how to use the ...

12.3 Type Conversion in Expression Evaluation

https://dev.mysql.com/doc/refman/5.7/en/type-conversion.html

Because the conversions produced by this library differ in some cases from non-dtoa results, the potential exists for incompatibilities in applications that rely on previous results. When an operator is used with operands of different types, type ...

2.6 Installing MySQL Using Unbreakable Linux Network (ULN)

https://dev.mysql.com/doc/refman/5.7/en/uln-installation.html

If you are changing your package source to use ULN and not changing which build of MySQL you are using, then back up your data, remove your existing binaries, and replace them with those from ULN. Linux supports a number of different solutions for ...

2.10.11 Upgrade Troubleshooting

https://dev.mysql.com/doc/refman/5.7/en/upgrade-troubleshooting.html

The same is true if the new version of MySQL implements a built-in function with the same name as an existing stored function. If problems occur, such as that the new mysqld server does not start, verify that you do not have an old my.cnf file from ...

Displaying 481 to 490 of 499 total results