[ixpmanager] 6.4.0 Upgrade issue?

[Barry O’Donovan]

Hi Ed,

You can leave Telescope disabled. It’s more of a development / debugging / problem solving tool that ships with Laravel.

 - Barry

Sent from my iPad

> On 28 May 2024, at 08:45, Edrich de Lange <edd at edd.za.net> wrote:
> 
> 
> The table was just over a gig.
> 
> Ive reenabled telescope , and its not maxing mysql yet, but will look after a while
> 
> It looks like it was running multiple updates on the same table, and that slowed things down the whole time.
> 
> And I suspect the DB is growing rapidly due to the driver error from the php 8.1 vs 8
> 
> Kind regards
> 
> Edd
> 
> On 27 May 2024, at 17:18, Barry O'Donovan (INEX) wrote:
> 
> Hi Ed,
> 
> we haven't seen any performance issues in development or production. Your snippet below shows a lot happening with Telescope
> 
> What does this SQL command show you:
> 
> SELECT TABLE_NAME AS `Table`,
> ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS `Size (MB)`
> FROM information_schema.TABLES
> WHERE
> TABLE_SCHEMA = "ixpmanager" AND TABLE_NAME LIKE 'telescope%'
> ORDER BY (DATA_LENGTH + INDEX_LENGTH) DESC;
> 
> changing "ixpmanager" to your database name as appropriate.
> 
> Once you've done that, and if big, you can also run the following in the database to clear it out:
> 
> SET FOREIGN_KEY_CHECKS = 0;
> TRUNCATE TABLE telescope_entries_tags;
> TRUNCATE TABLE telescope_entries;
> TRUNCATE TABLE telescope_monitoring;
> SET FOREIGN_KEY_CHECKS = 1;
> 
> Also try adding the following to your .env:
> 
> TELESCOPE_ENABLED=false
> 
> 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
> 
> PHP Warning: Undefined array key "driver" in
> 
> @portal:/srv/ixpmanager# php -v
> PHP 8.1.28 (cli) (built: May 23 2024 12:32:40) (NTS)
> 
> 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.
> 
> 
> Barry
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.inex.ie/pipermail/ixpmanager/attachments/20240528/c1f6e515/attachment.htm>