by XTIVIA | Feb 15, 2017 | Blog, MySQL
MySQL has is a maximum number of concurrent connections permitted to access the database, defined by the max_connections variable. The default value for max_connections is 151, and if the error Too Many Connections occurs, it means all connections are being...
by XTIVIA | Feb 14, 2017 | Blog, MySQL
When a MySQL replica instance is no longer to be associated with a primary database instance in a replication design, the replica not only needs to be stopped, but the connection information pointing to the primary must be cleared as well. In older versions of MySQL...
by XTIVIA | Feb 9, 2017 | Blog, MySQL
A MySQL error commonly encountered is to have “packet too large” reported and it is often coupled with a “lost connection to MySQL server during query” error as the server closes the connection. The errors occur when a MySQL communication...
by XTIVIA | Feb 8, 2017 | Blog, MySQL
The MySQL InnoDB storage engine is used by default in all newer versions of MySQL (5.5.5+). As a well-performing transactional storage engine with crash recovery capability, it is the storage engine of choice for most database settings. One of the most important...
by XTIVIA | Jan 11, 2017 | Blog, Db2
What is db2prereqcheck? db2prereqcheck is a tool IBM provides to check for all OS and software prerequisites prior to and during the installation of Db2. It is included with every fixpack and base code that Db2 provides. When to use db2preqcheck Use db2prereqcheck...
by XTIVIA | Jan 6, 2017 | Blog, Informix
Online Defragmentation Do you have large tables that contain too many extents but haven’t been able to schedule a maintenance window to reorganize? With the release of Informix 11.70, IBM introduced a new defragmentation utility that lets you reorganize a table...
