Reply to thread

Message: <blockquote data-quote="TRockz" data-source="post: 4467365" data-attributes="member: 108791">Platforms and interfaces  <a href="http://en.wikipedia.org/wiki/File:MySQLadministrator1.jpg" target="_blank"><img src="http://upload.wikimedia.org/wikipedia/commons/thumb/e/ed/MySQLadministrator1.jpg/180px-MySQLadministrator1.jpg" alt="" class="fr-fic fr-dii fr-draggable " style="" /></a>  <a href="http://en.wikipedia.org/wiki/File:MySQLadministrator1.jpg" target="_blank"><img src="http://en.wikipedia.org/skins-1.5/common/images/magnify-clip.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></a> The MySQL Administrator in Linux   MySQL is written in <a href="http://en.wikipedia.org/wiki/C_%28programming_language%29" target="_blank">C</a> and <a href="http://en.wikipedia.org/wiki/C%2B%2B" target="_blank">C++</a>. The <a href="http://en.wikipedia.org/wiki/SQL" target="_blank">SQL</a> parser uses <a href="http://en.wikipedia.org/wiki/Yacc" target="_blank">yacc</a> and a home-brewed <a href="http://en.wikipedia.org/wiki/Lex_programming_tool" target="_blank">lexer</a>, sql_lex.cc<a href="http://en.wikipedia.org/wiki/MySQL#cite_note-9" target="_blank">[10]</a> MySQL works on many different <a href="http://en.wikipedia.org/wiki/System_platform" target="_blank">system platforms</a>, including <a href="http://en.wikipedia.org/wiki/AIX_operating_system" target="_blank">AIX</a>, <a href="http://en.wikipedia.org/wiki/BSD/OS" target="_blank">BSDi</a>, <a href="http://en.wikipedia.org/wiki/FreeBSD" target="_blank">FreeBSD</a>, <a href="http://en.wikipedia.org/wiki/HP-UX" target="_blank">HP-UX</a>, <a href="http://en.wikipedia.org/wiki/IBM_i5/OS" target="_blank">i5/OS</a>, <a href="http://en.wikipedia.org/wiki/Linux" target="_blank">Linux</a>, <a href="http://en.wikipedia.org/wiki/Mac_OS_X" target="_blank">Mac OS X</a>, <a href="http://en.wikipedia.org/wiki/NetBSD" target="_blank">NetBSD</a>, <a href="http://en.wikipedia.org/wiki/Novell_NetWare" target="_blank">Novell NetWare</a>, <a href="http://en.wikipedia.org/wiki/OpenBSD" target="_blank">OpenBSD</a>, <a href="http://en.wikipedia.org/wiki/OpenSolaris" target="_blank">OpenSolaris</a>, <a href="http://en.wikipedia.org/wiki/EComStation" target="_blank">eComStation</a> , <a href="http://en.wikipedia.org/wiki/OS/2" target="_blank">OS/2</a> Warp, <a href="http://en.wikipedia.org/wiki/QNX" target="_blank">QNX</a>, <a href="http://en.wikipedia.org/wiki/IRIX" target="_blank">IRIX</a>, <a href="http://en.wikipedia.org/wiki/Solaris_%28operating_system%29" target="_blank">Solaris</a>, <a href="http://en.wikipedia.org/wiki/Symbian" target="_blank">Symbian</a>, <a href="http://en.wikipedia.org/wiki/SunOS" target="_blank">SunOS</a>, <a href="http://en.wikipedia.org/wiki/SCO_OpenServer" target="_blank">SCO OpenServer</a>, <a href="http://en.wikipedia.org/wiki/UnixWare" target="_blank">SCO UnixWare</a>, <a href="http://en.wikipedia.org/wiki/Sanos" target="_blank">Sanos</a>, <a href="http://en.wikipedia.org/wiki/Tru64" target="_blank">Tru64</a> and <a href="http://en.wikipedia.org/wiki/Microsoft_Windows" target="_blank">Microsoft Windows</a>. A port of MySQL to <a href="http://en.wikipedia.org/wiki/OpenVMS" target="_blank">OpenVMS</a> is also available.<a href="http://en.wikipedia.org/wiki/MySQL#cite_note-10" target="_blank">[11]</a> <a href="http://en.wikipedia.org/wiki/Library_%28computing%29" target="_blank">Libraries</a> for accessing MySQL databases are available in all major <a href="http://en.wikipedia.org/wiki/Programming_language" target="_blank">programming languages</a> with language-specific <a href="http://en.wikipedia.org/wiki/Application_programming_interface" target="_blank">APIs</a>. In addition, an <a href="http://en.wikipedia.org/wiki/ODBC" target="_blank">ODBC</a> interface called <a href="http://en.wikipedia.org/wiki/MyODBC" target="_blank">MyODBC</a> allows additional programming languages that support the ODBC interface to communicate with a MySQL database, such as <a href="http://en.wikipedia.org/wiki/Active_Server_Pages" target="_blank">ASP</a> or <a href="http://en.wikipedia.org/wiki/Adobe_ColdFusion" target="_blank">ColdFusion</a>. The MySQL server and official libraries are mostly implemented in <a href="http://en.wikipedia.org/wiki/ANSI_C" target="_blank">ANSI C</a>/<a href="http://en.wikipedia.org/wiki/ANSI_C%2B%2B" target="_blank">ANSI C++</a>. To administer MySQL databases one can use the included <a href="http://en.wikipedia.org/wiki/Command_line" target="_blank">command-line</a> tool (commands: mysql and mysqladmin). Also downloadable from the MySQL site are <a href="http://en.wikipedia.org/wiki/Graphical_user_interface" target="_blank">GUI</a> administration tools: <a href="http://en.wikipedia.org/w/index.php?title=MySQL_Administrator&action=edit&redlink=1" target="_blank">MySQL Administrator</a> and <a href="http://en.wikipedia.org/w/index.php?title=MySQL_Query_Browser&action=edit&redlink=1" target="_blank">MySQL Query Browser</a>. Both of the GUI tools are now included in one package called tools/5.0.html MySQL GUI Tools. In addition to the above-mentioned tools developed by MySQL AB, there are several other commercial and <a href="http://en.wikipedia.org/wiki/Non-commercial" target="_blank">non-commercial</a> tools available. Examples include <a href="http://en.wikipedia.org/wiki/Navicat" target="_blank">Navicat</a> Free Lite Edition or <a href="http://en.wikipedia.org/wiki/SQLyog" target="_blank">SQLyog</a> Community Edition, they are free desktop based GUI tools and <a href="http://en.wikipedia.org/wiki/PhpMyAdmin" target="_blank">phpMyAdmin</a>, a free <a href="http://en.wikipedia.org/wiki/World_Wide_Web" target="_blank">Web</a>-based administration interface implemented in <a href="http://en.wikipedia.org/wiki/PHP" target="_blank">PHP</a>.  [<a href="http://en.wikipedia.org/w/index.php?title=MySQL&action=edit&section=3" target="_blank">edit</a>] Features As of April 2009<a href="http://en.wikipedia.org/w/index.php?title=MySQL&action=edit" target="_blank">[update]</a>, MySQL offers MySQL 5.1 in two different variants: the MySQL Community Server and <a href="http://en.wikipedia.org/wiki/MySQL_Enterprise" target="_blank">Enterprise Server</a>.<a href="http://en.wikipedia.org/wiki/MySQL#cite_note-11" target="_blank">[12]</a> They have a common code base and include the following features:<ul> <li data-xf-list-type="ul">A broad subset of <a href="http://en.wikipedia.org/wiki/SQL:1999" target="_blank">ANSI SQL 99</a>, as well as extensions</li> <li data-xf-list-type="ul">Cross-platform support</li> <li data-xf-list-type="ul"><a href="http://en.wikipedia.org/wiki/Stored_procedure" target="_blank">Stored procedures</a></li> <li data-xf-list-type="ul"><a href="http://en.wikipedia.org/wiki/Database_trigger" target="_blank">Triggers</a></li> <li data-xf-list-type="ul"><a href="http://en.wikipedia.org/wiki/Cursor_%28databases%29" target="_blank">Cursors</a></li> <li data-xf-list-type="ul">Updatable <a href="http://en.wikipedia.org/wiki/View_%28database%29" target="_blank">Views</a></li> <li data-xf-list-type="ul">True VARCHAR support</li> <li data-xf-list-type="ul">INFORMATION_SCHEMA</li> <li data-xf-list-type="ul">Strict mode</li> <li data-xf-list-type="ul"><a href="http://en.wikipedia.org/wiki/X/Open_XA" target="_blank">X/Open XA</a> <a href="http://en.wikipedia.org/wiki/Distributed_transaction_processing" target="_blank">distributed transaction processing</a> (DTP) support; <a href="http://en.wikipedia.org/wiki/Two-phase-commit_protocol" target="_blank">two phase commit</a> as part of this, using Oracle's <a href="http://en.wikipedia.org/wiki/InnoDB" target="_blank">InnoDB</a> engine</li> <li data-xf-list-type="ul">Independent <a href="http://en.wikipedia.org/wiki/Storage_engine" target="_blank">storage engines</a> (<a href="http://en.wikipedia.org/wiki/MyISAM" target="_blank">MyISAM</a> for read speed, InnoDB for transactions and <a href="http://en.wikipedia.org/wiki/Referential_integrity" target="_blank">referential integrity</a>, <a href="http://en.wikipedia.org/wiki/MySQL_Archive" target="_blank">MySQL Archive</a> for storing historical data in little space)</li> <li data-xf-list-type="ul">Transactions with the InnoDB, BDB and Cluster storage engines; savepoints with InnoDB</li> <li data-xf-list-type="ul"><a href="http://en.wikipedia.org/wiki/Secure_Sockets_Layer" target="_blank">SSL</a> support</li> <li data-xf-list-type="ul">Query <a href="http://en.wikipedia.org/wiki/Caching" target="_blank">caching</a></li> <li data-xf-list-type="ul">Sub-<a href="http://en.wikipedia.org/wiki/Select_%28SQL%29" target="_blank">SELECTs</a> (i.e. nested SELECTs)</li> <li data-xf-list-type="ul">Replication with one master per slave, many slaves per master, no automatic support for multiple masters per slave.</li> <li data-xf-list-type="ul">Full-text <a href="http://en.wikipedia.org/wiki/Indexing" target="_blank">indexing</a> and searching using MyISAM engine</li> <li data-xf-list-type="ul">Embedded database library</li> <li data-xf-list-type="ul">Partial <a href="http://en.wikipedia.org/wiki/Unicode" target="_blank">Unicode</a> support (<a href="http://en.wikipedia.org/wiki/UTF-8" target="_blank">UTF-8</a> sequences longer than 3 bytes are not supported; <a href="http://en.wikipedia.org/wiki/UTF-16/UCS-2" target="_blank">UCS-2</a> encoded strings are also limited to the <a href="http://en.wikipedia.org/wiki/Basic_Multilingual_Plane" target="_blank">BMP</a>)</li> <li data-xf-list-type="ul"><a href="http://en.wikipedia.org/wiki/ACID" target="_blank">ACID</a> compliance using the InnoDB, <a href="http://en.wikipedia.org/wiki/Berkeley_DB" target="_blank">BDB</a> and Cluster engines</li> <li data-xf-list-type="ul"><a href="http://en.wikipedia.org/wiki/Shared-nothing" target="_blank">Shared-nothing</a> clustering through <a href="http://en.wikipedia.org/wiki/MySQL_Cluster" target="_blank">MySQL Cluster</a></li> </ul>The MySQL Enterprise Server is released once per month and the sources can be obtained either from MySQL's customer-only Enterprise site or from MySQL's <a href="http://en.wikipedia.org/wiki/Bazaar_%28software%29" target="_blank">Bazaar</a> repository, both under the GPL license. The MySQL Community Server is published on an unspecified schedule under the GPL and contains all bug fixes that were shipped with the last MySQL Enterprise Server release. Binaries are no longer provided by MySQL for every release of the Community Server.<a href="http://en.wikipedia.org/wiki/MySQL#cite_note-12" target="_blank">[13]</a><a href="http://en.wikipedia.org/wiki/MySQL#cite_note-13" target="_blank">[14]</a></blockquote>

Verification: Payakata winadi keeyak tibeda?

Top Bottom

Search

Latest ads

Reply to thread