A modern MySQL server contains a lot of useful meta-data in information_schema and performance_schema, which can help bring visibility into what is happening inside of your database server. However, sometimes this data is quite fine grained and needs finessing in order to get to that point

MySQL 5.7 includes a new SYS schema installed by default.…

Back in October I have write about possible ways of running multiple MySQL instances on the same hardware. As the months passing by, the project of splitting our database schemas into standalone instances is closing in, so I started to check the different ways. EDIT: This post is outdated, here is the follow up. I started […]

I want to use LIKE query as work on sql i mean If using a SQL or Mysql Like query to query data it will return data even if its only partially matched if i search just t then it will return all the records match t so you can add LIKE statement by using querystringyou can easily implem

Tue, 2016-01-26 11:59maria-luisaraviol

In December 2015, MariaDB Evangelist Colin Charles was asked to present on MariaDB Security and Encryption at the London MySQL Meetup group. This blog is a summary of Colin’s presentation.

A few words about meetup groups

In December 2015, the London MySQL Meetup Group meeting took place at an amazing location: the Yoox Net-a-Porter Group offices at Westfield London Shopping Centre. A brilliant location and fantastic host: Yoox-Net-a-Porter not only sponsored the venue, but also offered great food and drinks (special thanks to them!).

The goal of the London MySQL Meetup Group is to keep up with the MySQL ecosystem awareness and it’s great to see rooms full of old and new faces every new meeting. Some of the group members work for the three major distribution companies, some are DBAs, some …

Last month/year I published a blog post on mysqlserverteam.com with an example of how MySQL 5.7 gives you improved performance for queries with derived tables.

The query example was part of my tutorial “How to Analyze and Tune MySQL Queries for Better Performance” at Oracle OpenWorld 2015. Slides for the entire presentation can be found here.

I want to use LIKE query as work on sql i mean If using a SQL or Mysql Like query to query data it will return data even if its only partially matched if i search just t then it will return all the records match t so you can add LIKE statement by using querystringyou can easily implem

when you install laravel and get the records from database then occur You need to specify a file path to store the seed laravel error that error happened because your php can not loading openssl extension so If you are using windows then you should enable openssl extension in following path

Over several previous blog posts, we’ve already discussed what information the 

EXPLAIN FORMAT=JSON

 output provides for some subqueries. You can review those discussions here, here and here. EXPLAIN FORMAT=JSON shows many details that you can’t get with other commands. Let’s now finish this topic and discuss the output for the rest of the subquery types.

…

If you want to sort multiple columns in Laravel by using orderBy Whenever you need to give multiple column in your query then you can use twice time orderBy and give them you can give multiple columns in laravel by following example strongUsers Table strongtable classtable tableb

Reminder: MTS = Multi-Threaded Slave.

Update 2017-04-17: since the publication of this post, many things happened:

the procedure for fixing a crashed slave has been automated (Bug#77496) Bug#80103 as been closed at the same time as Bug#77496 but I still think there are unfixed things, see Bug#81840

End of update 2017-04-17.

I will be talking about parallel replication at FOSDEM in Brussel on