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

Whenever you are making table using migration with foreign key like i give you example as under and you forgot to set delete cascade on table then how can you add delete cascade in existing table so lets see your migration pre classlanguagephppublic function up Schemacreatelo

In February my colleague Morgan Tocker will travel through Europe and talk about MySQL 5.7, which recently went GA.

In Munich we're having a meeting for PHPers and other Web developers, where Morgan will talk about MySQL and JSON and I'll also be around.

Summary of the talk:

With the newly added JSON support in MySQL, you can combine the flexibility of NoSQL with the strength of a relational database. In this session, Morgan will explain the new JSON datatype, and the new set of functions for handling JSON documents, available storage and indexing options. In addition, he will present benchmarks showing how much one can expect from the MySQL server in different use case scenarios.

About Morgan: Morgan rejoined the MySQL team at Oracle in 2013 as MySQL Community Manager, having …

Many time you have face a problem in windows wampserver or virtualhost of indexphp file overwrite i also fetch that problem likehttplocalhosttestindexphpadminIn this url you can see indexphp wtite in url but URL must be without indexphp so if you are using windows wampserver then y