Database – Can anyone help fix this slow query in WordPress?

I used the Query Monitor plugin to find slow queries on my WordPress site. The below mentioned WP_Query-> get_posts () takes about .3646 polling time of the entire database polling time of .3976.

SELECT wp_posts.ID
FROM wp_posts
LEFT JOIN wp_term_relationships
ON (wp_posts.ID = wp_term_relationships.object_id)
WO 1 = 1
AND wp_posts.ID NOT IN (203598)
AND (wp_term_relationships.term_taxonomy_id IN (17)
OR wp_term_relationships.term_taxonomy_id IN (11652,20693,21952,23971,24907,24908,25928))
AND wp_posts.post_type = & # 39; post & # 39;
AND ((wp_posts.post_status = & # 39; publish & # 39;))
GROUP BY wp_posts.ID
ORDER TO wp_posts.post_date DESC
LIMIT 0, 6

I suspect it has something to do with the over 20,000 tags used in posts on my site. Is that so? If so, how do you suggest correcting this slow query? Or how do I go about deleting tags that are not used in more than 5 posts of all posts on the site?

Please help.

boot – 18.4 slow boot

I have freshly installed and it boots very slowly.

Hardware configuration:

Core i5 7th generation
Hard drive 200 GB 

Issue of systemd analysis time :

Startup ended in 14.337s (firmware) + 3.534s (loader) + 4.867s (kernel) + 1min 7.184s (user space) = 1min 29.923s reaches 4,264s in user space after 1min

And the issue of systemd analysis blame

    33.177s dev-sda2.device
31.575s systemd-journal-flush.service
23.691s systemd-udevd.service
22.251s systemd-sysctl.service
20.026s plymouth-quit-wait.service
17,986s snap-gnome  x2dsystem  x2dmonitor-87.mount
16,667s snap-gnome  x2dcharacters-284.mount
11.096s mysql.service
8,533s keyboard-setup.service
7.825s NetworkManager-wait-online.service
7.753s snapd.service
5,276s bolting service
4,942s systemd-modules-load.service
4.705s thermald.service
4.545s udisks2.service
4.408s NetworkManager.service
4.307s plymouth-start.service
3,934s networkd-dispatcher.service
3,297s ModemManager.service
3.147s accounts-daemon.service
3.041s systemd-tmpfiles-setup-dev.service
2.767s php7.1-fpm.service
2.615s grub-common.service
2.389s wpa_supplicant.service
2.279s fwupd.service
2.217s systemd-random-seed.service
2,198s apache2.service
1.959s avahi-daemon.service
1.105s rsyslog.service
982ms apparmor.service
911ms dev-loop18.device
867ms gdm.service
860ms systemd-remount-fs.service
830ms networking.service

Is there a way to fix the problem?

grub2 – SLOW BOAT IN UBUNTU 18.04.02

I have just installed Ubuntu 18.04.02. It turns out that it boots too slowly. I do not even have windows in dual boot with Ubuntull.
My laptop specifications are

  1. Intel Core i5-8250U 8th generation
  2. NVIDIA GEFORCE MX150 (2G GDDR5) graphics
  3. 1TB hard drive
  4. RAM 8 GB

When I ran

systemd analysis time

the edition that gave it to me was

Start ended in 3.786s (firmware) + 4.374s (loader) + 3.871s (kernel) + 48.681s (user space) = 1min 712ms reaches 44,742s in user space

when I ran

 systemd analysis blame

the edition that gave it to me was

28.056s systemd-journal-flush.service
25.155s dev-sda2.device
20.898s systemd-udevd.service
15.232s snap-core18-970.mount
10.658s plymouth-quit-wait.service
5.158s keyboard-setup.service
5.071s tie service
3.076s udisks2.service
3.008s snapd.service
2,772s networkd-dispatcher.service
2,754s NetworkManager.service
2.650s ModemManager.service
2.646s accounts-daemon.service
2.561s grub-common.service
2.420s avahi-daemon.service
2.410s wpa_supplicant.service
2.408s rng-tools.service
2.406s gpu-manager.service
2.405s preload service
1.358s dev-loop0.device
1,185s apport-autoreport.service
1.109s systemd-backlight @ backlight: intel_backlight.service
1.026s snap-gnome  x2dsystem  x2dmonitor-57.mount
962ms snap-evince-95.mount
925ms dev-loop1.device
924ms dev-loop2.device
918ms dev-loop3.device
889 ms systemd-fsck @dev-disk-by  x2duuid-7CB3  x2d3F04.service
879ms dev-loop5.device
877ms dev-loop8.device
854ms dev-loop7.device
706ms systemd-remount-fs.service
671 ms systemd-sysctl.service
658 ms sys-kernel-debug.mount
657ms systemd-module-load.service
657ms dev-hugepages.mount
653ms dev-mqueue.mount
640ms dev-loop6.device
616ms gdm.service
591ms rsyslog.service
525ms tlp.service
486ms of upward power
431ms equipment service
418ms kmod-static-node.service
370 ms systemd-tmpfiles-setup.service
350ms dev-loop4.device
344ms plymouth-start.service
333 ms systemd-tmpfiles-setup-dev.service
324ms thermald.service
317ms networking.service
309ms systemd-logind.service
304ms systemd-journald.service
271ms apport.service
266 ms snap-gnome  x2dlogs-45.mount
266ms swapfile.swap
261ms systemd-resolved.service
247ms systemd-random-seed.service
246ms console-setup.service
240ms polkit.service
237ms nvidia-persisted.service
186 ms boot-efi.mount
179ms systemd-localed.service
156 ms user@121.service
136ms systemd-udev-trigger.service
134 ms plymouth-read-write.service
108 ms user@1000.service

when I ran system analysis

systemd analysis critical chain

it gave me the edition

The time after activating or starting the device is printed after the "@" mark.
The time required for the device to start is printed after the "+" sign. @ 44.742s
└─ @ 44.742s
└─snapd.seed.service @ 34.346s + 9ms
    └─snapd.service @ 31.336s + 3.008s
      └─ @ 31.297s
└─ @ 31.297s
└─snapd.socket @ 31.296s + 542us
            └─ @ 31.213s
└─systemd-update-utmp.service @ 31.113s + 99ms
                └─systemd-tmpfiles-setup.service @ 30.742s + 370ms
                  └─systemd-journal-flush.service @ 2.685s + 28.056s
                    └─systemd-remount-fs.service @ 1.978s + 706ms
                      └─systemd-journald.socket @ 1.974s
└─system.slice @ 1.973s
└─-.slice @ 1,963s

Does anyone know how to solve my problem?
Please help me.

Networking – Extremely slow WiFi speeds on Lubuntu 19.04?

Recently re-installed Lubuntu 19.04 on a new SSD because the old one failed. However, with the updated versions of Lubuntu I get extremely slow WiFi speeds. This was not a problem with the previous installation of 17.10. After some research, I found on 18:04 several posts to Intel Wi-Fi adapters. However, my lspci-sourced chipset is a Ralink RT5392 chipset, so solutions to Intel adapters did not help. Checking the normal Internet speed on other computers in the house is only possible on Lubuntu computers. Any suggestions?

EDIT: and now it seems unreliable to show the networks as available, sometimes the network icon disappears and needs to be restarted etc. Strange, because it's a fresh install a few hours ago with a new image from today.

Internal memory – Samsung Galaxy S6 4.6 MB / s sequential write access (Why slow?)

I bought a Samsung Galaxy S6 in August 2016. Everything was fine until last week.
It has very sluggishly. For example, if I draw my unlock pattern after a reboot, it will take a while to load the boot screen until the screen turns off. I get in after a few tries, but each tap takes a long time to respond. Loading the keyboard takes about 25 seconds.

I downloaded System Monitor, but the CPU usage was not 100%, so there is no app / virus that consumes too much CPU time.
According to Geekbench 4, the CPU / GPU performance for the Galaxy S6 is even above average.

But then I decided to test the memory speed. I ran Androbench and the results are very bad (see screenshot).
Screenshot of Androbench

Normally, the performance should conform to this test.

My questions are: How can I find out why storage is so slow?
Is it just Flash Wear? Is a driver broken? Which part should I replace if it is a hardware error?

If something is unclear, just comment it and I'll work on the question.
Thank you in advance!

Java – Practical implementation of slow lossless compression

I can compress any file (text, image, random data, video, audio) with a size of 120 KB to 80 KB lossless, which corresponds to a lossless reduction of more than 30%. So far the program is very slow, as it takes 10 minutes to shrink files of this size. Although it can be improved to be fast, hopefully to microseconds, if not to nanoseconds.

That means with my program we can compress every 1 GB file lossless to 666 MB.

  1. Divide a 1GB file into 120K
  2. We have 8333 files
  3. Compress any file with my program
  4. Each file would be at most 80 KB in size
  5. 80 KB * 8333 files = 666.7 MB

I did not really test a 1 GB file as this would be impractical (10 minutes * 8333 files = 1,388 days).

  1. Would it be really practical in the real world if it were improved?

  2. Is there a method, a program, an algorithm that can do the same thing? Because I've read about information theory that says it's impossible to compress files lossless (I think my program was not finished when they published the article)

mobile data – S7 slow practically useless at the app level

I know that this is a common complaint, but I have reviewed the forums and can not find a solution to this very specific problem. Symptoms: Since my return from abroad 2 months ago my S7 hardly receives data from the mobile network at the app level, e.g. I was just trying to load Google News, and it took about 20 seconds. The next two attempts ran out.

Strange thing is, if I activate the hotspot and connect a tablet or a laptop, the same page is loaded immediately. Therefore, antannae obv. Alright, data transfer test from the laptop to the hotspot are as follows:

Enter image description here

However, I can not even run this test directly on the phone.
With WLAN it behaves much better, without the data transfer is noticeably slower.

What I have tried:

  • Uninstall all games, unnecessary apps from my kids, etc.

  • clear cache

  • Use a cache cleanup app

  • Factory settings reset

  • Hard reset

  • Delete the APN settings and drag again

None of the above statements has any effect. These days, I've decided to hotspot my 7-inch tablet instead of using the phone directly.

Can someone please free me from my misery – I'm just about to throw this thing together.

php – The first loading of the page is VERY SLOW (not related to the cache)

Before I move on, let me just mention that I can search for solutions everywhere, try many different configurations, and not solve the problem.

I have installed WordPress (on 3 different servers for testing) on ​​Ubuntu 18.04 with Nginx, PHP 7.2 and MySQL.

After about 20-30 minutes of idle (no requests to the server) it takes about 30-40 seconds for the site to load. After this initial loading, everything works fine (I've disabled caching), whether you're logging in from another computer.

I just want to mention that this is a clean WordPress installation.

I tried to play with the Nginx configuration file, but I've found that requesting HTML files (without PHP) works fine. So, I decided that it was somehow PHP and I tried to change the configuration file, which leads to the same behavior.

I am sure that I miss something here and hope that you can help me to solve this problem.

Tell me if you need more information.