Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the sue domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /www/htdocs/w01a7138/opendb.de/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the shortcodes-ultimate domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /www/htdocs/w01a7138/opendb.de/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the complianz-gdpr domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /www/htdocs/w01a7138/opendb.de/wp-includes/functions.php on line 6114

Deprecated: Creation of dynamic property EDD_Theme_Updater_Admin::$item_name is deprecated in /www/htdocs/w01a7138/opendb.de/wp-content/themes/mh-magazine/includes/updater/theme-updater-admin.php on line 54

Deprecated: Creation of dynamic property EDD_Theme_Updater_Admin::$beta is deprecated in /www/htdocs/w01a7138/opendb.de/wp-content/themes/mh-magazine/includes/updater/theme-updater-admin.php on line 60

Warning: Cannot modify header information - headers already sent by (output started at /www/htdocs/w01a7138/opendb.de/wp-includes/functions.php:6114) in /www/htdocs/w01a7138/opendb.de/wp-includes/rest-api/class-wp-rest-server.php on line 1893

Warning: Cannot modify header information - headers already sent by (output started at /www/htdocs/w01a7138/opendb.de/wp-includes/functions.php:6114) in /www/htdocs/w01a7138/opendb.de/wp-includes/rest-api/class-wp-rest-server.php on line 1893

Warning: Cannot modify header information - headers already sent by (output started at /www/htdocs/w01a7138/opendb.de/wp-includes/functions.php:6114) in /www/htdocs/w01a7138/opendb.de/wp-includes/rest-api/class-wp-rest-server.php on line 1893

Warning: Cannot modify header information - headers already sent by (output started at /www/htdocs/w01a7138/opendb.de/wp-includes/functions.php:6114) in /www/htdocs/w01a7138/opendb.de/wp-includes/rest-api/class-wp-rest-server.php on line 1893

Warning: Cannot modify header information - headers already sent by (output started at /www/htdocs/w01a7138/opendb.de/wp-includes/functions.php:6114) in /www/htdocs/w01a7138/opendb.de/wp-includes/rest-api/class-wp-rest-server.php on line 1893

Warning: Cannot modify header information - headers already sent by (output started at /www/htdocs/w01a7138/opendb.de/wp-includes/functions.php:6114) in /www/htdocs/w01a7138/opendb.de/wp-includes/rest-api/class-wp-rest-server.php on line 1893

Warning: Cannot modify header information - headers already sent by (output started at /www/htdocs/w01a7138/opendb.de/wp-includes/functions.php:6114) in /www/htdocs/w01a7138/opendb.de/wp-includes/rest-api/class-wp-rest-server.php on line 1893

Warning: Cannot modify header information - headers already sent by (output started at /www/htdocs/w01a7138/opendb.de/wp-includes/functions.php:6114) in /www/htdocs/w01a7138/opendb.de/wp-includes/rest-api/class-wp-rest-server.php on line 1893
{"id":363,"date":"2010-10-03T13:09:36","date_gmt":"2010-10-03T11:09:36","guid":{"rendered":""},"modified":"2021-02-10T00:03:38","modified_gmt":"2021-02-09T23:03:38","slug":"mysql-abkoemmling-mariadb-ueberholspur_363","status":"publish","type":"post","link":"https:\/\/opendb.de\/mysql\/mysql-abkoemmling-mariadb-ueberholspur_363\/","title":{"rendered":"MySQL-Abk\u00f6mmling MariaDB auf der \u00dcberholspur"},"content":{"rendered":"

Die Entwickler des freien MariaDB haben einen ersten Release-Kandidaten der Version 5.2 vorgelegt, die von MySQL 5.1.50 abgeleitet ist. Eine \u00fcberarbeitete Thread-Programmierung in InnoDB soll Anwendern dieser Datenbank-Engine mehr Tempo bringen. \u00c4hnlicher Code findet sich in dem ebenfalls k\u00fcrzlich ver\u00f6ffentlichten Release-Kandidaten von MySQL 5.5.<\/p>\n

Mit seinem Plug-in-Konzept f\u00fcr Authentifizierungsmodule h\u00e4ngt MariaDB seinen Vorg\u00e4nger jedoch ab \u2013 in den Genuss dieser noch zu entwickelnden Funktion sollen nur kommerzielle Kunden von MySQL kommen. Bislang mussten MariaDB- und MySQL-Nutzer jeweils eigene Datenbank-Accounts besitzen, eine Wiederverwendung von Systemkonten, wie sie etwas bei Oracle und Informix m\u00f6glich ist, war ebenso wenig vorgesehen wie die Anbindung von Verzeichnisdiensten. Eins der drei Authentifizierungsmodule von MariaDB erm\u00f6glicht es nun einem unter Unix angemeldeten Benutzer, ohne weitere Passwort-Abfrage eine Verbindung zur Datenbank aufzubauen. Allerdings m\u00fcssen die Plug-ins beim Einrichten der Datenbank ausdr\u00fccklich installiert werden. Per API sollen sich eigene Authentifizierungsmodule schreiben lassen.<\/p>\n

MariaDBs Virtual Columns gibt es in MySQL ebenfalls nicht. Diese berechneten Spalten werden im CREATE TABLE-Statement mit den Schl\u00fcsselw\u00f6rtern VIRTUAL oder PERSISTENT gekennzeichnet. Erstere erzeugt der Server bei jeder Abfrage neu, f\u00fcr die zweiten berechnet er die Werte dauerhaft und speichert sie mit allen anderen Spalten in der Tabelle. Der Code f\u00fcr diese Funktion stammte urspr\u00fcnglich von Andrej Zakhov und war f\u00fcr MySQL 6 vorgesehen, dessen Entwicklung jedoch eingestellt wurde.<\/p>\n

Quelle: http:\/\/www.heise.de\/newsticker\/meldung\/MySQL-Abkoemmling-MariaDB-auf-der-Ueberholspur-1100560.html<\/a><\/p>","protected":false},"excerpt":{"rendered":"

Die Entwickler des freien MariaDB haben einen ersten Release-Kandidaten der Version 5.2 vorgelegt, die von MySQL 5.1.50 abgeleitet ist. Eine \u00fcberarbeitete Thread-Programmierung in InnoDB soll Anwendern dieser Datenbank-Engine mehr Tempo bringen. \u00c4hnlicher Code findet sich in dem ebenfalls k\u00fcrzlich ver\u00f6ffentlichten Release-Kandidaten von MySQL 5.5.<\/p>\n

[…]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":{"0":"post-363","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-mysql"},"_links":{"self":[{"href":"https:\/\/opendb.de\/wp-json\/wp\/v2\/posts\/363","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/opendb.de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/opendb.de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/opendb.de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/opendb.de\/wp-json\/wp\/v2\/comments?post=363"}],"version-history":[{"count":0,"href":"https:\/\/opendb.de\/wp-json\/wp\/v2\/posts\/363\/revisions"}],"wp:attachment":[{"href":"https:\/\/opendb.de\/wp-json\/wp\/v2\/media?parent=363"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/opendb.de\/wp-json\/wp\/v2\/categories?post=363"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/opendb.de\/wp-json\/wp\/v2\/tags?post=363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}