Add an index to a mysql table
Create an index to a mysql table. Say there is a product_id column: Add to existing table
MySQL
[ERROR] /usr/libexec/mysqld: Sort aborted
Checking the log shows: Check the processlist on a plesk server: Kill the process: Create an index on the table
Upgrade WordPress to 4.1 – The admin backend the connection times out
Upgrade WordPress to 4.1. The admin backend the connection times out and the server gets really slow:error “The server at domain.com is taking too long to respond.” It looks like this is actually a common issue with this version of wordpress. https://wordpress.org/support/topic/multisite-extremely-slow-after-upgrading-to-41 1) Open database via phpMyAdmin 2) Open table “wp_options” and look for “db_version” … Read more
Purge Binary Logs fails on full hard drive
The purge binary command fails – no logs are deleted and the process hangs: Checking the error log: The PURGE BINARY LOGS command requires free space to be able to clear the logs, which is why this command was failing. To be able to run the command please to stop MySQL, zero the first binary … Read more
How to Create a MySQL User: Remove a MySQL User, Show a MySQL User
This article shows how to create a MySQL user, remove a MySQL user and to show a list of MySQL users. Grant all privileges on a database to a single user: Or… Remove a USer from Mysql Review a List of MySQL Users Remove a MySQL User To remove a user from MySQL, we again … Read more
Find Mysql Default Options
To find the my.conf file location use the following command:
Resolving mysql Error “Cannot connect to DB: Too many connections”
There are 2 different limits for MYSQL. Max Connections and Max user connections. By default, the limit is 151 for max connections and 0 or unlimited for user connections. MySQL server has a default limit of 151 simultaneous connections. Most connections to the SQL server run very quickly so even a large amount of queries … Read more
Reset the Mysql password
How to reset the mysql password on a linux server. CentOS First, stop the MySQL service/daemon. On Centos/RHEL you would run: Next, edit the MySQL config file (/etc/my.cnf on CentOS/RHEL) and add the following to the [mysqld] section. Start MySQL back up You will now be able to connect as user root without any password. … Read more
How can I view currently running MySQL queries?
You can use the “show processlist” command to view currently running queries. This is useful if you are looking to see if a query is locking a table, or if you have too many open queries, or for any other number of reasons. On a Linux Plesk server the MySQL password is stored in /etc/psa/.psa.shadow. … Read more