mytop & mysql: queries per second
GID asked: On a MySQL 5.5.62 server, with InnoDB tables, I run mytop, and in the "qps now" field it reports something like 40-70. The historical qps is about 60. …
Improving Performance of my SQL Database
plattnat asked: Using mysqltuner i’m a bit worried at the maximum of memory sql seems to want to be able take… I just want to tune SQL to run better …
MySQL 8.0 Installation on Unbuntu 20.04 authentication_string Message
lee03 asked: i followed several tutorials to install MySQL 8.0 on Ubuntu 20.04. Everything works with no errors reported in the mysql log. The question i have is that when …
How to skip-name-resolve in Mysql8 and use IPs instead?
Houman asked: I’m trying to disable the DNS name resolving as I have many other servers connecting to the central database. The DNS resolving is slow and can apparently be …
MySQL installation on centOS fails – dependency issues
TechniCollins asked: I tried to install mysql on centOS following this digital ocean guide. I ran the following commands; wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm md5sum mysql80-community-release-el7-3.noarch.rpm sudo rpm -ivh mysql80-community-release-el7-3.noarch.rpm sudo yum install …
SELinux Permissions Error on Fedora 32
navjotjsingh asked: I am getting this error repeatedly while trying to run Nextcloud on Fedora 32 type=AVC msg=audit(1601229230.944:718): avc: denied { connectto } for pid=584 comm="php-fpm" path="/var/lib/mysql/mysql.sock" scontext=system_u:system_r:httpd_t:s0 tcontext=system_u:system_r:unconfined_service_t:s0 tclass=unix_stream_socket …
Best practice on where to store my.cnf configuration with MariaDB
Tristan asked: After a small update ran by an Ansible playbook from MariaDB 10.5.4 to MariaDB 10.5.5, the custom configuration file got silently overriden by the default configuration causing the …
'myname'@'%' can access to mysql server remotely but not with 'myname'@'123.456.489.%'
Herbert asked: I am working on accessing to mysql server remotely. My home pc to pc at the office. I can access with ‘myname’@’%’. but I can’t with ‘myname’@’123.456.489.%’. ‘123.456.489.012’(redacted) …
Postfix SSL USING SNI
Bc96 asked: I What to give assign multiple SSL cert to Multiple Domains I have manage to do so : by creating a single wild card SSL cert (e.g mail.example.com …
Mysql packages skipped [dependency problems]
Matthew asked: This may look like a repeat question, but I have done my research and still am unable to find a solution to this problem. The problem: When installing …