MemHT Portal is a Free PHP CMS and Blog
It permit the creation and the management online of websites with few and easy steps.
It's completelly customizable, expandable and suitable for all needs.
Moderators: Moderators
Forum RSS feedReply
mysql slow queries
AuthorText
baselkanaan
Junior Member
Avatar

Posts: 79
Contributes: 20

Gender: _MALE_
Online: No

Version: 4.0.1
Country: Jordan
Languages: Arabic / English
Date: 21/09/2008 22:16
mysql slow queries
#post12206
Other problem which I can't resloved it !

evry day I'm received many log in my server temp

all of these log usually has same content like this >>>>....

""""""""""""""""""""""""""""""""""""""""""""""

code

# Sun Sep 21 08:19:46 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use ******_memht;
SET insert_id=1412800,timestamp=1222006786;
INSERT INTO memht_statistics_livedata (id,date,ip,user,page,agent,referer,requesturi,isbot,cookies)
  VALUES (null,DATE_ADD(NOW(),INTERVAL 9 HOUR),'217.164.139.9','','news','Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; InfoPath.2; SPOENB/1.0; .NET CLR 2.0.50727)','','/news_5808_Xilisoft-DVD-Creator-3.0.38.0919.html','','1')

# Sun Sep 21 08:25:00 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use *****_memht;
SET insert_id=1412897,timestamp=1222007100;
INSERT INTO memht_statistics_livedata (id,date,ip,user,page,agent,referer,requesturi,isbot,cookies)
  VALUES (null,DATE_ADD(NOW(),INTERVAL 9 HOUR),'190.87.71.27','','news','Java/1.6.0_07','','/rss-news-275.xml','1','0')

# Sun Sep 21 08:28:10 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use ******_memht;
SET insert_id=1412952,timestamp=1222007290;
INSERT INTO memht_statistics_livedata (id,date,ip,user,page,agent,referer,requesturi,isbot,cookies)
  VALUES (null,DATE_ADD(NOW(),INTERVAL 9 HOUR),'116.80.61.176','','news','Mozilla/5.0 (Windows; U; Windows NT 5.1; ja; rv:1.9.0.1) Gecko/2008070208 Firefox/3.0.1','http://www.google.co.jp/search?hl=ja&client=firefox-a&rls=org.mozilla%3Aja%3Aofficial&hs=njk&q=NeoDownloader+2.3+serial&btnG=%E6%A4%9C%E7%B4%A2&lr=','/news_5347_NeoDownloader-2.3c-with-serial.html','','0')

# Sun Sep 21 08:30:21 2008
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use ******_memht;
SET insert_id=1413015,timestamp=1222007421;
INSERT INTO memht_statistics_livedata (id,date,ip,user,page,agent,referer,requesturi,isbot,cookies)
  VALUES (null,DATE_ADD(NOW(),INTERVAL 9 HOUR),'190.42.2.122','','news','Java/1.6.0_02','','/rss-news-275.xml','1','0')

# Sun Sep 21 08:30:21 2008
# Query_time: 4  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE memht_statistics_loadtime SET hits=hits+1 WHERE time='2.25'


""""""""""""""""""""""""""""""""""""""""""""""

Any suggestions to resolve this proplem.. Smile

Middown.com
Memht 3.9.0
version: 4.0.1
Home: www.middown.com
Delete Edit Quote
 
mem
MemHT's Dad
Admin & Developer

Avatar

Posts: 4642
Contributes: 1949

Gender: _MALE_
Online: No
Date: 21/09/2008 22:18
Re: mysql slow queries
#post12207
How many entries the memht_statistics_livedata table have?
Delete Edit Quote
 
mem
MemHT's Dad
Admin & Developer

Avatar

Posts: 4642
Contributes: 1949

Gender: _MALE_
Online: No
Date: 21/09/2008 22:33
Re: mysql slow queries
#post12208
If they are more than 3/4.000 open inc/inc_functions.php

Find
code
$dblink->query("DELETE FROM memht_statistics_livedata WHERE (date + INTERVAL 2 DAY) < $tzNOW");
or
code
$dblink->query("DELETE FROM memht_statistics_livedata WHERE (date + INTERVAL 1 DAY) < $tzNOW");
and replace with
code
$dblink->query("DELETE FROM memht_statistics_livedata WHERE (date + INTERVAL 12 HOUR) < $tzNOW");
Delete Edit Quote
 
baselkanaan
Junior Member
Avatar

Posts: 79
Contributes: 20

Gender: _MALE_
Online: No

Version: 4.0.1
Country: Jordan
Languages: Arabic / English
Date: 22/09/2008 06:04
Re: mysql slow queries
#post12210
Sorry for your time ...

how I can know what do need "How many entries the memht_statistics_livedata table have?"

from where !?

I was posted an 2 images from my status this morning

Image:

Image

View Image resized (Original file: 829x559)
Thumb


I hope this image helpfully to know what was need!

Smile
version: 4.0.1
Home: www.middown.com
Delete Edit Quote
 
subject-28
Senior Member
Avatar

Posts: 158
Contributes: 158

Gender: _NEUTRAL_
Online: No
Date: 22/09/2008 06:43
Re: mysql slow queries
#post12211
This can be done using phpmyadmin and look at the entry's for whichever tables
Delete Edit Quote
 
mem
MemHT's Dad
Admin & Developer

Avatar

Posts: 4642
Contributes: 1949

Gender: _MALE_
Online: No
Date: 22/09/2008 10:13
Re: mysql slow queries
#post12213
phpMyAdmin > Check how many rows the table called "memht_statistics_livedata" have. Anyway do the mod i told you
Delete Edit Quote
 
baselkanaan
Junior Member
Avatar

Posts: 79
Contributes: 20

Gender: _MALE_
Online: No

Version: 4.0.1
Country: Jordan
Languages: Arabic / English
Date: 22/09/2008 15:50
Re: mysql slow queries
#post12217
quote
mem:
phpMyAdmin > Check how many rows the table called "memht_statistics_livedata" have. Anyway do the mod i told you

OK .. mem
I have 50730 rows in "memht_statistics_livedata"

and I was edited inc_functions.php ..!

I will tell you if this success tomorrow !

Thanks mem Smile
version: 4.0.1
Home: www.middown.com
Delete Edit Quote
 
mem
MemHT's Dad
Admin & Developer

Avatar

Posts: 4642
Contributes: 1949

Gender: _MALE_
Online: No
Date: 22/09/2008 16:09
Re: mysql slow queries
#post12218
50.730 Smile

On memht.com i feel thye difference between 3.000 and 7.000 and you have 50.730?? Do you EVER execute the maintenance? Set your maintenance to 10 minutes in config
Delete Edit Quote
 
Reply
Tags Cloud
Advertising
News Archive
Language
Help MemHT Portal
Navigator
Users Block
Hi Guest
IP: 38.103.63.59

Username
Password
New files
MemHT Wiki
Friends
MemHT Portal is a free software released under the GNU/GPL License by Miltenovik Manojlo