vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   long_query problem (https://vborg.vbsupport.ru/showthread.php?t=217260)

Nassou 06-27-2009 11:31 AM
long_query problem
 
1 Attachment(s)
Hello everybody ;

I have some problems with long-query-log , the forum is very stable but it's not ok in the log , i explain :

I have set up this configuration on my.cnf :
Code:
# Here you can see queries with especially long duration
log_slow_queries    = /var/log/mysql/mysql-slow.log
long_query_time = 4
With this configuration i don't have a lot of long_query , logs look :

Code:
Time                Id Command    Argument
# Time: 090627  1:00:11
# User@Host: xxx[xxx] @ localhost []
# Query_time: 6  Lock_time: 0  Rows_sent: 239788  Rows_examined: 239788
use database;
SELECT /*!40001 SQL_NO_CACHE */ * FROM `post`;
# Time: 090627  1:00:20
# User@Host: xxxx[xxxx] @ localhost []
# Query_time: 8  Lock_time: 0  Rows_sent: 3741271  Rows_examined: 3741271
SELECT /*!40001 SQL_NO_CACHE */ * FROM `postindex`;
I don't understand what this messages means.

And this is , my log error with this configuration when i added ( > log-queries-not-using-indexes ) on my.cnf

Code:
# Here you can see queries with especially long duration
log_slow_queries    = /var/log/mysql/mysql-slow.log
long_query_time = 4
log-queries-not-using-indexes
Because the log are too long , i have decided to upload this , please download the attachement file to see the log.


Some one can explain me , what can i do to resolve this problem ?

Thanks !

Cryo 06-27-2009 02:29 PM
This isn't really a problem. Long queries are simply queries that take a longer amount of time to execute. If they're common throughout a script or site it can lead to higher loads and performance issues (among other things). Unless I'm mistaken the query above is just a vB cron job running.

Nassou 06-27-2009 06:28 PM
Quote:
Originally Posted by Cryo (Post 1838418)
This isn't really a problem. Long queries are simply queries that take a longer amount of time to execute. If they're common throughout a script or site it can lead to higher loads and performance issues (among other things). Unless I'm mistaken the query above is just a vB cron job running.
Yes but these query surcharge a little my server !

Then i want to optimize this !

Cryo 06-27-2009 07:00 PM
What plugins do you have installed on your forum?

snakes1100 06-27-2009 07:10 PM
You can do away with postindex by switching to the MySQL FULLTEXT options in the search type in vb's admincp, tick the option to empty postindex when converting.

This should also eliminate the other query as well as the post table wont need to be scanned to sync the vb default search.

Nassou 06-28-2009 10:01 PM
Quote:
Originally Posted by snakes1100 (Post 1838548)
You can do away with postindex by switching to the MySQL FULLTEXT options in the search type in vb's admincp, tick the option to empty postindex when converting.

This should also eliminate the other query as well as the post table wont need to be scanned to sync the vb default search.
i don't know if i can say this , but who is better MYSQL FULL TEXT Or Default vBulletin INDEX?


All times are GMT. The time now is 11:47 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00945 seconds
  • Memory Usage 1,725KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete