Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 35690 10 Older Entries
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...]
Measuring Percona Server Docker CPU/network overhead
+0 Vote Up -0Vote Down

Now that we have our Percona Server Docker images, I wanted to measure the performance overhead when we run the database in the container. Since Docker promises to use a lightweight container, in theory there should be very light overhead. We need to verify that claim, however. In this post I will show the numbers for CPU and network intensive workloads, and later I will take a look …

  [Read more...]
MySQL Cluster 7.5 — the First Milestone Is Here!
Employee_Team +1 Vote Up -0Vote Down

I’m happy to announce that the first Development Milestone Release (DMR) of MySQL Cluster 7.5 is now available!

Some highlights of this first milestone release of MySQL Cluster 7.5 are:

  • This release is based on MySQL 5.7, so users can enjoy all of the …
  [Read more...]
MySQL Community Awards 2016: Call for Nominations!
+1 Vote Up -0Vote Down

The 2016 MySQL Community Awards event will take place, as usual, in Santa Clara, during the Percona Live Data Performance Conference, April 2016.

The MySQL Community Awards is a community based initiative. The idea is to publicly recognize contributors to the MySQL ecosystem. The entire process of discussing, voting and awarding is controlled by an independent group of community members, typically based of past winners or their representatives, as well as known contributors.

It is a self-appointed, self-declared, self-making-up-the-rules-as-it-goes committee. It is also very aware of the importance of …

  [Read more...]
MariaDB JIRA is moving
+0 Vote Up -0Vote Down

The MariaDB JIRA instance that currently is in use for project and issue tracking will change. The current instance is hosted in Atlassian’s cloud and it has worked well, but we have hit the maximum user limit of 2000 users. It’s fantastic to see how many of you actually report bugs and other issues in the MariaDB […]

The post MariaDB JIRA is moving appeared first on MariaDB.org.

MySQL Connector/Python currently not available from PyPI
Employee +1 Vote Up -0Vote Down

With PEP 470 now requiring files to be hosted on PyPI, you may have noticed that MySQL Connector/Python is now no longer available using the pip-tool.

The MySQL Engineering team at Oracle really would like to have the connector available through PyPI and have been talking with the Python Foundation towards that. We know users and developers of OpenStack, for example, have requested this as well as lots of other Python users.

For now …

  [Read more...]
MySQL Support People - Percona Support
+1 Vote Up -0Vote Down

I planned to continue this series of posts with the one about MySQL Support engineers who joined us in Oracle while I was working there, but based on recent events in my life I'd prefer to postpone it and move directly to the team I worked for during last 3+ years, Percona Support Team.

Disclamer: In the list below I still try to pay attention to public contribution by each of engineers mentioned to MySQL Community, mostly in a form of bug reports. This is not the only way they contributed, but I have to stick to this format in current series of posts. I also base my comments mostly on my memory and quick search of public …

  [Read more...]
Generated columns in MariaDB and MySQL
+0 Vote Up -0Vote Down

It has been seven years since the last time I blogged about generated columns, and a lot has happened -- now both MariaDB and MySQL support them. So it's time to look again, see how well they're doing, and compare to the SQL standard's Optional feature T175 Generated columns.

This is not an introductory description or an explanation why you'd want to use generated columns rather than (say) triggers and views. For that, I'd recommend the relevant manuals or the blog posts …

  [Read more...]
FOSDEM 2016 – GALLERY
+1 Vote Up -0Vote Down

  [Read more...]
Vote for Database of the Year on LinuxQuestions.org
+0 Vote Up -0Vote Down

Thu, 2016-02-04 14:24mariadb

Vote MariaDB for Database of the Year! MariaDB is nominated for Database of the Year by LinuxQuestions.org. LQ for short is Linux user community that each year votes for the best database of the year.

You can, of course, vote for MariaDB!

The site requires a simple registration - which may take a few moments, but it is well worth your time!

  1. Register on linuxquestions.org
  2. Activate account by email
  3. Post a message to get the right to vote, e.g. …
  [Read more...]
Showing entries 1 to 10 of 35690 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.