Search Results
https://dev.mysql.com/doc/refman/9.7/en/select-benchmarking.html
For example: mysql> SELECT BENCHMARK(1000000,1+1); +------------------------+ | BENCHMARK(1000000,1+1) | +------------------------+ | 0 | +------------------------+ 1 row in set (0.32 sec) This result was obtained on a Pentium II 400MHz system. It ... To measure the speed of a specific MySQL expression or function, invoke the BENCHMARK() function using the mysql client ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-geohash-functions.html
Geohash is a system for encoding latitude and longitude coordinates of arbitrary precision into a text string. If any SRID argument refers to an undefined spatial reference system (SRS), an ER_SRS_NOT_FOUND error occurs. Geohash values are strings ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-relation-functions-mbr.html
Functions in this section detect arguments in either Cartesian or geographic spatial reference systems (SRSs), and return results appropriate to the SRS. If any geometry argument is a syntactically well-formed geometry in an undefined spatial ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-types.html
The grammar for spatial reference system (SRS) definitions is based on the grammar defined in OpenGIS Implementation Specification: Coordinate Transformation Services, Revision 1.00, OGC 01-009, January 12, 2001, Section 7.2. For differences from ...
https://dev.mysql.com/doc/refman/9.7/en/upgrading.html
You perform this procedure first on some test systems to make sure everything works smoothly, and then on the production systems. This chapter describes the steps to upgrade a MySQL installation. Upgrading is a common procedure, as you pick up bug ...
https://dev.mysql.com/doc/refman/9.7/en/using-stack-trace.html
stack_bottom = 0x41fd0110 thread_stack 0x40000 mysqld(my_print_stacktrace+0x32)[0x9da402] mysqld(handle_segfault+0x28a)[0x6648e9] /lib/libpthread.so.0[0x7f1a5af000f0] /lib/libc.so.6(strcmp+0x2)[0x7f1a5a10f0f2] ... On some operating systems, the ...
https://dev.mysql.com/doc/refman/9.7/en/verifying-md5-checksum.html
Each operating system and setup offers its own version of tools for checking the MD5 checksum. Typically the command is named md5sum, or it may be named md5, and some operating systems do not ship it at all. After you have downloaded a MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/which-version.html
After choosing which MySQL version to install, decide which distribution format to install for your operating system. -DWITH_ZLIB={system|bundled} for features that depend on compression -DWITH_DEBUG=1 for debugging support For additional ... When ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/intro.html
The different kinds of backups that can be performed with MySQL Enterprise Backup, how to perform them, and some tips on choosing the right kind of backups for your system. How to use MySQL Enterprise Backup in special situations or for special ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/meb-troubleshooting.html
If mysqlbackup encounters problems during operating system calls, it returns the corresponding OS error codes. You might need to consult your operating system's documentation for the meaning of those error codes and how to handle them. To ...