mysqlhacker

MySQL Blocked Becauase of Too Many Connections

admin — Fri, 02 Oct 2009 18:21:45 +0000

This morning we found out that one of our MySQL server is blocking connection for all our Web servers due to too many connections. We solved the problem of too many connections that were coming from the Web server but still MysQL had the Web hosts blocked. To unblock, we had to run the following command [...]

Debugging a MySQL Issue with PHP Using XMP instead of PRE

admin — Fri, 26 Jun 2009 17:30:34 +0000

Recently, I was helping a co-worker debug a MySrQL issue with an old app that started breaking after the dev team switched the app’s textareas to TinyMCE editor. Typically, for quick-and-dirty debugging sessions that we want to wrap in minutes, we use a simple dumpQuery() function in PHP that prints out any query used in [...]

Using mysqladmin for monitoring MySQL server (Part I)

kabir — Wed, 14 Jan 2009 17:08:39 +0000

How to use mysqladmin based shell scripts to monitor your MySQL server

Increasing the Memory Size for Memory Tables

kabir — Mon, 05 Jan 2009 20:36:33 +0000

How to increase maximum memory allocation used for MEMORY tables on MySQL servers

Exporting (dumping) VIEWs Using mysqldump

kabir — Mon, 29 Dec 2008 22:38:26 +0000

How to export views using mysqldump

Understanding MySQL Query Cache for PHP Developers (Part I)

kabir — Sun, 14 Dec 2008 03:02:16 +0000

Understanding MySQL Query Cache for PHP Developers

Using SQL Directives to Control Query Performance

kabir — Sun, 09 Nov 2008 21:47:37 +0000

How to use MySQL directives to enhance your query performance

Using mytop to Interactively Monitor MySQL Processes

kabir — Sat, 08 Nov 2008 20:34:25 +0000

How to use mytop and ajaxMyTop to monitor mysql processes.

Backing Up MySQL Using a BASH Shell Script

kabir — Wed, 05 Nov 2008 16:00:02 +0000

How to automatically backup MySQL database using a Bash script.

Calculating Maximum Connections for MySQL Server

kabir — Sat, 01 Nov 2008 18:00:02 +0000

How to calculate maximum connections for your MySQL server

Beware of MySQL View Filtering in Your PHP Code

kabir — Sat, 01 Nov 2008 02:46:04 +0000

Why MySQL VIEW filtering (i.e. applying WHERE clause) might be a bad for performance.

Using SHOW FULL PROCESSLIST to Debug PHP Query

kabir — Fri, 31 Oct 2008 03:18:17 +0000

How to debug MySQL queries using SHOW FULL PROCESSLIST and a comment trick.

Keeping Your Database “Fresh” Using MERGE Engine

kabir — Thu, 30 Oct 2008 23:19:07 +0000

How to keep MySQL database appear "FRESH AS NEW" every day using MERGE tables

Distributing Your MySQL Database Across Disk Partitions

kabir — Thu, 30 Oct 2008 05:31:58 +0000

How to relocate all your databases, or single database or a single MYISAM table to a different disk partition

Backing Up a Live MySQL Database without Locking it!

kabir — Thu, 30 Oct 2008 03:51:51 +0000

How to backup MySQL database without taking it off-line or locking it

Reclaiming Your InnoDB Tablespace

kabir — Thu, 30 Oct 2008 02:47:42 +0000

How you can reclaim the lost disk space when using InnoDB tables

Automatically Loading MySQL Memory Tables on MySQL Startup or Reboot

kabir — Wed, 29 Oct 2008 04:16:04 +0000

How to load MySQL memory tables at MySQL server startup or reboot cycle

Speeding Up ZenCart with MySQL Memory Tables

kabir — Wed, 29 Oct 2008 03:43:07 +0000

How to speed up zencart using MySQL memory tables.

Understanding Useful Table Engine Types

kabir — Tue, 28 Oct 2008 19:45:05 +0000

Quick look at various MySQL table engines.