Slow query logger 2.2.1

[Nirjonadda]

It'll rebuild statistics and such on the table which may help.

We will optimize all database table and update you.

show create table xf_user;

 

[interforo]

I got this

Stack trace
#0 src/XF/Db/AbstractAdapter.php(189): SV\SlowQueryLogger\Db\Mysqli\SlowQueryLogAdapter->logQueryCompletion()
#1 src/XF/Db/AbstractAdapter.php(405): XF\Db\AbstractAdapter->rawQuery('COMMIT')
#2 src/XF/Mvc/Entity/Entity.php(1288): XF\Db\AbstractAdapter->commit()
#3 src/addons/Siropu/AdsManagerLite/Pub/Controller/Ad.php(215): XF\Mvc\Entity\Entity->save()
#4 src/XF/Mvc/Dispatcher.php(352): Siropu\AdsManagerLite\Pub\Controller\Ad->actionTrackImpressions(Object(XF\Mvc\ParameterBag))
#5 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('Siropu\\AdsManag...', 'TrackImpression...', Object(XF\Mvc\RouteMatch), Object(Siropu\AdsManagerLite\Pub\Controller\Ad), NULL)
#6 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(Siropu\AdsManagerLite\Pub\Controller\Ad), NULL)
#7 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#8 src/XF/App.php(2345): XF\Mvc\Dispatcher->run()
#9 src/XF.php(512): XF\App->run()
#10 index.php(20): XF::runApp('XF\\Pub\\App')
#11 {main}

 

[Xon]

We will optimize all database table and update you.



View attachment 261011

You need to somehow get the full table schema. I have no idea how to get phpmyadmin todo that

 

[interforo]

@Nirjonadda and @interforo can you try running this command?

optimize table xf_user

It'll rebuild statistics and such on the table which may help.


If you can get the full output of the following statement somehow, as phpmyadmin tends to truncate it;

show create table xf_user;

Will it override or break anything?

 

[Xon]

It may render your site inaccessible until the operation completes (due to locking), but otherwise there should be no data loss.

 

[interforo]

can you help me with:

Server error log
Exception: Slow query: 3.3056 seconds, /forum/threads/simone-inzaghi.2361520/page-587 src/addons/SV/SlowQueryLogger/Db/Mysqli/SlowQueryLogAdapter.php:387
Generated by: GianlucaPISA Dec 1, 2021 at 12:38 AM
Stack trace
#0 src/XF/Db/Mysqli/Statement.php(110): SV\SlowQueryLogger\Db\Mysqli\SlowQueryLogAdapter->logQueryCompletion()
#1 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#2 src/XF/Db/AbstractAdapter.php(220): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#3 src/XF/Repository/Thread.php(235): XF\Db\AbstractAdapter->insert('xf_thread_read', Array, false, 'thread_read_dat...')
#4 src/XF/Repository/Thread.php(256): XF\Repository\Thread->markThreadReadByUser(Object(XF\Entity\Thread), Object(SV\WarningImprovements\XF\Entity\User), 1638299387)
#5 src/XF/Pub/Controller/Thread.php(136): XF\Repository\Thread->markThreadReadByVisitor(Object(XF\Entity\Thread), 1638299387)
#6 src/XF/Mvc/Dispatcher.php(352): XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#7 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:Thread', 'Index', Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\Thread), NULL)
#8 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\Thread), NULL)
#9 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#10 src/XF/App.php(2345): XF\Mvc\Dispatcher->run()
#11 src/XF.php(512): XF\App->run()
#12 index.php(20): XF::runApp('XF\\Pub\\App')
#13 {main}

 

[Xon]

Xon updated Slow query logger with a new update entry:

2.2.0 - Maintenance & bugfix update

• Require XenForo 2.2+
• Require php 7.2+
• Fix infinite recussion which could result in segfaults when the caching backend is empty and fetching XF options triggers a database query
• Prune stacktrace sql query logs once >150 queries are collected, and be more aggressive about flipping LogSimpleOnly flag
• Only collect stack-traces if the _debug flag is present in the request

Read the rest of this update entry...

 

[Xon]

Xon updated Slow query logger with a new update entry:

2.2.1 - Bugfix update

• Fix various numerical admincp options which did not step in the incremental values as intended, while allowing arbitrary values in the range to be entered

Read the rest of this update entry...