PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-tuning-monitoring.html
The information in these tables is system-wide: it summarizes the compression statistics across all compressed tables in your database. Based on the information in the INNODB_CMP and INNODB_CMP_PER_INDEX tables and overall application performance ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-transaction-management.html
The default MySQL setting AUTOCOMMIT=1 can impose performance limitations on a busy database server. This issue is expected to be infrequent with the default setting innodb_change_buffering=all, which allows update and delete operations to be cached ... To optimize InnoDB transaction processing, find the ideal balance between the performance overhead of transactional features and the workload of your ...To minimize the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached.html
Instead of formulating queries in SQL, you can use simple get, set, and incr operations that avoid the performance overhead associated with SQL parsing and constructing a query optimization plan. You can also access the same InnoDB tables through ...
https://dev.mysql.com/doc/refman/5.7/en/dynamic-system-variables.html
For a description of the privilege requirements for setting system variables, see Section 5.1.8.1, “System Variable Privileges” The following table lists all dynamic system variables applicable within mysqld. Please see the corresponding item ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-stopwords.html
The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server and collation_server system variables). False hits or misses might occur for stopword lookups if the ...For example, lookups are case-insensitive if the collation is latin1_swedish_ci, whereas lookups are case-sensitive if the collation is latin1_general_cs or ...
https://dev.mysql.com/doc/refman/5.7/en/type-conversion.html
mysql> SELECT 38.8, CAST(38.8 AS CHAR); -> 38.8, '38.8' mysql> SELECT 38.8, CONCAT(38.8); -> 38.8, '38.8' See later in this section for information about the character set of implicit number-to-string conversions, and for modified rules that apply ...For example, MySQL automatically converts strings to numbers as necessary, and vice ... When an operator is used ...
https://dev.mysql.com/doc/refman/5.7/en/derived-tables.html
For example, a subquery in a SELECT statement FROM clause is a derived table: SELECT ... This does not work: SELECT AVG(SUM(column1)) FROM t1 GROUP BY column1; However, this query provides the desired information: SELECT AVG(sum_column1) FROM ... A ...
https://dev.mysql.com/doc/refman/5.7/en/activestate-perl.html
If you cannot get the procedure to work, you should install the ODBC driver instead and connect to the MySQL server through ODBC: use DBI; $dbh= DBI->connect("DBI:ODBC:$dsn",$user,$password) || die "Got error $DBI::errstr when connecting to $dsn\n"; ...For example, you might try a setting like this: C:\> set HTTP_proxy=my.proxy.com:3128 Start the PPM program: C:\> C:\perl\bin\ppm.pl If you have not previously done so, install DBI: ppm> install DBI If this succeeds, run the following command: ppm> install DBD-mysql This procedure should work with ActiveState Perl 5.6 or ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-data-encryption.html
When an application or authenticated user wants to access encrypted data, InnoDB uses a master encryption key to decrypt the tablespace key. mysql> ALTER TABLE t1 ENCRYPTION='Y'; To disable encryption for file-per-table tablespace, set ...The ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-unix-servers.html
For MySQL installation using an RPM distribution, server startup and shutdown is managed by systemd on several Linux platforms. On these platforms, mysqld_safe is not installed because it is unnecessary. For information about using systemd to handle ... Note The discussion here uses mysqld_safe to launch multiple instances of ...