How to install Apache, MySQL and PHP on Ubuntu 14.04 Update Apache Install MySQL Install PHP Restart Server Check Apache Open a web browser and navigate to http://IPADDRESS. You should see a message saying It works! Check PHP
# mysql –version mysql Ver 15.1 Distrib 5.5.37-MariaDB, for Linux (x86_64) using readline 5.1 I ran the mysql command on the system – I received the error message shown below: I checked to see if the mysqld service was running and found it was not. When I tried to start the service, it wouldn’t start. … Read more
From MySQL Large Configuration. MySQL Large Original After Optimization Other ideas… mysql optimize innodb_buffer_pool_instances = 2 reduced the number of max connections to 500 (which is still high) syn error adjusting /proc/sys/net/ipv4/tcp_max_syn_backlog nf_conntrack: table full, dropping packet. network and ulimit settings number of connections in time_wait – how to contrl: set both tcp_tw_recycle and lowered tcp_fin_timeout … Read more
Linux Shortcuts Find Plesk Password on older plesk versions. Login via ssh as root and run the following command: Show encrypted admin password: Show Plesk MySQL password Show processlist Export Plesk database Import Plesk database # mysql -u admin -p`cat /etc/psa/.psa.shadow` database < /tmp/database.sql Email Commands [bash] /usr/local/psa/admin/bin/mailqueuemng -s tail -50 /usr/local/psa/var/log/maillog tail -50 /var/log/maillog ... Read more
Login with ssh Login to mysql # mysql -uadmin -p`cat /etc/psa/.psa.shadow` use the mysql db. mysql> use mysql; mysql> SELECT* FROM db; To add same user to another database, you have to insert that user into db table and give him same privileges he already has for his existing database. mysql> INSERT INTO db VALUES(‘localhost’,’second_db’,’same_username_you_used_for_first_db’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’N’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’,’Y’); … Read more
# mysqladmin kill process id
Trying to LOAD DATA with phpmyadmin #1085 – The file ‘/tmp/phpqcXPYv’ must be in the database directory or be readable by all #1148 – The used command is not allowed with this MySQL version /etc/mysql/my.cnf [mysqld] local-infile=0 If this is set to local-infile=1 – and restart mysql – this should work Also – if that … Read more
http://dev.mysql.com/doc/refman/5.0/en/how-to-avoid-table-scan.html http://dev.mysql.com/doc/refman/5.0/en/explain.html http://www.percona.com/blog/2014/03/14/tools-and-tips-for-analysis-of-mysqls-slow-query-log/
There is a nice tool like Percona’s ‘pt-query-digest’ tool at http://www.percona.com/doc/percona-toolkit/2.2/pt-query-digest.html, which will automatically parse the slow_query_log and analyze it for the slowest queries. you run the command pt-query-digest slowquerylog.txt Wich should output a summary and a list of the longest-to-execute queries.