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-memcached-tuning.html
Benchmarks suggest that queries and DML operations (inserts, updates, and deletes) that use the memcached interface are faster than traditional SQL. If instead the application performed automated toll collection for each car, you would set ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-schema.html
Disabling logging can be useful for a number of reasons, including those listed here: Not sending changes across the network generally saves bandwidth, buffering, and CPU resources. ndb_apply_status Table ndb_binlog_index Table ndb_replication ...
https://dev.mysql.com/doc/refman/5.7/en/csv-storage-engine.html
When you store data into the table, the storage engine saves it into the data file in comma-separated values format. The CSV storage engine stores data in text files using comma-separated values format. The CSV storage engine is always compiled ...
https://dev.mysql.com/doc/refman/5.7/en/enum.html
An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time. See Section 11.3.1, “String Data Type Syntax” for ENUM type syntax and length ...
https://dev.mysql.com/doc/refman/5.7/en/events-metadata.html
To obtain metadata about events: Query the event table of the mysql database. Event Scheduler Time Representation Each session in MySQL has a session time zone (STZ). This is the session time_zone value that is initialized from the server's global ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-index-types.html
To get the best performance from queries, inserts, and other database operations, it is important to understand how InnoDB uses the clustered index to optimize the common lookup and DML operations. How the Clustered Index Speeds Up Queries Accessing ... Each InnoDB table has a special index called the clustered index that stores row ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-init-startup-configuration.html
A large data file can also result from long running queries that use temporary tables. The default 16KB page size is appropriate for a wide range of workloads, particularly for queries involving table scans and DML operations involving bulk updates.
https://dev.mysql.com/doc/refman/5.7/en/key-cache-restructuring.html
If the cache contains any dirty blocks, the server saves them to disk before destroying and re-creating the cache. However, restructuring does not block queries that need to use indexes assigned to the cache. File system caching is not as efficient ... A key cache can be restructured at any time by updating its parameter ...
https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-optimization-tips.html
The resulting fast database operations are then available to be reused by other queries, applications, and even code written in different programming languages. In this case, you must provide code in your application to pack and unpack information, ... This section lists a number of miscellaneous tips for improving query processing speed: If your application makes several database requests to perform related updates, combining the statements into a stored routine can help ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-tables.html
By contrast, using the Performance Schema tables, information about replica status can be searched using general SELECT queries, including complex WHERE conditions, joins, and so forth. Query results can be saved in tables for further analysis, or ...This is similar to the information available from the SHOW SLAVE STATUS statement, but representation in table form is more accessible and has usability benefits: SHOW SLAVE STATUS output is useful for visual inspection, but not so much for programmatic ...