Troubleshooting of MySQLTuner - Revision history

Planetoid: /* How to resolve: (Cygwin) couldn't find diagnostic data */

2025-11-05T02:48:01Z

How to resolve: (Cygwin) couldn't find diagnostic data

← Older revision		Revision as of 10:48, 5 November 2025
Line 11:		Line 11:
	BEGIN failed--compilation aborted at mysqltuner.pl line 45.		BEGIN failed--compilation aborted at mysqltuner.pl line 45.
	</pre>		</pre>

	~~Solution:~~
	~~# Download the Cygwin installation file {{kbd \| key=<nowiki>setup-x86_64.exe</nowiki>}} from [https://cygwin.com/install.html Cygwin Installation]~~
	~~# Install the perl_pods package using either method below:~~

	Solution:		Solution:

Planetoid: /* How to resolve: (Cygwin) couldn't find diagnostic data */

2025-11-05T02:47:41Z

How to resolve: (Cygwin) couldn't find diagnostic data

← Older revision		Revision as of 10:47, 5 November 2025
Line 13:		Line 13:

	Solution:		Solution:
	# Download the installation file {{kbd \| key=<nowiki>setup-x86_64.exe</nowiki>}} ~~of Cygwin~~ from [https://cygwin.com/install.html Cygwin Installation]		# Download the Cygwin installation file {{kbd \| key=<nowiki>setup-x86_64.exe</nowiki>}} from [https://cygwin.com/install.html Cygwin Installation]
	# ~~Open~~ the ~~command line window~~		# Install the perl_pods package using either method below:
	# ~~Change to the directory where~~ the file {{kbd \| key=<nowiki>setup-x86_64.exe</nowiki>}} ~~located e~~.g. {{kbd \| key=<nowiki>~~cd C:\Downloads>~~</nowiki>}} ~~and than press~~ the ~~key {{kbd \| key=<nowiki>Enter</nowiki>}}~~
	# ~~To install~~ the packages: ~~perl_pods~~<ref>[https://stackoverflow.com/questions/36393757/how-do-i-use-diagnostics-for-perl-on-cygwin cpan - How do I 'use diagnostics' for Perl on Cygwin? - Stack Overflow]</ref><ref>[https://cygwin.com/faq/faq.html#faq.setup.cli Does Setup accept command-line arguments?]</ref>. ~~Keyin~~ {{kbd \| key=<nowiki>setup-x86_64.exe -q -P "perl_pods"</nowiki>}}		Solution:
			# Download the Cygwin installation file {{kbd \| key=<nowiki>setup-x86_64.exe</nowiki>}} from [https://cygwin.com/install.html Cygwin Installation]
			# Install the perl_pods package using either method below:

			'''Method 1: Using Cygwin Setup Window (GUI)'''
			# Double-click {{kbd \| key=<nowiki>setup-x86_64.exe</nowiki>}} to launch the setup wizard
			# Follow the installation wizard until you reach the "Select Packages" screen
			# If the view dropdown shows "Pending", change it to "Full" to see all available packages
			# Search for "perl_pods" in the search box
			# Click on the "Skip" text next to perl_pods to change it to the version number (this selects it for installation)
			# Click "Next" to proceed with the installation

			'''Method 2: Using Command Line (CMD)'''<ref>[https://stackoverflow.com/questions/36393757/how-do-i-use-diagnostics-for-perl-on-cygwin cpan - How do I 'use diagnostics' for Perl on Cygwin? - Stack Overflow]</ref><ref>[https://cygwin.com/faq/faq.html#faq.setup.cli Does Setup accept command-line arguments?]</ref>
			# Open a command line window
			# Navigate to the directory containing {{kbd \| key=<nowiki>setup-x86_64.exe</nowiki>}}, for example: {{kbd \| key=<nowiki>cd C:\Downloads</nowiki>}}, then press {{kbd \| key=<nowiki>Enter</nowiki>}}
			# Enter the following command: {{kbd \| key=<nowiki>setup-x86_64.exe -q -P "perl_pods"</nowiki>}}

	Environment:		Environment:
	* Windows 2008 R2 standard		* Windows 2008 R2 standard
	* Cygwin version: CYGWIN_NT-6.1 Win2008R2-0-0 2.9.0(0.318/5/3) 2017-09-12 10:18 x86_64 Cygwin (information returned from {{kbd \| key=<nowiki>uname -a</nowiki>}})		* Cygwin version: CYGWIN_NT-6.1 Win2008R2-0-0 2.9.0(0.318/5/3) 2017-09-12 10:18 x86_64 Cygwin (information returned from {{kbd \| key=<nowiki>uname -a</nowiki>}})


	== How to resolve: (Cygwin) wget command not found ==		== How to resolve: (Cygwin) wget command not found ==

Unknown user: /* How to resolve: Performance schema should be activated for better diagnostics */

2021-05-08T16:35:22Z

How to resolve: Performance schema should be activated for better diagnostics

← Older revision		Revision as of 00:35, 9 May 2021
Line 74:		Line 74:
	* Verify the MySQL setting. Execute the SQL query {{kbd \| key=<nowiki>SHOW VARIABLES LIKE 'performance_schema'</nowiki>}}. The result should be OFF.		* Verify the MySQL setting. Execute the SQL query {{kbd \| key=<nowiki>SHOW VARIABLES LIKE 'performance_schema'</nowiki>}}. The result should be OFF.
	* Stop the MySQL service.		* Stop the MySQL service.
	* Open the MySQL configuration file named {{kbd \| key=<nowiki>my.ini</nowiki>}} The file maybe located in different path e.g. C:\xampp\mysql\bin\my.ini		* Open the MySQL configuration file named {{kbd \| key=<nowiki>my.ini</nowiki>}} on {{Win}} or {{kbd \| key=<nowiki>my.cnf</nowiki>}} on {{Linux}} The file maybe located in different path e.g. C:\xampp\mysql\bin\my.ini on {{Win}}
	* Edit the MySQL configuration file		* Edit the MySQL configuration file

Unknown user at 16:31, 8 May 2021

2021-05-08T16:31:59Z

@@ Line 2: / Line 2: @@
 __TOC__
 == How to resolve: (Cygwin) couldn't find diagnostic data ==
@@ Line 32: / Line 22: @@
 * Cygwin version: CYGWIN_NT-6.1 Win2008R2-0-0 2.9.0(0.318/5/3) 2017-09-12 10:18 x86_64 Cygwin (information returned from {{kbd | key=<nowiki>uname -a</nowiki>}})
 == How to resolve: (Cygwin) unzip: command not found ==

Unknown user at 16:31, 8 May 2021

2021-05-08T16:31:14Z

← Older revision		Revision as of 00:31, 9 May 2021
Line 1:		Line 1:
	"~~MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability."<ref>~~[https://github.com/major/MySQLTuner-perl ~~major/MySQLTuner-perl:~~ MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability.~~]</ref>~~		"[https://github.com/major/MySQLTuner-perl MySQLTuner] is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability."

	__TOC__		__TOC__

	== How to resolve: wget command not found ==		== How to resolve: (Cygwin) wget command not found ==
	Condition: When I tried to download the MySQLTuner using {{kbd \| key=<nowiki>wget</nowiki>}} command but met the error.		Condition: When I tried to download the MySQLTuner using {{kbd \| key=<nowiki>wget</nowiki>}} command but met the error.

Line 13:		Line 13:
	# To install the packages: wget. Keyin {{kbd \| key=<nowiki>setup-x86_64.exe -q -P "wget"</nowiki>}} or follow the steps on [https://superuser.com/questions/693284/wget-command-not-working-in-cygwin terminal - WGET Command Not Working in Cygwin - Super User] if you prefer the GUI window.		# To install the packages: wget. Keyin {{kbd \| key=<nowiki>setup-x86_64.exe -q -P "wget"</nowiki>}} or follow the steps on [https://superuser.com/questions/693284/wget-command-not-working-in-cygwin terminal - WGET Command Not Working in Cygwin - Super User] if you prefer the GUI window.

	== How to resolve: couldn't find diagnostic data ==		== How to resolve: (Cygwin) couldn't find diagnostic data ==
	Condition:		Condition:
	<pre>		<pre>
Line 33:		Line 33:


	== How to resolve: unzip: command not found ==		== How to resolve: (Cygwin) unzip: command not found ==
	Condition:		Condition:
	<pre>		<pre>

Unknown user: /* references */

2021-05-08T16:25:19Z

references

← Older revision		Revision as of 00:25, 9 May 2021
Line 85:		Line 85:
	* Verify the MySQL setting again. Execute the SQL query {{kbd \| key=<nowiki>SHOW VARIABLES LIKE 'performance_schema'</nowiki>}}. The result should be ON.		* Verify the MySQL setting again. Execute the SQL query {{kbd \| key=<nowiki>SHOW VARIABLES LIKE 'performance_schema'</nowiki>}}. The result should be ON.

	== ~~references~~ ==		== References ==
	<references/>		<references/>

Unknown user: How to resolve: Performance schema should be activated for better diagnostics

2021-05-08T13:18:26Z

How to resolve: Performance schema should be activated for better diagnostics

@@ Line 60: / Line 60: @@
 * Specify the host parameter to command line e.g. {{kbd | key=<nowiki>perl mysqltuner.pl --host 127.0.0.1</nowiki>}}
 * Check the typo of mysql account and password
 == references ==

Unknown user: /* How to resolve: couldn't find diagnostic data */

2021-05-08T13:04:18Z

How to resolve: couldn't find diagnostic data

@@ Line 31: / Line 31: @@
 * Windows 2008 R2 standard
 * Cygwin version: CYGWIN_NT-6.1 Win2008R2-0-0 2.9.0(0.318/5/3) 2017-09-12 10:18 x86_64 Cygwin (information returned from {{kbd | key=<nowiki>uname -a</nowiki>}})
 == How to resolve: Attempted to use login credentials, but they were invalid. ==

Unknown user: /* How to resolve: couldn't find diagnostic data */

2021-05-08T12:57:13Z

How to resolve: couldn't find diagnostic data

← Older revision		Revision as of 20:57, 8 May 2021
Line 25:		Line 25:
	# Download the installation file {{kbd \| key=<nowiki>setup-x86_64.exe</nowiki>}} of Cygwin from [https://cygwin.com/install.html Cygwin Installation]		# Download the installation file {{kbd \| key=<nowiki>setup-x86_64.exe</nowiki>}} of Cygwin from [https://cygwin.com/install.html Cygwin Installation]
	# Open the command line window		# Open the command line window
			# Change to the directory where the file {{kbd \| key=<nowiki>setup-x86_64.exe</nowiki>}} located e.g. {{kbd \| key=<nowiki>cd C:\Downloads></nowiki>}} and than press the key {{kbd \| key=<nowiki>Enter</nowiki>}}
	# To install the packages: perl_pods<ref>[https://stackoverflow.com/questions/36393757/how-do-i-use-diagnostics-for-perl-on-cygwin cpan - How do I 'use diagnostics' for Perl on Cygwin? - Stack Overflow]</ref><ref>[https://cygwin.com/faq/faq.html#faq.setup.cli Does Setup accept command-line arguments?]</ref>. Keyin {{kbd \| key=<nowiki>setup-x86_64.exe -q -P "perl_pods"</nowiki>}}		# To install the packages: perl_pods<ref>[https://stackoverflow.com/questions/36393757/how-do-i-use-diagnostics-for-perl-on-cygwin cpan - How do I 'use diagnostics' for Perl on Cygwin? - Stack Overflow]</ref><ref>[https://cygwin.com/faq/faq.html#faq.setup.cli Does Setup accept command-line arguments?]</ref>. Keyin {{kbd \| key=<nowiki>setup-x86_64.exe -q -P "perl_pods"</nowiki>}}

Unknown user: /* How to resolve: wget command not found */

2021-05-08T12:56:11Z

How to resolve: wget command not found

← Older revision		Revision as of 20:56, 8 May 2021
Line 10:		Line 10:
	# Download the installation file {{kbd \| key=<nowiki>setup-x86_64.exe</nowiki>}} of Cygwin from [https://cygwin.com/install.html Cygwin Installation]		# Download the installation file {{kbd \| key=<nowiki>setup-x86_64.exe</nowiki>}} of Cygwin from [https://cygwin.com/install.html Cygwin Installation]
	# Open the command line window		# Open the command line window
			# Change to the directory where the file {{kbd \| key=<nowiki>setup-x86_64.exe</nowiki>}} located e.g. {{kbd \| key=<nowiki>cd C:\Downloads></nowiki>}} and than press the key {{kbd \| key=<nowiki>Enter</nowiki>}}
	# To install the packages: wget. Keyin {{kbd \| key=<nowiki>setup-x86_64.exe -q -P "wget"</nowiki>}} or follow the steps on [https://superuser.com/questions/693284/wget-command-not-working-in-cygwin terminal - WGET Command Not Working in Cygwin - Super User] if you prefer the GUI window.		# To install the packages: wget. Keyin {{kbd \| key=<nowiki>setup-x86_64.exe -q -P "wget"</nowiki>}} or follow the steps on [https://superuser.com/questions/693284/wget-command-not-working-in-cygwin terminal - WGET Command Not Working in Cygwin - Super User] if you prefer the GUI window.