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).
In this joint webinar, PingCAP will provide an introduction and overview of TiDB, tailored for those with a strong background in MySQL. PingCAP will use MySQL as an example to explain …
[Read more]Fedora 30 is out today. We congratulate the Fedora community on another rev of their favorite Linux distro. As usual, we support the latest Fedora from day one, and we have added the following MySQL products to our official MySQL yum repos: MySQL Server (8.0.16 and 5.7.26) Connector C++ 8.0.16 Connector Python 8.0.16 Connector ODBC […]
(In the previous post, Part 1, we covered Data Writing.)
In this blog post, we continue on our series of exploring MyRocks mechanics by looking at configurable server variables and column family options. In our last post, I explained at a high level how data first entered memory space and in this post, we’re going to pick up where we left off and talk about how the flush from immutable memtable to disk occurs. We’re also going to talk about how newly created secondary indexes on existing tables get written to disk.
We already know from our previous post in the series that a flush can be prompted by one of several events, the most common of which would be when an active memtable is filled to its maximum capacity and is rotated into immutable status.
When your immutable memtable(s) is ready …
[Read more]This post is just a reminder on how to find which settings have been set on MySQL Server.
If you have modified some settings from a configuration file or during runtime (persisted or not), these two queries will show you what are the values and how they were set. Even if the value is the same as the default (COMPILED) in MySQL, if you have set it somewhere you will be able to see where you did it.
Global Variables
First, let’s list all the GLOBAL variables that we have configured in our server:
SELECT t1.VARIABLE_NAME, VARIABLE_VALUE, VARIABLE_SOURCE
FROM performance_schema.variables_info t1
JOIN performance_schema.global_variables t2
ON t2.VARIABLE_NAME=t1.VARIABLE_NAME
WHERE t1.VARIABLE_SOURCE != 'COMPILED';
This is an example of the output:
Session Variables
And now the same query for the session variables:
SELECT t1.VARIABLE_NAME, VARIABLE_VALUE, …[Read more]
FromDual has the pleasure to announce the release of the new version 0.9 of its popular FromDual Ops Center for MariaDB and MySQL focmm.
The FromDual Ops Center for MariaDB and MySQL (focmm) helps DBA's and System Administrators to manage MariaDB and MySQL database farms. Ops Center makes DBA and Admins life easier!
The main task of Ops Center is to support you in your daily MySQL and MariaDB operation tasks. More information about FromDual Ops Center you can find here.
Download
The new FromDual Ops Center for MariaDB and MySQL
(focmm) can be downloaded from here. How to
install and use focmm is documented in the …
As of 8.0.16, the mysql_upgrade binary is deprecated, but its functionality is moved into the server. Let’s call this functionality the “server upgrade”. This is added alongside the Data Dictionary upgrade (DD Upgrade), which is a process to update the data dictionary table definitions.…
Facebook Twitter Google+ LinkedIn
Dear MySQL users,
MySQL Connector/ODBC 5.3.13, a new version of the ODBC driver for
the
MySQL database management system, has been released.
The available downloads include both a Unicode driver and an
ANSI
driver based on the same modern codebase. Please select the
driver
type you need based on the type of your application – Unicode or
ANSI.
Server-side prepared statements are enabled by default. It is
suitable
for use with any MySQL version from 5.6.
This is the sixth release of the MySQL ODBC driver conforming to
the
ODBC 3.8 specification. It contains implementations of key
3.8
features, including self-identification as a ODBC 3.8
driver,
streaming of output parameters (supported for binary types only),
and
support of the SQL_ATTR_RESET_CONNECTION connection attribute
(for the
Unicode driver only).
The release is now available in …
[Read more]
The ST_DISTANCE function has been upgraded in
MySQL 8.0.16 to allow you to specify the unit of measure between
to locations. Previously you had to convert from meters to
what you desired but now you can use the
INFORMATION_SCHEMA.ST_UNITS_OF_MEASURE table to help you get many
of the more popular measurements (foot, yard, statue mile,
nautical mile, fathom) and some ones that are new to me (chain,
link, various feet). However some measures are
omitted (furlong,smoot) that may have some relevance in your
life.
select * from information_schema.ST_UNITS_OF_MEASURE;
Fetching table and column names from `mysql` for
auto-completion... Press ^C to stop.
+--------------------------------------+-----------+---------------------+-------------+
| UNIT_NAME …
Building the Vitess community has been our pride and joy. Being able to contribute to the MySQL community, even more so. Vitess' Sugu Sougoumarane has been nominated by the MySQL group for Oracle's 2019 MySQL Community Contributor Award Program, where he joins folks like Shlomi Noach, Peter Zaitsev, Gabriela D'Ávila Ferrara, Giuseppe Maxia and many other active MySQL community members recognised for their contributions to MySQL. Criteria for the nominations included: most active code contributor, bug report,most active MySQL blogger, people who play an active role in translating or documenting MySQL articles, people who provide feedback on DMR releases, Labs release, or change proposal, as well as anyone in the community who did really useful work that ought to be thanked publicly.
MySQL 8.0.16 has been released last Thursday. In it, you can find some new replication features. Here is a quick summary. Follow-up blog posts will provide details about these features.
… Tweet Google Plus Share
