MySQL tagged articles

MySQL is the world’s second most widely used relational database management system (RDBMS) and most widely used open-source RDBMS.

MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack (and other ‘AMP’ stacks). LAMP is an acronym for “Linux, Apache, MySQL, Perl/PHP/Python.”

Applications which use MySQL databases include: TYPO3, MODx, Joomla, WordPress, phpBB, MyBB, Drupal and others.

Igor Moiseev Applied mathematician, Web Developer

Learning NoSQL, PHP and Linux 10 Apr 2015

Find all tables without primary key in MySQL 17 Feb 2015 Query that helps to find tables without primary key, simple and efficient way to find performance bottlenecks

Speedup MySQL with tmpfs 23 Jan 2015 Speeding up of the temporary table creation by putting the temp dir in RAM

Encoding hell, grep and iconv salvage! 16 Dec 2014 Howto extract records from dump, when database encoding is different to one set on the connection

Find all tables without primary key in MySQL 17 Feb 2015
Query that helps to find tables without primary key, simple and efficient way to find performance bottlenecks

Speedup MySQL with tmpfs 23 Jan 2015
Speeding up of the temporary table creation by putting the temp dir in RAM

Encoding hell, grep and iconv salvage! 16 Dec 2014
Howto extract records from dump, when database encoding is different to one set on the connection