You are here: Saotn.org » MySQL

MySQL

Disable Joomla Contacts component (com_contact) in MySQL / phpMyAdmin

MySQL / By / 6 January 2021

How-to disable Joomla’s built-in contact forms component and its ability to send a copy to the sender, directly in your MySQL database using phpMyAdmin

Often the built-in Joomla contact forms component (com_contact) is abused by spammers. These contact forms allow the sender to receive a copy of the form contents. All spammers need to do is enter the email address of the target as sender/from. This way, anyone can use the Joomla contact form for spamming anyone. This short article explains how to disable and combat this.

…

Disable Joomla Contacts component (com_contact) in MySQL / phpMyAdminRead More »

Disable WordPress XCloner Plugin logger in MySQL / phpMyAdmin

WordPress / By / 5 January 2021

If XCloner Logger option is enabled, it will store a log file inside the xcloner-XXXXX folder inside the backup archive. The file is named xcloner-xxxxx.log. This can generate a huge amount of temporary files and log files on your file system. This short article provides you one SQL statement to disable XCloner log directly in your WordPress MySQL database, using phpMyAdmin.

…

Disable WordPress XCloner Plugin logger in MySQL / phpMyAdminRead More »

How to Fix Yoast SEO for WordPress DeleteDuplicateIndexables MySQL error

WordPress / By / 25 June 2020

In recent days, there are a number of reports about broken Yoast SEO database operations, related to the DeleteDuplicateIndexables function. The PHP function is located in the file wordpress-seo\src\config\migrations\20200507054848_DeleteDuplicateIndexables.php, and in this post I’ll provide you with a possible fix for this statement. Read on.

…

How to Fix Yoast SEO for WordPress DeleteDuplicateIndexables MySQL errorRead More »

Reduce Wordfence CPU usage, disable Wordfence “Live Traffic View”

WordPress / By / 27 September 2019

Whenever WordPress is using a lot of CPU and you have Wordfence Security plugin enabled, it is recommended to double check some settings. Unfortunately the Wordfence “Live Traffic Options” (“Traffic logging mode”) feature can cause high CPU usage and load issues for WordPress websites. Therefore, I recommend you disable this feature to improve the performance of your WordPress website.

…

Reduce Wordfence CPU usage, disable Wordfence “Live Traffic View”Read More »

ASP and ASP.NET connection string examples for Microsoft SQL Server and MySQL

Code base / By / 20 September 2021

A connection string is sometimes a bit obscure. Do I need ODBC or OLE DB? When you need one and Google for it, you often find old ones that either don’t work at all anymore, or are not optimal. This article provides you with a couple of ASP.NET to SQL Server connection string examples, and as a bonus for ASP to MySQL too.

…

ASP and ASP.NET connection string examples for Microsoft SQL Server and MySQLRead More »

Your WordPress hosting at Warp Speed - img. credits: Christian Daryanto Limas @ flickr

Optimize(d) WordPress hosting (9+ practical tips)

WordPress / By / 6 September 2021

9+ Practical tips to optimize WordPress hosting

Optimized WordPress hosting is a subject on which a lot is written about. And therefore, this post is not about where to host your WordPress blog, or who offers the best WordPress hosting. This post is for you developers, what you can do to optimize your WordPress hosting stack.

…

Optimize(d) WordPress hosting (9+ practical tips)Read More »

MySQL InnoDB performance improvement: InnoDB buffer pool instances – Updated!

MySQL / By / 11 September 2021

Are you running into MySQL load problems? Learn how to tune MySQL servers for a heavy InnoDB workload, by configuring innodb_buffer_pool_instances. Dividing the InnoDB buffer pool into multiple instances improves Disk I/O. By doing so, you run your database and website more efficiently and faster. Here is a little help for you.

…

MySQL InnoDB performance improvement: InnoDB buffer pool instances – Updated!Read More »

Optimize WordPress MySQL tables through Cron, behind the scenes

WordPress / By / 1 July 2020

Schedule WordPress database optimization with WP-Cron

To regularly optimize my WordPress database tables, I created a small plugin that utilizes the WordPress Cron feature. This comes in handy to perform database optimization for WordPress on a regular basis, without forgetting about it. Just activate and enjoy. And here is the plugin code …

…

Optimize WordPress MySQL tables through Cron, behind the scenesRead More »

How to disable WordPress comments

WordPress / By / 17 February 2020

The WordPress comment system can be a bless for your blog, because of the user interaction. However, when the WordPress comment option is abused by spammers, it becomes a real pain in the “@ss”. With thousands spam reactions, disabling -and removing- WordPress comments is the only way to go. Here is how to disable WordPress comments in both the WordPress Dashboard interface and in your MySQL database.

…

How to disable WordPress commentsRead More »