ZabbixãDockerã³ã³ããã§éçšæã®äž»ããŒèšå®
TL;DR Zabbixã¯6.0ããhistoryããŒãã«ã«äž»ããŒã䜿ãããã«ãªããŸãããserver,frontendã®ããã©ãŒãã³ã¹åäžãšããŒãã«ãµã€ãºåæžãèŠèŸŒããããã§ãã https://www.zabbix.com/whats_new_6_0#performance_improvements å ¬åŒã®Dockerã³ã³ãããéçšããŠããå ŽåãDBã³ã³ããã¯å¥ãªã®ã§/usr/share/zabbix-sql-scripts/mysql/history_pk_prepare.sqlããªãã以äžããååŸãããšãããããŸããããŸããã https://git.zabbix.com/projects/ZT/repos/rsm-scripts/browse/database/mysql/history_pk_prepare.sql çµç·¯ Zabbixã®ããã·ã¥ããŒãã®ã·ã¹ãã æ å ±ã«ããããŒã¿ããŒã¹ã®ãã¹ããªããŒãã«ãäž»ããŒã䜿çš: ãããããšè¡šç€ºãããŠããããšã«æ°ã¥ããŸããã 調ã¹ããšãããZabbix 6.0ããhistoryããŒãã«ã®äž»ããŒã®äœ¿çšã«å¯Ÿå¿ããŠãããšã®ããšã§ããã https://www.zabbix.com/whats_new_6_0#performance_improvements æ°èŠã«6.0以éãã€ã³ã¹ããŒã«ããã°èªåã§äž»ããŒãèšå®ããããã以åã®ããŒãžã§ã³ã®ã¢ããã°ã¬ãŒãã®å Žåã¯æåã§å¯Ÿå¿ããå¿ èŠãããããã§ãã https://www.zabbix.com/documentation/6.0/en/manual/appendix/install/db_primary_keys åŒç€Ÿã®ç°å¢ã¯å ¬åŒã®Dockerã³ã³ããã§éçšããŠãŠãDBã¯MariaDBã®å ¬åŒDockerã³ã³ããã䜿çšããŠããŸãããMySQL 8.0+ with mysqlshãã®æé ã«åŸã£ãŠé²ãããšãããéäžã§æå®ãããŠããã/usr/share/zabbix-sql-scripts/mysql/history_pk_prepare.sqlããèŠã€ãããŸããã ãã®æé ã¯1ã€ã®ãµãŒããŒã«web,server,DBãã€ã³ã¹ããŒã«ããæ³å®ãšæãããŸããå ¬åŒã®Dockerã³ã³ããã®web,serverãããŠã³ãããŠãã¡ã€ã«åã§æ€çŽ¢ããŠãèŠã€ãããã åäœã®ZabbixãµãŒããæ§ç¯ããŠãã¡ã€ã«ãåãåºãã®ãé¢åã ã£ãã®ã§ããããæ€çŽ¢ããå ¬åŒã®ãªããžããªãšæããã以äžããããŠã³ããŒãããŠæµã蟌ãã ãšãããããŸããããŸããã https://git.zabbix.com/projects/ZT/repos/rsm-scripts/browse/database/mysql/history_pk_prepare.sql
Excelã§åè§ã«ãã®ãã¡ã€ã«åã§åŒ·å¶ä¿è·ãã¥ãŒ
TL;DR 2023幎5æ2æ¥15:00çŸåšãOffice 365ã®ææ°ã®Excelã§åè§ã«ãã®ãã¡ã€ã«åãã€ããOneDriveåæå¯Ÿè±¡ã®ãã©ã«ãã§éããšæ¯åä¿è·ãã¥ãŒã«ãªãäžå ·åãããããã§ãã ãã¯ããã¡ã€ã«åã«åè§ã«ãã¯é¿ããã»ããè¯ãã®ãããããŸãã⊠çµç·¯ å©çšè ãããèªåã®å Žåã ãExcelãã¡ã€ã«ãéããšæ¯åä¿è·ãã¥ãŒã«ãªããšã®ããšã詊ããŠã¿ããšããã¡ã€ã«ãµãŒãäžã§éãéã«ã¯ååã«ä¿è·ãã¥ãŒãšãªãããç·šéãæå¹ã«ããããã¯ãªãã¯ãããšä»¥éã¯ä¿è·ãã¥ãŒã«ã¯ãªããªããããã©ããã€ã³ã¿ãŒãããããããŠã³ããŒããããã¡ã€ã«ã§ã¯ãªãã£ãœãã®ãæ°ã«ãªãããªãä¿è·ãã¥ãŒã«? ãã®ãã¡ã€ã«ããOneDriveã§åæããŠãããã¹ã¯ãããã§éããšãååã ãã§ãªããæ¯åä¿è·ãã¥ãŒã«ãªãããç·šéãæå¹ã«ããããã¯ãªãã¯ããŠãã 7-zipãMark-of-the-Webã«å¯Ÿå¿ãããã¥ãŒã¹ã¯ç¥ã£ãŠããã®ã§ããããåå ã ãããšããããã€ããåçŸã詊ã¿ããã©ãã«ããã¡ãMark-of-the-Webã®å Žåã¯ãšã¯ã¹ãããŒã©ãŒã§ãã¡ã€ã«ã®ããããã£ã«ãSecurityãã®é ç®ã远å ãããã§ãã¯ããã¯ã¹ã衚瀺ãããã¯ããã衚瀺ãããªã⊠https://www.bleepingcomputer.com/news/microsoft/7-zip-now-supports-windows-mark-of-the-web-security-feature/ Excelã«ãŠä¿è·ãã¥ãŒã®ãã§ãã¯ããã¯ã¹ã®ãã¡ããã€ã³ã¿ãŒãããããååŸãããã¡ã€ã«ã«å¯ŸããŠãä¿è·ãã¥ãŒãæå¹ã«ãããã®ãã§ãã¯ããããšãã®ã¿çºçããã®ã§ãMark-of-the-Webãšçµ¡ãã§ããããªãã®ãªã®ã ããäžèšã®éããã¡ã€ã«ã®ããããã£ã«ã¯è©²åœã®é ç®ã衚瀺ãããªãã ãŸãããšã¯æã£ããã念ã®ãããšæãããã¡ã€ã«åã«å«ãŸããŠããåè§ã«ããåé€ãããšããåé¡ãè§£æ¶âŠããžã⊠æ€èšŒãããšãããåè§ã«ãããã¡ã€ã«åã«å«ãŸãããšçºçãããçºçããã®ã¯Excelã®ã¿ããã€2023/5/2 15:00æç¹ã§ææ°ã® 2304(build 16327.20214)ã§çºçããããšãŸã§çªãæ¢ããããã(ããŸããŸç€Ÿå ã«ãã£ããå€ãããŒãžã§ã³ã®Excelã§ã¯çºçããªãã£ã) åæ§ã®çç¶ãWebã§ã¯èŠã€ãããªãã£ãã®ã§ãçŸæç¹ã§æªè§£æ±ºã®åé¡ãšå€æãå©çšè ã«ã¯åè§ã«ããå šè§ã«ãã«å€ããããšã§ã®æ«å®å¯Ÿå¿ãæç€ºãWin+Fã§Feedback Hubã«ãŠå ±åããã 1æ¥ã€ã¶ããŠããŸã£ãâŠ
MariaDBã§å®è¡èšç»ãSQLçµã¿ç«ãŠã®ä¿®æ£
TL;DR SQLã¯æããã«ãã£ãŠããã®ã«åäœãé ããäžãããã©ã¡ãŒã¿ã«ãã£ãŠå€ãããšãã£ãç¶æ³ã§ã¯EXPLAINã§å®è¡èšç»ã確èªããŸããã æå³ããªãé§åé ã«ãªã£ãŠããããšããããŸã çµç·¯ ä»äºã§ã®è©±ã®ãã詳现ãªSQLã®å 容ã¯ãããªãããMariaDB(10.6.12)ã§ãã£ãããšä»¥äžã®ãããªSQLã§ç¹å®ã®äŒç¥šçªå·ãæå®ããå Žåã«å¿çãé ããŠã¿ã€ã ã¢ãŠãããäºè±¡ãçºçãŸããã SELECT ... FROM ( ( A INNER JOIN B ON B.PRODUCT_CD = A.PRODUCT_CD ) LEFT OUTER JOIN C ON C.CUSTOMER_CD = A.CUSTOMER_CD C.PRODUCT_CD = A.PRODUCT_CD AND C.SIZE = A.SIZE ) LEFT OUTER JOIN C AS D ON D.CUSTOMER_CD = A.CUSTOMER_CD D.PRODUCT_CD = A.PRODUCT_CD AND D.SIZE = 0 WHERE A.SLIP_NO = 123456789 æ¬åœã¯ãã£ãšå€æ°ã®ããŒãã«ãJOINããŠããŸããããæå°éã®èŠçŽ ã ãåŒã£åŒµã£ãŠããŠãŸãã ããããã®çµåæ¡ä»¶ã¯äž»ããŒã䜿çšããŠããŸãã ã§ãWHEREå¥ã«æå®ããäŒç¥šçªå·ãç¹å®ã®çªå·ã®å Žåã«ãå¿çãè¿ã£ãŠããã«ã¿ã€ã ã¢ãŠãã«ãªãäºè±¡ãçºçããŸãããã»ãã®äŒç¥šçªå·ãæå®ãããšããè¿ã£ãŠããã®ã§ãSQLã«ææ³ãšã©ãŒã¯ãªãã§ãã æåŸã®C AS Dã®å€éšçµåãå€ããšããåž°ã£ãŠããã®ã§ããããããããã®ããŒãã«ã®çµåæ¡ä»¶ã«ãããããããŒã¿ããªãã®ã§ããã®äŒç¥šçªå·ã®å Žåã«ããŒã¿ãå€ããªãããšããããã§ããªãã§ãã ä»ãŸã§ãã®æã®åé¡ã«åœãã£ãããšããªãã£ãã®ã§äœ¿ããã«æžãã§ããããããŸã§é¿ããŠããEXPLAINæã䜿ã£ãŠå®è¡èšç»ãèŠãŠã¿ãŸããã ãããšãé§å衚ã以äžã®é çªã«ãªã£ãŠããŸããã A(PK) C(PK) D(PK) B(Null) ã«ãã³å ã¯ããŒã§ããA,C,Dã¯äž»ããŒã§çµåã§ããŠããŸãããBã¯NULLãšãªã£ãŠããŸã£ãŠããŸããã ããããã¯æšæž¬ã«ãªããŸãããããŒãã«B,C,Dã®ããããããŒãã«Aããçµåã§ããã®ã§ãçµ±èšããŒã¿ã®äžè¶³ãªã©ã絡ãã çµæãäžèšã®ãããªçµåé ã«ãªã£ãã®ã§ã¯ãªãããšèããŠããŸãã...
Chrostiniã§VSCodeãæãã
TL;DR Chromebookã®Chrostiniç°å¢ã§VSCodeãå®å®ããŠäœ¿ããŸãã~~ãã ããASUS CM5500ã§ã¯Terminalãæ£åžžã«åäœããŸããã~~2023.3.27 ASUS CM5500ã§ãæ£åžžã«åäœããŠããŸã çµç·¯ 以åã®èšäºã§ãChromebookã§Chrostiniäžã®VSCodeãçŽæ¥äœ¿ããšIME(Chrostini(Debian)ã«ã€ã³ã¹ããŒã«ããfcitx)ãäžå®å®ãªãããVSCode Serverçµç±ã§ã®å©çšãè¯ããšèšäºã«ããŠããŸãããã§ããããã£ã±ãæ¯åèµ·åããã®ã¯é¢åã§ããWindowsã«ãªã¢ãŒãæ¥ç¶ããŠVSCode䜿ã£ãŠåé¿ããŠããŸããã æè¿ã以äžã®èšäºãèŠã€ããå床ãã©ã€ããŸããã ChromeOS IME on Crostini äžèšURLã«åŸã£ãŠcrostini-ime-supportãæå¹ã«ããLinuxç°å¢ãåäœæããŠVSCodeãã€ã³ã¹ããŒã«ãããšãããæ®éã«ChromeOSã®IMEã䜿ããŸãã!!! fcitxã®ã€ã³ã¹ããŒã«çã®é¢åãªæé ãå¿ èŠãªããªããŸãã!! ~~ã§ããããªããASUS CM5500ã ãšãVSCodeå ã®Terminalã§æåãå ¥åãããš2éã§å ¥åãããŠããŸããŸãããaããšå ¥åãããšããaaããšåºãã®ã§ããåºãããšã¯1æåãã€æ¶ããã®ã§ãããVSCodeã®Terminalã®Echoèšå®ããããèŠãŠè²ã ãã£ãŠã¿ãŸããããã ãã§ããã ~~ äžæè°ãªããšã«ããã1ã€ChromebookãšããŠæã£ãŠããASUS CM3000ã§ã¯åé¡ãããŸããã§ãããCM5500ã¯x64ç³»ãCM3000ã¯ARM64ç³»ãªã®ã§ã€ã³ã¹ããŒã«ãããããã±ãŒãžãéãã®ã§ããã®ããããåå ãããããŸããããŸããTerminalã¯ChromeOSæšæºã®ãã®ã䜿ãã°è¯ãã®ã§ã以åããã¯äœ¿ãããšæã£ãŠããŸãã 2023.3.27 ASUS CM5500 ã§ãæ£åžžã«åäœããŠããŸããOSæŽæ°ã§å¯Ÿå¿ãããã®ãããããŸããã
Excelã§è¬ã®è¥å€§å
TL;DR Excelã®å®¹éè¥å€§åã§ã¯ã以äžã®é ã«åãåããŸããã èŠãç®ã§æããã«ãªããžã§ã¯ããè©°ã蟌ãŸããŠããªãã Ctrl+Endã§ãæ³å®ä»¥äžã«åºãç¯å²ãæå®ãããŠããªãã [ããŒã ]-[éžæ]-[ãªããžã§ã¯ãã®éžæãšè¡šç€º]ã§ãæ³å®ä»¥äžã®ãªããžã§ã¯ãã衚瀺ãããªãã ã¡ãã£ãšããããã°ã©ã ãã±ã£ãšäœãã®ã«ChatGPTã¯äŸ¿å© çµç·¯ ããExcelãã¡ã€ã«ãéããšåäœãé ãã®ã§ãªããšããªããªãããšåãåããããããŸããããšãããããã¡ã€ã«éã£ãŠãããã調ã¹ãŸããã ïŒãã¡ã€ã«ã§å®¹éã3MBãè¶ ããŠãããããªã倧ããã§ããæ°åŒãéãããããŒã¿ãéããã§åå ãèããŠããŸããããå°ãªããšãåŸè ã¯åå ã«ãªãããã§ãã ã·ãŒãæ°ã¯2ã€ãè¡ã¯1000è¿ããŸã§è¡ã£ãŠããã®ã§å°ããã¯ãªããããã»ã©ã§ããªãæããäžã«ããã®ã¯å·¥çšè¡šã§ã眫ç·ã®è¡šã«ç·ãªããžã§ã¯ãã倿°ãšããæãã§ãã¡ããã¡ãå€ããšããã»ã©ã§ããªãæãã ãã®æã®è¥å€§åã§ããããã®ã¯ãå©çšè ãæ°ã¥ããªããã¡ã«ããŒã¿ãå ¥åãããŠããã»ã«ã®ç¯å²ãåºãã£ãŠããŸã£ãŠããã±ãŒã¹ããã®å Žåã¯ã¹ã¯ããŒã«ããŒããããèŠã®å·¥çšè¡šã®ç¯å²ãããåºãèšå®ãããããã©ããã§ããããŸãããã©ããããã§ã¯ãªãããã§ãïœãã äžæ¹ã®ã·ãŒããèŠãç®äžããŒã¿ãå€ãããã¡ãã®ã·ãŒããåå ããªãšæããå°ããã€è¡ãåé€ããŠåãåããŠããããšèããŸããããããšã«ããåäœãéããå¥ã®ç»é¢ã«ãã©ãŒã«ã¹ãç§»ããŠæ»ã£ãŠããã ãã§ããŠã¹ãããããåããŸã⊠äžäžã«ã¹ã¯ããŒã«ããã®ãããã©ãæãã ãªããšãé 匵ã£ãŠãè€æ°ããå·¥çšè¡šã®ãã¡ãæåã®ãã®ã ãæ®ããŠä»ãåé€ããŸãããã容éã¯å€§ãããŸãŸãã§ããã®è¡šãåé€ããŠããŸã 容éã¯å€§ãããŸãŸã§ããããªããžã§ã¯ãã®ç¯å²éžæã§æªããããªå ŽæãéžæããŠããããããããªããžã§ã¯ãã¯ç¡ãã ããã§æ¹ããŠ[ããŒã ]-[éžæ]-[ãªããžã§ã¯ãã®éžæãšè¡šç€º]ãèŠãããšãããšããã衚瀺ãŸã§ã«5-10åãããã倧éã®ããã¹ãããã¯ã¹ã衚瀺ãããŸãããããã ⊠éåžžã§ããã°ããã§1ã€ãéžæããç¶æ ã§Ctrl+Aã§ãã¹ãŠã®å³åœ¢ãéžæã§ãããããªã®ã§ãããéãããŠãã€ãŸã§ç«ã£ãŠãéžæãçµãããŸãã⊠è²ã 詊è¡é¯èª€ããã®ã§ãããVBAã§ããã¹ãããã¯ã¹ãåé€ããŠããŸãã®ãæã£åãæ©ããã ãšèããŸããããããã£ããšãã«äœ¿ã£ãŠã¿ãããšæã£ãã®ãChatGPTãBingã§äœ¿ããããã«ãªã£ãŠããã®ã§ããã¹ãŠã®ããã¹ãããã¯ã¹ã®ãªããžã§ã¯ããåé€ããVBAãèããŠè¿ã£ãŠããå 容ã埮調æŽããã®ãä»¥äž Sub DeleteTextBoxes() Dim ws As Worksheet Dim shp As Shape Dim n As Long Application.ScreenUpdating = False Application.Calculation = xlCalculationManual For Each ws In ThisWorkbook.Worksheets For Each shp In ws.Shapes Debug.Print "[" &ws.Name & "ã·ãŒãã®åŠçãéå§" & "]" If shp.Type = msoTextBox Then shp.Delete n = n + 1 Debug.Print n & "åç®ã®ããã¹ãããã¯ã¹ãåé€ããŸãã" Else Debug....