query – Mysql + WordPress is killing my server (CPU usage is huge and it becomes slow)

I recently installed WordPress on a production server with 80K registered users. The problem is that the mysql database consumes the entire CPU and the server becomes very slow. I disabled all the add-ons and changed the name of the add-on folders and the problem persists.

up – 20:26:55 up to 6 days, 16:01, 1 user, average load: 4.42, 4.47, 4.54
Tasks: 192 in total, 2 in execution, 190 sleeping, 0 arrested, 0 zombies
% CPU (s): 55.2 us, 3.4 s, 0.0 ni, 40.7 id, 0.6 wa, 0.0 hi, 0.2 if, 0.0 st
Mem of KiB: 32639948 in total, 239032 free, 8069912 used, 24331004 buff / cache
KiB exchange: 8388604 in total, 8375548 free, 13056 used. 23506600 available Mem

PID USER PR NI VIRT RES SHR S% CPU% MEM TIME + COMMAND
3957 mysql 20 0 1629756 232200 9344 S 384.1 0.7 106: 23.68 mysqld

I have monitored mysql with mysql -u admin -p -e "SHOW COMPLETE PROCESS LIST"; and this same query is repeated many times:

| Query | 0 | statistics | SELECT ID, post_name, post_parent, post_type
FROM wp_posts
WHERE post_name IN (& # 39; wp-content & # 39 ;, & # 39; plugins & # 39 ;, & # 39; um-followers & # 39 ;, & # 39; active & # 39 ;, & # 39; js & # 39 ;, & # 39; um-followers-min-js & # 39;)
AND post_type IN (& # 39; page & # 39 ;, & # 39; file attachment & # 39;) | 0.000 |
| 13489 | mydbnumber1 | localhost | mydbnumber1 | Query | 0 | Copying to the table tmp | SELECT wp_users.user_login FROM wp_users INNER JOIN wp_usermeta ON (wp_users.ID = wp_usermeta.user_id) WHERE 1 = 1 AND (
(
(wp_usermeta.meta_key = & # 39; wp_capabilities & # 39; AND wp_usermeta.meta_value LIKE & # 39;% "administrator "% & # 39;)
)
) ORDER BY user_login ASC | 0.000 |

I searched this killer code query in all wordpress instalation files and only found matches in the file named: wp-admin includes deprecated.php line 523. So I decided to comment on that code snippet and reload the file disused .php to the server, but the problem persists!

This is crazy now, I have been researching this for 2 days and I can not find a solution. Could someone help me over?

Thank you for reading.

Shortcode – How to create custom variables in wordpress

I made a wordpress faucet site using some add-ons, and I'd like to do it a little better. I would like to make a reference link, so when it is http://free-liteco.in/?r=Your Address
, I would like the part of Your address to change from user to user, so I would put the user's litecoin address in the profile on the referral link, instead of saying their address. How can I do this?

topic development – How do I create a WordPress demo site with limited administrator access?

I would think that I would have to give the user the ability to create posts / pages and save the customizer settings to get an idea of ​​the subject.

I would like to create a new user role "administrator" that has all the permissions of an administrator, except the creation / deletion of users. This way you can not stay out of your site. Then I would create a function by hooking it into the wp_logout Action hitch to remove all posts / pages, and set the customizer settings to the default, when the user logs off.

Problems installing wordpress – Stack Overflow in Spanish

I have to install wordpress on a server, I uploaded the folder to the server as such and wanted to start the installation, but upon entering this message appeared:

enter the description of the image here

The upload of the files itself, gave me problems, 29 files were not uploaded and I had to upload them manually to each folder that corresponded

Is there anything I can do about it to correct it other than having to upload wordpress again and discard the installation I was doing?

I do not know if it would help to say something but, when trying to enter the browser to the website using the ip of the server to which subi wordpress loads setup-config.php that is in the wp-admin folder

enter the description of the image here

That is the route that charges to be exact …

I would appreciate if you could help me

Alternate button for the sidebar widget for mobile devices and ipad under OCEANWP WordPress

Stack exchange network

The Stack Exchange network consists of 176 question and answer communities that include Stack Overflow, the largest and most reliable online community for developers to learn, share their knowledge and develop their careers.

Visit Stack Exchange

licenses – About the WordPress license

Does the license grant me permission to create a totally new project in a different programming language that implements certain WordPress features, such as the structure of the database or classes such as Wp_Query?

To be clear, I do not want to re-deploy WordPress in a different language. I want to create my own CMS with a new name that implements certain WordPress features, and I mean "it's like WordPress". I can do this?

Thank you

wordpress – Using ACF or Embedded with Elementor

So I am using Elementor to build my WordPress site, and I have installed the ACF plugin that comes integrated.

Everything works fine, except for an ACF that I configured as the & # 39; oEmbed & # 39; I would like to take the output result and insert it in my publications.

Elementor documents state that they support oEmbed (bottom of page):
https://docs.elementor.com/article/381-elementor-integration-with-acf

However, this page lists the widgets that use ACF and which types are compatible, but oEmbed is not mentioned here:
https://docs.elementor.com/article/452-which-widgets-support-acf-and-pods-custom-fields

I wonder if I can use the short code widget, and somehow create a short code that summons the integrated player. Any good link on how to create such a short code?

Thank you

plugins – Mix static and dynamic wordpress sites?

It may seem easy, but is there a good way to mix static-generated wordpress pages through wp2static with dynamic wordpress pages that I can not functionally convert? For example:

WordPress installation
├───index.html
├───site1.html
├───site2_withsearch.php
4.site4.html
├───site5_withcontactform.php

Is this hybrid version in some way possible, because the php functionality is only used with the search and contact form? To accelerate the static pages and return to the slow dynamics?
Thanks for any advice.

Why does not css work when I change my wordpress and sql file to another computer?

HIII, I developed a website using "Elementor" and when I copy the sql file and the wordpress file installed on my disk, I moved these files to another computer, I placed it and ran sql on phpmy admin, the problem is when I run wordpress on my another computer, css does not work. I mean, my design appears in disarray, there are no positions, etc., can you help me?