Search
About me
-
Name: Shlomi Noach
Location: Israel
I am a software engineer, DBA and MySQL geek.
-
Name: Shlomi Noach
-
Speaking
-
Recent Posts
Similar Posts
- How common_schema installs itself
- common_schema rev. 218: QueryScript, throttling, processes, documentation
- mycheckpoint (rev 208): aggregation tables, enhanced charting, RPM distribution
- common_schema 1.1 released: split(), try-catch, killall(), profiling
- common_schema, rev. 178: foreach(), repeat_exec(), Roland Bouman, query analysis
Archives
- May 2013
- April 2013
- March 2013
- February 2013
- January 2013
- December 2012
- November 2012
- October 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- June 2008
Blogroll
Categories
- Development (RSS) (10)
- Linux (RSS) (1)
- MySQL (RSS) (280)
- OpenOffice (RSS) (1)
Meta
Tag Cloud
- Analysis Backup Books common_schema community Configuration Data Types Development Execution plan Graphs Hack Humor Indexing INFORMATION_SCHEMA InnoDB Installation Linux logs memcached Monitoring mycheckpoint MyISAM mysqlconf mysqldump New Features openark kit Open Source Opinions PerconaLive Performance Planet python QueryScript Replication Schema scripts Security Speaking Sphinx SQL sql_mode Stored routines Syntax Triggers Web
'Schema' Tag
-
Announcing common_schema: common views & routines for MySQL
July 13, 2011Today I have released common_schema, a utility schema for MySQL which includes many views and functions, and is aimed to be installed on any MySQL server. What does it do? There are views answering for all sorts of useful information: stuff related to schema analysis, data dimensions, monitoring, processes & transactions, security, internals... There are [...]
-
Reasons to use AUTO_INCREMENT columns on InnoDB
March 22, 2011An InnoDB table must have a primary key (one is created if you don't do it yourself). You may have a natural key at hand. Stop! Allow me to suggest an AUTO_INCREMENT may be better. Why should one add an AUTO_INCREMENT PRIMARY KEY on a table on which there's a natural key? Isn't an AUTO_INCREMENT [...]
-
Thoughts and ideas for Online Schema Change
October 7, 2010Here's a few thoughts on current status and further possibilities for Facebook's Online Schema Change (OSC) tool. I've had these thoughts for months now, pondering over improving oak-online-alter-table but haven't got around to implement them nor even write them down. Better late than never. The tool has some limitations. Some cannot be lifted, some could. [...]
-
mk-schema-change? Check out ideas from oak-online-alter-table
March 10, 2010In response to Mark Callaghan's post mk-schema-change. I apologize for not commenting on the post itself, I do not hold a Facebook account. Anyway this is a long write, so it may as well deserve a post of its own. Some of the work Mark is describing already exists under openark kit's oak-online-alter-table. Allow me [...]
-
Common wrong Data Types compilation
November 18, 2008During my work with companies using MySQL, I have encountered many issues with regard to schema design, normalization and indexing. Of the most common errors are incorrect data types definition.
Here's a compilation of "the right and the wrong" data types.