Lisa Smith

Senior MySQL Database Engineer

Lisa works closely with multiple clients to provide professional MySQL services ranging from design and implementation of InnoDB Cluster to basic health check and performance optimization. Lisa holds MySQL 5.6 Database Administrator certification and worked with XTIVIA's MySQL Team to achieve Oracle Gold Partner status for specialization in MySQL 5.

MySQL Error – Too Many Connections

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 used by... read more

MySQL Replication: Disconnecting a Replica

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... read more

MySQL Error – Packet Too Large

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... read more

The MySQL InnoDB Buffer Pool

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... read more