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.
Whenever you want to define your scheduler task and if you are working on laravel framework then you can do it easy way and very secure Laravel provide strongSchedulingstrong and Scheduling through you can manage your cron if you need to run every day every minute every hourly weekly on
Whenever you need to get difference between two dates in months in laravel 5 then you can get easily using Carbon Laravel by default provide Carbon class Carbon class throught you can calculate difference between two dates in monthsIn Following example you can see we have a two dates first t
Its very common need to get last insert id in programming field if you are working on laravel framework and you want to fetch last created id i mean max id then you do easilylaravel provide method to get last inserted idIf you are working with DBtable then you have to use insertGetId fo
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 the community; a no-nonsense, non-political, adhering to tradition, self criticizing committee.
The Call for Nominations is open. We are seeking the community’s assistance in nominating candidates in the following categories:
MySQL Community Awards: Community Contributor of the …
[Read more]
Many a times we have faced this problem that when we commit
something and it breaks something on the server due to some
syntax error.
I know that these can be caught by IDEs and
good editors, but sometimes there might be an syntax error
introduced after a code merge conflict resolution and
commit.
To address this, we can use git pre-commit hooks to check for any
syntax errors in the to be committed files.
There is a good script I found which does this at https://github.com/ReekenX/phpcheck-git
Steps to add pre-commit php syntax check with git:
(Issue …
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 orphaned rows.
Finding orphaned rows
Finding orphaned rows is fairly simple either using an exclusion
join or a NOT EXISTS query.
Using the sakila database, here are two queries to …
[Read more]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 at IO.
For the CPU-bound load, I will use a sysbench OLTP read-only workload with data fitting into memory (so there is no IO performed, and the execution path only goes through the network and CPU).
My server is 24 cores (including hyper-threads), with Intel(R) Xeon(R) CPU E5-2643 v2 @ …
[Read more]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:
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.
