Infobox software logo Image MySQL.svg 180px screenshot Image Mysql screenshot.PNG 300px A command line ... Screenshot of the default MySQL command line. developer Oracle Corporation Oracle formerly Sun Microsystems Sun , formerly MySQL AB released start date 23 May 1995 latest release version 5.5.23 ... 5.5 en news 5 5 23.html title Changes in MySQL 5.5.23 publisher Oracle Corporation accessdate ... 04 10 frequently updated yes programming language C programming language C , C ref cite web title MySQL url http www.ohloh.net p mysql analyses latest work Ohloh.net ref operating system Cross platform ... www.mysql.com br http dev.mysql.com dev.mysql.com MySQL IPAc en icon m a s k ju l My S Q L , ref name whatismysql cite web title What is MySQL?, MySQL 5.1 Reference Manual publisher MySQL ... way to pronounce MySQL is My Ess Que Ell not my sequel , but we do not mind if you pronounce ... k w l My Sequel is the world s most used ref http www.mysql.com why mysql marketshare ref relational ... the Myths publisher MySQL AB url http dev.mysql.com tech resources articles dispelling the myths.html ... doc refman 5.1 en history.html title History of MySQL, MySQL 5.1 Reference Manual publisher MySQL ... http dev.mysql.com doc refman 5.1 en what is mysql.html title What is MySQL, MySQL 5.1 Reference Manual publisher MySQL AB accessdate 2011 08 26 ref The MySQL development project has made its source ... software proprietary agreements. MySQL was owned and sponsored by a single Business for profit firm, the Sweden Swedish company MySQL AB , now owned by Oracle Corporation . ref name sunacquire ... Announces Completion of MySQL Acquisition Paves Way for Secure, Open Source Platform to Power the Network ... projects that require a full featured database management system often use MySQL. For commercial use ... MySQL databases include TYPO3 , Joomla , WordPress , phpBB , Drupal and other software built on the LAMP software bundle LAMP software stack. MySQL is also used in many high profile, large scale World ... more details
unref date February 2008 Infobox Software name MySQL Enterprise Server logo Commented out because image was deleted Image MySQL.svg 200px caption developer Oracle Corporation latest release version 5.5.8 operating system Cross platform genre Relational database management system RDBMS license GNU General Public License GPL Commercial, http www.mysql.com company legal mysqlenterpriseagmt.pdf Subscription Agreement website URL http www.mysql.com enterprise MySQL Enterprise is a subscription based service produced by Oracle Corporation and targeted toward the business commercial market. Oracle s official support, training and certification focus on MySQL Enterprise. MySQL Enterprise contains MySQL Enterprise Server software, a distribution of the MySQL Server MySQL Enterprise Monitor MySQL Enterprise Backup MySQL Workbench Standard Edition Production Support New versions of MySQL Enterprise Server are released monthly as Rapid Updates MRUs , and quarterly as Service Packs QSPs . Relationship to free or community versions MySQL Enterprise Server 5.5, the software component of the MySQL Enterprise subscription offering, is a subset of the MySQL Community Server 5.5. External links http www.mysql.com products enterprise database MySQL Enterprise Server 5.5 http www.mysql.com products enterprise advisors.html MySQL Network Monitoring and Advisory Services http www.mysql.com products enterprise support.html MySQL Production Support MySQL Category MySQL ... more details
Infobox company name MySQL AB logo type Private company genre Database software status Acquired predecessor ... products MySQL , MySQL Cluster services revenue operating income net income aum assets equity owner ... MySQL Aktiebolag AB founded 1995, acquired by Sun Microsystems 2008, now owned by Oracle Corporation since 2010 was a Computer software software company. MySQL AB is the creator of MySQL , a relational database management system , as well as related products such as MySQL Cluster . The company was dually ... MySQL AB was one of the largest open source companies worldwide. Around 70 of the employees worked for MySQL from their Telecommuting home offices . ref cite news title Fortune MySQL Workers in 25 ... mysql greatteams fortune index.htm date 2006 05 31 accessdate 2010 05 19 first1 Josh last1 Hyatt ref On 16 January 2008, MySQL AB announced that it had agreed to be acquired by Sun Microsystems for approximately ... MySQL publisher MySQL AB url http mysql.com news and events sun to acquire mysql.html accessdate 2008 ... Cite web url http blogs.mysql.com kaj 2008 01 16 sun acquires mysql title Sun acquires MySQL publisher MySQL AB date 2008 01 16 accessdate 2008 01 16 ref ref cite web title Investor Relations FAQ publisher ... 16 ref ref cite web title MySQL blogs Sun acquires MySQL url http blogs.mysql.com kaj sun acquires mysql.html ... Apache , and PHP , the MySQL Server forms one of the building blocks of the LAMP software bundle LAMP technology stack . The company claims a user base of over 5 million MySQL installations worldwide and over 10 million product downloads in 2004. Business model MySQL AB representatives are commonly ... distinguishes this second generation of companies, such as MySQL AB and Trolltech , from earlier ..., MySQL AB makes MySQL available under the GNU General Public License GPL at no charge, but sells ..., such as inclusion of MySQL AB technology in a closed source product. Other sources of revenue for MySQL AB are providing support and consulting, as well as training and certification for MySQL ... more details
Infobox Software name MySQL Manager logo Commented out because image was deleted Image MySQL Manager.png 48px MySQL Manager icon screenshot Deleted image removed Image MySQL Manager screenshot.png 300px MySQL Manager in Server 10.3. caption MySQL Manager in Mac OS X Server Mac OS X v10.3 v10.3 . collapsible yes developer Apple Computer status Active latest release version 10.4 I am assuming this, I have 10.3 server available to me. User CyberSkull latest release date release date YYYY MM DD latest preview version latest preview date operating system Mac OS X Server size programming language genre license website http www.apple.com server macosx MySQL Manager is an application that is included in the Mac OS X Server that starts and stops the MySQL Database service that is within the server. The application is located in tt Applications Servers MySQL Manager.app tt . Unlike other server tools, this tool is only installed on the server itself. External links http www.apple.com server macosx mac stub br clear both Mac OS X Server Category Mac OS X Server it MySQL Manager Mac OS X ... more details
http mysqlworkbench.org ?p 1323 MySQL Workbench 5.2.39 GA Available ref latest release date release ... URL http mysqlworkbench.org MySQL Workbench is a visual database design tool that integrates SQL ... design , creation and maintenance into a single integrated development environment for the MySQL ... of software, MySQL GUI Tools Bundle MySQL GUI Tools Bundle . History fabFORCE.net DBDesigner4 ... design and querying tool for the MySQL database released under the GNU General Public License ... only tool DBDesigner4 offers a comprehensive feature set including reverse engineering of MySQL databases ... Zinner was approached by representatives from MySQL AB and joined the company in late 2003 to take over the development of graphical user interface GUI tools for MySQL which lead to the creation of the MySQL ... Interview with Michael G. Zinner , MySQL.com. Retrieved 2010 03 26. ref MySQL GUI Tools Bundle File MySQLadministrator1.png thumb The MySQL Administrator part of GUI Tools The MySQL GUI Tools Bundle is a cross platform open source suite of desktop applications for the administration of MySQL database servers, and for building and manipulating the data within MySQL databases. It was developed by MySQL AB and later by Sun Microsystems and released under the GPL. Development on the GUI Tools bundle has stopped, and is now only preserved under the Download Archives of the MySQL site. ref http dev.mysql.com downloads gui tools 5.0.html MySQL GUI Tools Bundle Archived Downloads , MySQL.com, Retrieved 2010 03 26. ref The GUI Tools bundle has been superseded by MySQL Workbench, and reached its End of Life with the beta releases of MySQL Workbench 5.2. However, the MySQL Support team continued ... MySQL Product Support EOL Announcements , MySQL.com, Retrieved 2010 03 26. ref Future releases of MySQL Workbench will add a migration plugin, providing features comparable to the MySQL Migration Toolkit component within the MySQL GUI Tools bundle. Releases The first preview version of MySQL ... more details
refimprove date February 2008 Infobox software name MySQL Cluster title logo Image MySQL.svg 180px logo caption screenshot File caption collapsible author developer MySQL AB A subsidiary of Oracle Corporation ... br http dev.mysql.com dev.mysql.com MySQL Cluster is a technology which provides Shared nothing architecture shared nothing clustering capabilities for the MySQL database management system . It was first included in the production release of MySQL 4.1 in November 2004. It is designed to provide high ... January 2011 MySQL Cluster is implemented through an additional storage engine available within MySQL ... MySQL Cluster has a few important concepts behind its design, which add both benefits and burdens. Replication MySQL Cluster uses synchronous replication through a two phase commit mechanism in order ... to what is usually referred to as http dev.mysql.com doc en replication.html MySQL Replication , which ... with MySQL 5.1, it is also possible to replicate asynchronously between clusters this is sometimes referred to as MySQL Cluster Replication or geographical replication . See http dev.mysql.com doc refman 5.1 en mysql cluster replication.html MySQL Cluster Replication . Horizontal data partitioning ... release, users can define their own partitioning schemes. Hybrid Storage MySQL Cluster allows .... MySQL Cluster maintains all Index database indexed columns in distributed memory. Non indexed ... page cache . Storing non indexed columns on disk allows MySQL Cluster to store datasets larger than the aggregate memory of the clustered machines. MySQL Cluster writes Redo log Redo logs ... to the synchronous data replication within the cluster. When a MySQL Cluster table is maintained ... are sequential and limited random access patterns are involved, MySQL Cluster can achieve higher ... RDBMS. Shared nothing MySQL Cluster is designed to have no single point of failure . Provided that the cluster ... are also supported. Implementation MySQL Cluster uses three different types of nodes processes Data ... more details
Infobox Software name MySQL Federated Storage Engine logo screenshot caption author Patrick Galbraith, Brian Aker developer released 2005 latest release version latest release date latest preview version latest preview date operating system Linux , Mac OS X , Unix Microsoft Windows Windows platform x86 architecture x86 , x86 64 , SPARC , MIPS architecture MIPS , PowerPC language C C genre Database engine license GNU General Public License website http mysql.bkbits.com http mysql.bkbits.com Portal Free software The MySQL Federated storage engine for the MySQL relational database management system is a storage engine which allows a user to create a table that is a local representation of a foreign remote table. It utilizes the MySQL client library API as a data transport, treating the remote data source the same way other storage engines treat local data sources whether they be MYD files MyISAM , memory MySQL Cluster Cluster , Heap , or tablespace InnoDB . Each Federated table that is defined there is one .frm data definition file containing information such as the URL of the data source . The actual data can exist on a local or remote MySQL instance. To create a Federated table, one has to specify a URL in the CONNECTION string source lang sql create table t1 a int, b varchar 32 ENGINE FEDERATED CONNECTION mysql user hostname test t1 source The connection URL is in the format of scheme user pass host port schema tablename Upon creation of a Federated table, the user must ensure that the remote data source does indeed exist or an error will be issued. The MySQL Federated Storage Engine was authored by Patrick Galbraith and Brian Aker and is currently being maintained by Patrick Galbraith and Antony Curtis. It was introduced in 2005 with MySQL 5.0. External links http dev.mysql.com doc refman 5.0 en federated storage engine.html MySQL Documentation on Federated Storage Engine Category MySQL database software stub fr Federated ... more details
not support any indexes, so you will be looking at a table scan for any SELECT tasks. MySQL is examining ... on to help table scan times is the fact that Archive tables are supported by the MySQL Query Cache ... file generated is a byte array representing the data format and contents of that file. In MySQL 5.1, a copy of the MySQL FRM file is stored in the header of each Archive file. The FRM file, which represents the definition of a table, allows an Archive file to be restored to a MySQL server ... differs from the other MySQL analytical engine, MyISAM , by being a row level locking engine ... t1 a int, b varchar 32 ENGINE ARCHIVE source The MySQL Archive Storage Engine was authored and is maintained by Brian Aker . It was introduced in 2004 with MySQL 4.1. References Reflist External links http dev.mysql.com doc refman 5.1 en archive storage engine.html MySQL Documentation on Archive Storage Engine database software stub MySQL Category MySQL ... more details
Orphan date May 2011 Infobox Software name MySQL Datacontroller Plugin Storage Engine logo screenshot caption author Francis Lavalliere developer released 2010 latest release version latest release date latest preview version latest preview date operating system Linux , Mac OS X , Unix Microsoft Windows Windows platform x86 architecture x86 , x86 64 language C C genre Database engine license GNU General Public License website https launchpad.net datacontroller http www.theacesolutions.com The MySQL Datacontroller storage engine for the MySQL relational database management system is a storage engine which allows a user to create a table that is a local representation of a foreign remote table. The foreign table can be located into another storage engine like Oracle or Microsoft SQL Server MSSQL . It utilizes the MySQL client library API, Free TDS and OCILIB as a data transport, treating the remote data source the same way other storage engines treat local data sources. Each Federated table that is defined there is one .frm data definition file containing information such as the URL of the data source . The actual data can exist on a local or remote Oracle, Microsoft SQL Server MSSQL , or MySQL instance. To create a Federated table, one has to specify a URL in the CONNECTION string source lang sql create table foo id int, bar varchar 255 , dt date ENGINE DATACONTROLLER CONNECTION oracle username password hostname 1521 SID foo source The connection URL is in the format of scheme ... on the MySQL Federated Storage Engine was authored by Patrick Galbraith and Brian Aker and is currently being maintained by Patrick Galbraith and Antony Curtis. It was introduced in 2005 with MySQL 5.0. The DataController Storage engine was introduced in 2010 by Francis Lavalliere working with MySQL ... doc refman 5.0 en federated storage engine.html MySQL Documentation on Federated Storage Engine https launchpad.net datacontroller MySQL DataController Plugin Category MySQL database software stub ... more details
Infobox Software name dbForge Studio for MySQL logo File Dbforgestudio small.jpg caption dbForge Studio for MySQL collapsible author developer Devart released latest release version 5.0 latest release ..., Non commercial, and Free website http www.devart.com dbforge mysql studio www.devart.com dbforge mysql studio dbForge Studio for MySQL is a software application created by Devart company Devart for developing and administrating the popular Relational Database Management System RDBMS MySQL . TOC Editions licenses dbForge Studio for MySQL has three editions Express, Standard, and Professional. Express ... Studio for MySQL as well as a lot of new features and improvements. ref http devart.com news 2010 dbforgestudio450.html dbForge Studio for MySQL release news , Devart ref Version 4.0 saw release on 10 ... version 5.0 was released and is the most current as of now. ref http www.devart.com dbforge mysql studio history.html 5.00 dbForge Studio for MySQL history , Devart ref Functionality dbForge Studio for MySQL has got both standard features of most database tools and unique functionality. Main features of dbForge Studio for MySQL, v5.0 include Administration and Maintenance tools A comprehensive Security Manager to administer user accounts and privileges Special MySQL administration tools boosting MySQL server maintenance Backup and restore wizards supporting large databases and enabling users ... fragment in one or several tables Service control to administrate several MySQL servers on different ... and MySQL query optimization, achieved through comparison of profiling results. Reporting and Analysis tools provide extended capabilities to prepare data reports with MySQL reporting tool and conversion ... Access , ODBC. Database Designer a visual database design and editing tool for MySQL. Provides the complete ... between tables on a MySQL database diagram. Enables easy execution of stored routines. Code Debugger a dedicated debugger for MySQL. Uses database server as an engine for checking user created SQL scripts ... more details
multiple issues orphan February 2009 unreferenced October 2008 notability September 2009 Infobox Book name Learning PHP and MySQL image image caption author Michele E. Davis br Jon A. Phillips country Flagicon USA United States language English language English series Learning publisher O Reilly Media pub date June 2006 First edition br August 2007 Second edition pages 384 First edition br 432 Second edition isbn ISBN 0 596 10110 4 First edition br ISBN 0 596 51401 8 Second edition Learning PHP and MySQL is a tutorial book for PHP and MySQL , and is published by O Reilly Media O Reilly . Editions First edition 2006 384 pages ISBN 0 596 10110 4 Second edition 2007 432 pages ISBN 0 596 51401 8 External links http shop.oreilly.com product 9780596101107.do O Reilly Online catalog Learning PHP & MySQL http shop.oreilly.com product 9780596514013.do O Reilly Online catalog Learning PHP & MySQL, Second Edition Category 2006 books Category 2007 books Category O Reilly Media books Category Computer programming books Category Books about free software Category PHP programming language Category MySQL compu book stub ... more details
This is a comparison between the two primary database engines InnoDB and MyISAM for the MySQL database management system DBMS . A database engine or storage engine is the underlying software component that a DBMS uses to create, read, update and delete CRUD data from a database . POV date October 2011 refimprove date March 2010 class wikitable Name Free Transactional Aria storage engine Aria GPL No BlitzDB GPL No Falcon storage engine Falcon GPL Yes InnoDB GPL Yes MyISAM GPL No InfiniDB CPL No XtraDB GPL Yes Comparison between InnoDB and MyISAM InnoDB recovers from a crash or other unexpected shutdown by replaying its logs. MyISAM must fully scan and repair or rebuild any indexes or possibly tables which had been updated but not fully flushed to disk. Since the InnoDB approach is approximately fixed time while the MyISAM time grows with the size of the data files, InnoDB offers greater availability as database sizes grow. InnoDB, with innodb flush log at trx commit set to 1, flushes the transaction log after each transaction, greatly improving reliability. ref name trx commit http dev.mysql.com doc refman 5.5 en innodb parameters.html sysvar innodb flush log at trx commit MySQL 5.5 Reference Manual InnoDB Startup Options and System Variables ref MyISAM has to be run on top of a fully ... time. ref http dev.mysql.com doc refman 5.5 en innodb performance group commit.html MySQL 5.5 ... MySQL 5.5 Reference Manual The InnoDB Storage Engine ref InnoDB will store rows in primary key order ... 5.5 en myisampack.html MySQL 5.5 Reference Manual myisampack Generate Compressed, Read Only MyISAM ... http dev.mysql.com doc refman 5.5 en fulltext search.html MySQL 5.5 Reference Manual Full Text ... doc mysql en myisam storage engine.html MySQL Documentation on MyISAM Storage Engine http www.geeksww.com tutorials database management systems mysql installation mysql tablecache informationschema ... in using MyISAM MySQL DEFAULTSORT Myisam Category MySQL database software stub ca MyISAM cs ... more details
Refimprove date January 2008 This is a list of AMP Apache HTTP Server Apache , MySQL , Perl PHP Python programming language Python solution stack s for all computer platforms these software bundles are used to run dynamic Web sites or servers. There are LAMP software bundle LAMP s for Linux WAMP s for Microsoft Windows Windows MAMP s for Macintosh SAMP Sun Web Stack SAMP s for Solaris operating system Solaris and FreeBSD FAMPs for FreeBSD . Cross platform XAMPP Zend Server Zend Server CE Zend Server Community Edition Linux LAMP software bundle Bitnami LAMPStack Open Source License, Apache HTTP Server Apache 2 1.3, PHP 4.x 5.x, MySQL 4.1 5, Python programming language Python 2.3 2.4 Bitnami LAPPStack Open Source License, Apache HTTP Server Apache 2, PHP 5.x, PostgreSQL 8.1, Python programming language Python 2.4 http sourceforge.net projects opew OPEW Multi language development distribution including Apache HTTP Server Apache 2, PHP 5.3.10, Node.js 0.6.x, Ruby programming language Ruby 1.9.x, Python programming language Python 3.x, Perl 5.x, Go programming language Go , Tcl , Lua programming language Lua , MySQL , PostgreSQL 9.1, SQLite 3.x, MongoDB 2.x, Redis and Git software Git Mac MAMP DAMP software bundle DAMP Bitnami MAMPStack Open Source License, Apache HTTP Server Apache 2, PHP 5.x, MySQL 5, Python programming language Python 2.4 Windows For a full list and comparison of available Windows AMP packages WAMP , see Comparison of WAMPs Booting These stacks boot from media. SLAMPP Citation needed date August 2011 References references External links http www.portablefreeware.com ?sc 125 List of portable Web Servers http wikis.sun.com display WebStack Sun s Web Stack Project DEFAULTSORT AMP Packages Category Lists of software Category Web development software pl AMP oprogramowanie ... more details
Infobox software name InnoDB logo caption developer Oracle Corporation latest release version latest release date operating system Cross platform genre Database engine license GNU General Public License GPL or Proprietary software proprietary website URL http www.innodb.com InnoDB is the default database engine storage engine for MySQL as of MySQL 5.5. It provides the standard ACID compliant Database transaction transaction features, along with foreign key support Declarative Referential Integrity . It is included as standard in most binaries distributed by MySQL AB , the exception being some Original equipment manufacturer OEM versions. InnoDB became a product of Oracle Corporation after their acquisition of Innobase Innobase Oy in October 2005. ref cite web url http www.oracle.com us corporate press 016679 EN title Oracle Announces the Acquisition of Open Source Software Company, Innobase publisher Oracle Corporation Oracle accessdate 2012 01 30 ref The software is dual licensed it is distributed under the GNU General Public License , but can also be licensed to parties wishing to combine InnoDB in proprietary software . ref cite web url http www.innodb.com licenses.php title Licensing MySQL and InnoDB publisher InnoDB.com accessdate 2008 07 31 ref See also Comparison of MySQL database engines References Reflist External links Official website http www.innodb.com http www.mysqltutorial.org understand mysql table types innodb myisam.aspx Mysqltutorial.org , InnoDB and other table types in MySQL http www.geeksww.com tutorials database management systems mysql tips and tricks notsowellknown differences between myisam and innodb mysql server storage engines.php Not so well known differences between MyISAM and Innodb MySQL server storage engines http dev.mysql.com doc mysql en innodb.html Dev.mysql.com , InnoDB in the MySQL manual MySQL Category MySQL Category Oracle software bg InnoDB ca InnoDB cs InnoDB de InnoDB es InnoDB fr InnoDB id InnoDB it InnoDB lv InnoDB ja I ... more details
MyODBC is an ODBC interface and allows programming language s that support the ODBC Interface computer science interface to communicate with a MySQL database. The official name is Connector ODBC which designates the MySQL AB product family of MySQL ODBC drivers. These are known as the MyODBC drivers . External links http dev.mysql.com doc refman 5.1 en connector odbc introduction.html Introduction to MyODBC http forge.mysql.com wiki MyODBC MyODBC Page on MySQL Forge Wiki http dev.mysql.com downloads connector odbc 3.51.html MySQL Connector ODBC 3.51 Downloads http dev.mysql.com downloads connector odbc 5.1.html MySQL Connector ODBC 5.1 Downloads http webaj.com how setup mysql dsn datasbase source centos myodbc and unixodbc command line.htm How to setup sic MyODBC compu prog stub Category Data access technologies Category Application programming interfaces lt MyODBC ru MyODBC ... more details
Ndb Cluster is the distributed database system underlying MySQL Cluster . It can be used independently of a MySQL Server. From the MySQL Server perspective the Ndb Cluster is a Database engine Storage engine for storing tables of rows. From the Ndb Cluster perspective, a MySQL Server instance is an API process connected to the Cluster. Ndb Cluster can concurrently support access from other types of API processes. All API processes can operate on the same tables and data stored in the Ndb Cluster. Standalone Ndb Cluster Ndb Cluster has the following capabilities independent of any attached MySQL Server Persistent, distributed storage of tables with unique or ordered indexes Redo logging, checkpointing, system recovery Primary key, unique key, table scan and ordered index scan Parallel scan execution with pushed down filters Row locks, transactional updates Synchronous data replication within the cluster, automatic failover recovery Automatic connection failover for API processes Standard ... by any attached MySQL servers Online index add, online table alter Online add node, table reorganisation Online backup Online upgrade MySQL Cluster Ndb Cluster MySQL Server s MySQL Cluster currently uses the MySQL Server to provide the following capabilities on top of Ndb Cluster SQL parsing optimising ... Ndb Cluster is often configured as a MySQL Cluster An Ndb Cluster with attached MySQL Server processes with one or more non MySQL Server API processes attached. All API processes including the MySQL Server use the NDBAPI ref name NdbApiDocs http dev.mysql.com doc ndbapi en index.html The MySQL Cluster ... recommended that at least one MySQL Server is connected to an Ndb Cluster to perform ... http dev.mysql.com doc refman 5.5 en mysql cluster limitations.html Known Limitations of MySQL Cluster ref when compared to a traditional MySQL implementation. Database administrator DBA s considering ... Category MySQL ... more details
Innobase Oy is a Finnish company headquartered in Helsinki , Finland . Innobase is best known for being the developer of InnoDB transactional storage engine for the MySQL open source database system. Innobase Oy is a subsidiary of Oracle Corporation , which acquired Innobase in 2005. History In 1995 Heikki Tuuri founded Innobase Oy to develop InnoDB. In September 2000 Innobase Oy started collaboration with MySQL AB, which resulted in the release of MySQL that incorporated InnoDB in March 2001. InnoDB was originally closed source, but was released to open source after Innobase failed to find a buyer for InnoDB and started collaboration with MySQL. MySQL tried to close a deal with Innobase in the following years, but eventually Oracle acquired Innobase in October, 2005. Oracle eventually also acquired Sun Microsystems , owner of MySQL AB, in January 2010. External links http www.innodb.com Innobase Oy Finland company stub Category Oracle acquisitions ru Innobase ... more details
Server or Windows Internal Database Xaraya PHP and MySQL XOOPS PHP and MySQL Xpress Engine PHP with MySQL , Cubrid , Firebird , SQLite , PostgreSQL , MSSQL References references See also List ... more details
, developers, and administrators of MySQL an open source database. All tools are standalone, with minimal dependencies and no need for installation. It is claimed to make MySQL easier and safer to manage ... for MySQL, there is also support for PostgreSQL and Memcached e.g. mk query digest . As of late 2011 ... name. Included tools mk archiver Archive rows from a MySQL table into another table or a file. mk checksum filter Filter checksums from mk table checksum. mk deadlock logger Extract and log MySQL deadlock information. mk duplicate key checker Find duplicate indexes and foreign keys on MySQL tables. mk error log Find new and different MySQL error log entries. mk fifo split Split files and pipe lines to a fifo without really splitting. mk find Find MySQL tables and execute actions, like GNU find. mk heartbeat Monitor MySQL replication delay. mk index usage Read queries from a log and analyze how they use indexes. mk kill Kill MySQL queries that match certain criteria. mk loadavg Watch MySQL load and take action when it gets too high. mk log player Split and play MySQL slow logs. mk merge mqd results Merge multiple mk query digest reports into one. mk parallel dump Dump MySQL tables in parallel. mk parallel restore Load files into MySQL in parallel. mk profile compact Compact the output ... Parses logs and more. Analyze, transform, filter, review and report on queries for MySQL, PostgreSQL ... caused by other processes. mk show grants Canonicalize and print MySQL grants so you can effectively replicate, compare and version control them. mk slave delay Make a MySQL slave server lag behind its master. mk slave find Find and print replication hierarchy tree of MySQL slaves. mk slave move Move a MySQL slave around in the replication hierarchy. mk slave prefetch Pipeline relay logs on a MySQL slave to pre warm caches. mk slave restart Watch and restart MySQL replication after errors. mk table checksum Perform an online replication consistency check, or checksum MySQL tables efficiently ... more details
Infobox software name MyISAM logo caption developer Oracle Corporation latest release version latest release date operating system Cross platform genre Database engine license GNU General Public License website URL http www.mysql.com MyISAM was the default storage engine for the MySQL relational database management system versions prior to 5.5 ref http dev.mysql.com doc refman 5.5 en innodb.html ref . It is based on the older ISAM code but has many useful extensions. The major deficiency of MyISAM is the absence of Database transaction transaction s support. Versions of MySQL 5.5 and greater have switched to the InnoDB engine to ensure referential integrity constraints, and higher Concurrency computer science concurrency . Each MyISAM table is stored on disk in three files. The files have names that begin with the table name and have an extension to indicate the file type. MySQL uses a .frm file to store the definition of the table, but this file is not a part of the MyISAM engine instead it is a part of the server. The data file has a .MYD MYData extension. The index file has a .MYI MYIndex extension. See also Comparison of MySQL database engines Notes Reflist External links http dev.mysql.com doc mysql en myisam storage engine.html MySQL Documentation on MyISAM Storage Engine http www.geeksww.com tutorials database management systems mysql installation mysql tablecache informationschema and open files limit.php MyISAM s open files limit and table cache problem explained http www.mysqlperformanceblog.com 2006 06 17 using myisam in production The article about problems which will occur in using MyISAM DEFAULTSORT Myisam Category MySQL MySQL database software stub ca MyISAM cs MyISAM de MyISAM es MyISAM fr MyISAM it MyISAM lv MyISAM pl MyISAM ru MyISAM tr MyISAM uk MyISAM zh MyISAM ... more details
Orphan date February 2009 notability Biographies date October 2008 Baron Schwartz is an American software engineer most notable for his contributions to the MySQL database. He is currently Chief Performance Architect at Percona, Inc. ref http www.percona.com about us our team ref and lives in Charlottesville, Virginia . Schwartz is the lead author of High Performance MySQL, 2nd and 3rd ed. published 2008 and 2012, O Reilly . ref http www.amazon.com High Performance MySQL Optimization Load balancing dp 0596101716 ref He contributed a chapter to Web Operations published 2010, O Reilly . ref http oreilly.com catalog 0636920000136 ref He created the Maatkit toolkit for MySQL, ref http www.maatkit.org ref for which he received MySQL s 2008 MySQL Code Contributor of the Year Award. ref http www.mysql.com why mysql awards community 2008.html ref He has released a set of templates to monitor MySQL under Cacti software Cacti . ref http www.xaprb.com blog tag cacti templates ref He developed and maintains Innotop, ref http code.google.com p innotop ref an open source interactive monitoring tool for MySQL and InnoDB . References reflist External links http blogs.sun.com barton808 entry mysql conf08 talkin to baron Talkin to Baron Sun Microsystems Sun s George Barton interviews Baron Schwartz http www.oreillynet.com pub au 2850 Author Biography from O Reilly Media Persondata Metadata see Wikipedia Persondata . NAME Schwartz, Baron ALTERNATIVE NAMES SHORT DESCRIPTION DATE OF BIRTH PLACE OF BIRTH DATE OF DEATH PLACE OF DEATH DEFAULTSORT Schwartz, Baron Category Year of birth missing living people Category Living people Category Software engineers ... more details
, Finland , is the main author of the original version of the open source MySQL database and a founding member of the MySQL AB company. After studying at although not graduating from the Helsinki University ... MySQL Allan Larsson . ref cite web publisher MySQL AB title MySQL AB Management Team url http ... of the MySQL database with David Axmark , released in 1996. He is the co author of the MySQL ... Software Entrepreneur of The Year prize. Until MySQL AB s sale to Sun Microsystems in January 2008, ref cite web publisher MySQL AB title Sun to Acquire MySQL url http www.mysql.com news and events sun to acquire mysql.html accessdate 2008 09 05 ref he was the chief technical officer of MySQL AB and still one of the primary forces behind the ongoing development of MySQL. ref cite web author Kaj Arn title Monty The First MySQL Fellow publisher Kaj Arn url http www.planetmysql.org kaj ?p 108 accessdate 2007 06 18 ref Due to selling MySQL to Sun, Widenius earned about 16.6 million in capital ..., and has a daughter My after whom MySQL is named, according to History of MySQL and a son Max giving the name for MaxDB from his first marriage. According to the MySQL documentation s history, it is unclear ... on a branch of the MySQL code base with the Aria storage engine. The product is known affectionately ... website On 12 December 2009, Monty asked MySQL customers to lobby the EC with regards to the Oracle acquisition of Sun, citing concerns about potential Oracle control of MySQL, ref cite web publisher Monty s blog title Help saving MySQL url http monty says.blogspot.com 2009 12 help saving mysql.html accessdate 2009 12 12 ref this resulted in an online petition campaign called Help MySQL ... more details
November 6, 1962 in Espoo , Finland was chief executive officer CEO of MySQL AB . He served as chief executive officer from January 2001 to February 2008, when Sun Microsystems bought MySQL Inc and MySQL .... ref . cite web title With Demand Growing, MySQL CEO calls it quits url http gigaom.com 2009 02 06 with demand growing mysql ceo calls it quits ref In February 2008 he was announced as member of the board ... cite web title Former MySQL CEO M rten Mickos Joins RightScale Board of Directors url http www.rightscale.com news events press releases 2009 Former MySQL CEO Marten Mickos Joins RightScale Board of Directors.php ... In Residence . ref cite web title Former MySQL CEO Marten Mickos Joins Benchmark As Entrepreneur In Residence publisher TechCrunch url http www.techcrunch.com 2009 09 29 former mysql ceo marten ... New CEO at MySQL AB publisher MySQL AB url http www.mysql.com news and events press release release ... title Press Release MySQL Wins Audemars Piguet Changing Times Award url http www.linuxpr.com releases ... Award to M rten Mickos publisher Nokia url http www.nokia.com A4136001?newsid 1089660 ref See also MySQL AB MySQL Sun Microsystems Eucalyptus computing Eucalyptus Systems References Reflist External links ... 2010 08 23 marten mickos mysql ceo video M rten Mickos, ex CEO of MySQL on Oracle, Open Source Startups & Lessons of MySQL Video http aaltoes.com 2009 12 shoot for the stars afternoon with marten Shoot ... at O Reilly MySQL CE 2011, Data in the Cloud http www.youtube.com watch?v llO EFQk3dM Making it in America by the Finn who sold MySQL for a billion dollars http thenextweb.com entrepreneur 2011 03 23 making it in america by the fin who sold mysql for a billion dollars Interview with M rten Mickos in BizDeans Talk Entrepreneur and ex CEO of MySQL http www.deanstalk.net deanstalk 2009 11 interview with marten ... Why Oracle Won t Kill MySQL http www.forbes.com 2009 04 20 mysql marten mickos technology enterprise tech mysql.html Interview with MySQL CEO by Guy Kawasaki http blog.guykawasaki.com 2006 08 ten questions ... more details
The MySQLi Extension MySQL Improved is a relational database driver used in the PHP programming language to provide an interface with MySQL database s. MySQLi is an improved version of the older PHP MySQL driver, offering various benefits. ref name overview http www.php.net manual en mysqli.overview.php ref The developers of the PHP programming language recommend using MySQLi when dealing with MySQL server versions 4.1.3 and newer takes advantage of new functionality . ref name overview Technical details The MySQLi extension provides various benefits with respect to its predecessor, the most prominent of which, according to the PHP website, ref name overview are An object oriented interface Support for prepared statements Support for multiple statements Support for transactions Enhanced debugging support Embedded server support References reflist Further reading refbegin http www.php.net manual en book.mysqli.php MySQLi documentation on PHP.net refend Category SQL data access Category Data access technologies database software stub de MySQLi fr MySQLi ru MySQLi ... more details
of ZRM for MySQL the ZRM Enterprise edition, the ZRM Cluster edition and the ZRM Community edition ... Recovery Manager for MySQL. Retrieved on June 28, 2009. ref ZRM server runs on Windows , Solaris operating ... content zmanda recovery manager 30 mysql ubuntu server Linux Journal review of ZRM on Ubuntu. ref When backing up MySQL databases on Solaris operating system Solaris , ZRM is able to take benefit of snapshot feature of ZFS ref http www.sun.com bigadmin features articles zrm mysql sfx4540.jsp ... has been integrated By Zmanda for use with Tivoli Storage Manager via a MySQLMySQL Database backup agent ref http www.zmanda.com tivoli mysql backup.html Zmanda Recovery Manager for MySQL Tivoli Storage ... content en us enterprise other resources b netbackup for mysql zmanda recovery manager 21184779.en us.pdf ref , providing a MySQL backup agent for NetBackup. See also Advanced Maryland Automatic Network ... of Zmanda Recovery Manager for MySQL http www.theregister.co.uk 2010 02 22 zmanda zrm tsm The Register ... more details
Encyclopedia
top
