If you get this MySQL error while you alter a table: ERROR 1114 (HY000): The table ‘site’ is fullage doneERROR 1114 (HY000): The table ‘site’ is fullage done Make sure the partition is not full. Type this command to see the partition status: df -hdf -h
With MariaDB there is a file that contains user\pass for MySQL autologin: /etc/mysql/debian.cnf/etc/mysql/debian.cnf Here is an example output of /etc/mysql/debian.cnf: # Automatically generated for Debian scripts. DO NOT TOUCH! [client] host = localhost user = debian-sys-maint password = randomstring socket = /var/run/mysqld/mysqld.sock [mysql_upgrade] host = localhost user = debian-sys-maint password = randomstring socket = /var/run/mysqld/mysqld.sock […]
Edit /etc/mysql/my.cnf as follow: [mysqld] skip-name-resolve[mysqld] skip-name-resolve Then restart mysql service: /etc/init.d/mysql restart/etc/init.d/mysql restart
Here is an example of PHP MySQLi persistent connection: $mysqli = new mysqli("p:123.123.123.123", "user123", "123", "testdb1");$mysqli = new mysqli("p:123.123.123.123", "user123", "123", "testdb1"); Do not use “localhost” as host.
To make sure MySQL uses all available server RAM: 1) Edit /etc/mysql/my.cnf 2) Increase innodb buffer pool size to 85% of RAM Example, if you have 64GB RAM: innodb_buffer_pool_size = 55Ginnodb_buffer_pool_size = 55G So InnoDB will load as much data it can in the buffer pool. 3) Increase the max connections: This is good for […]
If you get this error message on your PHP script: Warning: mysqli::real_connect(): (HY000/2002): Cannot assign requested address in …Warning: mysqli::real_connect(): (HY000/2002): Cannot assign requested address in … Make sure to use a persistent connection “p:”: $mysqli = new mysqli("p:10.1.1.1", "user", "pass", "db");$mysqli = new mysqli("p:10.1.1.1", "user", "pass", "db");
Use DISTINCT() to select only unique values from a MySQL column: SELECT DISTINCT(Email) AS Email FROM Users ORDER BY Email DESC;SELECT DISTINCT(Email) AS Email FROM Users ORDER BY Email DESC;
If you get this error in /var/log/syslog: mysqld[611]: 2017-01-21 11:03:14 12313188453123 [Warning] Aborted connection 12351011 to db: ‘clients’ user: ‘username’ host: ‘localhost’ (Got timeout reading communication packets)mysqld[611]: 2017-01-21 11:03:14 12313188453123 [Warning] Aborted connection 12351011 to db: ‘clients’ user: ‘username’ host: ‘localhost’ (Got timeout reading communication packets) Then there is a problem with the MySQL timeouts. […]
Edit /etc/mysql/my.cnf as follow: [mysqld] max_allowed_packet = 1024M[mysqld] max_allowed_packet = 1024M Restart MySQL server: /etc/init.d/mysql restart/etc/init.d/mysql restart
Edit /etc/mysql/my.cnf as follow: [mysqld] max_allowed_packet = 1024M connect_timeout = 300 wait_timeout = 300[mysqld] max_allowed_packet = 1024M connect_timeout = 300 wait_timeout = 300 More “unpopular” timeouts: net_write_timeout = 300 interactive_timeout = 300 net_buffer_length = 512M net_read_timeout = 300net_write_timeout = 300 interactive_timeout = 300 net_buffer_length = 512M net_read_timeout = 300 Restart MySQL server: /etc/init.d/mysql restart/etc/init.d/mysql restart