Tips for speeding up dump and import data in MySQL
Importing large SQL datasets into MySQL can take a long time. These tips speed it up by adjusting indexes, inserts, autocommit, and constraint checks.
THE KNOWLEDGE BASE
All articles.
392 notes on Linux, tools and troubleshooting
How to fix yum error: database disk image is malformed
If yum reports "Error: database disk image is malformed" while installing or updating packages, as shown below: [[email protected] ~]# yum install ruby Loaded plugin
Check MySQL database size using SQL query
SQL queries to check space used by MySQL databases and tables. Check size of all database: run the query below to check each database's size. SELECT TABLE_SCHEMA
How to fix "Service unavailable from cause of too many queries to uribl.com"
If Zimbra cannot receive email while sending works normally, check the log for a message like this: zimbramail postfix/smtpd[xxx]: NOQUEUE: reject: RCPT from mailx.ezylin
Enable SFTP logging transfer
SFTP, installed with OpenSSH, does not normally log activity. To log access and file changes, configure its Subsystem settings.
Find out which processes are using swap space
A script to identify processes using SWAP on a server. It displays process details and the amount of swap space each process uses. #!/bin/bash # Get current swap usage for all
How to resolve yum error [Errno 14] PYCURL ERROR 6 - "Couldn't resolve host"
After installing CentOS, yum installs or updates may fail with "[Errno 14] PYCURL ERROR 6 - "Couldn't resolve host"", as in the example below: http://mirrors.psu.ac.th/pub
How to fix error: 97: Address family not supported by protocol on Zimbra
When starting the zimbra service, you may encounter the error message below: Starting nginx...nginx: [emerg] socket() [::]:7143 failed (97: Address family not supported by protocol) failed. Starting mta...Faile
How to fix "wget: unable to resolve host address" issue
If wget reports unable to resolve host address, first test network connectivity, then check whether wget is trying IPv6 on a machine without IPv6 access.