MySQL

ยปTag:MySQL

Display Full SQL Query in Show Processlist of MySQL

In MySQL database system, by default the SHOW PROCESSLIST query displays only first 100 characters of the running SQL query or SQL statement in the Info column. The limited and trimmed length of SQL statement may prevent [...]

By | July 15th, 2015|Categories: Databases|Tags: , , |0 Comments

Upgrade MySQL to MariaDB 10 (Part 2 – Upgrade MariaDB/MySQL 5.5 to Version 10.0)

MariaDB is a relational database management system (rDBMS) that was forked from MySQL, the de-facto database for most popular open-source web platform and apps. MariaDB is intended as the enhanced drop-in replacement for MySQL, so that developers [...]

By | January 27th, 2015|Categories: Databases|Tags: , |1 Comment

Upgrade MySQL to MariaDB 10 (Part 1 – Install MariaDB 5.5)

MariaDB is a relational database management system (rDBMS) that was forked from MySQL, the de-facto database for most popular open-source web platform and apps. MariaDB is intended as the enhanced drop-in replacement for MySQL, so that developers [...]

By | January 27th, 2015|Categories: Databases|Tags: , |0 Comments

Virtualmin: You Do Not Have Access to This MySQL Database After Changing Password

After changing password of MySQL or MariaDB administration user, such as root, Virtualmin no longer has access to the database of the virtual servers. When attempting to manage database of a virtual server via "Edit Databases," Virtualmin [...]

By | January 9th, 2015|Categories: Databases|Tags: , , , |0 Comments

How to Read MySQL Binary Log Files (BinLog) with mysqlbinlog

MySQL database server generates binary log files for every transaction to the databases, provided administrator does not disable or comment out the "log-bin" parameter in my.cny configuration file. The binary log files are written in binary format. [...]

By | October 6th, 2007|Categories: Databases|Tags: , |9 Comments

Using PHP-MySQL Persistent Connections to Run WordPress Blog

When connecting to MySQL database, WordPress weblog based on PHP scripting will use non-persistent connection by default. That is, WordPress will trigger PHP to generate a new connection to MySQL server for each dynamic page request, and [...]

By | September 14th, 2007|Categories: Web Publishing|Tags: , , , |7 Comments

Pin It on Pinterest