Came across the need to perform maintenance on a MySQL database which holds millions of records, we needed to remove all data which was 2+ years old which involved deleting around 530 million records from a very large table, hitting nearly 200GB.
Continue reading...
Laravel defaults to storing all dates in UTC format, this is highly recommended as UTC time never changes unlike other time zones which have daylight savings. It is best practice to store and read dates in UTC, and then convert UTC to your required time zone for the user interface. Great article below of a
Continue reading...
Damaged or crashed MySQL tables due to an unsafe server shut downs, disk space limits or general MySQL failures? Do a find and find and repair on your damaged MySQL tables.
Continue reading...