MySQL v5.5 changes the default storage engine to InnoDB. If you'd like to upgrade your tables from MyISM to InnoDB, here is a simple SQL query that will generate the necessary code to upgrade all tables in a single SQL database.
SET SESSION group_concat_max_len = 204800;
SELECT GROUP_CONCAT('ALTER... Read more.
It's the cloud... Read more.
This is a great quote on why Javabean Hosting isn't looking to race to the bottom. We're not looking to build something that isn't sustainable or disrespects customers. We are looking to deliver nothing short of the best for our users.... Read more.
This doesn't bode well for MySQL users. Thankfully, Open Source advocates have been working on a drop in replacement called MariaDBwhich will prove incredibly valuable as MySQL becomes more closed source.... Read more.
Friday, August 10, 2012 I will finally take the leap from bachelorhood to married life.After almost 9 (yes, nine) years and 11 months my fianc and I will tie the knot. Although everyone can't join us there in person, we'd like you to celebrate with us.
To celebrate our happiness, we would like to o... Read more.
I got last minute word from my upstream provider that they would need to perform emergency datacenter maintenance. The maintenance was scheduled to improve the datacenter's latency and redundancy.
This morning we reported to our upstream provider higher than normal server loads. Although fluctuatio... Read more.
Like any good bug or problem, we started to hear (and see) reports of slow downs in page load times on Friday night. We investigated this and found that the data center we host our server in had a slow down in their SAN disk storage. This caused increased IO, server load, and page load times.
Th... Read more.
Over the weekend some users may have noticed that their site started to experience some 403 errors. I'd like to take a minute to explain what happened, how it was fixed, and what lessons were learned in the process.
Recently, a user had complained that they were unable to add email... Read more.
A good read for individuals looking for ways to improve their SEO.... Read more.