In this blog post, I’ll look at how to use the loose_ option prefix in my.cnf in MySQL. mysqld throws errors at startup – and refuses to start up – if a non-existent options are defined in the my.cnf file. For example:
|
1 |
2016-10-05 15:56:07 23864 [ERROR] /usr/sbin/mysqld: unknown variable 'bogus_option=1' |
The MySQL manual has a solution: use the loose_ prefix option in my.cnf file. In the prior example, if we specify loose_bogus_option=1 […]
Read More
This blog discusses the gradual end of MyISAM in MySQL. The story that started 20 years ago is coming to its end. I’m talking about the old MyISAM storage engine that was the only storage provided by MySQL in 1995, and was available in MySQL for 20+ years. Actually, part of my job as a MySQL consultant […]
Read More
Take Percona’s One-Click 2017 Top Database Concerns Poll. With 2017 coming quick around the corner, it’s time to start thinking about what next year is going to bring to the open source database community. We just finished Percona Live Europe 2017, and at the conference we looked at new technologies, new techniques, and new ideas. […]
Read MoreThis blog reports the results of Percona’s database security poll. As Peter Zaitsev mentioned recently in his blog post on database support, the data breach costs can hit both your business reputation and your bottom line. Costs vary depending on the company size and market, but recent studies estimate direct costs ranging in average from $1.6M to 7.01M. […]
Read More
In this blog post, I’ll provide my thoughts about Consul for ProxySQL service discovery and automation. I approached Consul recently while looking for a service discovery and configuration automation solution for ProxySQL. My colleague Nik Vyzas wrote a great post on this topic, and I suggest you read it. I wrote this article to share my first impressions […]
Read More
Around this time last year, Gartner named Percona a Challenger in the 2015 Magic Quadrant for Operational Database Management Systems (Gartner Operational DBMS MQ). For those not familiar with these, Magic Quadrants (MQ) are a set of market research reports published by Gartner that provide qualitative analysis into a market by highlighting its participants, relevant trends, […]
Read MoreFrom everyone at Percona, we’d like to send a big thank you to all our sponsors, exhibitors, and attendees at this year’s Percona Live Europe Open Source Database Conference. The conference was an outstanding success! The sold-out event brought the European open source database community together, with a technical emphasis on the core topics of MySQL, […]
Read More
This blog post discusses how to use MySQL shell securely from Bash. The Bourne shell is everywhere. It is part of the most basic Linux install. You will find it on the biggest SPARC machines down to a Raspberry Pi. It is nice to know it will always be there. Unlike other, more complex scripting […]
Read More
We’re winding down here at the Percona Live Europe Open Source Database Conference 2016, but there are still talks going on. The conference has a technical focus with an emphasis on the core topics of MySQL, MongoDB, PostgreSQL and other open source databases. Tackling subjects such as analytics, architecture and design, security, operations, scalability and […]
Read More
The Percona Live Europe 2016 conference is moving along quickly, and today we saw a lot of presentations on open source database that AREN’T MySQL or MongoDB. There are more than 100 open source databases in the world, each with their own design and use case sweet spots. At Percona Live Europe, we get a […]
Read MorePercona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.
Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.
No, thank you. Please do not ask me again.
