Server System Variables Type Integer The maximum number of rows to return from  SELECT  statements. For more information, see Using Safe- Updates Mode (--safe-updates). The default value for a new connection is the maximum number of rows that the server permits per table. Typical default values are (2$^{32}$) − 1 or (2$^{64}$) − 1. If you have changed the limit, the default value can be restored by assigning a value of  DEFAULT . If a  SELECT  has a  LIMIT  clause, the  LIMIT  takes precedence over the value of  sql_select_limit • sql_warnings System Variable sql_warnings Scope Global, Session Dynamic Yes SET_VAR  Hint Applies No Type Boolean Default Value OFF Command-Line Format --ssl-ca=file_name System Variable ssl_ca Scope Global Dynamic ( ≥  8.0.16) Yes Dynamic ( ≤  8.0.15) No SET_VAR  Hint Applies No Type File name Default Value NULL • ssl_ca This variable controls whether single-row  INSERT  statements produce an information string if warnings occur. The default is  OFF . Set the value to  ON  to produce an information string. The path name of the Certificate Authority (CA) certificate file in PEM format. The file contains a list of trusted SSL Certificate Authorities. As of MySQL 8.0.16, this variable is dynamic and can be modified at runtime to affect the TSL context the server uses for new connections. See Server-Side Runtime Configuration and Monitoring for Encrypted Connections. Prior to MySQL 8.0.16, this variable can be set only at server startup. • ssl_capath 890 Command-Line Format --ssl-capath=dir_name System Variable ssl_capath Scope Global Dynamic ( ≥  8.0.16) Yes Dynamic ( ≤  8.0.15) No