Social Networks for the life of the world
It’s straightforward to get WordPress to capture the MySQL queries it uses to generate each page view. We can then analyze the captured queries. Capturing WordPress offers a way to capture a list of the database queries it uses in each page view. It’s simple: define the global SAVEQUERIES symbol. You can define it permanently … Read more
People are using the Index WP MySQL For Speed WordPress plugin! That’s great. But it shoots into the dark: nobody can tell how much improvement they’ve seen except subjectively. That’s not good. It’s hard to improve something unless we can actually measure it. Two things can make a troublesome query. If it runs just once … Read more
Installing old versions of MySQL is a giant pain. An AskUbuntu contributor gave a workable procedure. Need to run MySQL 5.5? Download this VM. Running MySQL 5.7 is easier. Install Ubuntu 18.04, then do sudo apt install mysql-server-5.7 .
I have a Windows Presentation Foundation app using CEFSharp as a browser control. I’m porting it to use the new WebView2 control from Microsoft. That’s a workable idea now because it embeds a new Edge object in the WPF app. So, there’s no need to download the whole Chromium Embedded Framework mischegoss which saves download … Read more
This pulls together some notes on handling plugin programming for WordPress multisite (network) installations. Basic information Lots of this information comes from the globally instantiated $wpdb object. Tables To get a list of WordPress tables you can use the wpdb::tables() method. Here’s a quick way to get a useful list of tables. This list include … Read more
WooCommerce and its Storefront theme display so-called category archive pages to list products in the category. If the category includes a description, it shows at the top of the page along with the category’s name. This php snippet adds an Edit link to those pages allowing a privileged user logged in to the Dashboard to … Read more
I just stumbled across this article debunking the idea that skinny road bicycle tires are faster than wider ones. I’ve been riding on 700c x 25 Continental clincher tires pumped to 100 psi (~7 bar) for a long time now. But when I read Jan Heine’s piece I resolved to try some 700c x 32 … Read more
Writing a WordPress plugin I had to dig around to figure out maintenance mode. That’s when visitors get this message. Briefly unavailable for scheduled maintenance. Check back in a minute. It’s easy to do from plugin or theme code. To enter maintenance mode Write a file named .maintenance into your document root with something like … Read more
Rick James and I have cooked up a plugin, Index WP MySQL for Speed, to help optimize the way WordPress uses its MySQL database. It adds indexes to WordPress’s tables in MySQL to allow them to deliver data more efficiently without needing WordPress code changes. Users do not see any change in functionality, only in … Read more
The New York Times ran an article last Friday about the struggles people have had using all those vaccination-appointment web sites. The biggest complaint? The sites “crash” because they have too much traffic. I’ve worked at a company that runs scaled-up web technology. We have a customer with a vast seasonal rush, with millions of … Read more
