Tips and Tricks Any My.SQL Database Developer Should Consider.Since its introduction in 1.My. SQL quickly became the worlds most popular database management system.With that type of popularity comes great responsibilityand countless improvements, updates, and fanciful tricks.Scour the web and there really is no shortage of My.SQL tips and tricks.So which ones are the most helpful Below you will find the list of the top 2.My. SQL tips for experts and rookies alike.SQL Database Tips and Tricks.Do Not Edit Dump files.If you have ever seen the dump files created by mysqldump, they look an awful lot like regular, harmless text files.But for anyone who has ever tried to edit them, they have quickly learned that they are anything but a text file.Most people edit them in a standard text editor, and then the corruptions start to appear.The only guaranteed way to avoid problems is to leave the dump files alone.My. ISAM Block Size.One of the better kept secrets is a setting for block sizes in the indexes of My.ISAM tables. The setting, myisamblocksize can be found in the.MYI files in the key buffer, as well as the disc.It has a default value of 1k, which is quite small to be optimal on a modern system.Most file systems will have used a larger size block.And we know that writing a single index block will require a read and then a write.The operating system will never have to write to the underlying disc, just so long as the block size is either equal to, or greater than filesystem block size.Turning on delaykeywrite.If you have tables that contain generated columns, use the mysqldump utility provided with MySQL 5.Images/VS_SQLite-nuget-iOS.png' alt='Dump Mysql Database Command Line Windows Updates' title='Dump Mysql Database Command Line Windows Updates' />
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2017
Categories |