All of Percona’s open-source software products, in one place, to download as much or as little as you need.
linux-os-tuning-for-mysql-database-performance
All of Percona’s open-source software products, in one place, to download as much or as little as you need.
SystemTapã§MySQLã®Disk I/Oを分æžã™ã‚‹ - SH2ã®æ—¥è¨˜
実験エントリã§ã™ã€‚ å‹•æ©Ÿ Oracleã®Statspack/AWRã§å–れるファイルå˜ä½ã®Disk I/Oæƒ…å ±ã‚’ã€MySQLã§ã‚‚採å–ã—ãŸã„。ã“ã‚Œã¯æ¬¡ã«ç¤ºã™ã‚ˆã†ãªãƒ‡ãƒ¼ã‚¿ã§ã™ã€‚ File IO Stats DB/Inst: ORA112/ORA112 Snaps: 6-7 ->Mx Rd Bkt: Max bucket time for single block read ->ordered by Tablespace, File Tablespace Filename ------------------------ ---------------------------------------------------- Av Mx Av Av Rd Rd Av Av Buffer BufWt Reads Reads/s (ms) Bkt Blks/Rd Writes Writes/s Wai
The History of etcd | CoreOS
Red Hat Enterprise Linux 8.8 and 9.2 leverage Intel’s 5th Gen of features including higher cpu count, faster DDR5 memory, larger 3rd level caches, improved interprocessor bandwidth, and complete implementation of Intel’s Advanced Matrix Extensions. Included in this blog are two new Dell SAP HANA BW...
è² è·è©¦é¨“ã®ãŸã‚ã®ãƒŽã‚¦ãƒã‚¦ã¨ Webフレームワークã®è² è·è©¦é¨“ (Python,Node,Go,PHP) - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article? ã“ã®è¨˜äº‹ã¯Retty Advent Calendar 2017 ã«ãŠã‘ã‚‹ 22日目ã®è¨˜äº‹ã§ã™ã€‚ 昨日㯠@saku ã•ã‚“ã® swiftã§ä¸¸ç”»åƒã‚’パフォーマンス高ã表示ã™ã‚‹æ–¹æ³• ã§ã—ãŸã€‚ ã¯ã˜ã‚㫠趣味ã®Bot開発ã‹ã‚‰æ°—ã¥ã‘ã°Webフレームワークã®è² è·è©¦é¨“ã‚’è¡Œãªã£ã¦ã„ã¾ã—ãŸã€‚ Software Engineerã®@tkngueã§ã™ã€‚普段æ¥å‹™ã¨ã—ã¦ã¯ã€Data Engineer/Web Service開発/データ分æžã‚„ã£ã¦ã¾ã™ 「速ã•ã¯æ£ç¾©ã€ ã¨ã¯çš†ã®å…±é€šã®èªè˜ã§ã€è¨€ã†ã¾ã§ã‚‚ãªã„ã“ã¨ã ã¨æ€ã†ã®ã§ã™ãŒ 本記事ã§ã¯ã€é€Ÿã•ã£ã¦ãªã‚“ã ã‚ã†ã£ã¦è€ƒãˆã¦
I/Oè² è·ã®æ£ç¢ºãªçŠ¶æ³ã¯iowaitã§ã¯åˆ†ã‹ã‚Šã¾ã›ã‚“ - Qiita
ã•ãらインターãƒãƒƒãƒˆã®ã‚¢ãƒ‰ãƒ™ãƒ³ãƒˆã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼9日目ã¨ã—ã¦ã€ã‚µãƒ¼ãƒå±‹ã‚‰ã—ãã€é‹ç”¨ã«é–¢ã™ã‚‹ã‚³ãƒžãƒ³ãƒ‰ã®ä½¿ã„方を紹介ã—ã¾ã™ã€‚ サーãƒã®è² è·ãŒé«˜ã¾ã£ã¦ããŸã¨ãã«ã€vmstatã‚„topãªã©ã®ã‚³ãƒžãƒ³ãƒ‰ã§èª¿æŸ»ã™ã‚‹äº‹ãŒå‡ºæ¥ã¾ã™ãŒã€I/Oè² è·ã‚’wa(iowait)ã«ã‚ˆã£ã¦åˆ¤æ–ã™ã‚‹äººã‚‚多ã„ã¨æ€ã„ã¾ã™ã€‚ ãŸã ã€çµè«–ã‹ã‚‰è¨€ã†ã¨ã€iowaitã¯æ£ç¢ºã«I/Oã®è² è·ã‚’表ã—ã¦ã„ã‚‹ã‚ã‘ã§ã¯ã‚ã‚Šã¾ã›ã‚“。 ã“れらをã€å®Ÿéš›ã«æ¼”ç¿’ã‚’ã—ãªãŒã‚‰è¦‹ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ iowaitã¨idle iowaitã¨ã¯ã‚ãã¾ã§ã‚‚ã€CPUãŒç©ºã„ã¦ã„ã‚‹ã®ã«I/OãŒãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã£ã¦ã„るプãƒã‚»ã‚¹ã‚’示ã—ã¦ã„ã‚‹ã ã‘ã§ã€CPUã®åˆ©ç”¨çŽ‡ãŒé«˜ã„ã¨ãã«ã¯I/OãŒãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã£ã¦ã„ã¦ã‚‚iowaitãŒä¸ŠãŒã‚Šã¾ã›ã‚“。 åŒæ§˜ã«å‹˜é•ã„ã•ã‚ŒãŒã¡ãªã®ãŒã€id(idle)ã¯CPUã®ç©ºãを示ã—ã¦ã„ã‚‹ã¨ã„ã†ã‚‚ã®ã§ã™ãŒã€idleã¯å¿…ãšã—ã‚‚CPUã®ç©ºã時間を示ã—ã¦ã„ã‚‹ã‚‚ã®ã§ã¯ã‚ã‚Šã¾ã›
PostgreSQL performance on EXT4 and XFS | PostgreSQL Addict
In case you haven't noticed, the schedule for pgconf.eu 2015 was published a few days ago. One of my talks is called PostgreSQL Performance on EXT4, XFS, F2FS, BTRFS and ZFS and aims to compare PostgreSQL performance of modern Linux file systems (and also impact of various tuning options like write barriers, discard etc.). It's not an entirely new talk - it's a reworked (and significantly improved
Redisサーãƒã®CPUè² è·å¯¾ç–パターン - ゆã†ã†ãブãƒã‚°
Redisã¯å¤šå½©ãªãƒ‡ãƒ¼ã‚¿æ§‹é€ ã‚’ã‚‚ã¤1インメモリDBã§ã‚ã‚Šã€æ˜¨ä»Šã®Webアプリケーションã®ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã®ä¸€ã¤ã¨ã—ã¦ã€åºƒã利用ã•ã‚Œã¦ã„る。 ã—ã‹ã—ã€ä¸€æ–¹ã§ã€æ€§èƒ½æ”¹å–„ã®ãŸã‚ã®æ‰‹æ³•ã‚’体系的ã«ã¾ã¨ã‚ãŸè³‡æ–™ãŒè¦‹å½“ãŸã‚‰ãªã„ã¨æ„Ÿã˜ã¦ã„ãŸã€‚ 実際ã€æœ€åˆã«CPUè² è·ãŒå•é¡Œã«ãªã£ãŸã¨ãã«ã©ã†ã—ãŸã‚‚ã®ã‹ã¨æ‚©ã¿ã€èª¿æŸ»ã¨è©¦è¡ŒéŒ¯èª¤ã‚’ç¹°ã‚Šè¿”ã—ãŸã€‚ ãã“ã§ã€ã“ã®è¨˜äº‹ã§ã¯ã€è‡ªåˆ†ã®çµŒé¨“を基ã«ã€Redisサーãƒã®CPUè² è·å¯¾ç–を「CPUè² è·å‰Šæ¸›ã€ã€Œã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ãƒƒãƒ—ã€ã€Œã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã€ã«åˆ†é¡žã—ã€ãƒ‘ターンã¨ã—ã¦ã¾ã¨ã‚る。 背景 Redisã®CPUè² è·å¯¾ç–パターン CPUè² è·å‰Šæ¸› multiコマンド Redisパイプライニング Luaスクリプティング Redisモジュール(夢) スケールアップ スケールアウト å‚照用スレーブ 垂直分割 水平分割 Redis Clusterã«ã‚ˆã‚‹æ°´å¹³åˆ†å‰² ãã®ä»– スライド資料 ã‚ã¨ãŒã å‚考資料 背景 R
Linux Performance
static, benchmarking, tuning: sar, perf-tools, bcc/BPF: bpftrace, BPF book: Images license: creative commons Attribution-ShareAlike 4.0. This page links to various Linux performance material I've created, including the tools maps on the right. These use a large font size to suit slide decks. You can also print them out for your office wall. They show: Linux observability tools, Linux static perfor
Innotop - MySQLã®ãŸã‚ã®ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ã§é«˜æ©Ÿèƒ½ãªèª¿æŸ»ãƒ„ール | Yakst
MySQL Performance Blogã®ç¿»è¨³ã€‚MySQLをリアルタイムãªã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹ã‚’見るツールã«innotopãŒã‚る。ã“ã®ã‚·ãƒ³ãƒ—ルã ãŒéžå¸¸ã«å½¹ç«‹ã¤ãƒ„ールã®åŸºæœ¬çš„ãªä½¿ã„方やã€è¤‡æ•°ã®ã‚µãƒ¼ãƒã®çŠ¶æ…‹ã‚’一度ã«ç¢ºèªã™ã‚‹æ–¹æ³•ãªã©ã‚’解説ã™ã‚‹ã€‚ MySQLã®GUIモニタリングツールã¯ã€æˆ‘々ã®ã‚らゆるニーズや状æ³ã«ã„ã¤ã§ã‚‚ã´ã£ãŸã‚Šãã‚‹ã‚‚ã®ã¨ã¯é™ã‚‰ãªã„。ãã†ã„ã£ãŸãƒ„ールã®å¤šãã¯ã€MySQLサーãƒã®ç¾åœ¨ã®çŠ¶æ…‹ã‚’リアルタイムã«è¡¨ç¤ºã—ã¦ãれるã¨ã„ã†ã‚ˆã‚Šã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«éŽåŽ»ã©ã®ã‚ˆã†ãªã“ã¨ãŒèµ·ããŸã‹ã®æ´å²çš„ãªè¦‹æ–¹ã‚’æä¾›ã—ã¦ãれるよã†è¨è¨ˆã•ã‚Œã¦ã„る。Cactiã‚„Zabbixã€Gangliaã€Nagiosã¨ã„ã£ãŸç´ 晴らã—ã„フリーã®ãƒ„ールもã‚る。ã—ã‹ã—ã“れらã¯ã€MySQLインスタンスã§ä½•ãŒè¡Œã‚ã‚Œã¦ã„ã‚‹ã‹ã®è©³ç´°ã‚’見るãŸã‚ã«ã¯æ£ã—ãè¨å®šã‚’ã™ã‚‹å¿…è¦ãŒã‚る。ãã—ã¦ãã†ã„ã£ãŸè¨å®šã¯ã€ç´ æ—©ãã§ãã‚‹ã¨ã¯è¨€ã„難ãã€é¢å€’ãªã‚‚ã®ã§ã‚ã‚‹(G
innotopã§MySQL状態をtop風ã«è¡¨ç¤ºï¼ˆã‚°ãƒ«ãƒ¼ãƒ—å˜ä½ã§ï¼ï¼‰ - mikedaã®æ—¥è¨˜
innotopã¯MySQLã®çŠ¶æ…‹ã‚’top風ã«è¡¨ç¤ºã™ã‚‹ã‚³ãƒžãƒ³ãƒ‰ã§ã™ã€‚ DBã‚’1å°ãšã¤è¦‹ã¦ã„ãã¶ã‚“ã«ã¯ç‰¹ã«ä½¿ã†å¿…è¦æ€§ã‚’æ„Ÿã˜ãªã‹ã£ãŸã®ã§ã™ãŒã€ サーãƒã®ã‚°ãƒ«ãƒ¼ãƒ”ング＆一括表示機能ãŒã‚ã‚‹ã“ã¨ã‚’知ã£ã¦ã“ã‚Œã¯ã‘ã£ã“ã†ä¾¿åˆ©ãªã®ã§ã¯ï¼Ÿã¨æ€ã„ãªãŠã—ãŸã®ã§ インストールã‹ã‚‰ã‚°ãƒ«ãƒ¼ãƒ—è¨å®šã¾ã§ã«ã¤ã„ã¦æ›¸ã„ã¦ã¿ã¾ã™ã€‚ サンプルイメージ グループå˜ä½ã§ã‚¯ã‚¨ãƒªãƒ¼ãƒªã‚¹ãƒˆã‚’表示 グループå˜ä½ã§ãƒ¬ãƒ—リケーション状態を表示 インストール ã“ã“ã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ ※今回使ã£ãŸã®ã¯innotop1.8 ＆ CentOS5.Xã§ã™ã€‚ ä¾å˜ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« # yum install perl-DBI perl-DBD-mysql # rpm -Uvh http://download.fedora.redhat.com/pub/epel/5/x86_64/epel-release-5-4.noarch.r
Linux perf Examples
Recent posts: 29 Oct 2024 » AI Flame Graphs 22 Jul 2024 » No More Blue Fridays 24 Mar 2024 » Linux Crisis Tools 17 Mar 2024 » The Return of the Frame Pointers 10 Mar 2024 » eBPF Documentary 28 Apr 2023 » eBPF Observability Tools Are Not Security Tools 01 Mar 2023 » USENIX SREcon APAC 2022: Computing Performance: What's on the Horizon 17 Feb 2023 » USENIX SREcon APAC 2023: CFP 02 May 2022 » Brendan
EC2 インスタンス上㧠perf コマンドを使ã£ã¦ã¿ãŸ | iret.media
cloudpack 㮠自称 Sensu芸人 ã® ã‹ã£ã±ã“㨠å·åŽŸ 洋平（@inokara）ã§ã™ã€‚ ã¯ã˜ã‚㫠サーãƒãƒ¼ç‰ã®ãƒ‘フォーマンスã®è§£æžã‚„ボトルãƒãƒƒã‚¯ã®èª¿æŸ»ã‚’è¡Œã†ã«éš›ã—ã¦åˆ©ç”¨ã™ã‚‹ã‚³ãƒžãƒ³ãƒ‰ã¨ã—ã¦ã¯â€¦ top vmstat iostat sysstat ç‰ã‚’利用ã™ã‚‹ã“ã¨ã¯å¤šã„。ã“れらã®ã‚³ãƒžãƒ³ãƒ‰ã§è¦‹å½“ã¯ã¤ã‘られãŸã‚Šã™ã‚‹ã‚‚ã®ã®ã€ã‚ˆã‚Šç´°ã‹ã„（例ãˆã°ã‚«ãƒ¼ãƒãƒ«ãƒ¬ãƒ™ãƒ«ï¼‰ãƒ¬ãƒ™ãƒ«ã§èª¿æŸ»ã—ãŸã„å ´åˆã«å½¹ã«ç«‹ã¡ãã†ãªã®ãŒ perf コマンド。 ã¨ã„ã†ã“ã¨ã§ã€æ—©é€Ÿè©¦ã—ã¦ã¿ãŸã€‚ å‚考 perfã®ä½¿ã„ã‹ãŸ – J perfを使ã£ãŸPostgreSQLã®è§£æž(å‰ç·¨) 6.4.2. Perf ã®ä½¿ç”¨æ–¹æ³• perf コマンドã«ã¤ã„㦠ãã‚‚ãã‚‚ãªã«ï¼Ÿ 一言ã§è¨€ã†ã¨â€¦ Linux ã®æ€§èƒ½è§£æžãƒ„ール ã–ã£ãり出æ¥ã‚‹ã“ã¨ã‚’言ã†ã¨â€¦ 実行ã•ã‚Œã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ 㨠OS ã¨ã®ã‚„ã‚Šã¨ã‚Šï¼ˆã‚¤ãƒ™ãƒ³ãƒˆï¼‰ã‚’見るã“ã¨ãŒå‡ºæ¥ã‚‹ OS ã¨ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã®ã‚„
パフォーマンスå‘上ã®ãŸã‚ã®ãƒ‡ã‚¶ã‚¤ãƒ³è¨è¨ˆ
Webサイトã®ãƒ‘フォーマンスã¯ã€ã€Œ9：1ã§ãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰å´ã®ãƒ‘フォーマンスãŒé‡è¦ã€ã ã¨è¨€ã‚ã‚Œã¦ã„ã¾ã™ã€‚パフォーマンスã®å‘上ã«ã¯ã€ã‚¤ãƒ³ãƒ•ãƒ©å´ã ã‘ã§ãªãフãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã®è¨è¨ˆãŒå¤§ã„ã«å½±éŸ¿ã—ã¾ã™ã€‚ãã“ã§æœ¬æ›¸ã¯ã€Webサイトã®ãƒ‘フォーマンスå‘上ã«ã¤ã„ã¦ãƒ‡ã‚¶ã‚¤ãƒ³é¢ã‹ã‚‰ã®ã‚¢ãƒ—ãƒãƒ¼ãƒã«ç‰¹åŒ–ã—ã€æ—¥ã€…ã®æ¥å‹™ã«å–ã‚Šè¾¼ã‚ã‚‹CSSã€HTMLã®ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚„ã€Webサイトã§ä½¿ç”¨ã™ã‚‹ç”»åƒã‚’作æˆã™ã‚‹éš›ã®ãƒ’ントを紹介ã—ã¦ã„ã¾ã™ã€‚ã¾ãŸã€ãƒ‡ã‚¶ã‚¤ãƒŠãƒ¼ã ã‘ã§ãªãã€ã‚µã‚¤ãƒˆé‹å–¶ã«æºã‚ã‚‹ã™ã¹ã¦ã®ã‚¹ã‚¿ãƒƒãƒ•ãŒãƒ‘フォーマンスã¸ã®æ„è˜ã‚’高ã‚ã‚‹ãŸã‚ã®åŠ¹æžœçš„ãªå–り組ã¿ã«ã¤ã„ã¦ã‚‚解説ã—ã¾ã™ã€‚ 賞賛ã®å£° 推薦ã®è¨€è‘‰ ã¯ã˜ã‚㫠監訳者ã¾ãˆãŒã 1ç« ã€€ã‚µã‚¤ãƒˆãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¯ãƒ¦ãƒ¼ã‚¶ã‚¨ã‚¯ã‚¹ãƒšãƒªã‚¨ãƒ³ã‚¹ 1.1　ブランドã«ä¸Žãˆã‚‹å½±éŸ¿ 1.1.1　ユーザã®å†è¨ªå• 1.1.2　検索エンジンã®é †ä½ 1.2　モãƒã‚¤ãƒ«ãƒ¦ãƒ¼ã‚¶ã¸ã®å½±éŸ¿ 1.2.1　モãƒã‚¤ãƒ«ãƒãƒƒãƒˆãƒ¯ãƒ¼
PostgreSQL Scalability: Towards Millions TPS - Alexander Korotkov's blog
PostgreSQL scalability on multicore and multisocket machines became a subject of optimization long time ago once such machines became widely used. This blog post shows brief history of vertical scalability improvements between versions 8.0 and 8.4. PostgreSQL 9.2 had very noticeable scalability improvement. Thanks to fast path locking and other optimizations it becomes possible to achieve more tha
Javaã®è¬Žã®ãƒ‘フォーマンス劣化ç¾è±¡ã¨ã®æˆ¦ã„ - Cybozu Inside Out | サイボウズエンジニアã®ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€‚アプリケーション基盤ãƒãƒ¼ãƒ ã®æ¨ªç”°ã§ã™ã€‚ Javaã®è¬Žã®ãƒ‘フォーマンス劣化ã«ã¾ã¤ã‚る調査をã—ã¦ã„ãŸã®ã§ã™ãŒã€1ヶ月ã®è‹¦åŠ´ã®æœ«ã«åŽŸå› ãŒã‚ã‹ã‚Šã¾ã—ãŸã®ã§ã€å ±å‘Šã•ã›ã¦ã„ãŸã ãã¾ã™ï¼ 公開後ã«é ‚ã„ãŸã¯ã¦ãªãƒ–ックマークã§ã®ã”指摘・社内ã§ã®ã‚¿ã‚¤ãƒãƒ»èªã¿ã«ãã„ãªã©ã®æŒ‡æ‘˜ã‚’å—ã‘ã¦ãŸã®ã§ã€è¬¹ã‚“ã§ä¿®æ£ã•ã›ã„ãŸã ãã¾ã™ã€‚ ä¿®æ£ã—ãŸå†…容ã«ã¤ãã¾ã—ã¦ã¯ã€è¨˜äº‹ã®æœ€å¾Œã‚’å‚ç…§ã—ã¦ãã ã•ã„。 å¿™ã—ã„人ã®ãŸã‚ã®ã¾ã¨ã‚ jdk-7u4以é™ã®jdk-7 *1 ã§Javaã®ãƒ‘フォーマンスãŒåŠ£åŒ–ã™ã‚‹è¬Žã®ç¾è±¡ CodeCacheã®å®¹é‡é™ç•Œã«è¿‘ã¥ãã¨JITコンパイラをåœæ¢ã—ã¦ã‚³ãƒ³ãƒ‘イルã—ãŸã‚³ãƒ¼ãƒ‰ã‚’æ¨ã¦ã‚‹æ©Ÿèƒ½ãŒåŽŸå› ã ã£ãŸ 起動オプションã§å›žé¿ã§ãã‚‹ã®ã§ã€é•·æœŸé‹ç”¨ã™ã‚‹ã¨ã㯠-XX:-UseCodeCacheFlushing, -XX:ReservedCodeCacheSize=128m ã‚’ã¤ã‘ã‚‹ 上ã®ã‚ªãƒ—ションをè¨å®šã—ãŸæ™‚ã«ã€C
2015 Archives
We’ve all been there. You’re putting together a proposal or a slide deck or a blog post, and you think to yourself “Oh, man… it sure would be great to include some stats around how performance affected [insert metric of your choice]. Now how the heck do I find that stat?†Sure, you may be […] We’re deep in the holiday season and you’re looking for that last minute speed gift. Here’s something valu
1
ランã‚ング
ランã‚ング
ランã‚ング
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
{{#tags}}- {{label}}
{{/tags}}