Category: MySQL
When optimizing MySQL performance, tailoring the configuration to the server’s available memory is critical. Two scripts—one in Python and the other in Bash—offer automated solutions to calculate recommended MySQL …
SQL is the language to interact with databases, so we need to make them as fast as possible as the Database Operations may usually be expensive. Use indexes Indices …
MySQL MyISAM database engine has been depreciated in the latest version since 5.5.1. The MyISAM is table locking while InnoDB (now the default database engine for MySQL since 5.5.1) …
The MySQL table has a command Show Table Status which prints a table summary, but it contains lots of information about all tables in the current database (to change …
November 13, 2014
apache server, database, DevOps, FTP, linux, mysql, MySQL, security, SSH, Ubuntu, ubuntu, Virtual Private Server, webhosting
In this post, we know how important the security is. If you manage your server (VPS, cloud hosting or dedicated server), then you must have root access. The root …
