EdKrasnov

Dear Ollie Jones,
Thank you so much for your patience, help and the right plugin!

Hi, @OllieJones!

Thank you so much for your help!
It probably doesn’t matter, but I seem to have mysql version 11.4.3 and php 8.2 on the server, but when creating indexes, php version 7.4 is displayed https://skr.sh/sSnwyuXcuN2

And could you tell me more:
1. Next to the name of the optimized table, 2 MySQL is written everywhere – what does the number “2” mean?
2. This morning, all sites on the server began to work with errors, even those sites where I did not optimize the database. I am sure that the problem is not related to your plugin, because after deleting the indexes and disabling your plugin, the problem with the site did not disappear. Tell me, in theory, can your plugin make any changes that may affect the performance of the site, MySQL or the site located in the same phpMyAdmin?

3. Are there any tests that can be used to understand the effectiveness of the new indexes and the performance of the database?

I’m sorry if the question seems silly to you. )

Hello, Ollie Jones!
Thanks a lot for the hint!
I installed your plugin, could you check if everything is configured correctly and whether the plugin is working correctly, whether indexes have been created? Metadata uploaded to id w6JJdVwZ

Old news and articles from 2012-2016 still open for a long time, 5-7 seconds. Examples of news: https://giport.ru/sovet/19122
https://giport.ru/news/77048
https://giport.ru/news/32068

Hello @frankfer ,
I have a similar problem. It is worth LSC, I switched from Yoast to RankMath and a lot of slow Like queries appeared on the server in the mysqld-slow.log log, which create a large load on the server (6-10 seconds per request).
I have described this problem here: https://www.ads-software.com/support/topic/rand-math-puts-a-lot-of-load-on-the-database-with-like-queries/ Please check your log to see if you have a similar problem.

I have already deactivated the Rank Math plugin, the Analytics module has also been disabled, but tasks continue to appear in Scheduled Actions as well. How to stop all this madness???? https://skr.sh/sSJ8C6qFZ7m
My website is hanging. Why don’t you warn me that your plugin creates such a heavy load on the site and database? (

Slow queries with like %something% are not indexed. How do I turn them off?

Thank you, I will check it and I will definitely give you feedback.
Please don’t close the topic yet.

ShareThis?(@sharethis), sorry, there seems to be a problem, it worked yesterday, and this morning it disappeared again somewhere.
I don’t understand why the plugin disappears from the admin panel, although it is displayed as active in the list of plugins: https://skr.sh/sIO7ExtLSqa
Clicking on the settings link opens a page with the phrase “Sorry, you are not allowed to view this page.”: https://skr.sh/sIOfK7QLVdC

We have an OpenLiteSpeed web server installed and a public cache is enabled on the web server. Could there be a problem with your plugin related to this?

Example page: https://giport.ru/news/world-news/telekanal-iha-v-rajone-stambula-mramornoe-more-vnezapno-otstupilo-na-20-metrov

Emoticons should be in this place under the news:
https://skr.sh/sIOiEmvOIBQ

ShareThis (@sharethis), извините, проблема похоже есть, вчера заработал, а сегодня утром опять пропал куда-то.
Не пойму из-за чего плагин пропадает из админки, хотя в списке плагинов он отображается как активный: https://skr.sh/sIO7ExtLSqa
При переходе по ссылке settings открывается страница с фразой “Извините, вам не разрешено просматривать эту страницу.”: https://skr.sh/sIOfK7QLVdC

У нас установлен web-сервер OpenLiteSpeed и включен публичный кэш на веб сервере. Может ли с этим связана проблема с вашим плагином?

Пример страницы: https://giport.ru/news/world-news/telekanal-iha-v-rajone-stambula-mramornoe-more-vnezapno-otstupilo-na-20-metrov

Смайлы должны находиться в этом месте под новостью:
https://skr.sh/sIOiEmvOIBQ

ShareThis (@sharethis), я очень извиняюсь. Все заработало, спасибо большое за отклик.
Плагин прекрасный!

Hey Reza (@reventon94)!
Thank you for your reply! )
Unfortunately, the statistics that I wrote about above are not in the plugin.
There are no summary statistics for all posts by authors. Only “popular posts” statistics are displayed, but this information is of no practical use.
The statistics filter for the period does not work, the data for all time is displayed.

To make it clearer what I need, imagine that you have 30 authors who write news and the salary of each author depends on the number of news posted per month and the traffic received for the news for a certain period (for example, last month).

Also, there should be a filter by categories of news, because different categories of news can be paid differently. For example, to be able to highlight specific news or article headings.

I also noticed a bug in your plugin, in the statistics for “Authors” users with “Editor” rights are not displayed.

And one more thing: graphs are beautiful, but with a large amount of data it would be nice if the statistics could be uploaded to a CSV file for further processing.
I think that all this is not difficult to do if you understand the practical benefits of the data received.

I would love to buy your plugin, but please make it workable.

Reza, Good afternoon!
I need statistics on specific authors for a certain period, for example for the last month with the following data:
1. How many posts were posted during the period by a particular author.
2. Post title with a link to view the post.
3. The number of unique views of each post for a certain period (excluding robots and views less than 15 seconds).
4. The total number of unique views of all posts from one author.

These statistics would be very useful for sites with a large number of authors.

And if you also make it possible to calculate remuneration for each author, indicating the cost of 1 post and the cost for every 1000 views, then it will be great in general.

What from this list can your plugin do?
I watched your demo, but did not see that the plugin can take into account statistics for a certain period on the number of views and posts.

Will you be able to implement such statistics and in what time frame?`

Reza, Good afternoon!
I need statistics on specific authors for a certain period, for example for the last month with the following data:
1. How many posts were posted during the period by a particular author.
2. Post title with a link to view the post.
3. The number of unique views of each post for a certain period (excluding robots and views less than 15 seconds).
4. The total number of unique views of all posts from one author.

These statistics would be very useful for sites with a large number of authors.

And if you also make it possible to calculate remuneration for each author, indicating the cost of 1 post and the cost for every 1000 views, then it will be great in general.

What from this list can your plugin do?
I watched your demo, but did not see that the plugin can take into account statistics for a certain period on the number of views and posts.

Will you be able to implement such statistics and in what time frame?`

George, thanks! The question on the account of development is cancelled. )

Advise only a plug-in for accounting statistics of authors and posts.

Hi @nsinelnikov
I wrote in a previous message that in the “Import” section I do not have a choice to import data into your plugin (screenshot https://prnt.sc/1yKDphXumuGy ).
And I still have nothing to export from the plugin, it is empty, there is no data yet.
Maybe you can throw off the data for importing job titles?
————
Я писал в предыдущем сообщении, что у меня в разделе “Импорт” нет выбора для импорта данных в ваш плагин (скринот https://prnt.sc/1yKDphXumuGy ).
А экспортировать из плагина мне пока нечего, он пустой, данных пока нет.
Может быть вы сможете скинуть данные для импорта названий вакансий?