作者: Ran

Laravel Development

php artisan view:clear
php artisan cache:clear
php artisan route:clear
php artisan config:clear
php artisan clear-compiled

composer dump-autoload

Laravel Production

php artisan view:clear
php artisan route:clear
php artisan config:clear
php artisan config:cache
php artisan route:cache
php artisan clear-compiled

composer dump-autoload -o --no-dev --classmap-authoritative

https://try-puppeteer.appspot.com/

const browser = await puppeteer.launch();

const page = await browser.newPage();

await page.setViewport({
    width: 1920,
    height: 1080,
    deviceScaleFactor: 1,
});

await page.emulateMedia('screen');
await page.goto('https://csrone.com/');
await page.evaluate(function() {
    $('#GRI-content-included').remove();
    $('#back_to_top').remove();
    $('.cc-floating.cc-theme-classic').remove();
});

// force lazy loading
await page.evaluate(() => window.scrollTo(0, Number.MAX_SAFE_INTEGER));

// Here I'd love to use page.waitForNetworkIdle() instead of something similar
await page.waitFor(500);

await page.screenshot({
    path: 'screenshot.png',
    fullPage: true
});

await browser.close();

SELECT
    TABLE_NAME AS `Table`,
    ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024, 2) AS `Size (MB)`
FROM
    information_schema.TABLES
WHERE
    TABLE_SCHEMA = 'DatabaseName'
ORDER BY
    (DATA_LENGTH + INDEX_LENGTH)
DESC;

資料來源：https://chartio.com/resources/tutorials/how-to-get-the-size-of-a-table-in-mysql/