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.

Using the Mysqlbinlog Utility

MySQL binary logging is used for replication and also for point-in-time recovery of a MySQL database instance. It records any changes to database contents and may be recorded in a “statement-based” or “row-based” format. The default location to... read more

MySQL Max Connect Errors

When connection requests to a MySQL database from a given host are interrupted, MySQL keeps track of the number of successive interruptions in the host cache. MySQL will eventually block the host, giving them a message [1129] “Host ‘host_name’ is... read more

MySQL Error 1227 “Access denied; you need (at least one of) the SUPER privilege(s) for this operation”

Here at XTIVIA we have provided professional services many times to clients running into errors while restoring a MySQL database from a backup created with mysqldump. One specific error on import of a backup, Error 1227, reports “Access denied; you need (at... read more

ERROR 1114 – The table is full

At XTIVIA, we have encountered the MySQL Error 1114, “table is full” on quite a few occasions. The description for the error is usually misleading as it implies that a table has reached or exceeded a maximum set limitation. Tables utilizing the InnoDB... read more

Analyzing and Optimizing the MySQL InnoDB Log Buffer and InnoDB Redo Log

When changes are made to InnoDB tables in MySQL, the changes are first stored in memory in the InnoDB log buffer, then written to the InnoDB log files which are often referred to as the redo logs. The innodb_log_buffer_size variable may be adjusted to optimize... read more

MySQL Error-Too Many Open Files

Learn with XTIVIA how to address the common MySQL Error, “Too many open files.” If you encounter the error where MySQL reports “Can’t open file: (errno: 24)”, analyze a few variables. The error usually occurs when the maximum number of... read more