MySQL
Priceless Monty
While working with Monty Widenius on a bug I reported in MariaDB I was surprised to not get an IRC response for a few minutes. When committed Monty can identify, create a workaround, and patch a problem in code before you have time to read all the responses he also types.
Read moreHurting the little guy?
Today I come back from the dentist, if that wasn’t bad enough news, I get an email from Google AdWords titled Your Google AdWords Approval Status. In the email, all my AdWords campaigns are now disapproved, because of:
Read moreUnderstanding the various MySQL Products & Variants
The MySQL marketplace today is far more complex then simply choosing between a particular version of MySQL that Sun/MySQL produces. The MySQL server product in general is released under the GNU General Public License (GPL) v2 , however you should carefully review the MySQL Legal Policies {#s0rl} as a number of exceptions and different license agreements operate for companion tools such as MySQL Cluster, MySQL client libraries and documentation for example.
Read moreBeginner CSV Engine issues
I’ve just started using the CSV engine for a practical application and I’ve come across a few subtle and unexpected issues/limitations. First, you can’t create any columns in your CSV table nullable.
Read moreInfobright Community Edition(ICE) – It’s Free
The March NY MySQL Meetup featured a presentation from Infobright , a data warehousing solution built on the MySQL Product. With a pitch of “Simplicity, Scalability and low TCO” I became more impressed with the capability to delivery on these as the presentation proceeded.
Read moreIdentifying Bad Memory
I was having problems recently with a dedicated production server, that runs my MySQL Server and a number of websites. It’s most annoying when your system crashes without any reporting in /var/log/messages
Read moreTesting your system
I have raised this specific topic 3 times this week alone, twice in a MySQL setting. The fundamental philosophy of testing is NOT to verify features of your product that work, it is to BREAK your system.
Read moreConfiguration management concepts for database objects
Correctly managing your MySQL database objects such as schemas, tables, indexes, base data etc, is critical to the success of a 24×7 online website. I rarely encounter a robust working solution as part of my consulting so I would like to share my experience in identifying the best practices you should be adopting whether your an existing organization or just an individual with a simple website.
Read morePlanet MySQL at a new URL
Did anybody notice that http://planetmysql.org now redirects to http://planet.mysql.com ? Curious to know the reason why, perhaps an official MySQL person can give us some details. Also it’s a 302 redirect, not a 301 redirect, interesting?
Read moreEliminating unnecessary internal temporary tables
I can’t stress enough that people look at SQL statements that are being executed against your production MySQL database, and you optimize queries when you can. Often it’s the improvement to the large number of similar queries executed that can optimize resources.
Read moreAnnouncing “MySQL Essentials” Training
Are you having problems getting up to speed on MySQL? Are you asking yourself “Is there a hands-on training course we can send a developer/system admin to learn MySQL?”. In response, at 42SQL we have put together two new training courses, MySQL Essentials and MySQL Operations.
Read moreThe art of looking at the actual SQL statements
It’s a shame that MySQL does not provide better granularity when you want to look at all SQL statements being executed in a MySQL server. I canvas that you can with the general log, but the inherit starting/stopping problems in 5.
Read moreWatching a slave catchup
This neat one line command can be of interest when you are rebuilding a MySQL slave and replication is currently catching up. $ watch --interval=1 --differences 'mysql -uuser -ppassword -e "
Read more