Updating mysql database with php

15 Apr

Because of the special attention given by the Maria DB developers to maintain compatibility with My SQL, either client application can connect to either database, as shown in Figures 1 and 2. These include the Aria, Xtra DB (an enhanced and extended version of the Inno DB storage engine), PBXT, Federated X (a drop-in replacement for Federated), OQGraph, and Sphinx SE storage engines.

All of these are available for My SQL; however, to use them, you need to compile or install them yourself. PLUGINS table now has PLUGIN_MATURITY and PLUGIN_AUTH_VERSION columns, so you can see the version numbers of your plugins and whether a version you have installed is of stable, beta, or other quality. PROCESSLIST table has been given a new column, TIME_MS .

The My ISAM key cache can suffer from lock contention if you have many application threads accessing the cache.

The segmented key cache alleviates this problem by dividing the key cache into a number of “segments.” Up to 64 segments can be specified.

For example, if you have several applications interacting with the database, pushing some of the calculations down into the database might help simplify application development and enforce data integrity.

One new feature in Maria DB that adds flexibility is virtual columns, which are columns that are calculated and updated “on the fly.” An early version of this feature was contributed to My SQL back in 2008 by Andrey Zhakov, but it never found its way into a stable release of My SQL.

Often, you want your applications to do all the calculations and have your database just hold the data.

One group of (mostly) former My SQL employees, led and funded by My SQL co-founder Michael “Monty” Widenius, was concerned enough to leave Sun/​Oracle, start a new company (Monty Program), and create a branch of My SQL called Maria DB.

Maria DBThe goal for Maria-DB is to be a drop-in replacement for My SQL – with more features and better performance.