Mysqltuner - Revision history

Tony: /* innodb_log_file_size should be (=16M) if possible, so InnoDB total log files size equals to 25% of buffer pool size */

2023-05-31T09:46:22Z

innodb_log_file_size should be (=16M) if possible, so InnoDB total log files size equals to 25% of buffer pool size

← Older revision		Revision as of 09:46, 31 May 2023
Line 17:		Line 17:
	==innodb_log_file_size should be (=16M) if possible, so InnoDB total log files size equals to 25% of buffer pool size==		==innodb_log_file_size should be (=16M) if possible, so InnoDB total log files size equals to 25% of buffer pool size==
	That's current situation, so change log_file_size together with innodb_buffer_pool_size		That's current situation, so change log_file_size together with innodb_buffer_pool_size
			*[https://www.percona.com/blog/how-to-calculate-a-good-innodb-log-file-size/ Calculate good innodb_log_file_size]

	==Attempted to use login credentials from Debian maintenance account, but they failed.==		==Attempted to use login credentials from Debian maintenance account, but they failed.==

Tony: /* FAQ */

2022-11-22T10:17:41Z

FAQ

← Older revision		Revision as of 10:17, 22 November 2022
Line 23:		Line 23:
	or		or
	mysqltuner --defaults-file ~/.my.cnf		mysqltuner --defaults-file ~/.my.cnf


			==Attempted to use login credentials from DirectAdmin, but they failed.==
			Check mysqladmin ping

Tony: /* Attempted to use login credentials from Debian maintenance account, but they failed. */

2022-11-12T13:20:13Z

Attempted to use login credentials from Debian maintenance account, but they failed.

← Older revision		Revision as of 13:20, 12 November 2022
Line 21:		Line 21:
	Find the secret mysqltuner config or use		Find the secret mysqltuner config or use
	mysqltuner --user root		mysqltuner --user root
			or
			mysqltuner --defaults-file ~/.my.cnf

Tony: /* FAQ */

2022-11-12T12:38:19Z

FAQ

← Older revision		Revision as of 12:38, 12 November 2022
Line 17:		Line 17:
	==innodb_log_file_size should be (=16M) if possible, so InnoDB total log files size equals to 25% of buffer pool size==		==innodb_log_file_size should be (=16M) if possible, so InnoDB total log files size equals to 25% of buffer pool size==
	That's current situation, so change log_file_size together with innodb_buffer_pool_size		That's current situation, so change log_file_size together with innodb_buffer_pool_size

			==Attempted to use login credentials from Debian maintenance account, but they failed.==
			Find the secret mysqltuner config or use
			mysqltuner --user root

Tony at 09:44, 20 April 2021

2021-04-20T09:44:40Z

← Older revision		Revision as of 09:44, 20 April 2021
Line 1:		Line 1:
	=Links=		=Links=



Line 13:		Line 14:

	hmm		hmm

			==innodb_log_file_size should be (=16M) if possible, so InnoDB total log files size equals to 25% of buffer pool size==
			That's current situation, so change log_file_size together with innodb_buffer_pool_size

Tony at 13:37, 16 March 2021

2021-03-16T13:37:16Z

← Older revision		Revision as of 13:37, 16 March 2021
Line 1:		Line 1:
	=Links=		=Links=

	~~=FAQ=~~

	==name resolution is active : a reverse name resolution is made for each new connection and can reduce performance==		= FAQ =

			== name resolution is active : a reverse name resolution is made for each new connection and can reduce performance ==

	Option '''skip-name-resolve'''		Option '''skip-name-resolve'''



			== Table cache hit rate: 0% ==

			hmm

Tony: Created page with "=Links= =FAQ= ==name resolution is active : a reverse name resolution is made for each new connection and can reduce performance== Option '''skip-name-resolve'''"

2020-03-19T13:42:25Z

Created page with "=Links= =FAQ= ==name resolution is active : a reverse name resolution is made for each new connection and can reduce performance== Option '''skip-name-resolve'''"

New page

=Links=

=FAQ=

==name resolution is active : a reverse name resolution is made for each new connection and can reduce performance==
Option '''skip-name-resolve'''