(Giuseppe Maxia) I have been preaching since 2003 that the default deployment of MySQL (where root can access without password) should be changed to something more secure.
Tag: Open Source
Not a cool new feature for Master_Host
(Ronald Bradford) I was surprised to find on a customer MySQL server this new syntax for Master_host in SHOW SLAVE STATUS.
Determining the USL’s coefficient of performance, part 2
(Baron Schwartz) Last time I said that the USL has a forgotten third coefficient, the coefficient of performance. This is the same thing as the system’s throughput at concurrency=1, or C(1). How do you determine this coefficient? There are at least three ways.
Is there room for more MySQL IO Optimization?
(Peter Zaitsev) I prefer to run MySQL with innodb_flush_method=O_DIRECT in most cases – it makes sure there is no overhead of double buffering and I can save the limited amount of file system cache I would normally have on database server for those things which need to be cached — system files, bina
Abusing MySQL string arithmetic for tiny SQL injections
(Krzysztof Kotowicz) Today I’ve found a small nifty trick that may become helpful when exploiting SQL injection vulnerabilities for MySQL. Namely, you can abuse MySQL string typecasting.
PostgreSQL 9.3 Lateral Part 1: Use with HStore
(Leo Hsu and Regina Obe) One of the improvements coming in PostgreSQL 9.3 is the new LATERAL SQL clause. LATERAL allows you to write more succinct code than you would be able to otherwise and will be a welcome companion to extensions like hstore and PostGIS which both have a plethora of set returnin
Managing hierarchical data with MySQL
(Vincent Lamanna) One of the most complex problem I’ve seen as a developer is dealing with some kind of hierarchy in a data model. It’s not much about storing the relationship but more it comes to generating reports that take into account this hierarchy.
Empty row if condition does not match
(Quassnoi) Just found that in a Google referer to the blog:
MySQL 5.6 Delayed Replication – Making a Slave Deliberately Lag Behind a Master
(Tony Darnell) In the majority of MySQL replication scenarios, you want your slave databases to be a mirror of your master databases. You usually don’t want your slave to be behind your master by more than a few seconds – and your main goal is for your slave to always be in sync with your master.
Common use cases for the MySQL Join statement
(Vincent Lamana) Since I started working as a software engineer, I’ve seen a lot of people misusing or trying to avoid MySQL Join statement. These statements can actually be quite handy when used properly.