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/performance-schema-query-profiling.html
mysql> UPDATE performance_schema.setup_consumers SET ENABLED = 'YES' WHERE NAME LIKE '%events_statements_%'; mysql> UPDATE performance_schema.setup_consumers SET ENABLED = 'YES' WHERE NAME LIKE '%events_stages_%'; Under the user account you are ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-system-variables.html
performance_schema_users_size Command-Line Format --performance-schema-users-size=# System Variable performance_schema_users_size Scope Global Dynamic No Type Integer Default Value -1 (signifies autoscaling; do not assign this literal value) Minimum ...The Performance Schema automatically sizes the values of several of its parameters at server startup if they are not set ...Performance Schema system variables have the following meanings: performance_schema Command-Line Format --performance-schema[={OFF|ON}] System Variable performance_schema Scope Global Dynamic ...
https://dev.mysql.com/doc/refman/5.7/en/show-grants.html
SHOW GRANTS requires the SELECT privilege for the mysql system database, except to display privileges for the current user. SHOW GRANTS [FOR user] This statement displays the privileges that are assigned to a MySQL user account, in the form of ...
https://dev.mysql.com/doc/refman/5.7/en/environment-variables.html
If this variable is set, its value overrides the default for $HOME/.mysql_history. USER The default user name on Windows when connecting to mysqld. For example, setting UMASK=0600 is equivalent to UMASK=384 because 0600 octal is 384 decimal. The ...
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/range-optimization.html
If conditions that cover sets of rows contained within intervals are combined with OR, they form a condition that covers a set of rows contained within the union of their intervals. If the conditions are combined with AND, they form a condition that ... The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value ...
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/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/replication-features-current-user.html
In some cases, such as statements that change passwords, the function reference is expanded before it is written to the binary log, so that the statement includes the user name. For all other cases, the name of the current user on the source is ...