Hottest Guide
Currently viewing the tag: "table"
These are the two highly used string types in MySQL. Both store the character values. It’s very difficult to explain exactly how these values are stored on disk and in memory, because the implementations are storage engine-dependent (for example, Falcon uses its own storage formats for almost every data type). I am going to explain [...]
MySQL Performance Boost by Selecting the Right Table Engine
Today I am going to explain you how the MySQL table engine affects the database performance. While designing MySQL-based applications, you should decide which storage engine to use for storing your data. If you don’t think about this during the initial phase, you will possible face [...]
10 ways to wreck the database
1. Dumping raw data
If you want that nobody understand the database data. Store the data not as useful information. Store in a raw format so that if somebody wants the data dump of a particular table or the data of many table using join they will not [...]
