mongodbã®explainを使ã£ã¦é…ã„クエリを調査ã—ã¦ã¿ã¦ã‹ã‚‰ã®index貼るメモ - tweeeetyã®ã¶ã‚ãçš„ã‚ã‚‚ã¯ã˜ã‚ã« mongodb×phpã§ã„ã‚ã„ã‚集計ã—ã¦ã„ã‚‹ã®ã§ã™ãŒphpã«timeoutã§exceptionåã‹ã‚Œã¡ã‚ƒã„ã¾ã—ãŸçš„ãªã¨ãã® ç°¡å˜ãªèª¿æŸ»ã¨å¯¾å¿œãƒ¡ãƒ¢ã«åˆã‚ã›ã¦indexを貼るã®ã‚‚メモã£ã¦ãŠãã¾ã™ã€‚ åã‹ã‚ŒãŸã‚¨ãƒ©ãƒ¼ã¯ã“ã‚“ãªæ„Ÿã˜ Fatal error: Uncaught exception \'MongoCursorTimeoutException\' with message \'10.2.xx.xx:27017: Read timed out after reading 0 bytes, waited for 30.000000 seconds\' in ・・・çœç•¥ ã¾ãšã¯explainã®ç°¡å˜ãªèª¬æ˜Žã‹ã‚‰ クエリã®èª¿æŸ»ã£ã¦ã“ã¨ã§é‰„æ¿ã®explainã§ã™ãŒã“ã‚“ãªæ„Ÿã˜ã§ä½¿ã„ã¾ã™ db.collection.find().explain() 出力ã•ã‚Œã‚‹çµæžœã¯jsonå½¢å¼ã§ã™ãŒå„keyã®æ„味
Goodbye MongoDB, Hello PostgreSQL
{{#tags}}- {{label}}
{{/tags}}