Search Results
https://dev.mysql.com/doc/internals/en/determining-authentication-method.html
Method used for authentication is tied to the user account and stored in the plugin column of mysql.user table. Client informs about the user account it wants to log into in the Handshake Response Packet. Only then server can look-up the mysql.user ...
https://dev.mysql.com/doc/workbench/en/wb-forward-engineering-sql-scripts.html
Exporting privileges for nonexistent users will result in errors when you execute the CREATE script. This ensures that any existing instance of each object is removed when the output is executed. This causes display of any warnings generated when ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-source.html
rpl_semi_sync_master_timeout Command-Line Format --rpl-semi-sync-master-timeout=# Deprecated Yes System Variable rpl_semi_sync_master_timeout Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 10000 Minimum Value 0 Maximum ...Attempting to set the value of auto_increment_increment or auto_increment_offset to a noninteger value produces an error, and the actual value of the variable remains ...
https://dev.mysql.com/doc/internals/en/threads.html
Calls thr_setconcurrency() if it is available at compile time; this call is generally assumed to exist only on Solaris, its value should reflect the number of physical CPUs. The other reads queries from the relay log and executes them. Threads in ...
https://dev.mysql.com/doc/internals/en/guided-tour-majordir-myisam.html
We will begin by mentioning that myisam is one of what we call the MySQL storage engine directories. But the files in those directories are mostly analogues of what's in the myisam directory, and the myisam directory is sort of a 'template'. On the ...
https://dev.mysql.com/doc/internals/en/innodb-user-records.html
In the User Records part of a page, you'll find all the records that the user inserted. There are two ways to navigate through the user records, depending whether you want to think of their organization as an unordered or an ordered list. If you ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-spring-config-transactional.html
<aop:config> <aop:pointcut id="daoMethods" expression="execution(* code.Ex3Dao.*(..))"/> <aop:advisor advice-ref="txAdvice" pointcut-ref="daoMethods"/> </aop:config> This basically says that all methods called on the Ex3Dao interface will be wrapped ... Spring allows us to add transactions into our code without having to deal directly with the JDBC ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-networking.html
Default Value com.mysql.cj.protocol.StandardSocketFactory Since Version 3.0.3 connectTimeout Timeout for socket connect (in milliseconds), with 0 being no timeout. Default Value 0 Since Version 3.0.1 socketTimeout Timeout, specified in milliseconds, ...Since Version 5.0.5 maxAllowedPacket Maximum allowed packet size to send to ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-overview.html
The MySQL 8.0 Secure Deployment Guide documents procedures for deploying a Linux-generic binary distribution of MySQL Enterprise Edition Server with features for implementing and managing the security of your MySQL installation. Features required ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-61.html
Figure 1.23 Status And System Variables: Custom SQL Editor Views Additional viewing options were added for executed statements: Result Grid Available previously, and it remains the default view. This section summarizes many of the new features ...