How to set and enable MariaDB slow query log
Posted on in Categories BASH Shell, CentOS, Debian / Ubuntu, FreeBSD, Linux, MySQL, RedHat and Friends, Suse, UNIX last updated March 29, 2017
Tag: /etc/my.cnf
MySQL: Connect From an Other System / Computer
Posted on in Categories MySQL, RedHat and Friends last updated April 18, 2011
How do I connect to my MySQL database server from an other server (say Apache or Tomcat app server) in same VLAN under CentOS / Fedora / RHEL / Redhat Linux?
MySQL: Set Cache Size
Posted on in Categories MySQL last updated April 16, 2010How do I set query cache under MySQL running under UNIX / Linux / BSD or Windows operating systems?
Where Are MySQL Files Stored in UNIX / Linux
Posted on in Categories MySQL last updated February 25, 2010Where are my mysql database and table files are stored in UNIX or Linux operating systems?
MySQL Bin Files Eating Lots of Disk Space
Posted on in Categories CentOS, Debian / Ubuntu, File system, Linux, MySQL, Storage, Ubuntu Linux, UNIX last updated December 18, 2008Q. I get a large amount of bin files in the MySQL data directory called “server-bin.n” or mysql-bin.00000n, where n is a number that increments. What is MySQL Binary Log? How do I stop these files being created?
MySQL: Change Default Port Under Linux / UNIX
Posted on in Categories CentOS, Debian / Ubuntu, Linux, MySQL, Networking, RedHat and Friends, Solaris-Unix, Suse, Ubuntu Linux, UNIX last updated August 26, 2008Q.I’m using MySQL 5 under Red Hat Enterprise Linux 5. How do I change default mysql server port (tcp port 3306) under Linux or UNIX operating systems?