MySQLの公式java client使用時はprotobuf-javaの依存をexcludeしましょう - xuwei-k's blog
以下を読めばわかる人、読んだことある人は、この先読む必要ありません。 github.com| xuwei-k's blog
In this chapter we’ll discuss HTTPS and why it’s so important before updating our DNS and obtaining our first SSL certificate from Let’s Encrypt. Then we’ll add a new config file to Nginx for our first site complete with a redirect from HTTP to HTTPS. Next we’ll create a database for the site and we’ll use WP-CLI to install WordPress. We’ll wrap up with a discussion about creating more sites on the server. The post Configure Nginx to Serve WordPress Over<span class="no-widows">...| SpinupWP
CloudLinux has released support for MySQL 8.4 LTS through the CloudLinux MySQL Governor. This release from MySQL brings important improvements designed to make your databases faster, more secure, and easier to manage.| СloudLinux Blog
以下を読めばわかる人、読んだことある人は、この先読む必要ありません。 github.com| xuwei-k's blog
こんにちは。アンドパッドでDBREを務めている久保と申します。 今日はAurora MySQLの認証プラグインを caching_sha2_password 認証へ移行している最中に発見したMariaDB Connector/Cの挙動についてお話しします。 背景 認証プラグインの caching_sha2_password 移行の背景について説明します。 従来の mysql_native_password 認証には以下のような課題があります。 パスワードのハッシュ関数が古...| ANDPAD Tech Blog
How Ninja Van scaled logistics with TiDB, moving beyond MySQL sharding to real-time insights and seamless growth.| TiDB
One of the most persistent challenges facing engineering leaders is how to design a scalable, secure, and cost-efficient multi-tenant SaaS architecture. While multi-tenancy enables shared infrastructure and rapid onboarding, it also introduces significant complexity, especially at scale. In a recent webinar Kathryn Sizemore, Principal Solutions Architect at TiDB, explored the realities of building scalable multi-tenant […] The post 3 Tips to Scale Multi-Tenant SaaS Data Without Pain appeare...| TiDB
Peak-moment failures are never polite. In 2015, Target’s website buckled on Cyber Monday while holiday carts sat idle. Delta canceled 1,300 flights when a single software outage rippled through critical systems. Analysts have shown that just 100 ms of extra latency trims roughly 1% of revenue, while Google observed a 20% traffic drop from a […] The post Why Legacy SQL Is a Scaling Time Bomb: How Distributed SQL Defuses Future Risks appeared first on TiDB.| TiDB
Im gleichen Projekts, über das ich letzte Woche geschrieben habe, hatte ich die Aufgabe bekommen, die Leistung der Website zu optimieren. Ein Hauptproblem war die sehr langsame Anmeldung ins Backend. Jedes Mal, wenn ich mich eingeloggt habe, musste ich etwa … Weiterlesen →| Kau-Boys
Database migration is one of those tasks that can either go smoothly or turn into a nightmare depending on your preparation. If you're considering migrating from MySQL to PostgreSQL, you're making a smart choice – PostgreSQL offers superior data integrity, better JSON support, advanced indexing, and robust ACID compliance. However, the migration process requires careful planning and understanding of the differences between these two database systems. In this comprehensive guide, I'll walk y...| TechPlanet
I’m using percona-tools to do an online schema modification today, and thought I would document the process, especially as even the installation guides seem to be badly linked, out of date, a…| addshore
En el mundo de la administración de bases de datos, pocas cosas generan más frustración que un volcado que falla cuando parecía estar todo bajo control. Ese| Administración de Sistemas
XTIVIA helps jumpstart your BI and reporting journey with Oracle Linux, MySQL Enterprise, and Jaspersoft setup.| Virtual-DBA Remote DBA Services & Support - Certified Database Experts
Reading SwiftData vs Realm: Performance Comparison reminded me of an anecdote from my days working on Shark, at Apple. I don’t really remember the timing – sometime between 2006 and 2010 – but presumably around 2006 as I recall it was when Core Data was still relatively new. For whatever reason, there was a huge… Read more| Wade Tregaskis
As part of my recent work in upgrading our partner & customer ticketing system to make things sweeter for all our users I have been assigned a task involving importing data from a CSV that was generated using MySQL’s SELECT ... INTO OUTFILE. The problem was that the source table contained BLOB fields. The resulting… Continue reading Reading from MySQL data with BLOBs dumped to CSV→| Mike Kaganski's blog
You can set up a zapier integration to connect all of your most important data sources and pull them into your Cyfe dashboard. Learn about the top use cases.| Cyfe
Node MySQL is a great traditional alternative to mongo and all the jazz youngins are using. One important advice – never use + to concatenate queries unless you know what you’re doing.| N’s Blog
Andy Pavlo of the CMU Database Group is well known for saying that while NoSQL databases acquire cyclical popularity, all databases eventually iterate back to a SQL interface — it happened with MongoDB and Google’s BigTable for example.| Made by Mikal
I recently troubleshoot an interesting MySQL crash, and I think it is worth sharing (with the related bugs). MySQL crashed when the disk was full, you can see the free disk graph below. The Y-axis is in the tens of GiB scale and the X-axis is in the hour scale. Can you guess what happened ? Just to make sure we agree on the meaning of the graph above, let's describe it| J-F Gagné's MySQL Blog
As I wrote in a LinkedIn post , I am working on a blog post related to binary logging of big transactions. I thought I would split this pos...| jfg-mysql.blogspot.com
Microsoft has updated .NET Aspire to version 9.3, including reverse proxy support, MySQL integration, easier integration with Azure […]| DEVCLASS
In this article, we’ll learn how to connect MySQL database with Python using the PyMySQL database driver. Connect Database with Python First, we need to install a MySQL database driver called PyMySQL that will help us bridge Python and MySQL. Now, after installing this package, we can start the connection process by importing it into […]| GeekPython – Python Programming Tutorials
Fix the Nextcloud Hub 10 row format warning with this step-by-step guide and script to automate converting tables to ROW_FORMAT=DYNAMIC.| Pieter Bakker
Azure Database for MariaDB retires in 2025. Learn your migration options and step-by-step guidance in this helpful article. Read now.| XTIVIA
This chapter is all about setting up the software needed to run a WordPress site. First we’ll install Nginx and configure it with better settings for our use. Next we’ll install PHP and its packages required by WordPress and configure PHP-FPM. Then we’ll install WP-CLI and MariaDB. The post Install Nginx, PHP 8.3, WP-CLI, and<span class="no-widows"> </span>MySQL appeared first on SpinupWP.| SpinupWP
Read here what Cruddiy is and what it can do for you: here is the code. TLDR: Cruddiy is no-code Bootstrap 4 PHP form builder for MySQL tables. I started Cruddiy when the Covid-19 lockdowns happened this spring, to keep me busy. And I released it on GitHub. After 25 stars 🤩 and 13 forks […] The post Cruddiy: table relationship support via foreign keys appeared first on Jan van den Berg.| Jan van den Berg
Benchmarking MySQL gives a rough idea of server capacity, helping estimate concurrency, QPS limits, and the impact of tuning — but results aren’t absolute.| Another Boring Tech Blog
Should Sqitch and URI::mysql use DBD::MariaDB instead of DBD::mysql? If so, what are the implications for Sqitch deployment and usage?| Just a Theory
I just submitted a MySQL Contribution and I would like to gather feedback about it. Depending on the received feedback, I might submit an updated contribution. The contribution is Counters for Slow InnoDB Sync Reads, and its goal is to make MySQL easier to operate on “complex” IO subsystems (like network drives in the cloud). The bug report / feature request Bug #117740 :| J-F Gagné's MySQL Blog
When running tests, it is sometimes useful to slow down IOs to clearly show the impact of reading from the disk. Modern laptops and servers usually have fast local SSDs, and most cloud vendors provide, in addition to fast local disks, relatively fast network block devices (EBS for AWS and Persistent Disk for GCP). Even when using magnetic network block devices, IOs are not guaranteed| J-F Gagné's MySQL Blog
Yes, you read this correctly: because the MySQL client is insecure and allows running arbitrary commands, and because mysqldump blindly trusts the server it is dumping from, a hostile MySQL Server on which mysqldump is executed could trigger arbitrary command execution (also known as a remote code execution). This post raises awareness on this vulnerability and shows how a secure MySQL| J-F Gagné's MySQL Blog
A month ago, I announced that I am working on a MySQL Contribution to add database / schema in the slow query log file (bug report, LinkedIn, Twitter, Facebook, and MySQL Community Slack). My contribution is ready, and before submitting it, I would like feedback, so I am writing this post as a Request for Comments (RFC). If you are in a hurry, you can go directly to the RFC Fake PR.&| J-F Gagné's MySQL Blog
Yes, this is a catchy title, but it is true, and it got you reading this post :-). Another title could have been “Please load this mysql-dump: what could go wrong ?”. As you guessed, loading a dump is not a risk-free operation. In this post, I explain how the insecure MySQL client makes this operation risky and how to protect against it. And if you think this post is not| J-F Gagné's MySQL Blog
Not very long ago (well, maybe a little longer, this post is in draft for more than a year), in the spawn of less than 5 days, I suggested many colleagues to reproduce a problem they had with MySQL in a "more simple environment". Such more simple environment can be created with dbdeployer. dbdeployer is a tool to create "MySQL Sandboxes" on a Mac (laptop or desktop) or on Linux (vm,| J-F Gagné's MySQL Blog
A few days ago, Oracle released three new MySQL GA versions: 8.2.0, 8.0.35 and 5.7.44. I skimmed the release notes (8.2.0, 8.0.35 and 5.7.44), and I am not impressed. I guess that I would be even less impressed / more disappointed if I had checked in greater detail, and if I had reviewed the 8.1.0, 8.0.34 and 5.7.43 release notes. The subject of my disappointment is Oracle not| J-F Gagné's MySQL Blog
When trying to understand queries in the slow log, an interesting metric to look at is rows examined. Also, when trying to understand CPU spikes on a MySQL instance, the InnoDB Metric dml_reads and the global status Innodb_rows_read are interesting to check. In a similar way, when trying to gather information about which queries are loading the system, SUM_ROWS_EXAMINED from the| J-F Gagné's MySQL Blog
I am finalizing my Percona Live talk MySQL and Vitess (and Kubernetes) at HubSpot. In this talk, I mentioned that I like that Percona is providing better MySQL with Percona Server. This comes with a little inconvenience though: with improvements, sometimes comes regression. This post is about such regression and a workaround I implemented some time ago (I should have shared it| J-F Gagné's MySQL Blog
I just booked my travel arrangements for Percona Live 2023. In case you missed it, one of the most important MySQL Conference of the year is happening in Denver from Monday May 22 to Wednesday 24. I will be there and I am giving a talk about how HubSpot operates Percona Server / MySQL with Vitess in Kubernetes. My colleague, Mali Akmanalp, is also speaking about the tools we| J-F Gagné's MySQL Blog
In May 2020, I published a Planet for the MySQL Community Pluto Beta. I was satisfied with the result and was considering it done, but I did not invest the time to promote it to release (a non-beta site was running for a few months without being advertised). I finally came to it, and today I am happy to deprecate the beta and announce the release of Planet for the MySQL Community.&| J-F Gagné's MySQL Blog
In my previous post about InnoDB Stalls on Empty Free List, I used a test environment that might look a little artificial : a table larger than the InnoDB Buffer Pool but fitting in the Linux Page Cache. This configuration allows serving very quickly what MySQL thinks are IOs because these are hit in the filesystem cache. In this post, I explain why this environment is not| J-F Gagné's MySQL Blog
Sometimes, the MySQL Optimizer chooses a wrong plan, and a query that should execute in less than 0.1 second ends-up running for 12 minutes ! This is not a new problem: bugs about this can be traced back to 2014, and a blog post on the subject dates of 2015. But even if this is old news, because this problem recently came to my attention, it is a problem worth writing on. This| J-F Gagné's MySQL Blog
I am currently working on a script to auto-enable parallel replication / multi-threaded replication (MTR) when there is replication lag. For testing this script, I need to trigger replication lag that would disappear after enabling MTR. I came-up with a simple solution for that, and I thought it could be useful to more people, so I am writing this blog post about it. Read-on for| J-F Gagné's MySQL Blog
Parece mentira, mas o MySQL está completando 30 anos em 2025. Três décadas de código aberto, performance, confiabilidade (sim, a gente sabe dos bugs também 😅) e uma comunidade incrível que cresce a cada ano. E, claro, isso merece ser comemorado! 📍 Onde e quando? Vamos nos reunir em São Paulo, no dia 4 de...| Another Boring Tech Blog
Link: https://www.perlmonks.org/?node_id=11163487 I seek the wisdom of the Perl Monks: > The Sqitch project got [a request][sqitch-825] to switch from [DBD::mysql] > to [DBD::MariaDB]. DBD::mysql 5's requirement to build from the MySQL 8 > client library provides the impetus for the request, but in poking around, I > found a [blogs.perl.org post] highlighting some Unicode fixes in > DBD::MariaDB, as well. > > Now, Sqitch likely doesn't have the Unicode issue (it always works with Perl > Unico...| Just a Theory
There has been some recent chat once again on the Wikibase telegram groups around importing, and the best approach to import a large amount of data into a Wikibase instance. 2 years ago I started a little GitHub project aimed at profiling the speed of loading using the action API, and various settings, DB versions…| addshore
| Thomas Hunter II
A more accurate title would’ve been porting Postgres’ conditional selectivity to MySQL, but you’d ask me what’s conditional selectivity then! This blog post series will explain both.| Uddeshya’s Musings
Welcome to part 2 of the series, in this post, we’ll discuss implementing a new histogram style inspired by Postgres in MySQL for estimating row selectivity.| Uddeshya’s Musings
If you're interested in MySQL performance tuning and monitoring, then Releem is a very nice tool that can assist you in your endeavor.| Vlad Mihalcea
Is your WordPress site as fast as it can be? Learn how to identify database queries slowing down your site and other ways to speed sql query execution time.| Delicious Brains
Black Friday or Dark Friday? Tips to Ensure Your MySQL Instance Survives Black Friday is one of the most demanding days of the year for e-commerce and online services, and your database is at the heart of it all. A slow or offline MySQL instance can turn your Black Friday into a Dark Friday, costing... O post Black Friday or Dark Friday? Depends If MySQL Stands the Rush apareceu primeiro em Another Boring Tech Blog.| Another Boring Tech Blog
In this blog post, I will test Dolphie, an open-source project by Charles Thompson. Dolphie is an open-source tool that provides real-time analytics for MySQL, MariaDB, and ProxySQL. As a first-time user, my goal is to go from zero to hero, exploring how easy it is to start using the tool while getting familiar with... O post Testing Dolphie For the First Time: Features and Feedback apareceu primeiro em Another Boring Tech Blog.| Another Boring Tech Blog
Learn how MySQL manages temporary file storage during online DDL operations, including examples, file locations, and strategies to handle disk space issues effectively.| Another Boring Tech Blog
With MySQL 8.0.23, the concept of invisible columns was introduced. Columns marked as invisible do not appear in standard [crayon-673af490038d2383475115-i/] queries and don’t require changes to existing application code. Later, in MySQL 8.0.30, support for automatically generated invisible primary keys (GIPKs) was added for InnoDB tables created without an explicit primary key. This enhancement, controlled by... O post Adding an Invisible Primary Key to an Existing Table in MySQL aparece...| Another Boring Tech Blog
Problem During the installation of Magento, you might encounter an error similar to the...| Goglides Dev 🌱
MariaDB is free as in love, but MariaDB Plc is no longer free as in independent. It's been swallowed up by private equity.| LowEndBox
Random insertions or deletions in a secondary index can lead to fragmentation, where the physical order of index pages on disk no longer aligns with the logical order of records. A common sign of fragmentation is that a table occupies more space than expected, though determining the exact amount is challenging. InnoDB stores data and... O post Monitoring and Optimizing Fragmented Tables in MySQL apareceu primeiro em Another Boring Tech Blog.| Another Boring Tech Blog
2022年2月現在の情報です 参考資料 https://docs.aws.amazon.com/ja_jp/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Managing.Performance.html インスタンス別のmax_connectionsのデフォルト値 インスタンスクラス max_connections のデフォルト値 db.t2.small 45 db.t2.medium 90 db.t3.small 45 db.t3.medium 90 db.t3.large 135 db.t4g.medium 90 db.t4g.large 13…| 開発覚書はてな版
Recently I was working with a client to support a text-search type functionality on their website. Given a search category and a list of words, the app was to return the highest relevancy titles that matched those words. For purposes of demonstration, assume the ranking was simple, using only an "or" search on the list of words. (So for example, a search of "Green tea" would match return all titles that matched "Green" or "Tea", and relevancy scoring didn't need to take into account if mo...| Ops Monkey
Due to some very favorable benchmarking results, I am planning to migrate some of our production databases to Myqsl5 on Nexenta. Previously the database was running on a Debian Linux server, and the I/O subsystem performed much worse on that system.| Ops Monkey
In this post, I will walk you through the process of upgrading an RDS Aurora MySQL DB engine with minimal downtime.| Ashley's Blog
Stack Overflow has published its 2024 developer survey, showing little change in programming language popularity despite calls for […]| DEVCLASS
MySQL Brasil Meetup 2024 - Participe do MySQL Meetup 2024 em São Paulo! Um dia inteiro de palestras e discussões sobre MySQL, com temas desde ferramentas open-source até soluções em nuvem Oracle. Inclui visita ao data center da Oracle. Não perca!| Another Boring Tech Blog
In the ever-evolving landscape of data management, databases play a crucial role in storing, organizing, and retrieving information efficiently. As we| Bestarion
Firefly III is a budget management app that I’m trying to self-host. Being a| astrid.tech
Learn why Apache Arrow is significant for data interoperability and accelerating analytics workflows in our latest post.| Dremio
| The Grumpy Troll: The Grumpy Troll
I’ve previously published a post on extracting table names when /or/i was filtered which leads to filtering of the word information_schema. I did some more research into this area on my own and fou…| 🔐Blog of Osanda
MariaDB 10.5 is the latest major stable release of MariaDB, released in the spring of 2020. It was imported into Debian.org in late summer 2020 by the author of this blog post. Debian is one of the most popular Linux distributions and the “mother” of many other distributions, most notably Ubuntu. Thus when MariaDB 10.5 […]| Linux-natives
We check execution plans and benchmark results to see if using a LIMIT clause is useful when checking for existence of N values in SQL| Java, SQL and jOOQ.
A blog post about some post exploitation scenarios with MySQL, MSSQL, PostgreSQL and Oracle that use SQL Injection to make network requests resulting in Server Side Request Forgery/Cross Site Port Attacks.| i break software - My work with different software, bug hunting and interesti...
Build full-stack (Angular 17 + Node.js + Express + MySQL) example: CRUD App. Node Express for REST API, Angular with HttpClient, Form Submit.| BezKoder
I’ve been using Microsoft’s SQL Server Management Studio since it was called Enterprise Manager, way back when. Over the years, I have become so accustomed to using F5 to run queries that when even after a long time using MySQL Workbench, muscle memory rules and I still hit F5 and wonder why my queries don’t … Continue reading "MySQL Workbench: Adding F5 to execute"| OppoverBakke
This post shows how to create a two-tier architecture to deploy a WordPress application using CloudFormation.| Vuyisile Ndlovu
We will have a look at the new Spring Boot 3.1 feature supporting Docker Compose files on startup. No need to start Docker compose separately again| RefactorFirst
Here we see how we can boost the bulk insert performance using JPA to insert large number of records into a database| RefactorFirst
This guide will walk you through installing and configuring nginx, PHP and Mysql optimized for MacOS Big Sur on Apple Silicon - M1 Arm processors. Note: Most of this content originated from this post. Here, I’ve pared it down and fixed the relevant content. Credit goes to the original author: Kevin Dees.| Chris Bergerons Tech Blog
I wrote a simple plugin for NZBGet that inserts download history into a MySQL database. Having my download list in a database makes operations on the data easier than groking text logs. I wanted to display my most recent downloads on a Grafana Dashboard: To use simply copy the Mysql-Log.py script into your NZBGet/scripts directory. In NZBGet, select settings and set the hostname of your MySQL instance. You can download the plugin on github| Chris Bergerons Tech Blog
"can't specify target table for update in FROM clause" is an annoying limitation in MySQL, for which jOOQ automatically implements a workaround.| Java, SQL and jOOQ.
DBD::mysql has long provided the interface to connect to the MySQL database from Perl code. But as old as it is, it was implemented with some critical bugs that cannot simply be corrected without breaking mountains of existing code relying on those bugs. For this same reason, though DBD::MariaDB corrects these bugs, care must be taken when migrating existing code to avoid subtle breakage.| blogs.perl.org
Why I enjoy PostgreSQL - Infrastructure Engineer's Perspective| Shayon Mukherjee
Published: Tue 05 May 2015| www.pgcli.com
Published: Sun 05 April 2015| www.pgcli.com
Learn how the Hibernate StatelessSession Upsert method works on PostgreSQL, MySQL, Oracle, and SQL Server.| Vlad Mihalcea
I still have a place in my heart for phpMyAdmin, that tool that I was introduced when developing PHP on my shared hosting provider many moons ago. It's just a great way to inspect your MariaDB/MySQL databases. These days I don't install any web applications (or databases) on my local machine, I u| William Denniss
Modern systems are complicated beasts with lots of interdependent activities between threads, programs and kernels. Figuring out some problems is nearly impossible without building some time machin…| domas mituzas
The “DBMS” part of MySQL is fine – storage engines (especially with new kids on the block), replication, etc, but it really sucks at executing SQL. I won’t even get into com…| domas mituzas
We’ve been learning for many years how to run Linux for databases, but over time we realized that many of our lessons learned apply to many other server workloads. Generally, server process w…| domas mituzas
If you remove a file, file system generally just marks in its metadata that previously occupied blocks can now be used for other files – that operation is usually cheap, unless the file has m…| domas mituzas
Generally in MySQL we send queries massaged to a point where optimizer doesn’t have to think about anything. In our major user database environment 99.9% of queries don’t have alternati…| domas mituzas
There was one MySQL feature that I was always very afraid to ask for. I sure needed it for past 15 years of my MySQL practice, and yet I never got to it. I wanted MySQL processlist (‘SHOW PRO…| domas mituzas
For years it was very easy to defend InnoDB’s advantage over competition – covering index reads were saving I/O operations and CPU everywhere, table space and I/O management allowed to …| domas mituzas
Most of database engines have to deal with underlying layers – operating systems, device drivers, firmware and physical devices, albeit different camps choose different methods. In MySQL worl…| domas mituzas
I’ve grown to love MySQL, but every now and then it has some strange restriction that temporarily stumps me. Then I discover a marvelous workaround and fall in love with it all over again. Th…| Reflections
This article will describe an understanding of different ways to use the SUBSTRING function in MySQL.| SQL Shack - articles about database auditing, server performance, data recove...
MySQL or MariaDB has several data types for handling text-based characters. There are several data types for handling smaller strings such as CHAR and VARCHAR data types. For larger text-based strings there are BLOB based data types such as TEXT. It's worth noting at this point that the below-quoted sizes do not necessarily represent the| JamesCoyle.net
The default authentication method allows an attacker to log into a MySQL server by only witnessing to the TCP handshake and knowing the hashed password.| cardaci.xyz
