Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 35699 10 Older Entries
Feedback Request: Enforcing SQL Mode
Employee_Team +0 Vote Up -0Vote Down

MySQL Server has an extensive collection of SQL modes which control a range of behavior ranging from compatibility modes for other RDBMS dialects (ANSI_QUOTES, PIPES_AS_CONCAT) to security (NO_AUTO_CREATE_USER) to explicit storage engine selection ( …

  [Read more...]
Log Buffer #459: A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

This Log Buffer Edition arranges few tips and tricks from the blogs of Oracle, SQL Server and MySQL.

Oracle:

Oracle ® Solaris innovation is due in part to the UNIX® the standard (1), the test suites (2) and the certification (3). By conforming to the standard, using the test suites and driving to certification, Oracle ® Solaris software engineers can rely on stable interfaces and an assurance that any regressions will be found quickly given more than 50,000 test cases.

Building on the program established …

  [Read more...]
Percona Server 5.7.10-2 second RC available
+0 Vote Up -0Vote Down

Percona is glad to announce the second release candidate of Percona Server 5.7.10-2 on February 8, 2016. Download the latest version from the Percona web site or from the Percona Software …

  [Read more...]
Percona XtraBackup 2.4.0-rc1 is now available
+0 Vote Up -0Vote Down

Percona is glad to announce the first release candidate of Percona XtraBackup 2.4.0-rc1 on February 8th 2016. Downloads are available from our download site and from apt and yum repositories.

  [Read more...]
Concurrent inserts and the RocksDB memtable
+0 Vote Up -0Vote Down

RocksDB started as a fork of LevelDB. While it will always be a fork, we describe it as derived from LevelDB given how much code has changed. It inherited a memtable that did not allow concurrent inserts courtesy of a mutex - readers ignored the mutex, writers must lock it. Writers waiting for the mutex linked their updates together and the thread at the head of the convoy applied all of their changes after getting the mutex.

Insert performance for RocksDB and LevelDB did not improve beyond one thread when sync on commit was disabled because of contention on the mutex. It could improve with more threads when sync on commit was …

  [Read more...]
MySQL 5.7: Introduction for Operational DBAs
+0 Vote Up -0Vote Down

Join us Tuesday, February 16, 2016 9:00am PST (UTC-8) for a webinar on the operational and monitoring features of MySQL 5.7 with Percona CEO Peter Zaitsev.

MySQL 5.7 is a great release, providing valuable features for both daily operations and ongoing development. In this, part two of our ongoing 5.7 webinar series, we will look into the new MySQL 5.7 features and enhancements that improve operations, with …

  [Read more...]
High availability read-write splitting with php-mysqlnd, MySQL Replication and HAProxy
+0 Vote Up -0Vote Down

MySQL Replication is used in a variety of use cases - scale out read workloads, provide high availability and geographic redundancy, offload backups and reporting/analytic jobs. However it has a big drawback - the application needs to be able to send writes to the master only. Updating more than one master in a replication setup can result in data inconsistency and cause replication to break.

An SQL-aware load balancer like …

  [Read more...]
MariaDB in the Running for 2015 LinuxQuestions.org Members Choice Database of the Year
+0 Vote Up -0Vote Down

MariaDB won the 2013 and the 2014 LinuxQuestions.org Members Choice Award Database of the Year, and is in the running again for 2015 winner. Up until 2012, MySQL held a near-monopoly on the title, having won every year since at least 2001 (except for 2002, won by PostgreSQL). Since 2013, however, it’s been all MariaDB, […]

The post MariaDB in the Running for 2015 LinuxQuestions.org Members Choice Database of the Year appeared first on MariaDB.org.

Fun with Bugs #41 - Bugs Fixed in MySQL 5.7.11
+0 Vote Up -0Vote Down

I've just noted that Oracle had released new versions of MySQL on February 5, 2016 formally, so while these days I am mostly thinking about the ways to do support properly, remembering my colleagues and trying to understand some of RocksDB internals, it's time to postpone all these and write about bugs again. This time about some of the public bug reports from MySQL Community and Oracle engineers that were fixed by Oracle in MySQL 5.7.11.

As usual, I'll try to mention who had reported a bug and who verified it, as I think that names …

  [Read more...]
Finding and deleting orphaned rows in MySQL
+0 Vote Up -0Vote Down

If you store data with a parent-child relationship in MySQL tables, then you may want to identify and/or delete orphaned rows from the child table. An orphaned row is defined as a child row that references a non-existant parent row. If you enforce the parent-child relationship with a foreign key constraint on the child table then orphans are less likely to occur, but you can still end up with orphans; for example if a user disables foreign_key_checks in a session and deletes a parent row. If you choose not to create foreign keys in your database in order to avoid the performance overhead, then you are at higher risk of having …

  [Read more...]
Showing entries 1 to 10 of 35699 10 Older Entries

Planet MySQL © 1995, 2016, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.