Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on an Ubuntu 16.04 server with PHP 7 support (through PHP-FPM) and MySQL support (LEMP = Linux + nginx (pronounced "engine x") + MySQL + PHP) .

When i was working my laravel application at that time i need to remove column from database But i am not sure that column is exists or not in tables So i was thinking but i found solution from Laravel Database Migration Schema we can check column is exists or not in tabales using hasColumn If

Sometimes we require to get randomly data using laravel query builder you can use mysql rand with order by If you want to get random data using laravel eloquent then we need to use DBraw In bellow example you can i use DBrawIn this example i use DBrawRAND inside orderBy an

Wed, 2016-05-04 07:17Johan Wikman

We are pleased to announce that MariaDB MaxScale 1.4.3 GA is now available for download!

If MariaDB MaxScale is new to you, we recommend reading this page first.

1.4.3 is a bugfix release, not bringing any new features but fixing certain issues found in 1.4.2.

MariaDB MaxScale 1.4 brings:

1. The Firewall Filter has been extended and can now be used for either black-listing or white-listing queries. In addition it is capable of logging both queries that match and queries that do not match.
2. Client-side …

I'm very pleased to be able to announce the immediate availability of the Open Data Export Layer (ODXL) for SAP/HANA! Executive summaryODXL is a framework that provides generic data export capabilities for the SAP/HANA platform. ODXL is implemented as a xsjs Web service that understands OData web requests, and delivers a response by means of a pluggable data output handler. Developers can use ODXL as a back-end component, or even as a global instance-wide service to provide clean, performant and extensible data export capabilities for their SAP/HANA applications.

Currently, ODXL …

I want to share this posts because when i was working in my laravel application i need to find word from string I mean check string contains word or not but i try to do at last i found two way we can check easily First one using pregmatch and other one strpos of php predefine if you have ques

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 10.0.25. See the release notes and changelog for details on this release. Download MariaDB Galera Cluster 10.0.25 Release Notes Changelog What is MariaDB Galera Cluster? MariaDB APT and YUM Repository Configuration Generator Thanks, and enjoy MariaDB!

The post MariaDB Galera Cluster 10.0.25 now available appeared first on MariaDB.org.

In this post, we’ll examine why in an initial flushing analysis we find that Performance Schema data is incomplete.

Having shown the performance impact of Percona Server 5.7 patches, we can now discuss their technical reasoning and details. Let’s revisit the MySQL 5.7.11 performance schema synch wait graph from the previous post, for the case of unlimited InnoDB concurrency:

First of all, this graph is a little “nicer” than reality, which limits its diagnostic value. There are two reasons for this. The first one is that page cleaner worker threads are invisible to Performance Schema (see bug 79894). This alone …

As promised, here are my slides from Percona Live Conference in US, Apr.2016 :

• MySQL 5.7 Performance & Scalability Benchmarks (PDF)
• MySQL 5.7 Demystified Tuning (PDF)

Feel free to ask any questions or details you're needing, etc..

Also, not really related to MySQL, but as I was asked so many times about "how did you manage to project your slides from Mac, but drive it an annotate via iPad?" - here is a short HOWTO:

• you need to have Keynote app installed on both your Mac and iPad
• you create your own WiFi Network on your Mac (MenuBar->WiFi->Create Network...)
• once done, connect to …

In this blog post, we’ll discuss some of the best practices for configuring optimal MySQL memory usage.

Correctly configuring the use of available memory resources is one of the most important things you have to get right with MySQL for optimal performance and stability. As of MySQL 5.7, the default configuration uses a very limited amount of memory – leaving defaults is one of the worst things you can do. But configuring it incorrectly can result in even worse performance (or even crashes).

The first rule of configuring MySQL memory usage is you never want your MySQL to cause the operating system to swap. Even minor swapping activity can dramatically reduce MySQL performance. Note the keyword “activity” here. It is fine to have some used space in your swap file, as there are …