Yesterday, Bhuvanesh published an article about how to verify the difference between allocated diskspace for a tablespace and the the data in it.
I commented with an old post explaining how to get some similar info only using SQL in case you don’t have filesystem access.
And finally, my friend Bill Karwin, commented how this info is not always accurate. Which, of course, I agree with.
This is why, I checked …
[Read more]DBTA (Database Trends and Applications) is a magazine delivering news and analysis on data science, big data, information management, and analytics. Every year, they conduct surveys among readers about various database-related software solutions to choose the best offers in a variety of categories such as ‘Best BI Solution’, ‘Best Cloud Database’, ‘Best Data Analytics Solution’, […]
The post dbForge Studio for MySQL is a DBTA 2019 Finalist appeared first on blog.
Its not the new term for DBAs. MySQL has an awesome parameter
innodb-file-per-tables allows MySQL to create
separate files for each tables. This helped a lot to manage the
disk space in more efficient way. But when we perform a large
batch job for delete or update the data in MySQL tables, you may
face this fragmentation issue. Comparing with SQL server, MySQL’s
fragmentation is not high. I had a similar situation where my
Disk space was consuming 80% and when I check the huge files in
OS, one table’s idb file consumed 300GB+. I know it
has some wasted blocks(but not actually wasted, MySQL will use
this space, it’ll not return this to OS) Then I checked the
information schema to find out the data size and its
index size. It was 27GB only. Then I realize, we did a batch
operation to delete many billions of records in that table.
Thanks to Rolando - MySQL DBA:
When I searched the similar …
[Read more]As an intro to his performance act, an “old school” entertainer Victor Borge once famously asked the audience: “Do you care for piano music?“, which was greeted by a crowd, only to be immediately followed by a self-ironic punch line – “Too bad.”…
Facebook Twitter LinkedIn
We have been working with PMM for quite a long time, we do most of the performance analysis with PMM for most of our clients. It also provides the flexibility that we have built our own custom dashboard. PMM has many advantages
Highly recommended for any production deployments its equivalent to Enterprise-grade monitoring and graphing tool.
Recently we have been working for our client on MySQL Consulting to scale peak sale of the year. Wherein we have deployed PMM to view the performance …
[Read more]Group Replication enables you to create fault-tolerant systems with redundancy by replicating the system state to a set of servers. Even if some of the servers subsequently fail, as long it is not all or a majority, the system is still available.…
Tweet Share
Understand dirty reads when using ProxySQL
Recently I had been asked to dig a bit about WHY some user where getting dirty reads when using PXC and ProxySQL.
While the immediate answer was easy, I had taken that opportunity to dig a bit more and buildup a comparison between different HA solutions.
For the ones that cannot wait, the immediate answer is …drum roll, PXC is based on Galera replication, and as I am saying from VERY long time (2011), Galera replication is virtually synchronous. Given that if you are not careful you MAY hit some dirty reads, especially if configured incorrectly.
There is nothing really bad here, we just need to know how to handle it right.
In any case the important thing is to understand some basic concepts.
Two ways of seeing the world (the theory)
Once more let us talk about data-centric approach and …
[Read more]MySQL 8.0.18 was just released, and it contains a brand new feature to analyze and understand how queries are executed: EXPLAIN ANALYZE.
What is it?
EXPLAIN ANALYZE is a profiling tool for your queries that will show you where MySQL spends time on your query and why.…
Facebook Twitter LinkedIn
Loading any large file into MySQL server using the LOAD DATA INFILE is a time consuming process , because it is single threaded and it is a single transaction too. But with modern hardwares system resource is not a bottle neck. At Mydbops we focus on improving the efficiency of process as we value performance more. MySQL introduced the parallel load data operations in its latest minor release MySQL 8.0.17 . I had the curiosity to test this feature and wanted to know, how it can improve the data loading comparing to the existing single threaded method . Through this blog I am going to compare the both methods .
Remember you can use the parallel data loading utility only via MySQL Shell .
Internal Work Flow :
This section describes the …
[Read more]The MySQL Development team is proud to announce a new version of the MySQL Shell with the following major improvements:
Python 3 Migration Due to the coming end-of-life (EOL) for Python 2.7… Facebook Twitter LinkedIn