Query all WordPress posts in MySQL not having a Yoast SEO meta description
Query all posts in WordPress not having a Yoast SEO meta description yet. You can run this on your MySQL prompt or in phpMyAdmin
Tag MySQL
Read MoreQuery all WordPress posts in MySQL not having a Yoast SEO meta description
MySQL Connector/ODBC C# test script
Whenever you need to test your ASP.NET connection to your MySQL database, using ODBC, you can use the following C# test script. Currently it uses MySQL ODBC 8.0 Unicode Driver, but you can easily change the version used
Restore single MySQL table from a full mysqldump backup file
Learn how to restore a single table from a full MySQL mysqldump backup file using Bash shell in Linux
Optimize(d) WordPress hosting (9+ practical tips)
9+ Practical tips to optimize WordPress hosting - or for any other PHP web application for that matter. Learn optimizing your WordPress hosting
MySQL InnoDB performance improvement: InnoDB buffer pool instances – Updated!
Are you running into MySQL load problems? InnoDB Buffer Pool optimization is an important step in tuning MySQL servers for a heavy InnoDB workload. Configuring innodb_buffer_pool_instances and increase read/write I/O threads. Dividing the InnoDB buffer pool into multiple instances can improve Disk I/O. And by doing so, you run your database & server more efficiently and faster. Here is a little help for you.
Optimize WordPress MySQL tables through Cron, behind the scenes
Schedule WordPress database optimization with WP-Cron.
Turn off swap
Learn how to turn off swap in Bash, because when a swap partition is enabled Linux starts swapping, which may degrade (MySQL) system performance
8 Tips to improve Joomla performance
Learn how to speed-up Joomla performance on Windows Server IIS using these 8 simple, but important, tips. Add caching, gzip compression, set your sessions & optimize MySQL database functions.
