Question : MariaDB 5.5 is installed on CentOS and serves a database in the total volume of around 40GBs (as […]
Tag: centos
SQL Server on CentOS using CAL licensing
Question : I have been running a PoC for a large data science workload with SQL Server on CentOS. I […]
Postgres 10 replica service error on startup
Question : I have migrated a database promoting the read-replica in a server with more capacity, this process worked smoothly. […]
How to dedicate server to MySQL for max performance?
Question : I am using MariaDB 10.5, I see this in MySQLTuner report Dedicate this server to your database for […]
MySQL replication stops everyday for no (obvious) reasons
Question : i’ve got a problem with my MySQL master-slave replication. It works just fine after i start it up […]
Can I copy installed mysql from ubuntu to centos7 directly without installation?
Question : I’m trying to copy an installed MySQL from Ubuntu to Centos7 because I do not want an installation […]
postgresql-setup –initdb with custom data directory
Question : I am trying to setup Postgres 12 on Centos 8. Postgres shall be installed in the default directory […]
Moving datadir OK start, but socket error for mysql client [duplicate]
Question : This question already has answers here: How to define custom path to MySQL socket file? (2 answers) Closed […]
Why is there a big gap in the actual Table space? (calculated vs information_schema vs file size)
Question : I have a InnoDB table with the following columns: BIGINT -> 8 bytes BIGINT -> 8 bytes ENUM(0,1) […]
Server has antivirus. Do I need to enable external locking on MySQL?
Question : From MySQL docs: If you only read tables with other programs, external locking is not required Assuming the […]