Login

Recent searches

No recent searches

Search options

Only available when logged in.
fosstodon.org is one of the many independent Mastodon servers you can use to participate in the fediverse.
Fosstodon is an invite only Mastodon instance that is open to those who are interested in technology; particularly free & open source software. If you wish to join, contact us for an invite.

Administered by:

Server stats:

10K
active users

fosstodon.org: AboutStatusProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.3.6

#Performance_Schema

0 posts0 participants0 posts today
lefred<p>MySQL 8 and Replication Observability<br />Many of us, old MySQL DBAs used Seconds_Behind_Source from SHOW REPLICA STATUS to find out the status and correct execution of (asynchronous) replication.</p><p>Please pay attention of the new terminology. I&#39;m sure we&#39;ve all used the old terminology.</p><p>However, MySQL replication has evolved a lot and the repli<br /><a href="https://lefred.be/content/mysql-8-and-replication-observability/" target="_blank" rel="nofollow noopener noreferrer" translate="no"><span class="invisible">https://</span><span class="ellipsis">lefred.be/content/mysql-8-and-</span><span class="invisible">replication-observability/</span></a><br />#80 <a href="https://fosstodon.org/tags/GroupReplication" class="mention hashtag" rel="tag">#<span>GroupReplication</span></a> <a href="https://fosstodon.org/tags/HeatWave" class="mention hashtag" rel="tag">#<span>HeatWave</span></a> <a href="https://fosstodon.org/tags/MySQL" class="mention hashtag" rel="tag">#<span>MySQL</span></a> <a href="https://fosstodon.org/tags/Performance_Schema" class="mention hashtag" rel="tag">#<span>Performance_Schema</span></a> <a href="https://fosstodon.org/tags/Replication" class="mention hashtag" rel="tag">#<span>Replication</span></a> <a href="https://fosstodon.org/tags/SYS" class="mention hashtag" rel="tag">#<span>SYS</span></a></p>
lefred<p>Query and Transaction size in MySQL<br />Some times it&#39;s important to know the size of a transaction, especially when you plan to migrate to a HA solution where by default transactions have a limited size to guarantee an optimal behavior of the cluster.</p><p>Today we will see the different possibilities to have an idea of the size of transactions.</p><p>First we need to split the t<br /><a href="https://lefred.be/content/query-and-transaction-size-in-mysql/" target="_blank" rel="nofollow noopener noreferrer" translate="no"><span class="invisible">https://</span><span class="ellipsis">lefred.be/content/query-and-tr</span><span class="invisible">ansaction-size-in-mysql/</span></a><br />#8.0 <a href="https://fosstodon.org/tags/MySQL" class="mention hashtag" rel="tag">#<span>MySQL</span></a> <a href="https://fosstodon.org/tags/MySQL8" class="mention hashtag" rel="tag">#<span>MySQL8</span></a>.0 <a href="https://fosstodon.org/tags/MySQLShell" class="mention hashtag" rel="tag">#<span>MySQLShell</span></a> <a href="https://fosstodon.org/tags/Performance_Schema" class="mention hashtag" rel="tag">#<span>Performance_Schema</span></a></p>
lefred<p>How to get client’s IP address when using MySQL Router ?<br />When you connect to a server (or cluster) using a TCP proxy level 7, also referred to as an application-level or Layer 7 proxy (highest level of the OSI model), the application doesn&#39;t connect directly to the back-end server(s). The proxy usually understands the p<br /><a href="https://lefred.be/content/how-to-get-clients-ip-address-when-using-mysql-router/" target="_blank" rel="nofollow noopener noreferrer" translate="no"><span class="invisible">https://</span><span class="ellipsis">lefred.be/content/how-to-get-c</span><span class="invisible">lients-ip-address-when-using-mysql-router/</span></a><br />#8.0 <a href="https://fosstodon.org/tags/HA" class="mention hashtag" rel="tag">#<span>HA</span></a> <a href="https://fosstodon.org/tags/InnoDBCluster" class="mention hashtag" rel="tag">#<span>InnoDBCluster</span></a> <a href="https://fosstodon.org/tags/InnoDBReplicaSet" class="mention hashtag" rel="tag">#<span>InnoDBReplicaSet</span></a> <a href="https://fosstodon.org/tags/MySQL" class="mention hashtag" rel="tag">#<span>MySQL</span></a> <a href="https://fosstodon.org/tags/MySQL8" class="mention hashtag" rel="tag">#<span>MySQL8</span></a>.0 <a href="https://fosstodon.org/tags/Performance_Schema" class="mention hashtag" rel="tag">#<span>Performance_Schema</span></a> <a href="https://fosstodon.org/tags/Router" class="mention hashtag" rel="tag">#<span>Router</span></a></p>
lefred<p>MySQL Database Service – find the info: part 4 – connections<br />As a MySQL DBA, you like to know who is connected on the system you manage. You also like to know who is trying to connect.</p><p>In this article, we will discover how we can retrieve the information and control who is using the MySQL DB instance we launched in OCI.</p><p><a href="https://lefred.be/content/mysql-database-service-find-the-info-part-4-connections/" target="_blank" rel="nofollow noopener noreferrer" translate="no"><span class="invisible">https://</span><span class="ellipsis">lefred.be/content/mysql-databa</span><span class="invisible">se-service-find-the-info-part-4-connections/</span></a><br />#8.0 <a href="https://fosstodon.org/tags/Cloud" class="mention hashtag" rel="tag">#<span>Cloud</span></a> <a href="https://fosstodon.org/tags/Information_Schema" class="mention hashtag" rel="tag">#<span>Information_Schema</span></a> <a href="https://fosstodon.org/tags/MDS" class="mention hashtag" rel="tag">#<span>MDS</span></a> <a href="https://fosstodon.org/tags/MySQL" class="mention hashtag" rel="tag">#<span>MySQL</span></a> <a href="https://fosstodon.org/tags/MySQL8" class="mention hashtag" rel="tag">#<span>MySQL8</span></a>.0 <a href="https://fosstodon.org/tags/OCI" class="mention hashtag" rel="tag">#<span>OCI</span></a> <a href="https://fosstodon.org/tags/Performance_Schema" class="mention hashtag" rel="tag">#<span>Performance_Schema</span></a></p>
lefred<p>MySQL Database Service – find the info: part 2 – disk space utilization<br />This article is the second of the new series dedicated on how a DBA can find the info he needs with MySQL Database Service in Oracle Cloud Infrastructure.</p><p>The first article was dedicated on Backups, this one is about Disk Space Utilization.</p><p>This <br /><a href="https://lefred.be/content/mysql-database-service-find-the-info-part-2-disk-space-utilization/" target="_blank" rel="nofollow noopener noreferrer" translate="no"><span class="invisible">https://</span><span class="ellipsis">lefred.be/content/mysql-databa</span><span class="invisible">se-service-find-the-info-part-2-disk-space-utilization/</span></a><br />#8.0 <a href="https://fosstodon.org/tags/Cloud" class="mention hashtag" rel="tag">#<span>Cloud</span></a> <a href="https://fosstodon.org/tags/HeatWave" class="mention hashtag" rel="tag">#<span>HeatWave</span></a> <a href="https://fosstodon.org/tags/MDS" class="mention hashtag" rel="tag">#<span>MDS</span></a> <a href="https://fosstodon.org/tags/MySQL" class="mention hashtag" rel="tag">#<span>MySQL</span></a> <a href="https://fosstodon.org/tags/MySQL8" class="mention hashtag" rel="tag">#<span>MySQL8</span></a>.0 <a href="https://fosstodon.org/tags/OCI" class="mention hashtag" rel="tag">#<span>OCI</span></a> <a href="https://fosstodon.org/tags/Performance_Schema" class="mention hashtag" rel="tag">#<span>Performance_Schema</span></a></p>
lefred<p>MySQL Database Service – find the info: part 1 – backups<br />In this new series of articles we will explore the different sources of information available when using MySQL Database Service on OCI to effectively perform your daily DBA job.</p><p>Of course there is way less things to take care of, like backups, upgrades, operating system and hard<br /><a href="https://lefred.be/content/mysql-database-service-find-the-info-part-1-backups/" target="_blank" rel="nofollow noopener noreferrer" translate="no"><span class="invisible">https://</span><span class="ellipsis">lefred.be/content/mysql-databa</span><span class="invisible">se-service-find-the-info-part-1-backups/</span></a><br />#8.0 <a href="https://fosstodon.org/tags/Cloud" class="mention hashtag" rel="tag">#<span>Cloud</span></a> <a href="https://fosstodon.org/tags/HeatWave" class="mention hashtag" rel="tag">#<span>HeatWave</span></a> <a href="https://fosstodon.org/tags/MDS" class="mention hashtag" rel="tag">#<span>MDS</span></a> <a href="https://fosstodon.org/tags/MySQL" class="mention hashtag" rel="tag">#<span>MySQL</span></a> <a href="https://fosstodon.org/tags/MySQL8" class="mention hashtag" rel="tag">#<span>MySQL8</span></a>.0 <a href="https://fosstodon.org/tags/OCI" class="mention hashtag" rel="tag">#<span>OCI</span></a> <a href="https://fosstodon.org/tags/Performance_Schema" class="mention hashtag" rel="tag">#<span>Performance_Schema</span></a></p>
ExploreLive feeds
About