Slow Image Loading Speeds

alrnetwork

Verified User
Joined
Feb 12, 2021
Messages
75
Location
Europe UTC+2
Oh crap! No I didn't run the 10.2 one first, I scrolled past it by mistake!

Sites are up.

Checking one reveals:


Extensionmysqli
Server version10.4.19-MariaDB
Client versionmysqlnd 7.4.19
 

alrnetwork

Verified User
Joined
Feb 12, 2021
Messages
75
Location
Europe UTC+2
Code:
root@srv1:/usr/local/directadmin/custombuild# mysql_upgrade
Version check failed. Got the following error when calling the 'mysql' command line client
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
FATAL ERROR: Upgrade failed

I also tried mysql -p and typed my root password, but it informed:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
 

bdacus01

Verified User
Joined
Jul 22, 2017
Messages
2,886
Location
Murfreesboro
run
Code:
cat /usr/local/directadmin/scripts/setup.txt
Do not post this output
You are looking for "mysql="
That is the mysql root password
Run this
Code:
mysqlcheck --defaults-extra-file=/usr/local/directadmin/conf/my.cnf --auto-repair -A -u root -p
And use the password in the above file.
 

alrnetwork

Verified User
Joined
Feb 12, 2021
Messages
75
Location
Europe UTC+2
Thanks! That worked.

Output is very large, as there are multiple DBs with many tables, but no errors, all show "OK"

Example:
Code:
da_roundcube.cache                                 OK
da_roundcube.cache_index                           OK
da_roundcube.cache_messages                        OK
da_roundcube.cache_shared                          OK
da_roundcube.cache_thread                          OK
da_roundcube.contactgroupmembers                   OK
da_roundcube.contactgroups                         OK
da_roundcube.contacts                              OK
da_roundcube.dictionary                            OK
da_roundcube.filestore                             OK
da_roundcube.identities                            OK
da_roundcube.searches                              OK
da_roundcube.session                               OK
da_roundcube.system                                OK
da_roundcube.users                                 OK
 

bdacus01

Verified User
Joined
Jul 22, 2017
Messages
2,886
Location
Murfreesboro
Once we get past this we are going to rest. Also check speed on images. If it is about same no worries.

feel free to give me some likes..
 
Last edited:

alrnetwork

Verified User
Joined
Feb 12, 2021
Messages
75
Location
Europe UTC+2
Code:
This installation of MariaDB is already upgraded to 10.4.19-MariaDB, use --force if you still need to run mysql_upgrade
 

bdacus01

Verified User
Joined
Jul 22, 2017
Messages
2,886
Location
Murfreesboro
then do
run
Code:
cat /usr/local/directadmin/scripts/setup.txt
Do not post this output
You are looking for "mysql="
That is the mysql root password
Run this
Code:
mysqlcheck --defaults-extra-file=/usr/local/directadmin/conf/my.cnf --auto-repair -A -u root -p
And use the password in the above file.
again
 

bdacus01

Verified User
Joined
Jul 22, 2017
Messages
2,886
Location
Murfreesboro
ok in the /etc/my.cnf
Code:
nano /etc/my.cnf
Make it look like this. Note: put your server fqdn where it shows "server.domainname.com"
Code:
[mysqld]
#local values
local-infile=0
#skip-name-resolve=1
#log-error=/usr/local/mysql/data/server.domainname.com.err
bind-address = 127.0.0.1
max_allowed_packet=64MB
#max_connections=25
wait_timeout=100

#innodb values
innodb_log_file_size=896MB #25% of Buffer pool
innodb_file_per_table
innodb_buffer_pool_size=7G # 50% of memory
innodb_buffer_pool_instances=7 #1 per GB

#temp values
tmpdir=/tmp
join_buffer_size=256k
table_definition_cache=1000
thread_cache_size=1000

then restart mariaDB with
Code:
systemctl restart mariadb
systemctl status mariadb
OR
systemctl restart mysqld
systemctl status mysqld
 
Last edited:

alrnetwork

Verified User
Joined
Feb 12, 2021
Messages
75
Location
Europe UTC+2
systemctl status mysqld worked.

Code:
root@srv1:/usr/local/directadmin/custombuild# systemctl status mysqld
● mysqld.service - MySQL database server
     Loaded: loaded (/etc/systemd/system/mysqld.service; enabled; vendor preset: enabled)
     Active: active (running) since Thu 2021-06-03 01:05:30 EEST; 2s ago
   Main PID: 514486 (mysqld_safe)
      Tasks: 35 (limit: 19111)
     Memory: 639.9M
     CGroup: /system.slice/mysqld.service
             ├─514486 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/mysqld.pid --socket=/usr/local/mysql/d>
             └─514625 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --log-error=/usr>

Jun 03 01:05:30 srv1.alr-network.co.uk systemd[1]: Started MySQL database server.
Jun 03 01:05:31 srv1.alr-network.co.uk mysqld_safe[514486]: 210603 01:05:31 mysqld_safe Logging to '/usr/local/mysql/data/srv1.alr-network.co.uk.err'.
Jun 03 01:05:31 srv1.alr-network.co.uk mysqld_safe[514486]: 210603 01:05:31 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
 
Top