Home Accessibility Courses Diary The Mouth Forum Resources Site Map About Us Contact
 
For 2023 (and 2024 ...) - we are now fully retired from IT training.
We have made many, many friends over 25 years of teaching about Python, Tcl, Perl, PHP, Lua, Java, C and C++ - and MySQL, Linux and Solaris/SunOS too. Our training notes are now very much out of date, but due to upward compatability most of our examples remain operational and even relevant ad you are welcome to make us if them "as seen" and at your own risk.

Lisa and I (Graham) now live in what was our training centre in Melksham - happy to meet with former delegates here - but do check ahead before coming round. We are far from inactive - rather, enjoying the times that we are retired but still healthy enough in mind and body to be active!

I am also active in many other area and still look after a lot of web sites - you can find an index ((here))
Management overview of MySQL - background and Philosophies

This morning, I listened to David Axmark from Sweden and Monty Widenius from Finland talk about their MySQL Database engine.

A LITTLE BACKGROUND

MySQL grew out of an internal project which became an Open Source project and has now additionally embraced a more commercial model in order to fund ongoing development. As Monty Widenius said (Bari, Italy, 11th October 2004), GeekCruise "The commercial model is desirable because I want to go on developing code and I don't want to have to speak at every conference to bring in the funds".

PHILOSOPHIES

It should be possible to download, try and install in 15 minutes. Too many open source projects have installation problems, tricks, etc. and that is NOT what they want for MySQL

Primary intent was for Data Warehousing, handling up to terabytes of data - so fast, efficient, mean in operation.

Design and support is such that you should NOT need to upgrade unless you want the new features. Robustness and reliability rather than any form of rocket-science novelties.

Documentation written with the code and IMPORTANT. And if a question is regularly asked it's added back into the documentation. "I don't like to spend time answering the same question every day, and I like to be able to refer people to a full answer".

FEATURES

Extended subset of ANSI SQL:2003 (Similar to most SQLs). Added features are those desired by the community; things are NOT added if they make it slow / obscure / effect ease of use and reliability.

Multiple storage engines (use MyISAM tables for quick read / writes, InnoDB for rollback and commit requirements, Heap for memory based)

Master - Slave replication, using query rather than data replication to be very bandwidth mean.

Large Databases easily handled - Terabytes!

Fast and easy to maintain.

SCALABILITY

EWeek benchmarks of Jan 2002 (old, but latest available) show performance and latency of MySQL to be virtually identical to Oracle, and well ahead of SQL Server, DB2 and others.

Large data farms - easy. See earlier comments.

Even seen Google Adwords - down the right hand side of every search you do? They're run using a MySQL database. Just think of the traffic that must be involved there!

MARKET AND MARKET SIZE

Currently (October 2004) 1 million downloads per month, of which over a half are the windows version (but, says Monty, skewed because it's included with Linux distributions so no need to download).

Over 50 books published on MySQL.

Biggest integrating customers Cisco, Novelle, SAP and HP all of whom integrate MySQL into their products. Other huge customers include Cox, NASA, Slashdot, Nokia, Yahoo. In the UK, the Sanger Institute for Geonome research in Cambridge also got an honourable mention.

NEW IN UPCOMING RELEASES:

4.1

 Subqueries
 Spacial data
 Unicode
 Multitable updates with a single query (I like this!)
 Inserts transmuted to updates if records already exist (like this too)
 Inline views
 SSL to access more securely
 Prepared statements - run same query with varied parameters

5.0

 Stored Procedures
 Triggers
 Views
 Read Cursors
 Greedy Optimiser
 Timeouts and query kills

There's been concern expressed that stored procedures slow a database, but that's not going to be the case with MySQL 5.0; the procedures are implemented in such a way that they don't have any detrimental effect on the performance of queries from prior releases.

Indeed, there's an improvement in performance with the greedy optimiser. This is a mechanism whereby multitable joins (over perhaps 6 to 10 tables) will be much faster.


See also SQL and MySQL training courses

Please note that articles in this section of our web site were current and correct to the best of our ability when published, but by the nature of our business may go out of date quite quickly. The quoting of a price, contract term or any other information in this area of our website is NOT an offer to supply now on those terms - please check back via our main web site

Related Material

MySQL - General
  [2053] - ()
  [2085] - ()
  [2134] - ()
  [2240] - ()
  [2426] - ()
  [2559] - ()
  [2561] - ()
  [2567] - ()
  [2861] - ()
  [3361] - ()

Introduction to SQL and MySQL
  [84] - ()
  [85] - ()
  [175] - ()
  [382] - ()
  [444] - ()
  [515] - ()
  [591] - ()
  [691] - ()
  [918] - ()
  [924] - ()
  [2134] - ()
  [2561] - ()
  [2567] - ()
  [2786] - ()
  [3269] - ()
  [3928] - ()

Sourcing, Running and Configuring MySQL
  [192] - ()
  [334] - ()
  [489] - ()
  [515] - ()
  [535] - ()
  [591] - ()
  [907] - ()
  [1095] - ()
  [1123] - ()
  [1131] - ()
  [1689] - ()
  [1731] - ()
  [1771] - ()
  [1935] - ()
  [2085] - ()
  [2209] - ()
  [2426] - ()
  [2444] - ()
  [2445] - ()
  [2458] - ()
  [4390] - ()
  [4406] - ()
  [4487] - ()

resource index - MySQL
Solutions centre home page

You'll find shorter technical items at The Horse's Mouth and delegate's questions answered at the Opentalk forum.

At Well House Consultants, we provide training courses on subjects such as Ruby, Lua, Perl, Python, Linux, C, C++, Tcl/Tk, Tomcat, PHP and MySQL. We're asked (and answer) many questions, and answers to those which are of general interest are published in this area of our site.

You can Add a comment or ranking to this page

© WELL HOUSE CONSULTANTS LTD., 2024: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • FAX: 01144 1225 793803 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho

PAGE: http://www.wellho.net/solutions/mysql-ma ... phies.html • PAGE BUILT: Wed Mar 28 07:47:11 2012 • BUILD SYSTEM: wizard