It is a pleasure to announce that G2 awards dbForge Studio for MySQL with the ‘Leader Summer 2021’ and ‘Momentum Leader Summer 2021’ badges in the DB Backup category and ‘Users Love Us’ badge in the Database Management Systems (DBMS) and Database Comparison categories. G2 is a peer-to-peer review website focusing on business services and […]
The post dbForge Studio for MySQL Awarded G2 Summer 2021 Badges appeared first on Devart Blog.
When you create a MySQL Database Service instance in OCI, you have the choice between 3 types: If you have minutes as RTO (Recovery Time Objective) in case of a failure, you must choose a High Availability instance that will deploy a Group Replication Cluster over 3 Availability Domains or 3 Fault D...
After having see how we can import data from PostgreSQL and Amazon Redshift, this time we will see how we can export data from Microsoft SQL Server and import it into MySQL Database Service in OCI. This time we will use something extra (for fun but also because it’s practical): OCI Object Storage ! ...
Help!
I am preparing a presentation for the Longhorn PHP conference titled PHP & MySQL -- How do PDO, MySQLi, and X DevAPI do what they do. This will be a comparison of using PHP with different MySQL Connectors. As far as I can tell there are no three way comparisons of mysqli, PDO, and the X DevAPI PECL extension. And much of the PDO versus myqli stuff looks to me like it has not aged well.
I have good material in the raw presentation about overall features, parameters for prepared queries. And a good section on the how's and whys on prepared queries.
But what else would you like to see in such a presentation? I have read some postings on the web about turning off buffering (fairly simple to do). But what else are would you like to see compared?
…
[Read more]We saw in this previous post how to import data from PostgreSQL to MySQL Database Service. Using almost the same technique, we will now import data from Amazon Redshift and import it to a MDS instance. With Redshit we have two options to export the data to CSV files that can be imported to MDS: usin...
MySQL Database Service (aka MDS) is very popular and many users wants to benefit from the managed MySQL service and from MySQL HeatWave. We see many users migrating their data from MySQL on-premise or from another cloud vendor to MDS… we also see people migrating from other data-stores like PostgreS...
This is the fourth episode of “Discovering MySQL Database Service“, a series of tutorials where I will show you, step by step, how to use MySQL Database Service and some other Oracle Cloud Infrastructure services.
In the previous episode we’ve created our Virtual Cloud Network, that provides you with complete control over your cloud networking environment that we will create in this Discovering MySQL Database Service journey.
In this episode, we’ll see what is OCI Object Storage and how to
export data to it from a MySQL instance using MySQL Shell.
In fact, in the process of creating a MySQL DB system, this step
is optional. But it is especially useful if you want to create a
MDS instance with data from a MySQL server on premise or in any
public/private cloud.
The post …
[Read more]During the development of the myloader –innodb-optimize-keys option, which was released in version 0.10.7, we found several issues and opportunities to improve the process. We had to change the approach, reimplement some of the core functionality and add a couple of data structures. That allowed us to implement, at a really low cost, a feature that executes the files that contain INSERT statements, sorted by Primary Key. This is desirable to reduce page splits, which cause on-disk tablespace fragmentation.
In this blog post, I will present the differences in data fragmentation for each version.
Test Details
These are local vm tests as there is no intention to show performance gain.
The table that I used is: …
[Read more]Since MySQL 5.6 InnoDB has supported persistent index statistics. This means that when you restart MySQL, InnoDB does not have to recalculate the statistics for the tables, rather it can read the statistics from its persistent storage. This has several advantages over the transient statistics, but as it turns out, there is also a catch: MySQL may under some circumstances never get around to update the index statistics. This particularly affects instances that are restarted frequently and tables with a large number of rows.
Information
Persistent statistics are the default, so unless you have explicitly chosen not to use them, then you are.
Background
Before I dive into why there are scenarios where persistent
statistics are never updated, it is necessary to recap how
persistent statistics work. Every time the statistics are
updated, the result is stored in the
mysql.innodb_index_stats table with …
Exploring the range of options available form clinical trial matching services and the role data plays by putting patients at the center of the search process.