(Leo Hsu and Regina Obe) There has been a lot of talk lately about PostgreSQL and what MySQL can learn from the PostgreSQL clan. We would like to look at the reverse of that. This article is a bit of a complement to Joshua Drake’s What MySQL (and really, Sun) can learn from PostgreSQL.
Tag: Open Source
How multiple disks can benefit for single client workload?
(Peter Zaitsev) Let us talk few more about disks. You might have read my previous post and Matt’s Reply and it looks like there are few more things to clarify and explain.
InnoDB plugin row format performance – II
(Venu Anuganti) This is a continuation post on InnoDB plugin row format performance with few more test scenarios to cover based on the feedback and questions that I got in my Inbox.
When SHOW SLAVE STATUS and the error log Disagree
(Yannick Gratton) When I do a show slave statusG, sometimes mysqld will lie to me and give me a wrong Exec_Master_Log_Pos. Let me explain with a situation from last night.
InnoDB plugin row format performance
(Venu Anuganti) Here is a quick comparison of the new InnoDB plugin performance between different compression, row formats that is introduced recently.
Is disk Everything for MySQL Performance?
(Peter Zaitsev) I read very nice post by Matt today and it has many good insights though I can’t say I agree on all points.
Setting up PostgreSQL as a Linked Server in Microsoft SQL Server 64-bit
(Leo Hsu and Regina Obe) We would like to thank Jeff Crumbley of IILogistics for providing many of these steps and informing us that Microsoft has finally released a 64-bit OLEDB for ODBC driver.
Turning On Multiple Statements In ColdFusion 8 MySQL 4/5 Datasource
(Ben Nadel) Lately, I have been doing a lot of work in ColdFusion 8 and MySQL 5. One of the things that I noticed immediately was that MySQL didn’t seem to allow multiple statements within one CFQuery tag. I read that this is apparently done to prevent SQL injection attacks, which as a ColdFusion de
MySQL extensions for hosting
(Maciej Dobrzanski) A few weeks ago I was asked to isolate some functionalities from Mark Callaghan’s MySQL patch bundle. They were extensions adding per-user and per-table accounting to the database, accessible with a new set of commands such as SHOW TABLE_STATISTICS, SHOW INDEX_STATISTICS and SHOW
Finding the right balance – MySQL’s changing development model
(Matthew Aslett) I’ve already taken a look at MySQL’s changing business model and the potential business drivers behind the company considering introducing new functionality under to Enterprise customers only. One area that I didn’t dive into was the impact on the company’s development model.