<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/xhtml; charset=utf-8">
</head>
<body><div style="font-family: sans-serif;"><div class="markdown" style="white-space: normal;">
<p dir="auto">The table was just over a gig.</p>
<p dir="auto">Ive reenabled telescope , and its not maxing mysql yet, but will look after a while</p>
<p dir="auto">It looks like it was running multiple updates on the same table, and that slowed things down the whole time.</p>
<p dir="auto">And I suspect the DB is growing rapidly due to the driver error from the php 8.1 vs 8</p>
<p dir="auto">Kind regards</p>
<p dir="auto">Edd</p>
<p dir="auto">On 27 May 2024, at 17:18, Barry O'Donovan (INEX) wrote:</p>
</div><div class="plaintext" style="white-space: normal;"><blockquote style="margin: 0 0 5px; padding-left: 5px; border-left: 2px solid #777777; color: #777777;"><p dir="auto">Hi Ed,</p>
<p dir="auto">we haven't seen any performance issues in development or production. Your snippet below shows a lot happening with Telescope</p>
<p dir="auto">What does this SQL command show you:</p>
<p dir="auto">SELECT TABLE_NAME AS `Table`,
<br>
ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS `Size (MB)`
<br>
FROM information_schema.TABLES
<br>
WHERE
<br>
TABLE_SCHEMA = "ixpmanager" AND TABLE_NAME LIKE 'telescope%'
<br>
ORDER BY (DATA_LENGTH + INDEX_LENGTH) DESC;</p>
<p dir="auto">changing "ixpmanager" to your database name as appropriate.</p>
<p dir="auto">Once you've done that, and if big, you can also run the following in the database to clear it out:</p>
<p dir="auto">SET FOREIGN_KEY_CHECKS = 0;
<br>
TRUNCATE TABLE telescope_entries_tags;
<br>
TRUNCATE TABLE telescope_entries;
<br>
TRUNCATE TABLE telescope_monitoring;
<br>
SET FOREIGN_KEY_CHECKS = 1;</p>
<p dir="auto">Also try adding the following to your .env:</p>
<p dir="auto">TELESCOPE_ENABLED=false</p>
<blockquote style="margin: 0 0 5px; padding-left: 5px; border-left: 2px solid #777777; border-left-color: #999999; color: #999999;"><p dir="auto">After digging around some more, there seems to be a lot of errors in the logs, and any command we run seems to generate the below error</p>
<p dir="auto">PHP Warning: Undefined array key "driver" in</p>
</blockquote><blockquote style="margin: 0 0 5px; padding-left: 5px; border-left: 2px solid #777777; border-left-color: #999999; color: #999999;"><p dir="auto">@portal:/srv/ixpmanager# php -v
<br>
PHP 8.1.28 (cli) (built: May 23 2024 12:32:40) (NTS)</p>
</blockquote><p dir="auto">Yeah, those errors are because you're running IXP Manager v6 which is targeted at PHP 8.0 on an 8.1 version. It's fine and they are only warnings.</p>
<br></blockquote></div>
<div class="markdown" style="white-space: normal;">
<blockquote style="margin: 0 0 5px; padding-left: 5px; border-left: 2px solid #777777; color: #777777;">
<ul>
<li>Barry</li>
</ul>
</blockquote>
</div>
</div>
</body>
</html>