Feb 25, 2020 |
MySQL, Storage Engine
Sometimes, you may experience “ERROR 1034: Incorrect key file” while running the ALTER TABLE or CREATE INDEX command:
|
|
mysql> alter table ontime add key(FlightDate); ERROR 1034 (HY000): Incorrect key file for table 'ontime'; try to repair it |
As the error message mentions key file, it is reasonable to assume we’re dealing with the MyISAM storage engine (the legacy storage engine which used to have such a thing), but no, we can clearly see […]
Feb 05, 2020 |
Insight for Developers, MariaDB, MySQL
Jan 20, 2020 |
Monitoring, MySQL, Percona Software
If you’re using MySQL’s Performance Schema you may use “query digests” as IDs to identify specific query patterns in the events_statements_summary_by_digest Performance Schema Table. You might assume these hashes are stable between different versions, so, for example, when upgrading from MySQL 5.7 to MySQL 8, you can compare the query response time and other execution […]
Jan 15, 2020 |
Monitoring, Percona Software
April 2021 Update: From Percona Monitoring and Management 2.27, the procedure is now simplified and it is possible by running:
|
|
docker exec pmm-server change-admin-password <new_password> |
If you’re automating Percona Monitoring and Management 2 (PMM) deployment with docker, you may want to set a different admin user password upon installation instead of being required to change it upon first […]
Jan 13, 2020 |
MySQL, Storage Engine
A few days ago I wrote about how grossly outdated statistics returned through MySQL’s Information_Schema can be. In that post, Øystein Grøvlen suggested taking a look at mysql.innodb_table_stats and mysql.innodb_index_stats as a better source of information. Let’s do just that! Let’s start with the good news. Unlike MySQL Data Dictionary Tables (mysql.table_stats, etc), mysql.innodb_table_stats and […]
Jan 08, 2020 |
MySQL
MySQL obviously got many things right, otherwise, it would not be the World’s Most Popular Open Source Database (according to DB-Engines). Sometimes, however, I run into some decisions or behaviors which are just plain bad designs. Many such designs have a lot of historical reasoning behind them and maybe they are still here because not […]
Jan 03, 2020 |
MySQL, Open Source
In MySQL 8, Information Schema was basically re-written to utilize the all-New Data Dictionary which made it faster and better in many ways. Yet it also introduces some very counterintuitive behaviors when it comes to how actual and consistent data is. Here is a simple test. Let’s create a table and insert a bunch of […]
Nov 22, 2019 |
Monitoring, MySQL, Percona Software
As Grafana powers our star product – Percona Monitoring and Management (PMM) – we have developed a lot of experience creating Grafana Dashboards over the last few years. In this article, I will share some of the considerations for designing Grafana Dashboards. As usual, when it comes to questions of design they are quite subjective, […]
Nov 19, 2019 |
MySQL
I often need to install a certain version of MySQL, MariaDB, or Percona Server for MySQL to run some experiments, whether to check for behavior differences or to provide tested instructions. In this blog series, I will look into how you can install MySQL, MariaDB, or Percona Server for MySQL with Docker. This post, part […]
Oct 31, 2019 |
Percona Services, Percona Software
One of the great things about Percona, and a Percona Support contract, is that we not only guarantee application performance but we also provide bug fixes for covered software—and not just advice on how to use it. This is most likely missing from most customer’s in-house support, as it requires a team with code knowledge […]
Oct 24, 2019 |
Percona Events
Every fall I enjoy traveling to key events to meet Percona’s customers and software users. Аfter meetup in Ryazan on November 5th sponsored by HighLoad++ in Moscow along with six other Percona experts. My talks will be: BpfTrace – Finally a Full-Fledged Replacement for Dtrace in Linux Query Analysis for MySQL, PostgreSQL, MongoDB Sessions by […]
Oct 23, 2019 |
Monitoring, MySQL
MySQL Workbench is a great multi-purpose GUI tool for MySQL, which I think is not marketed enough by the MySQL team and is not appreciated enough by the community for what it can do. MySQL Workbench Licensing MySQL Workbench is similar to MySQL Server and is an Open-Core product. There is Community Edition which has […]
Sep 25, 2019 |
Monitoring, Percona Software
As the saying goes, a picture is worth 1000 words – and this is why we don’t just talk about Percona Monitoring and Management (PMM) but also have a demo which allows you to explore many PMM features without having to install it. Though there is only so much you can do in a public […]
Aug 21, 2019 |
Cloud, Percona Software
While testing our PMM2 Beta and other Dockerized applications, you may want to clean up your docker install and start from scratch. If you’re not very familiar with Docker it may not be that trivial. This post focuses on cleaning up everything in docker so you can “start from scratch” which means removing all your […]
Aug 14, 2019 |
MySQL, Percona Software
While we often run MySQL on larger scale systems in Production for Test and Dev, sometimes we want to run MySQL on the tiniest cloud instances possible or just run it on our laptops. In these cases, MySQL 8 and MySQL 5.7 memory consumption is quite important. In comparing MySQL 8 vs MySQL 5.7, you […]
Jun 14, 2019 |
Percona Events
Not long after this year’s SouthEast LinuxFest 2019 in mid-June I’ll be speaking at a series of open source database meetups in Russia & UK, plus a big data MeetUp in France. At Percona we’re well aware of the growing number of Percona software users around the world, and whenever we have a chance to […]
Apr 30, 2019 |
MySQL, Webinars
Join Percona CEO Peter Zaitsev and PingCAP Senior Product and Community Manager Morgan Tocker as they present How to horizontally scale MySQL with TiDB while avoiding sharding issues on Wednesday, May 1st, 2019, at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). View the Recording In this joint webinar, PingCAP will provide an introduction and […]
Mar 04, 2019 |
Cloud, Insight for DBAs, MySQL, Webinars
Join Percona CEO Peter Zaitsev as he presents High Availability and Disaster Recovery in Amazon RDS on Wednesday, March 6th, 2019, at 11:00 AM PST (UTC-8) / 2:00 PM EST (UTC-5). View the Recording In this hour-long webinar, Peter describes the differences between high availability (HA) and disaster recovery (DR). Afterward, Peter will go through […]
Feb 15, 2019 |
Benchmarks, Insight for DBAs, MySQL
While implementing ClickHouse for query executions statistics storage in Percona Monitoring and Management (PMM), we were faced with a question of choosing the data type for metrics we store. It came down to this question: what is the difference in performance and space usage between Uint32, Uint64, Float32, and Float64 column types? To test this, […]
Feb 05, 2019 |
Insight for DBAs, MongoDB, MySQL, Percona Software, Webinars
Join Percona CEO Peter Zaitsev as he presents Percona Software News and Roadmap Update on Wednesday, February 6, 2019, at 11:00 AM PST (UTC-8) / 2:00 PM EST (UTC-5). View the Recording Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software. Topics include Percona Server for MySQL and […]
