To Get Data Base Size in MB and Free Space in MBSELECT table_schema “dbName”, sum( data_length + index_length ) / 1024 / 1024 “Data Base Size in MB”, sum( data_free )/ 1024 / 1024 “Free Space in MB”FROM information_schema.TABLESGROUP BY table_schema ; To Get Size in GB: SELECT sum(round(((data_length + index_length) / 1024 […]
UTF-8 is a multibyte encoding that can represent any Unicode character. ISO 8859-1 is a single-byte encoding that can represent the first 256 Unicode characters. Both encode ASCII exactly the same way. ISO-8859-1 vs UTF-8 ISO-8859-1 is a legacy standard from back in the 1980s. It can only represent 256 characters so only suitable for […]
Restart, Start, Stop MySQL from the Command Line Terminal, OSX, Linux To restart, start or stop MySQL server from the command line, do the following at the shell prompt… Start Stop Restart Mysql Commands Start Mysql on Linux — /etc/init.d/mysqld start Stop Mysql on Linux — /etc/init.d/mysqld stop Restart Mysql on Linux — /etc/init.d/mysqld restart […]
