background preloader

MySQL

Facebook Twitter

MySQL. MySQL (/maɪ ˌɛskjuːˈɛl/ "My S-Q-L",[6] officially, but also called /maɪ ˈsiːkwəl/ "My Sequel") is (as of March 2014[update]) the world's second most[nb 1] widely used[9][10] open-source relational database management system (RDBMS).[11] It is named after co-founder Michael Widenius's daughter, My.[12] The SQL phrase stands for Structured Query Language.[6] The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements.

MySQL

MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation.[13] For commercial use, several paid editions are available, and offer additional functionality. Applications which use MySQL databases include: TYPO3, MODx, Joomla, WordPress, phpBB, MyBB, Drupal and other software. Why MySQL could be slow with large tables ? June 9, 2006 by Peter Zaitsev144 Comments If you’ve been reading enough database related forums, mailing lists or blogs you probably heard complains about MySQL being unable to handle more than 1.000.000 (or select any other number) rows by some of the users.

Why MySQL could be slow with large tables ?

On other hand it is well known with customers like Google, Yahoo, LiveJournal,Technocarati MySQL has installations with many billions of rows and delivers great performance. What could be the reason ? The reason is normally table design and understanding inner works of MySQL. If you design your data wisely considering what MySQL can do and what it can’t you will get great perfomance if not, you might become upset and become one of thouse bloggers. Installing MySQL. So you want to take the plunge and install MySQL on your system?

Installing MySQL

It's not as difficult as you might think. In fact, if you're using a popular operating system, you can probably bypass the intricate compilation process and download a ready-to-install binary file. The first step in installing MySQL is to make sure that MySQL supports your operating system. MySQL Performance Forum: Welcome to the forum.