Some hand commands if you need to improve some SQL Queries: analyze query: explain select .. from TABLE; show index: show index from TABLE; analyze table: analyze table TABLE; sql query without cache: select SQL_NO_CACHE .. from TABLE; show mysql cache status: SHOW VARIABLES LIKE 'query_cache%'; Read More

MySQL dB Optimize Cheat Sheet

SSH, Debian sarge and MySQL 5">

I wanted to connect my MySql server via SSH from remote, but every time I tried to connect, i received this error message: "ERROR 2013 (HY000): Lost connection to MySQL server during query" (MySQL Admin) or this error via JDBC: [cc lang="bash" ...Read More

SSH, Debian sarge and MySQL 5

To repair a MySQL table, here are some VERY BASIC steps: 1.) Start admin tool: # mysql -u root 2.) Connect to db # connect DBNAME 3.) Repair it and cross fingers # repair table TABLENAME Ofcourse you need to replace the DBNAME and TABLENAME with you ...Read More

MySQL, repair table (very basic description..)