Magento2 Indexer ATTRIBUTES_CHUNK_SIZE












4














In MagentoCatalogModelIndexerProductFlatActionIndexer there is one constant:



/**
* Maximum size of attributes chunk
*/
const ATTRIBUTES_CHUNK_SIZE = 59;


reference: https://github.com/magento/magento2/blob/2.0/app/code/Magento/Catalog/Model/Indexer/Product/Flat/Action/Indexer.php#L26



It serves for splitting attributes into chunks during Flat table indexation process.



The question is: Why 59?










share|improve this question





























    4














    In MagentoCatalogModelIndexerProductFlatActionIndexer there is one constant:



    /**
    * Maximum size of attributes chunk
    */
    const ATTRIBUTES_CHUNK_SIZE = 59;


    reference: https://github.com/magento/magento2/blob/2.0/app/code/Magento/Catalog/Model/Indexer/Product/Flat/Action/Indexer.php#L26



    It serves for splitting attributes into chunks during Flat table indexation process.



    The question is: Why 59?










    share|improve this question



























      4












      4








      4


      2





      In MagentoCatalogModelIndexerProductFlatActionIndexer there is one constant:



      /**
      * Maximum size of attributes chunk
      */
      const ATTRIBUTES_CHUNK_SIZE = 59;


      reference: https://github.com/magento/magento2/blob/2.0/app/code/Magento/Catalog/Model/Indexer/Product/Flat/Action/Indexer.php#L26



      It serves for splitting attributes into chunks during Flat table indexation process.



      The question is: Why 59?










      share|improve this question















      In MagentoCatalogModelIndexerProductFlatActionIndexer there is one constant:



      /**
      * Maximum size of attributes chunk
      */
      const ATTRIBUTES_CHUNK_SIZE = 59;


      reference: https://github.com/magento/magento2/blob/2.0/app/code/Magento/Catalog/Model/Indexer/Product/Flat/Action/Indexer.php#L26



      It serves for splitting attributes into chunks during Flat table indexation process.



      The question is: Why 59?







      magento2 indexer magento-core






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited yesterday









      Himanshu

      704419




      704419










      asked Mar 2 '17 at 11:42









      Sinisa Nedeljkovic

      1,223719




      1,223719






















          1 Answer
          1






          active

          oldest

          votes


















          4














          Mysql has a limit of 63 joins per query. The 4 remaining are reserved for things like website and category associations.






          share|improve this answer





















          • Great answer, wasn't thought about that limitation in the variety of MySQL limitations.
            – Sinisa Nedeljkovic
            Mar 3 '17 at 8:40











          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "479"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f162571%2fmagento2-indexer-attributes-chunk-size%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          4














          Mysql has a limit of 63 joins per query. The 4 remaining are reserved for things like website and category associations.






          share|improve this answer





















          • Great answer, wasn't thought about that limitation in the variety of MySQL limitations.
            – Sinisa Nedeljkovic
            Mar 3 '17 at 8:40
















          4














          Mysql has a limit of 63 joins per query. The 4 remaining are reserved for things like website and category associations.






          share|improve this answer





















          • Great answer, wasn't thought about that limitation in the variety of MySQL limitations.
            – Sinisa Nedeljkovic
            Mar 3 '17 at 8:40














          4












          4








          4






          Mysql has a limit of 63 joins per query. The 4 remaining are reserved for things like website and category associations.






          share|improve this answer












          Mysql has a limit of 63 joins per query. The 4 remaining are reserved for things like website and category associations.







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Mar 3 '17 at 6:37









          Fabian Schmengler

          54k20127337




          54k20127337












          • Great answer, wasn't thought about that limitation in the variety of MySQL limitations.
            – Sinisa Nedeljkovic
            Mar 3 '17 at 8:40


















          • Great answer, wasn't thought about that limitation in the variety of MySQL limitations.
            – Sinisa Nedeljkovic
            Mar 3 '17 at 8:40
















          Great answer, wasn't thought about that limitation in the variety of MySQL limitations.
          – Sinisa Nedeljkovic
          Mar 3 '17 at 8:40




          Great answer, wasn't thought about that limitation in the variety of MySQL limitations.
          – Sinisa Nedeljkovic
          Mar 3 '17 at 8:40


















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Magento Stack Exchange!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.





          Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


          Please pay close attention to the following guidance:


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f162571%2fmagento2-indexer-attributes-chunk-size%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          1300-talet

          1300-talet

          Display a custom attribute below product name in the front-end Magento 1.9.3.8