Search Results
https://dev.mysql.com/doc/refman/8.4/en/memory-storage-engine.html
Despite the in-memory processing for MEMORY tables, they are not necessarily faster than InnoDB tables on a busy server, for general-purpose queries, or under a read/write workload. In particular, the table locking involved with performing updates ... The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in ...
https://dev.mysql.com/doc/refman/8.4/en/password-logging.html
PASSWORD ...) Passwords in those statements are rewritten to not appear literally in statement text written to the general query log, slow query log, and binary log. Passwords can be written as plain text in SQL statements such as CREATE USER, ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-prerequisites.html
You can use the following queries to check for schema and table names containing uppercase characters: mysql> select TABLE_NAME, if(sha(TABLE_NAME) !=sha(lower(TABLE_NAME)),'Yes','No') as UpperCase from information_schema.tables; If ... Before ...
https://dev.mysql.com/doc/connectors/en/connector-python-connectargs.html
buffered False Whether cursor objects fetch the results immediately after executing queries. Troubleshooting and Error Handling Warnings generated by queries are fetched automatically when get_warnings is set to True. This avoids excessive memory ...
https://dev.mysql.com/doc/connector-python/en/connector-python-connectargs.html
buffered False Whether cursor objects fetch the results immediately after executing queries. Troubleshooting and Error Handling Warnings generated by queries are fetched automatically when get_warnings is set to True. This avoids excessive memory ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/admin-advisors-reference.html
However, it is also the slowest choice (unless the disk has a battery-backed cache, which makes synchronization very fast). However, for performance reasons, it is recommended to run 64-bit binaries on 64-bit platforms, and 32-bit binaries on 32-bit ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-mysql-cluster.html
However, it also means that queries that could otherwise use range scans must be satisfied by other means, which can result in slower selects. How do I continue to send queries in the event that one of the SQL nodes fails? A.10.40. Transactions are ... In the following section, we answer questions that are frequently asked about MySQL NDB Cluster and the NDB storage ...
https://dev.mysql.com/doc/internals/en/prepared-stored-statement-execution.html
We'll need this query for general, binary, error and slow logs. A separate variable is needed because not all subqueries may get executed during the first execution of a statement. In order to call mysql_execute_command (the function that executes ...
https://dev.mysql.com/doc/refman/8.4/en/data-size.html
If it is a rare case that is limited by CPU speed, it might be slower. Indexes are good for retrieval, but slow down insert and update operations. Keep column names simple, so that you can use the same name across different tables and simplify join ... Design your tables to minimize their space on the ...
https://dev.mysql.com/doc/refman/8.4/en/system-schema.html
However, in most cases there are corresponding INFORMATION_SCHEMA tables that can be queried. It contains tables that store information required by the MySQL server as it runs. A broad categorization is that the mysql schema contains data dictionary ...