Technical Blog

Grants privileges to MySQL user CREATE USER  'root'@'localhost' IDENTIFIED BY 'pass'; pass : enter your password Grant full rights GRANT ALL ON *.* TO 'root'@'localhost'; more info http://dev.mysql.com/doc/refman/5.1/en/grant.html

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 of a

Notepad++ is a free (as in "free speech" and also as in "free beer") source code editor and Notepad replacement that supports several languages. Running in the MS Windows environment, its use is governed by GPL License. Based on the powerful editing component Scintilla, Notepad++ is written in C++ and uses pure Win32 API and STL which ensures a higher execution speed and smaller program size. By optimizing as many routines as possible without losing user friendliness, Notepad++ is trying to reduce the world carbon dioxide emissions. When using less CPU power, the PC can throttle down and reduce power consumption, resulting in a greener environment. You're encouraged to translate Notepad++ into your native tongue if there's not already a translation present in the Binary Translations page. And if you want, help translating Notepad++ official site into your native tongue would be greatly appreciated. official site : http://notepad-plus-plus.org Notepad