{"id":75018,"date":"2026-10-18T03:01:00","date_gmt":"2026-10-17T17:01:00","guid":{"rendered":"https:\/\/www.rjmprogramming.com.au\/ITblog\/?p=75018"},"modified":"2026-10-17T18:29:53","modified_gmt":"2026-10-17T08:29:53","slug":"php-mysql-wordpress-blog-apache-restart-watchdog-tutorial","status":"publish","type":"post","link":"https:\/\/www.rjmprogramming.com.au\/ITblog\/php-mysql-wordpress-blog-apache-restart-watchdog-tutorial\/","title":{"rendered":"PHP MySql WordPress Blog Apache Restart Watchdog Tutorial"},"content":{"rendered":"<div style=\"width: 230px\" class=\"wp-caption alignnone\"><a target=\"_blank\" href=\"http:\/\/www.rjmprogramming.com.au\/PHP\/apache_restart_watchdog.gif\" rel=\"noopener\"><img decoding=\"async\" style=\"border: 15px solid pink;\" alt=\"PHP MySql WordPress Blog Apache Restart Watchdog Tutorial\" src=\"http:\/\/www.rjmprogramming.com.au\/PHP\/apache_restart_watchdog.gif\" title=\"PHP MySql WordPress Blog Apache Restart Watchdog Tutorial\"  style=\"float:left;\"   \/><\/a><p class=\"wp-caption-text\">PHP MySql WordPress Blog Apache Restart Watchdog Tutorial<\/p><\/div>\n<p>A couple of days before yesterday&#8217;s <a title='PHP MySql WordPress Blog Performance PHP-FPM Configuration Tutorial' href='#phpmswpbpphp-fpmct'>PHP MySql WordPress Blog Performance PHP-FPM Configuration Tutorial<\/a> <a href='#myfour'>you may recall<\/a> we started <font color=purple>with four<\/font> <a title='PHP MySql WordPress Blog Performance Primer Tutorial' href='#phpmswpbppt'>PHP MySql WordPress Blog Performance Primer Tutorial<\/a> &#8220;Performance enhancement&#8221; ideas, and today, start down the <sup>side-<\/sup>road adding <font color=blue>two more ideas<\/font> into the mix &#8230;<\/p>\n<ul class=myfour>\n<li><font color=purple>MySql slow queries<\/font><\/li>\n<li><font color=purple>PHP slow processing<\/font><\/li>\n<li><font color=blue>inhouse watchdog resurrections<\/font><\/li>\n<li><font color=blue>blog image loading priorities<\/font><\/li>\n<li><font color=purple>caching ideas<\/font><\/li>\n<li><font color=purple>PHP-FPM (Multi PHP Manager) settings<\/font><\/li>\n<\/ul>\n<p>These two new ideas we think can <i>value add<\/i> to our &#8220;Performance enhancement&#8221; endeavours here regarding our AlmaLinux WHM <a target=\"_blank\" title='cPanel' href='https:\/\/www.cpanel.net' rel=\"noopener\">cPanel<\/a> Apache\/PHP\/MySql <font size=1>mainly<\/font> WordPress<a target=\"_blank\" href=\"https:\/\/wordpress.org\/\" rel=\"noopener\">.org<\/a> blog and other RJM Programming domain parts.<\/p>\n<p>We&#8217;ve already developed an &#8220;inhouse watchdog&#8221; regarding crontab Korn Shell command line scripting means by which, under compromised MySql database conditions (when we last presented <a target=\"_blank\" href='https:\/\/www.rjmprogramming.com.au\/ITblog\/mysql-watchdog-migration-transition-solution-tutorial\/' title='MySql Watchdog Migration Transition Solution Tutorial' rel=\"noopener\">MySql Watchdog Migration Transition Solution Tutorial<\/a>), we can perform the equivalent of &#8230;<\/p>\n<p><code><br \/>\nWHM cPanel -&gt; Restart Services -&gt; Database Server<br \/>\n<\/code><\/p>\n<p>Today&#8217;s work uses that same crontab &#8220;every minute&#8221; Korn Shell &#8230;<\/p>\n<p><code><br \/>\n* * * * * \/etc\/init.d\/cron_is_working.ksh<br \/>\n<\/code><\/p>\n<p> &#8230; mentioned in <a target=\"_blank\" href='https:\/\/www.rjmprogramming.com.au\/ITblog\/linux-centos-web-server-domlogs-diskspace-automating-solution-tutorial\/' title='Linux CentOS Web Server Domlogs Diskspace Automating Solution Tutorial' rel=\"noopener\">Linux CentOS Web Server Domlogs Diskspace Automating Solution Tutorial<\/a> inserting these Korn Shell scripting codelines &#8230;<\/p>\n<p><code><br \/>\ncurl -v --max-time 5 https:\/\/www.rjmprogramming.com.au\/Links.html<br \/>\ncret=\"`echo \\$?`\"<br \/>\nif [ \"`echo \\$cret`\" == \"28\" ]; then<br \/>\n \/usr\/local\/cpanel\/scripts\/restartsrv_httpd --restart --hard<br \/>\n cret=\"-7\"<br \/>\nfi<br \/>\n<\/code><\/p>\n<p> &#8230; to add to the &#8220;inhouse watchdog&#8221; smarts by, given an adverse website connection test, we can perform the equivalent of &#8230;<\/p>\n<p><code><br \/>\nWHM cPanel -&gt; Restart Services -&gt; HTTP Server (Apache)<br \/>\n<\/code><\/p>\n<p> &#8230; both as a resurrection measure and a &#8220;buying us more time&#8221; measure to relax more working on &#8220;Performance enhancement&#8221; ideas into the future.<\/p>\n<p>Regarding help here we got enormous help from &#8230;<\/p>\n<ul>\n<li><a target=\"_blank\" href='https:\/\/www.google.com\/search?q=detecting+%22took+too+long+to+respond%22+from+command+line&#038;rlz=1C5OZZY_en&#038;oq=detecting+%22took+too+long+to+respond%22+from+command+line&#038;gs_lcrp=EgZjaHJvbWUyBggAEEUYOTIHCAEQIRigATIHCAIQIRigATIHCAMQIRigATIHCAQQIRiPAjIHCAUQIRiPAtIBCjEwMTIyajBqMTWoAgiwAgHxBYony6mjwE9F&#038;sourceid=chrome&#038;source=chrome.rb&#038;ie=UTF-8' title='detecting \"took too long to respond\" from command line' rel=\"noopener\">detecting &#8220;took too long to respond&#8221; from command line<\/a><\/li>\n<li><a target=\"_blank\" href='https:\/\/www.google.com\/search?q=restartsrv_httpd+not+restarting+HTTP+Server+(Apache)+from+command+line&#038;rlz=1C5OZZY_en&#038;oq=restartsrv_httpd+not+restarting+HTTP+Server+(Apache)+from+command+line&#038;gs_lcrp=EgZjaHJvbWUyBggAEEUYOTIHCAEQIRiPAtIBCjIzMDY4ajBqMTWoAgiwAgHxBWLM5tLracXY&#038;sourceid=chrome&#038;source=chrome.rb&#038;ie=UTF-8' title='restartsrv_httpd not restarting HTTP Server (Apache) from command line' rel=\"noopener\">restartsrv_httpd not restarting HTTP Server (Apache) from command line<\/a><\/li>\n<\/ul>\n<p> &#8230; thanks.<\/p>\n<p><!--p>You can also see this play out at WordPress 4.1.1's <a target=\"_blank\" href='\/\/www.rjmprogramming.com.au\/ITblog\/php-mysql-wordpress-blog-apache-restart-watchdog-tutorial\/' rel=\"noopener\">PHP MySql WordPress Blog Apache Restart Watchdog Tutorial<\/a>.<\/p-->\n<hr>\n<p id='phpmswpbpphp-fpmct'>Previous relevant <a target=\"_blank\" title='PHP MySql WordPress Blog Performance PHP-FPM Configuration Tutorial' href='\/\/www.rjmprogramming.com.au\/ITblog\/php-mysql-wordpress-blog-performance-php-fpm-configuration-tutorial\/' rel=\"noopener\">PHP MySql WordPress Blog Performance PHP-FPM Configuration Tutorial<\/a> is shown below.<\/p>\n<div style=\"width: 230px\" class=\"wp-caption alignnone\"><a target=\"_blank\" href=\"http:\/\/www.rjmprogramming.com.au\/PHP\/pho_logging_on.gif\" rel=\"noopener\"><img decoding=\"async\" style=\"border: 15px solid pink;\" alt=\"PHP MySql WordPress Blog Performance PHP-FPM Configuration Tutorial\" src=\"http:\/\/www.rjmprogramming.com.au\/\/PHP\/php_logging_on.gif\" title=\"PHP MySql WordPress Blog Performance PHP-FPM Configuration Tutorial\"  style=\"float:left;\"   \/><\/a><p class=\"wp-caption-text\">PHP MySql WordPress Blog Performance PHP-FPM Configuration Tutorial<\/p><\/div>\n<p>Moving on from yesterday&#8217;s <a title='PHP MySql WordPress Blog Performance Primer Tutorial' href='#phpmswpbppt'>PHP MySql WordPress Blog Performance Primer Tutorial<\/a>&#8216;s <i>Performance monitoring theory 1<\/i> regarding our AlmaLinux Apache\/PHP\/MySql <font size=1>mainly<\/font> WordPress<a target=\"_blank\" href=\"https:\/\/wordpress.org\/\" rel=\"noopener\">.org<\/a> blog, involving &#8230;<\/p>\n<ul>\n<li>MySql slow queries &#8230; today, we move on to logging and monitoring &#8230;<\/li>\n<li>PHP slow processing<\/li>\n<\/ul>\n<p> &#8230; and it pans out to log and monitor the PHP this way we got advice from <a target=\"_blank\" href='https:\/\/www.google.com\/search?q=on+almalinux+where+is+a+log+that+would+detect+php+performance+issues%3F&#038;sca_esv=d11bf3d68244a04c&#038;rlz=1C5OZZY_en&#038;sxsrf=APpeQnurr3-TJbRLT_gkaCAKY1oNkwLl1g%3A1792021120480&#038;ei=gBLQaozoHNmc4-EP_oCV-AU&#038;biw=1440&#038;bih=699&#038;uact=5&#038;oq=on+almalinux+where+is+a+log+that+would+detect+php+performance+issues%3F&#038;gs_lp=Egxnd3Mtd2l6LXNlcnAiRW9uIGFsbWFsaW51eCB3aGVyZSBpcyBhIGxvZyB0aGF0IHdvdWxkIGRldGVjdCBwaHAgcGVyZm9ybWFuY2UgaXNzdWVzP0i7e1CbDlj5eHABeAGQAQCYAYMCoAHwIaoBBjAuMTUuN7gBA8gBAPgBAZgCDqACvBTCAgoQABhHGNYEGLADwgIFECEYoAHCAgcQIRgKGKABwgIEECEYCpgDAIgGAZAGCJIHBTEuOS40oAesP7IHBTAuOS40uAeuFMIHCDAuMTIuMS4xyAcogAgB&#038;sclient=gws-wiz-serp' rel=\"noopener\">on almalinux where is a log that would detect php performance issues?<\/a> &#8230;<\/p>\n<blockquote cite='https:\/\/www.google.com\/search?q=on+almalinux+where+is+a+log+that+would+detect+php+performance+issues%3F&#038;sca_esv=d11bf3d68244a04c&#038;rlz=1C5OZZY_en&#038;sxsrf=APpeQnurr3-TJbRLT_gkaCAKY1oNkwLl1g%3A1792021120480&#038;ei=gBLQaozoHNmc4-EP_oCV-AU&#038;biw=1440&#038;bih=699&#038;uact=5&#038;oq=on+almalinux+where+is+a+log+that+would+detect+php+performance+issues%3F&#038;gs_lp=Egxnd3Mtd2l6LXNlcnAiRW9uIGFsbWFsaW51eCB3aGVyZSBpcyBhIGxvZyB0aGF0IHdvdWxkIGRldGVjdCBwaHAgcGVyZm9ybWFuY2UgaXNzdWVzP0i7e1CbDlj5eHABeAGQAQCYAYMCoAHwIaoBBjAuMTUuN7gBA8gBAPgBAZgCDqACvBTCAgoQABhHGNYEGLADwgIFECEYoAHCAgcQIRgKGKABwgIEECEYCpgDAIgGAZAGCJIHBTEuOS40oAesP7IHBTAuOS40uAeuFMIHCDAuMTIuMS4xyAcogAgB&#038;sclient=gws-wiz-serp'><p>\n\u2022 PHP-FPM Slow Log: Captures backtraces of PHP scripts that exceed a defined time limit, helping pinpoint slow code or blocking functions.<br \/>\n<br \/>\n\t\u2022 Default \/ Common Path: \/var\/log\/php-fpm\/www-slow.log (or \/var\/log\/php8.x-fpm-slow.log depending on your PHP version)<br \/>\n<br \/>\n\t\u2022 cPanel Path: \/opt\/cpanel\/ea-phpXX\/root\/usr\/var\/log\/php-fpm\/error.log\n<\/p><\/blockquote>\n<p> &#8230; thanks &#8230; getting us to change the PHP-FPM configuration settings for the rjmprogramming.com.au domain specific PHP-FPM configuration settings in, for us, being in our WHM <a target=\"_blank\" title='cPanel' href='https:\/\/www.cpanel.net' rel=\"noopener\">cPanel<\/a> Terminal, going &#8230;<\/p>\n<p><code><br \/>\nvi \/opt\/cpanel\/ea-php81\/root\/etc\/php-fpm.d\/rjmprogramming.com.au.conf<br \/>\n<\/code><\/p>\n<p> &#8230; by appending &#8230;<\/p>\n<p><code><br \/>\nrequest_slowlog_timeout = 5s<br \/>\nslowlog = \/opt\/cpanel\/ea-php81\/root\/etc\/php-fpm.d\/www-slow.log<br \/>\n<\/code><\/p>\n<p> &#8230; and saving within the <i>vi<\/i> session, then in our WHM cPanel &#8230;<\/p>\n<p><code><br \/>\nRestart Services -&gt; HTTP Server (Apache)<br \/>\n<\/code><\/p>\n<p> &#8230; link click, and a Restart button click, to log to, for us start logging to &#8230;<\/p>\n<p><code><br \/>\n\/opt\/cpanel\/ea-php81\/root\/etc\/php-fpm.d\/www-slow.log<br \/>\n<\/code><\/p>\n<p> &#8230; pointing out to us two major pinchpoints exemplified by &#8230;<\/p>\n<table>\n<tr>\n<th>Codex loop.php<\/th>\n<th>WordPress error 404 event PHP<\/th>\n<\/tr>\n<tr>\n<th>Overuse of file_get_contents<\/th>\n<th>Rearrange use of file_get_contents &#8230;<br \/>passing more work to crontab\/curl overnight run<\/th>\n<\/tr>\n<tr>\n<td>\n<textarea style=font-size:6px;width:100%; rows=18><br \/>\n[16-Oct-2026 12:54:52]  [pool rjmprogramming_com_au] pid 2155053<br \/>\nscript_filename = \/home\/rjmprogr\/public_html\/ITblog\/index.php<br \/>\n[0x00007fe6f7816740] file_get_contents() \/home\/rjmprogr\/public_html\/ITblog\/wp-content\/themes\/twentyten\/loop.php:187<br \/>\n[0x00007fe6f78165c0] [INCLUDE_OR_EVAL]() \/home\/rjmprogr\/public_html\/ITblog\/wp-includes\/template.php:878<br \/>\n[0x00007fe6f7816460] load_template() \/home\/rjmprogr\/public_html\/ITblog\/wp-includes\/template.php:811<br \/>\n[0x00007fe6f7816330] locate_template() \/home\/rjmprogr\/public_html\/ITblog\/wp-includes\/general-template.php:206<br \/>\n[0x00007fe6f7816270] get_template_part() \/home\/rjmprogr\/public_html\/ITblog\/wp-content\/themes\/twentyten\/index.php:34<br \/>\n[0x00007fe6f7816210] [INCLUDE_OR_EVAL]() \/home\/rjmprogr\/public_html\/ITblog\/wp-includes\/template-loader.php:113<br \/>\n[0x00007fe6f7816140] [INCLUDE_OR_EVAL]() \/home\/rjmprogr\/public_html\/ITblog\/wp-blog-header.php:19<br \/>\n[0x00007fe6f78160b0] [INCLUDE_OR_EVAL]() \/home\/rjmprogr\/public_html\/ITblog\/index.php:36<br \/>\n<\/textarea>\n<\/td>\n<td>\n<textarea style=font-size:6px;width:100%; rows=18><br \/>\n[16-Oct-2026 12:54:53]  [pool rjmprogramming_com_au] pid 2155088<br \/>\nscript_filename = \/home\/rjmprogr\/public_html\/ITblog\/index.php<br \/>\n[0x00007fe6f781aad0] file_get_contents() \/home\/rjmprogr\/public_html\/ITblog\/wp-content\/themes\/twentyten\/404.php:2021<br \/>\n[0x00007fe6f7816650] selectNewBlogPostingTutorialPicture() \/home\/rjmprogr\/public_html\/ITblog\/wp-content\/themes\/twentyten\/404.php:3894<br \/>\n[0x00007fe6f7816210] [INCLUDE_OR_EVAL]() \/home\/rjmprogr\/public_html\/ITblog\/wp-includes\/template-loader.php:113<br \/>\n[0x00007fe6f7816140] [INCLUDE_OR_EVAL]() \/home\/rjmprogr\/public_html\/ITblog\/wp-blog-header.php:19<br \/>\n[0x00007fe6f78160b0] [INCLUDE_OR_EVAL]() \/home\/rjmprogr\/public_html\/ITblog\/index.php:36<br \/>\n<\/textarea>\n<\/td>\n<\/tr>\n<\/table>\n<p> &#8230; as two logging detection types of use to us, as we continue on our &#8220;Performance quest&#8221;.<\/p>\n<p><!--p>You can also see this play out at WordPress 4.1.1's <a target=\"_blank\" href='\/\/www.rjmprogramming.com.au\/ITblog\/php-mysql-wordpress-blog-performance-php-fpm-configuration-tutorial\/' rel=\"noopener\">PHP MySql WordPress Blog Performance PHP-FPM Configuration Tutorial<\/a>.<\/p-->\n<hr>\n<p id='phpmswpbppt'>Previous relevant <a target=\"_blank\" title='PHP MySql WordPress Blog Performance Primer Tutorial' href='\/\/www.rjmprogramming.com.au\/ITblog\/php-mysql-wordpress-blog-performance-primer-tutorial\/' rel=\"noopener\">PHP MySql WordPress Blog Performance Primer Tutorial<\/a> is shown below.<\/p>\n<div style=\"width: 230px\" class=\"wp-caption alignnone\"><a target=\"_blank\" href=\"http:\/\/www.rjmprogramming.com.au\/MySql\/slow_query_logging_on.gif\" rel=\"noopener\"><img decoding=\"async\" style=\"border: 15px solid pink;\" alt=\"PHP MySql WordPress Blog Performance Primer Tutorial\" src=\"http:\/\/www.rjmprogramming.com.au\/MySql\/slow_query_logging_on.gif\" title=\"PHP MySql WordPress Blog Performance Primer Tutorial\"  style=\"float:left;\"   \/><\/a><p class=\"wp-caption-text\">PHP MySql WordPress Blog Performance Primer Tutorial<\/p><\/div>\n<p>To our minds, when thinking about the performance of this blog, which we think could do with some attention given more traffic lately, it being an AlmaLinux Apache\/PHP\/MySql WordPress<a target=\"_blank\" href=\"https:\/\/wordpress.org\/\" rel=\"noopener\">.org<\/a> one, we know of four avenues of research we&#8217;d say are &#8230;<\/p>\n<ul id=myfour>\n<li>MySql slow queries<\/li>\n<li>PHP slow processing<\/li>\n<li>caching ideas<\/li>\n<li>PHP-FPM (Multi PHP Manager) settings<\/li>\n<\/ul>\n<p> &#8230; the last of which we&#8217;ll leave to last, but some of that can be got to via WHM <a target=\"_blank\" title='cPanel' href='https:\/\/www.cpanel.net' rel=\"noopener\">cPanel<\/a> options.<\/p>\n<p>With the first two, you will probably need to consider the information web server logging can provide you.  By default, we&#8217;re finding, AlmaLinux Apache\/PHP\/MySql web servers of any recent times do not by default log for either of the first two above.<\/p>\n<p>And so, today&#8217;s start down our road examining &#8220;performance&#8221;, we&#8217;ll outline how to set up logging to start investigating whether slow MySql database <font size=1>(further to <a title='PHP MySql Select Query UTF-8 Return Values Tutorial' href='#phpmssqutf-8rvt'>PHP MySql Select Query UTF-8 Return Values Tutorial<\/a>)<\/font> queries are &#8220;too adversely&#8221; affecting your Apache\/PHP\/MySql web server&#8217;s creation of your (perhaps WordPress blog) webpage(s).<\/p>\n<p>Here we got great advice from <a target=\"_blank\" href='https:\/\/www.google.com\/search?q=on+almalinux+where+is+a+log+that+would+detect+slow+mysql+queries%3F&#038;rlz=1C5OZZY_en&#038;oq=on+almalinux+where+is+a+log+that+would+detect+slow+mysql+queries%3F&#038;gs_lcrp=EgZjaHJvbWUyBggAEEUYOTIHCAEQIRiPAjIHCAIQIRiPAtIBCjI2NDgwajBqMTWoAgiwAgHxBXnhk69dcs3V&#038;sourceid=chrome&#038;source=chrome.rb&#038;ie=UTF-8' title='on almalinux where is a log that would detect slow mysql queries?' rel=\"noopener\">on almalinux where is a log that would detect slow mysql queries?<\/a> &#8230; thanks &#8230; gleaning &#8230;<\/p>\n<blockquote cite='https:\/\/www.google.com\/search?q=on+almalinux+where+is+a+log+that+would+detect+slow+mysql+queries%3F&#038;rlz=1C5OZZY_en&#038;oq=on+almalinux+where+is+a+log+that+would+detect+slow+mysql+queries%3F&#038;gs_lcrp=EgZjaHJvbWUyBggAEEUYOTIHCAEQIRiPAjIHCAIQIRiPAtIBCjI2NDgwajBqMTWoAgiwAgHxBXnhk69dcs3V&#038;sourceid=chrome&#038;source=chrome.rb&#038;ie=UTF-8'><p>\nBy default, MySQL&#8217;s slow query log is turned off on AlmaLinux. If it has been enabled, you can find the file path by running a quick SQL command, or you can configure it manually.\n<\/p><\/blockquote>\n<p> &#8230; leading us to &#8230;<\/p>\n<ol>\n<li>accessed WHM cPanel -&gt; Edit Database Configuration<\/li>\n<li>set the Slow Query logging to enabled<\/li>\n<li>Save<sup>d<\/sup> that change<\/li>\n<li>accessed WHM cPanel -&gt; Restart Services -&gt; Database Server<\/li>\n<li>click Restart button<\/li>\n<li>then, accessing WHM cPanel -&gt; Terminal, from then on, at it&#8217;s command line &#8230;<br \/>\n<code><br \/>\nls -l \/var\/lib\/mysql\/*.log<br \/>\ncat  \/var\/lib\/mysql\/65-254-93-2-slow.log  # as relevant, in our RJM Programming domain's case, if above not showing zero length log<br \/>\n<\/code><br \/>\n &#8230; were our means of knowing if slow MySql queries are a major issue\n<\/li>\n<\/ol>\n<p> &#8230; and after a day of logging?  We think this is not the major &#8220;performance&#8221; concern for our RJM Programming domain, that slow log still showing no issues.  And so, tomorrow, the quest continues.<\/p>\n<p><!--p>You can also see this play out at WordPress 4.1.1's <a target=\"_blank\" href='\/\/www.rjmprogramming.com.au\/ITblog\/php-mysql-wordpress-blog-performance-primer-tutorial\/' rel=\"noopener\">PHP MySql WordPress Blog Performance Primer Tutorial<\/a>.<\/p-->\n<hr>\n<p id='phpmssqutf-8rvt'>Previous relevant <a target=\"_blank\" title='PHP MySql Select Query UTF-8 Return Values Tutorial' href='\/\/www.rjmprogramming.com.au\/ITblog\/php-mysql-select-query-utf-8-return-values-tutorial\/' rel=\"noopener\">PHP MySql Select Query UTF-8 Return Values Tutorial<\/a> is shown below.<\/p>\n<div style=\"width: 230px\" class=\"wp-caption alignnone\"><a target=\"_blank\" href=\"http:\/\/www.rjmprogramming.com.au\/MySql\/php_mysql_utf8_fix.gif\" rel=\"noopener\"><img decoding=\"async\" style=\"border: 15px solid pink;\" alt=\"PHP MySql Select Query UTF-8 Return Values Tutorial\" src=\"http:\/\/www.rjmprogramming.com.au\/MySql\/php_mysql_utf8_fix.gif\" title=\"PHP MySql Select Query UTF-8 Return Values Tutorial\"  style=\"float:left;\"   \/><\/a><p class=\"wp-caption-text\">PHP MySql Select Query UTF-8 Return Values Tutorial<\/p><\/div>\n<p>Yes, ever since embracing emojis, we&#8217;re on the lookout for gobbledegook.  And yes, a lot of the strategies we found on the &#8220;stumbled upon&#8221; <a target=\"_blank\" title='Useful link, thanks' href='https:\/\/stackoverflow.com\/questions\/3682409\/reading-utf-8-content-from-mysql-table' rel=\"noopener\">Reading UTF-8 Content from MySql Table<\/a> we were familiar with, but one we weren&#8217;t, which was the one we discovered as gobbledegook in our Landing Page&#8217;s major dropdown outlining all the blog posts we&#8217;ve written at the RJM Programming WordPress Blog Website we&#8217;re running here, and you are reading now.<\/p>\n<p>The, was &#8230;<\/p>\n<p><code><br \/>\nJust Javascript Five Hundred Card Game Open Mis\ufffdre Progress Bar Tutorial (20210507)<br \/>\n<\/code><\/p>\n<p> &#8230; anti gobbledegook initiative scenario, with our changed tutorial_options.php cronatb\/curl morning scheduled Landing Page modifier, becomes &#8230;<\/p>\n<p><code><br \/>\nJust Javascript Five Hundred Card Game Open Mis\u00e8re Progress Bar Tutorial (20210507)<br \/>\n<\/code><\/p>\n<p> &#8230; improvement, came about from a consideration we have not thought about before &#8230; what about if MySql data contains UTF-8 data, and is part of a WordPress blog title, which ends up on the Landing Page big dropdown, already covered by a &#8230;<\/p>\n<p><code><br \/>\n&lt;meta http-equiv=\"Content-Type\" content=\"text\/html; charset=UTF-8\"&gt;<br \/>\n<\/code><\/p>\n<p> &#8230; was inspired by checking off the excellent &#8220;already catered for&#8221; anti gobbledegook (emoji) checklist measures, leaving the PHP &#8230;<\/p>\n<p>&lt;?php<br \/>\n<code><br \/>\n $res =  mysql_query(\"set names 'utf8'\");<br \/>\n<\/code><br \/>\n?&gt;<\/p>\n<p> &#8230; initiative, before any SQL SELECT type queries, idea, presented at <a target=\"_blank\" title='Reading UTF-8 Content from MySql Table' href='https:\/\/stackoverflow.com\/questions\/3682409\/reading-utf-8-content-from-mysql-table' rel=\"noopener\">Reading UTF-8 Content from MySql Table<\/a>, which fixed our issue very nicely, thanks, in <a target=\"_blank\" title='tutorial_options.php' href='http:\/\/www.rjmprogramming.com.au\/PHP\/Geographicals\/diff.php?one=http:\/\/www.rjmprogramming.com.au\/PHP\/tutorial_options.php-----------GETME' rel=\"noopener\">our changed<\/a> <a target=\"_blank\" title='tutorial_options.php' href='http:\/\/www.rjmprogramming.com.au\/PHP\/tutorial_options.php-----------GETME' rel=\"noopener\">tutorial_options.php<\/a> PHP crontab\/curl PHP helper.<\/p>\n<p>If this was interesting you may be interested in <a title='Click here to see topics in which you might be interested' href='#d58110' onclick='var dv=document.getElementById(\"d58110\"); dv.innerHTML = \"&lt;iframe width=670 height=600 src=\" + \"https:\/\/www.rjmprogramming.com.au\/ITblog\/tag\/mysql\" + \"&gt;&lt;\/iframe&gt;\"; dv.style.display = \"block\";'>this<\/a> too.<\/p>\n<div id='d58110' style='display: none; border-left: 2px solid green; border-top: 2px solid green;'><\/div>\n<hr>\n<p>If this was interesting you may be interested in <a title='Click here to see topics in which you might be interested' href='#d75000' onclick='var dv=document.getElementById(\"d75000\"); dv.innerHTML = \"&lt;iframe width=670 height=600 src=\" + \"https:\/\/www.rjmprogramming.com.au\/ITblog\/tag\/performance\" + \"&gt;&lt;\/iframe&gt;\"; dv.style.display = \"block\";'>this<\/a> too.<\/p>\n<div id='d75000' style='display: none; border-left: 2px solid green; border-top: 2px solid green;'><\/div>\n<hr>\n<p>If this was interesting you may be interested in <a title='Click here to see topics in which you might be interested' href='#d75010' onclick='var dv=document.getElementById(\"d75010\"); dv.innerHTML = \"&lt;iframe width=670 height=600 src=\" + \"https:\/\/www.rjmprogramming.com.au\/ITblog\/tag\/logfile\" + \"&gt;&lt;\/iframe&gt;\"; dv.style.display = \"block\";'>this<\/a> too.<\/p>\n<div id='d75010' style='display: none; border-left: 2px solid green; border-top: 2px solid green;'><\/div>\n<hr>\n<p>If this was interesting you may be interested in <a title='Click here to see topics in which you might be interested' href='#d75018' onclick='var dv=document.getElementById(\"d75018\"); dv.innerHTML = \"&lt;iframe width=670 height=600 src=\" + \"https:\/\/www.rjmprogramming.com.au\/ITblog\/tag\/watchdog\" + \"&gt;&lt;\/iframe&gt;\"; dv.style.display = \"block\";'>this<\/a> too.<\/p>\n<div id='d75018' style='display: none; border-left: 2px solid green; border-top: 2px solid green;'><\/div>\n","protected":false},"excerpt":{"rendered":"<p>A couple of days before yesterday&#8217;s PHP MySql WordPress Blog Performance PHP-FPM Configuration Tutorial you may recall we started with four PHP MySql WordPress Blog Performance Primer Tutorial &#8220;Performance enhancement&#8221; ideas, and today, start down the side-road adding two more &hellip; <a href=\"https:\/\/www.rjmprogramming.com.au\/ITblog\/php-mysql-wordpress-blog-apache-restart-watchdog-tutorial\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,12,29,37],"tags":[85,151,234,249,270,274,284,299,5732,1929,5734,716,4085,5733,717,2752,809,827,5729,915,932,1018,2260,1105,1106,2031,1138,5731,5730,1252,2027,1319,1397,1411,1421,1426,1456,3276],"class_list":["post-75018","post","type-post","status-publish","format-standard","hentry","category-database","category-elearning","category-operating-system","category-tutorials","tag-apache","tag-blog","tag-command-line","tag-configuration","tag-cpanel","tag-crontab","tag-curl","tag-database-2","tag-elapsed-time","tag-error","tag-koen-shell","tag-log","tag-log-file","tag-logfile","tag-logging","tag-monitor","tag-monitoring","tag-mysql","tag-mysql-query","tag-performance","tag-php","tag-query","tag-restart","tag-script","tag-scripting","tag-service","tag-shell","tag-slow-mysql-query","tag-slow-query","tag-terminal","tag-timeout","tag-tutorial","tag-watchdog","tag-web-server","tag-website","tag-whm","tag-wordpress","tag-wordpress-blog"],"_links":{"self":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts\/75018"}],"collection":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/comments?post=75018"}],"version-history":[{"count":10,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts\/75018\/revisions"}],"predecessor-version":[{"id":75028,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts\/75018\/revisions\/75028"}],"wp:attachment":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/media?parent=75018"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/categories?post=75018"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/tags?post=75018"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}