(Shlomi Noach) common_schema, revision 178 is now released, with major additions. This revision turns common_schema into a framework, rather than a set of views and functions.
Tag: Open Source
Never say ‘there is no way’
(Giuseppe Maxia) Reading a recent MySQL book, I saw an example of SHOW CREATE TABLE that comes with backticks (`) around the table and column names, and a comment:
How MySQL behaves with many schemata, tables and partitions
(Shinguz) Recently a customer claimed that his queries were slow some times and sometimes they were fast.
Waiting for table metadata lock and PECL/mysqlnd_ms
(Ulf Wendel) The MySQL administration SQL command SHOW PROCESSLIST may read “Waiting for table metadata lock” in its “State” column for a statement.
FLUSH STATUS surprise?
(peter_laursen) What does FLUSH STATUS do? We all know that it will simply reset all status variables (except for ‘uptime’) to same values as immediately after a server restart. Just google it and you will find that behaviour statet on hundreds of sites on the Internet.
Reading results of SHOW statements, on server side
(Shlomi Noach) SHOW statements are show stoppers on server side. While clients can get a SHOW statement as a result set just as any normal SELECT, things are not as such on server side.
Joins in MySQL
(Arjun Panwar) In a MySQL command, a join is used to select the data from two or more tables or views. In a join, we define multiple tables or views.
Enhanced conflict resolution with MySQL Cluster active-active replication
(Andrew Morgan) Part of the latest MySQL Cluster Development Milestone Release (MySQL Cluster 7.2.1 – select the “Development Release” tab at http://dev.mysql.com/downloads/cluster/#downloads) is a couple of enhancements to the conflict detection and resolution mechanism for active-active (multi-mas
Simplified MySQL SSL connections
(Mark Grennan) In last weeks OurSQL postcast (episode 65) Sheeri, Sarah and Jerry talked about making MySQL safe with SSL. Encryption always seems to be such a confusing subject. I think every database should be using SSL by default. So, I was wondering just how easily SSL could be setup.
Using live code interrupts to produce stats which in turn improves code
(Dathan Vance Pattishall) How do you know that your code is fast? Is it fast for your test cases or is it fast for every case? When changes are made how does that affect your customers? How do you know over a period of time if the system is faster or slower.
