Comments for code.openark.org http://shlomi-noach.github.io/blog/ Blog by Shlomi Noach Mon, 17 Dec 2018 11:38:00 +0000 hourly 1 https://wordpress.org/?v=5.3.3 Comment on Observations on the hashicorp/raft library, and notes on RDBMS by Sam Holmes https://shlomi-noach.github.io/blog/mysql/observations-on-the-hashicorpraft-library-and-notes-on-rdbms/comment-page-1#comment-551770 Mon, 17 Dec 2018 11:38:00 +0000 https://shlomi-noach.github.io/blog/?p=7717#comment-551770 Thank you very much for this article, it’s really helpful!

]]> Comment on 7 ways to convince MySQL to use the right index by Chun Yin Lo https://shlomi-noach.github.io/blog/mysql/7-ways-to-convince-mysql-to-use-the-right-index/comment-page-1#comment-545268 Thu, 06 Dec 2018 03:28:00 +0000 https://shlomi-noach.github.io/blog/?p=695#comment-545268 Please rename `t` to `data`. It is confusing at the first place

]]> Comment on MySQL Global status difference using single query by Wilson Hauck https://shlomi-noach.github.io/blog/mysql/mysql-global-status-difference-using-single-query/comment-page-1#comment-527441 Thu, 08 Nov 2018 15:25:00 +0000 https://shlomi-noach.github.io/blog/?p=3908#comment-527441 Shlomi, Should this query work with Maria DB 10.2.17 cpu has 6 cores. Results observed looks like this in my version.
+————————-+————-+————-+———-+———+———–+———————+
| variable_name | begin | end | diff | psec | pminute | NOW() |
+————————-+————-+————-+———-+———+———–+———————+
| created_tmp_disk_tables | 1237840 | 1237839 | -1 | -0 | -6 | 2018-11-06 17:51:02 |
| created_tmp_tables | 2524365 | 2524364 | -1 | -0 | -6 | 2018-11-06 17:51:02 |
| handler_tmp_write | 29418294952 | 29418294469 | -483 | -48 | -2898 | 2018-11-06 17:51:02 |
| memory_used | 2300318008 | 2297220056 | -3097952 | -309795 | -18587712 | 2018-11-06 17:51:02 |
| open_files | 111 | 109 | -2 | -0 | -12 | 2018-11-06 17:51:02 |
| opened_files | 4951963 | 4951959 | -4 | -0 | -24 | 2018-11-06 17:51:02 |
+————————-+————-+————-+———-+———+———–+———————+
6 rows in set (10.03 sec)
It looks like query picked up gs1 values before picking up gs0 values.
For my version of your base query, please visit http://www.mysqlservertuning.com, select Utility Scripts+ and download GLOBALSTATUSAGE10SEC.SQL for testing. After add to cart, checkout for $0.00 Order/Invoice total, please.
Thank you for your utilities.

]]> Comment on orchestrator 3.0.3: auto provisioning raft nodes, native Consul support and more by This Week in Data with Colin Charles 15: Percona Live 2018 Call for Papers and Best Practices for Observability - Percona Database Performance Blog https://shlomi-noach.github.io/blog/mysql/orchestrator-3-0-3-auto-provisioning-raft-nodes-native-consul-support-and-more/comment-page-1#comment-474677 Tue, 31 Jul 2018 14:37:37 +0000 https://shlomi-noach.github.io/blog/?p=7807#comment-474677 […] orchestrator 3.0.3 – auto-provisioning Raft nodes, native Consul support, SQLite or MySQL backed setups, web UI improvements and more. Solid release. […]

]]> Comment on Checking for AUTO_INCREMENT capacity with single query by Using Prometheus to Check for auto_increment Value Exhaustion - Percona Database Performance Blog https://shlomi-noach.github.io/blog/mysql/checking-for-auto_increment-capacity-with-single-query/comment-page-1#comment-474676 Tue, 31 Jul 2018 14:36:57 +0000 https://shlomi-noach.github.io/blog/?p=3421#comment-474676 […] are several ways to check for auto_increment capacity; this is just one of them. But what really matters is how PMM […]

]]> Comment on MySQL master discovery methods, part 6: other methods by Donatas Abraitis https://shlomi-noach.github.io/blog/mysql/mysql-master-discovery-methods-part-6-other-methods/comment-page-1#comment-457423 Thu, 21 Jun 2018 12:15:00 +0000 https://shlomi-noach.github.io/blog/?p=7854#comment-457423 How about another one method to “elect” the master node? Like here http://blog.donatas.net/blog/2017/02/26/exazk/

]]> Comment on MySQL master discovery methods, part 2: VIP & DNS by Jouni Järvinen https://shlomi-noach.github.io/blog/mysql/mysql-master-discovery-methods-part-2-vip-dns/comment-page-1#comment-441688 Sat, 12 May 2018 18:26:00 +0000 https://shlomi-noach.github.io/blog/?p=7863#comment-441688 Wonder why someone made it that hard.

]]> Comment on MySQL master discovery methods, part 2: VIP & DNS by Shlomi Noach https://shlomi-noach.github.io/blog/mysql/mysql-master-discovery-methods-part-2-vip-dns/comment-page-1#comment-441656 Sat, 12 May 2018 17:01:00 +0000 https://shlomi-noach.github.io/blog/?p=7863#comment-441656 @Jouni, thank you — I’ve never seen this vIP notation, and have always seen VIP notation. https://en.wikipedia.org/wiki/Virtual_IP_address

]]> Comment on MySQL master discovery methods, part 2: VIP & DNS by Jouni Järvinen https://shlomi-noach.github.io/blog/mysql/mysql-master-discovery-methods-part-2-vip-dns/comment-page-1#comment-440463 Tue, 08 May 2018 18:30:00 +0000 https://shlomi-noach.github.io/blog/?p=7863#comment-440463 Using ‘VIP’ to refer to ‘virtual IP’ is confusing, you should call it ‘vIP’ like ‘vGPU’ means ‘virtual GPU’, ‘vCPU’ means ‘virtual CPU’ and ‘vRAM’ means ‘virtual RAM’ whereas ‘VRAM’ means ‘video RAM’.

]]> Comment on REPLACE INTO: think twice by Shlomi Noach https://shlomi-noach.github.io/blog/mysql/replace-into-think-twice/comment-page-1#comment-437007 Tue, 01 May 2018 05:39:00 +0000 https://shlomi-noach.github.io/blog/?p=397#comment-437007 @SacTiw correct.

]]>