Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-localization.html
If this is the first time launching the MySQL Enterprise Monitor User Interface, you must set your time zone and locale. Setting the time zone ensures that you have an accurate time reference for any notifications from the MySQL Enterprise Advisors. Warning Set the time zone (and the system clock) correctly because this setting affects how MySQL Enterprise Service Manager's graphs display ...
https://dev.mysql.com/doc/connector-j/en/connector-j-other-changes.html
serverTimezone is now an alias for the connection property connectionTimeZone, which has replaced serverTimezone. Here are other changes with Connector/J 8.0 and beyond: Removed ReplicationDriver. Instead of using a separate driver, you can now ...
https://dev.mysql.com/doc/refman/8.4/en/insert-optimization.html
You can use the following methods to speed up inserts: If you are inserting many rows from the same client at the same time, use INSERT statements with multiple VALUES lists to insert several rows at a time. This is considerably faster (many times ... To optimize insert speed, combine many small operations into a single large ...
https://dev.mysql.com/doc/refman/8.4/en/sys-metrics.html
This view summarizes MySQL server metrics to show variable names, values, types, and whether they are enabled. The metric type determines the source from which the name is taken: For global status variables: The VARIABLE_NAME column of the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-performance-space-overview.html
However, before a hot backup can be restored, there needs to be an extra process of preparing the backup to make it consistent (i.e., correctly reflecting the state of the state of the database at the time the backup was completed). Also, ... When ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-statistics-estimation.html
Values much larger than 8 (say, 100), can cause a significant slowdown in the time it takes to open a table or execute SHOW TABLE STATUS. Because the statistics are automatically recalculated at various times other than on execution of ANALYZE ...
https://dev.mysql.com/doc/relnotes/connector-python/en/news-9-2-0.html
Functionality Added or Changed Bugs Fixed Functionality Added or Changed Added two new connection options: read_timeout (time limit to receive a response from the server) and write_timeout (time limit to send data to the server). Both options ...
https://dev.mysql.com/doc/internals/en/flush-tables.html
Every time a thread releases a table, it checks if the refresh version of the table (updated at open) is the same as the current refresh_version. The idea of FLUSH TABLES is to force all tables to be closed. This is mainly to ensure that if someone ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-routines-table.html
DATETIME_PRECISION For stored function temporal return values, the fractional seconds precision. CHARACTER_MAXIMUM_LENGTH For stored function string return values, the maximum length in characters. CHARACTER_OCTET_LENGTH For stored function string ... The ROUTINES table provides information about stored routines (stored procedures and stored ...
https://dev.mysql.com/doc/refman/8.4/en/update.html
Each matching row is updated once, even if it matches the conditions multiple times. The UPDATE statement supports the following modifiers: With the LOW_PRIORITY modifier, execution of the UPDATE is delayed until no other clients are reading from ...