Explore MySQL on Experts Exchange

Expert Solutions for Your Tech Problems

MySQLMySQL Server

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired...

Read more
  • 49K Content
  • 9.4K Contributors

Expert Spotlight
Tomas Helgi Johannsson
Database Administrator / Software Engineer

Over 20 years of experience as an Application Architect/Developer, a Database Administrator, and a PM focusing on performance.

Article

Troubleshooting MySQL Connection Attempts

bygr8gonzo
Having trouble connecting to MySQL? Getting the dreaded "Access denied for user ... (using password: YES)" message? This article will help you understand the authentication steps and where to look in your troubleshooting efforts.
Article

Table data compression, a multi-valuable database feature.

byTomas Helgi Johannsson
Data compression is a feature offered by many modern databases like Db2, Oracle, MySQL, MariaDB and SQLServer. However, many companies do not use this feature in their database systems. Either they lack the knowledge of its existence in the application/systems design phase or due to budget issues.
Article

DIY MySQL (ZIP) Installation on MS Windows

byChetan Khurana
Be a MySQL Ninja! Install MySQL the PowerDEV way - without installers!
Article
MT DV MySQL

USING MYSQLTUNER

byTammy Porter
MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability. The current configuration variables and status data is retrieved and presented in a brief format along with some basic performance suggestions.
Article

Writing Highly Scalable, Blazing Fast PHP Code

byDavid Favor
The title says it all. Writing any type of PHP Application or API code that provides high throughput, while under a heavy load, seems to be an arcane art form (Black Magic). This article aims to provide some general guidelines for producing this type of code.
Article

Power of the Recursive SQL arrives in MySQL and MariaDB

byTomas Helgi Johannsson

Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many

…
Article

Backups and Disaster Recovery

byPercona
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
Article

Multi-Threaded Slave Statistics

byPercona
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
Article

Where Do I Put ProxySQL?

byPercona
In this article, we’ll look at how to deploy ProxySQL.
Article

Faster Node Rejoins with Improved IST performance

byPercona
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
Article

Thread_Statistics and High Memory Usage

byPercona
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
Article

ClickHouse: One Year!

byPercona
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
Article

ClickHouse in a General Analytical Workload (Based on a Star Schema Benchmark)

byPercona
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
Article

MongoDB Through a MySQL Lens

byPercona
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Article

Database Solutions Engineer FAQs

byPercona
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller single-server environments.
Article

MySQL and MongoDB Alerting with Percona Monitoring and Management and Grafana

byPercona
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
Article

Three Things to Consider When Thinking About Containers

byPercona
Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
Article

How to deploy a WordPress Site in Azure

byShaun Vermaak
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Article

Master your MySQL data - Table partitioning approach for better performance.

byTomas Helgi Johannsson
When table data gets too large to manage or queries take too long to execute the solution is often …
Article

PHP Error Handling: Never Say die() Again

byRay Paseur
1
Introduction
This article is intended for those who are new to PHP error handling…

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more