BatchSizeManagementTest.php

Go to the documentation of this file.

<?php
namespace Magento\Framework\Indexer\Test\Unit;

use \Magento\Framework\DB\Adapter\AdapterInterface;
use \Magento\Framework\Indexer\BatchSizeManagement;

class BatchSizeManagementTest extends \PHPUnit\Framework\TestCase
{
    private $model;

    private $rowSizeEstimatorMock;

    private $loggerMock;

    protected function setUp()
    {
        $this->rowSizeEstimatorMock = $this->createMock(
            \Magento\Framework\Indexer\IndexTableRowSizeEstimatorInterface::class
        );
        $this->loggerMock = $this->createMock(\Psr\Log\LoggerInterface::class);
        $this->model = new BatchSizeManagement($this->rowSizeEstimatorMock, $this->loggerMock);
    }

    public function testEnsureBatchSize()
    {
        $batchSize = 200;
        $maxHeapTableSize = 16384;
        $tmpTableSize = 16384;
        $size = 20000;
        $innodbPollSize = 100;

        $this->rowSizeEstimatorMock->expects($this->once())->method('estimateRowSize')->willReturn(100);
        $adapterMock = $this->createMock(AdapterInterface::class);
        $adapterMock->expects($this->at(0))
            ->method('fetchOne')
            ->with('SELECT @@max_heap_table_size;', [])
            ->willReturn($maxHeapTableSize);
        $adapterMock->expects($this->at(1))
            ->method('fetchOne')
            ->with('SELECT @@tmp_table_size;', [])
            ->willReturn($tmpTableSize);
        $adapterMock->expects($this->at(2))
            ->method('fetchOne')
            ->with('SELECT @@innodb_buffer_pool_size;', [])
            ->willReturn($innodbPollSize);

        $this->loggerMock->expects($this->once())
            ->method('warning')
            ->with(__(
                "Memory size allocated for the temporary table is more than 20% of innodb_buffer_pool_size. " .
                "Please update innodb_buffer_pool_size or decrease batch size value ".
                "(which decreases memory usages for the temporary table). ".
                "Current batch size: %1; Allocated memory size: %2 bytes; InnoDB buffer pool size: %3 bytes.",
                [$batchSize, $size, $innodbPollSize]
            ));

        $adapterMock->expects($this->at(3))
            ->method('query')
            ->with('SET SESSION tmp_table_size = ' . $size . ';', []);

        $adapterMock->expects($this->at(4))
            ->method('query')
            ->with('SET SESSION max_heap_table_size = ' . $size . ';', []);

        $this->model->ensureBatchSize($adapterMock, $batchSize);
    }
}