PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-transaction-summary-tables.html
It has these effects: For summary tables not aggregated by account, host, or user, truncation resets the summary columns to zero rather than removing rows. For summary tables aggregated by account, host, or user, truncation removes rows for ...Event ...In addition, each transaction summary table that is aggregated by account, host, user, or thread is implicitly truncated by truncation of the connection table on which it depends, or truncation of ...row *************************** EVENT_NAME: transaction COUNT_STAR: 5 SUM_TIMER_WAIT: 19550092000 MIN_TIMER_WAIT: 2954148000 AVG_TIMER_WAIT: 3910018000 MAX_TIMER_WAIT: 5486275000 COUNT_READ_WRITE: 5 SUM_TIMER_READ_WRITE: 19550092000 MIN_TIMER_READ_WRITE: 2954148000 AVG_TIMER_READ_WRITE: 3910018000 MAX_TIMER_READ_WRITE: 5486275000 ...
https://dev.mysql.com/doc/refman/5.7/en/create-table.html
Important For users familiar with the ANSI/ISO SQL Standard, please note that no storage engine, including InnoDB, recognizes or enforces the MATCH clause used in referential integrity constraint definitions. Character data types (CHAR, VARCHAR, the ...By default, tables are created in the default database, using the InnoDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/connecting-disconnecting.html
If that works, you should see some introductory information followed by a mysql> prompt: $> mysql -h host -u user -p Enter password: ******** Welcome to the MySQL monitor. To connect to the server, you usually need to provide a MySQL user name when ...Some MySQL installations permit users to connect as the anonymous (unnamed) user to the server running on the local ...
https://dev.mysql.com/doc/refman/5.7/en/sql-prepared-statements.html
Typically, database applications process large volumes of almost-identical statements, with only changes to literal or variable values in clauses such as WHERE for queries and deletes, SET for updates, and VALUES for inserts. For example, the C API ...Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-stage-summary-tables.html
It has these effects: For summary tables not aggregated by account, host, or user, truncation resets the summary columns to zero rather than removing rows. For summary tables aggregated by account, host, or user, truncation removes rows for ...Event ...In addition, each stage summary table that is aggregated by account, host, user, or thread is implicitly truncated by truncation of the connection table on which it depends, or truncation of ...
https://dev.mysql.com/doc/refman/5.7/en/secure-client-programming.html
Be sure that your application remains secure if a user tries to perform SQL injection by entering something like ; DROP DATABASE mysql; into a form. Have your application connect to the database using a user name different from the one you use for ...Handle External Data Properly Handle MySQL Error Messages Properly Handle External Data Properly Applications that access MySQL should not trust any data entered by users, who can try to trick your code by entering special or escaped character sequences in Web forms, URLs, or whatever application you have ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-porting-mysql.html
If you are using lookup values that contain spaces, transform or hash them into values without spaces before using them as keys in calls to add(), set(), get(), and so on. For example, prepend the table name, or the database name and the table name, ...If there is a short numeric primary key column in an InnoDB table, use it as the unique lookup key for memcached by converting the integer to a string ... Consider these aspects of memcached applications when adapting an existing MySQL schema or ...
https://dev.mysql.com/doc/refman/5.7/en/repair-table-optimization.html
Setting a session value limits the effect of the change to your current session and does not affect other users. For key_buffer_size, you must take into account that the buffer is shared with those users. You may be able to its improve performance ... REPAIR TABLE for MyISAM tables is similar to using myisamchk for repair operations, and some of the same performance optimizations apply: myisamchk has variables that control memory ...
https://dev.mysql.com/doc/refman/5.7/en/memory-storage-engine.html
You can set the size for individual tables as described later in this section. User-Created and Temporary Tables MEMORY table contents are stored in memory, which is a property that MEMORY tables share with internal temporary tables that the server ... The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-provision-replica.html
For example: mysql -u<user> -p<password> < dumpM1_nopurge.sql mysql -u<user> -p<password> < dumpM2_nopurge.sql On the replica, issue RESET MASTER to clear the GTID execution history (assuming, as explained above, that all the dump files have been ...