Transcript What is MySQL

Database of the year 1998
Most affordable database 1998
Readers choice 1999
What is MySQL
• MySQL is a server/client SQL Server
• Multithreaded and multiuser
• Extremely fast and very robust
• Very scalable
• Designed to be used with large databases from the start
• A commercial database with extensive support, but still free
for must use
Downloads
We estimate that there are at least 500.000 MySQL installations today
History
1979: UNIREG Basic
1981: UNIREG C/Denix
1985-1994: UNIREG SunOS
mSQL
ODBC
1995: MySQL 1.0
ANSI SQL
1996: MySQL 3.11.0
Xmysql
Xmysqladmin
MySQL C Client
Graphical SQL Client
MySQL Perl
MyODBC
MSQL/MySQL-modules
(Perl client)
Platforms
• Native
– AIX 4.x
– BSDI 3.0/3.1
– DEC Tru64 Unix
– FreeDSB 3.x
– HP-UX 11.x
– OS/2 Warp
– SCO UnixWare 7.0.1
– SGI Irix 6.x
– Win95, Win98, NT
• Linux Threads or glibc
– Linux 2.0
• MIT-Pthreads
– BSDI 2.x
– FreeBSD 2.x
– HP-UX 10.20
– NetBSD 1.3 Intel
– NetBSD 1.3 Alpha
– Open BSD 2.x
– SunOS 4.x
• FSU-Pthreads
– SCO open server
API
C++
C
Delphi
Dylan
TCC
MySQL
Python
Java
Pike
Guile
ODBC
Perl
PHP3
Benchmarks
Crash-me
Why MySQL is fast
• Fast joins
• Join optimiser
• Index optimiser
• Where optimiser
• Range optimiser
• Efficient memory use
• Key & Record cache
• Index compression
• Optimiser for:
– IN()
– MIN()
– MAX()
– COUNT(*)
• No transactions
• Lock tables
• Disk & memory based
tables
Transactions
• Rarely really the only possibility
• Need a lot of memory and diskspace
• Slows down things by 3-4 times
• Alternatives:
– Lock tables
– Check first, update later
– Atomic or incremental updates
– Update log
Today
• Multithreaded, multiuser and very fast
• MySQL has a good, free ODBC driver
• Very portable and scalable
• Almost all ANSI SQL 92 and ODBC 3.0 functions and types
• Supports many languages and character sets
• Extensively documented, many MySQL books on their way
• Very robust, no memory leaks and extensively tested by
many users
Who is behind MySQL
• Allan Larsson: The boss at TcX
• David Axmark: Licensing, documentation, web
• Antti Halonen: Sales manager
• Hans Kierkegard: Handles license/support paperwork
• Michael ‘Monty’ Widenius: Main developer
• Sinisa Milivojevic: Developer
• Jani Tolonen: Developer
• A lot of people on the MySQL mailing lists that help by
answering questions on the mailing lists and finding
disfeatures in the new MySQL versions
Future
• The MySQL documentation includes a TODO which shows
the current snapshot of how we prioritise things
• We will not sacrifice speed or robustness; new features that
have a high impact on speed will always be optional
• We are striving for a full ANSI SQL 92 and ODBC x.x
target
• At Linux Expo we will announce a GPL version of MySQL
3.20
• The new ISAM library in MySQL 3.23 will soon be
released under GPL
License
• Free for internal use on non Microsoft platforms
• A license is required if
– You sell a product that includes the MySQL server
– You use MySQL as a part of a service
– You run it on Windows
• A license is NOT required if
– You sell a redistributable CD with MySQL (non
Microsoft OS)
Copyright
• The server has a copyright based on the Ghostscript license
• The standard clients developed by TcX are Public Domain
• The philosophy behind this is
– The clients should be totally free
– We allow free use of the software so long as people do
not try to make money directly from it
– People who want the right to keep their own software
proprietary, but also want the value of our work, can pay
for the privilege
Support
• No product is better than the support you can get with it
• We provide free support for real bugs on the mailing lists
• We also have commercial support for customers who want
guaranties
• Since the source is open, you can always look into in
yourself
• MySQL is VERY well tested due to its free availability
• The medium time for a bugfix has been under 24 hours!
http://www.mysql.com