Posts Tagged ‘ MySQL ’

MySQL Quick Reference

  • July 1st, 2011
  • Posted in MySQL

Lots of this was taken from here: http://www.pantz.org/software/mysql/mysqlcommands.html Figured since I referenced it so much … Show replication slave status. mysql> show slave status; Show process list. mysql> show processlist; (show full proccesslist;) Show variables. mysql> show variables like ‘%collation%’; To login (from unix shell) use -h only if needed. # [mysql dir]/bin/mysql -h hostname -u [ READ MORE ]

MySQL accepts network connections

Make sure skip-networking is commented out in my.cnf file. Test with: netstat -antulp | grep LISTEN tcp 0 0 127.0.0.1:199 0.0.0.0:* LISTEN 2297/snmpd tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 4485/mysqld tcp 0 0 :::22 :::* LISTEN 2334/sshd The mysqld entry will not be listed if MySQL is not accepting network connections[ READ MORE ]

MySQL Replication

  • September 27th, 2010
  • Posted in MySQL

The steps I followed to get a MySQL server and one MySQL slave setup were taken from here: http://onlamp.com/pub/a/onlamp/2005/06/16/MySQLian.html Live backups of MySQL using Replication Here’s how to setup a replication slave to ensure reliable backups without having to shutdown the server. Typically, replication is a system configuration whereby the MySQL server, known in this [ READ MORE ]

Overcoming MySQL’s 4GB Limit

Information taken from here: http://jeremy.zawodny.com/blog/archives/000796.html Another useful link: http://dev.mysql.com/doc/refman/5.0/en/full-table.html When this happens, the first reaction I hear is “You never told me that MySQL has a 4GB limit! What am I going to do?” Amusingly, I usually do describe the limit when I discuss the possibility of using MySQL with various groups–they often forget or [ READ MORE ]

MySQL and JOINs

  • September 7th, 2010
  • Posted in MySQL

There is a great write up about the differences between JOINs in MySQL here: http://www.wellho.net/mouth/158_MySQL-LEFT-JOIN-and-RIGHT-JOIN-INNER-JOIN-and-OUTER-JOIN.html Basically, a JOIN only returns records that match. A LEFT JOIN will returns all rows that match and IN ADDITION all rows in the left table that do not match as well. A RIGHT JOIN is similar to left except [ READ MORE ]

Follow

Get every new post delivered to your Inbox.