WordPress problem with a lot of posts

  • ignaziot

    (@ignaziot)


    6 years, 1 month ago

    Hello, i have a little problem.
    I have a wordpress blog with about 600.000 posts. The problem is that becomed not usable because very, very low.

    I have a cloud computer with 50 gb of ram, 10 processors, ssd hardisk.

    I have apache and mysql community, i increased the memory in wordpress settings and php. I increased the number of max connections, i added key when is possible to all column. I also edited my mysql configuration like this:

    [mysqld]
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
datadir		= /var/lib/mysql
log-error	= /var/log/mysql/error.log
bind-address	= 127.0.0.1
symbolic-links=0
federated
skip-name-resolve
log-warnings=2
default-storage-engine         = InnoDB
# SAFETY #
max-allowed-packet             = 2560M
max-connect-errors             = 1000000
# MyISAM #
key-buffer-size = 1G
# CACHES AND LIMITS #
tmp-table-size                 = 12048M
max-heap-table-size            = 12048M
max-connections                = 1500
thread-cache-size              = 500
open-files-limit               = 65535
table-definition-cache         = 81920
table-open-cache               = 81920
sort_buffer_size = 1000M
read_rnd_buffer_size = 1000M
query_cache_size=0
thread_stack = 4294967295
innodb-flush-method            = O_DIRECT
innodb-log-files-in-group      = 2
innodb-log-file-size           = 10G
innodb-flush-log-at-trx-commit = 1
innodb-file-per-table          = 1
innodb-buffer-pool-size        = 42G
innodb_buffer_pool_instances = 84
innodb_log_buffer_size=32M
innodb_thread_concurrency = 20
sql_mode=ONLY_FULL_GROUP_BY,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
long_query_time = 1
slow_query_log = 'ON'

    You can tell me, change your hardware is not enought but when i check, my processors are almost always at a minimum and the maximum ram consumption is limited to 22 gigabytes. In addition I also checked the use of hardisk with iotop and it does not seem that there is a particularly expensive consumption.

    Someone with enough skill to help me, would be so kind to spend two minutes of his time to express an opinion about it?

    Ps: the problem that is very slow occurs even in the absence of users and from the logs I do not see attempts to attack. I also use cloudflare.

  • The topic ‘WordPress problem with a lot of posts’ is closed to new replies.