Showing entries 1 to 10 of 256
10 Older Entries »
Displaying posts with tag: ubuntu (reset)
How to Monitor MySQL Deployments with Prometheus & Grafana at ScaleGrid

Monitoring your MySQL database performance in real-time helps you immediately identify problems and other factors that could be causing issues now or in the future. It’s also a good way to determine which components of the database can be enhanced or optimized to increase your efficiency and performance. This is usually done through monitoring software and tools either built-in to the database management software or installed from third-party providers.

Prometheus is an open-source software application used for event monitoring and alerting. It can be used along with a visualization tool like Grafana to easily create and edit dashboards, query, visualize, alert on, and understand your metrics. ScaleGrid provides full admin access to your MySQL deployments – this makes it …

[Read more]
Dynamic Tracing of MySQL Server With perf probe - Basic Example

I am going to write a series of blog posts based on my talks and experiences at Percona Live Europe 2019. The first one would be a kind of extended comment for a couple of slides from the "Tracing and Profiling MySQL" talk.

We can surely wait until Performance Schema instruments every other line of code or at least every important stage and wait in every storage engine we care about, but there is no real need for that. If you run any version of MySQL under Linux with more or less recent kernel (anything newer than 4.1 is good enough, in general), you can easily use dynamic tracing for any application (at least if there is symbolic information for the binaries), any time. As Brendan Gregg put it here:

[Read more]
How to Install phpMyAdmin with Nginx on Ubuntu 18.04 LTS

phpMyAdmin is a free and open-source web-based database management tool for MySQL. In this tutorial, we will learn how to install phpMyAdmin with Nginx on Ubuntu 18.04 server.

Max_connections 214 4.15.0-46-generic #49-Ubuntu

So the issue of max_connections dropping from the value set in your my.cnf file down to 214 has been around for a little while on Ubuntu.

As an example, it was noted here back in 2015

I ran into this again recently and was resolved with the following steps.

# cp /lib/systemd/system/mysql.service /etc/systemd/system/
# cd /etc/systemd/system/
# vi mysql.service


# systemctl daemon-reload
# systemctl restart mysql

Once those steps completed the MySQL connections were stable at the given parameter in the my.cnf file. 

How to Install Phorum with Nginx on Ubuntu 18.04 LTS

Phorum is a PHP and MySQL based Open Source forum software. In this guide, we will guide you step-by-step through the Phorum installation process on the Ubuntu 18.04 LTS operating system using Nginx as the web server, MySQL as the database, and and Let's Encrypt for HTTPS.

How to Install Nginx with PHP and MySQL (LEMP Stack) on Ubuntu 18.04

This tutorial shows how you can install Nginx on an Ubuntu 18.04 LTS server with PHP 7.2 support (through PHP-FPM) and MySQL support (LEMP = Linux + nginx (pronounced "engine x") + MySQL + PHP).

Dockerizing Laravel with Nginx MySQL and Docker Compose on Ubuntu 18.04 LTS

In this guide, we're going to show you how to Dockerize the Laravel project with PHP-FPM, MySQL database, and the Nginx web server using the Docker Compose on the Ubuntu Server 18.04. We're going to create a new docker image for the Laravel Project, and then create the docker-compose.yml script that contains some services including, the App/Laravel itself, Nginx web server, and MySQL database.

How to Install LEMP on Ubuntu 18.04

The LEMP stack is a web development platform for hosting static and dynamic websites. It is a combination of free and open-source software including Linux, Nginx, MySQL, and PHP. It is an alternative to the highly popular LAMP stack, the only difference being having Nginx as a web server instead of Apache. Requirements: For the […]

How to Install MySQL on Ubuntu 18.04

In this tutorial, we will show you how to install and improve the security of MySQL on Ubuntu 18.04. MySQL is one of the most popular and widely-used open-source relational database management systems. It is used for building web applications such as WordPress, Drupal, Joomla, and Magento, and is an important part of the LAMP/LEMP […]

How to Install Cachet Status Page System on Ubuntu 18.04 LTS

Cachet is a beautiful and powerful open source status page system written in PHP that allows you to better communicate downtime and system outages to your customers, teams, and shareholders. In this tutorial, we will install Cachet status page system by utilizing PHP, Nginx, MySQL, and Composer on Ubuntu 18.04 LTS.

Showing entries 1 to 10 of 256
10 Older Entries »