Technical Blog

Calculate table size and index size in Mysql mysql> SELECT table_name, `engine` ,ROUND ( data_length/ 1024 / 1024 , 2 ) total_size_mb, ROUND ( index_length/ 1024 / 1024 , 2 ) total_index_size_mb, table_rows FROM information_schema. TABLES WHERE table_schema = 'SalesDB' ORDER BY 3 ; SalesDB -- Database name total_size_mb -- Total size in MB query result table_name engine total_size_mb total_index_size_mb table_rows Customers InnoDB 0.45 0.11 1257 Invoices InnoDB 1.73 1.21 12785

Enabling the MySQL Event Scheduler After installation, be sure to enable the scheduler(new mysql installations have it off by default) to check status: Code: SELECT @@event_scheduler; to enable: Code: SET GLOBAL event_scheduler = 1; Execute mysql stored procedure call UpdateSales 'UpdateSales' <-- stored procedure name

http://www.dq.winsila.com/security/create-a-password-protected-folder-without-any-special-software.html

16.1. MySQL Cluster Overview MySQL Cluster is a technology that enables clustering of in-memory databases in a shared-nothing system. The shared-nothing architecture enables the system to work with very inexpensive hardware, and with a minimum of specific requirements for hardware or software. MySQL Cluster is designed not to have any single point of failure. In a shared-nothing system, each component is expected to have its own memory and disk, and the use of shared storage mechanisms such as network shares, network file systems, and SANs is not recommended or supported. MySQL Cluster integrates the standard MySQL server with an in-memory clustered storage engine called NDB (which stands for “ N etwork D ata B ase ”). In our documentation, the term NDB refers to the part of the setup that is specific to the storage engine, whereas “ MySQL Cluster ” refers to the combination of one or more MySQL servers with the NDB storage engine. A MySQL Cluster consists ...