Support Forums - All Posts - XOOPS Web Application System

31

Re: Long query problems.

2006/2/9 11:42
javier
Not too shy to talk
Posts: 184
Since: 2002/8/6 1

Quote:

John_N wrote:
Open a dialog with them and disable your modules to see if this has any dramatic affect on sql. In short, find out what is actually causing it and not just blaming the core.

Im not blaming the core, of course not, i think XOOPS its the best cms, i use since 4 years ago and i never had a problem before,
Im only try to discover where the problem is, sincerely i not trust in this hosting company,

Have not success searching the sleep process, them i make a little test, i tell to the hosting company i found the problem and solved (obvisuly is a lie), because im not trust in they words.

But the true is i DELETED ALL the forum topics (around 60.000 post)

and the hosting company never say a word again, that´s very strange, these people say about the sleep process, blah blah blah, now i not touch anything in the code, simply remove all the topics and they never say a word again,

My point is, if was true about the sleep process, no matter the number of forum topics,etc the problem should stay there or not?, however this people not complain again.
The site has 2000 daily visits and around 50 people online at the same time all the day.

------------------------

Exist any way to find the sleep process? because i not see nothing extrange in phpmyadmin process list,

best regards
Javier

32

Slow query problems. (22 seconds to complete)

2006/2/9 3:07
javier
Not too shy to talk
Posts: 184
Since: 2002/8/6 1

Hi,

My hosting company want kick me out because they say a normal site use 0.50 server resources and my site is using 3,58 making the whole server slow,
they say the XOOPS keeps processes in sleeping mode in the MySQL db.

In few words i have a slow querys problem. (around 22 seconds)

What i can do?

thanks in advance.
javier

33

Re: my site is using too much server resources

2006/2/7 7:34
javier
Not too shy to talk
Posts: 184
Since: 2002/8/6 1

Watdehek, i can´t make the reverse DNS thing because im in a shared server.

I have not success searching the sleep process, them i make a little test, i tell to the hosting company i found the problem and solved (obvisuly is a lie), because im not trust in they words.

But the true is i DELETED ALL the forum topics (around 60.000 post)

and the hosting company never say a word again, that´s very strange, these people say about the sleep process, blah blah blah, now i not touch anything in the code, simply remove all the topics and they never say a word again,

My point is, if was true about the sleep process, no matter the number of forum topics,etc the problem should stay there, however this people not complain again.

Someone can throw me a rope here?

This people lie because not want host a big site or with 2000 daily visits, 60 users online all the time,etc etc the site can´t follow in a shared server?

thanks in advance
javier

34

Re: my site is using too much server resources

2006/1/24 18:39
javier
Not too shy to talk
Posts: 184
Since: 2002/8/6 1

I really appreciatte your reply here phppp, thanks alot,

i just discovered i have certain problems in my cbb database,https://xoops.org/modules/newbb/viewtopic.php?topic_id=46183&forum=28&post_id=202874#forumpost202874

Problems caused by missing info in the lastest MySQL database upload,
i made some test and i think these missing info can´t generate the MySQL problems or i wrong?
i check the process list from the phpmyadmin, and i not see sleep process caused by clicking in these erroneus links with missing data,

sinceraly i have not clue about this,

with 50 or 60 users surfing all the day at the same time, is neccesary go ahead and move to a dedicated server?

best regards
javier

35

CBB Corrupted mysql messages problem

2006/1/23 18:40
javier
Not too shy to talk
Posts: 184
Since: 2002/8/6 1

Hi,
i have a big problem with the bb_post and bb_post_text tables of my CBB forum.

I have 58906 entrys in bb_post
and 59171 entrys in bb_post_text

that mean i have 265 corrupted entrys (missing in bb_post)

Reciently my host suspended my site dued to intensive MySQL querys in sleep mode, (see herehttps://xoops.org/modules/newbb/viewtopic.php?topic_id=46176&forum=7&post_id=202825#forumpost202825 )

Can be ALL these CBB corrupted data the guilty of the server load?

Sometimes happend exactly the contrary way, ex: i make a searh in the forum and i see post titles with missing post text data, when you click in one, give you a MySQL error and return to the forum index.

That can be the guilty (in few words CAN produce sleep process? )
of the sleep MySQL processes or simply come the day i need a dedicated server?

what i can do?
exist any way to detect what entrys are corrupted and delete?
if that is not the guilty of the sleep process i prefer no touch that,

thanks in advance.
best regards

javier

36

my site is using too much server resources

2006/1/23 14:07
javier
Not too shy to talk
Posts: 184
Since: 2002/8/6 1

Hi,

I have my site hosted in a shared server, the past days they suspended my site because the say a normal site use 0.50 server resources and my site is using 3,58 making the whole server slow,
they say the XOOPS keeps processes in sleeping mode in the MySQL db.
They say the problem was always since the begining but grow every month.

They show me this (obviusly i edited the database name,etc) some db querys keep in query long time.

| 84601 | *edited* | localhost | *edited* | Sleep | 122 |
| 84629 | *edited* | localhost | *edited* | Query | 1 | Copying to tmp table |
| 84601 | *edited* | localhost | *edited*| Sleep | 166 | | |

(tmp table? i have not a tmp table in my db)

i already activate all the cache features in my site, remove the statistics modules, and turn on the compresion in the cbb forum, and gzip in xoops.
And reduced the number of adsense banners, the google robot spend aroung 2.5gb of bandwith each month. the problem are the google banners?

But the problem still there, and i not see a solution

My site has around 2000 daily visitors, and around 50 or 60 visitors online all the time.

any ideas?
thanks in advance and excuse my poor english.

best regards
javier

37

insert google adsense search in newbb? (i think insert in smarty templates?)

2006/1/5 16:13
javier
Not too shy to talk
Posts: 184
Since: 2002/8/6 1

Hi,
I use adsense in my site since long time ago, i always used custom html blocks for that, this time i want include adsense in the newbb templates not as a block.

The adsense code banners work without problems if you insert in the templates, but the adsense google search not work.
I trying and trying and not found a solution, i already tried put the adsense search code in the neewbb_index.html (file template) withoutluck, simple doesn´t work, i tried include a shtml file in the index.php file and not luck, it appear at the top of the page,

I want put the adsense search between "welcome to blablabla forum" and the place where the categories start,

any idea?
best regards and thanks in advance,
Javier

38

Any way to check a certain user activities?

2006/1/3 9:21
javier
Not too shy to talk
Posts: 184
Since: 2002/8/6 1

Hi,
Exist any module or any way to monitoring a certain user activities inside the website?

I want know what certain users do inside the site, how many bandwith they use,etc etc.
What files they downloaded.

Thanks in advance.
Best Regards.

39

Re: exist any way to avoid duplicate entrys when i make a mysql insert?

2005/12/27 23:02
javier
Not too shy to talk
Posts: 184
Since: 2002/8/6 1

thanks for reply, i found a good way to solve my problem, i check the MySQL documents and i found the IGNORE command.

I modified my sql file, then i change:

Whit total commander i modified the sql file and replace ALL the

INSERT INTO

for:

INSERT IGNORE INTO

The command ignore simply ignore the duplicated entrys and follow adding all the entrys

best regards
Javier

40

exist any way to avoid duplicate entrys when i make a mysql insert? [SOLVED]

2005/12/27 20:20
javier
Not too shy to talk
Posts: 184
Since: 2002/8/6 1

Hi,
Today i lost 2 forums of my board, was totally deleted, now i trying to apply my backup but i get the following error:

MySQL said:

#1062 - Duplicate entry '3' for key 1

Of course that mean the entry 3 is already in the db, but the problem is not only these entry , the problem are thousand of entrys,

Exist any way to apply my sql file avoiding these stops? (because phpmyadmin stops every time it find a duplicate entry, i want directly jump the duplicate entrys or directly overwrite)

excuse my bad english, and thanks in advance for your replys.

Stats
Goal:	$100.00
Due Date:	Apr 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Forum Index

Re: Long query problems.

Slow query problems. (22 seconds to complete)

Re: my site is using too much server resources

Re: my site is using too much server resources

CBB Corrupted mysql messages problem

my site is using too much server resources

insert google adsense search in newbb? (i think insert in smarty templates?)

Any way to check a certain user activities?

Re: exist any way to avoid duplicate entrys when i make a mysql insert?

exist any way to avoid duplicate entrys when i make a mysql insert? [SOLVED]

Login

Search

Recent Posts

Re: Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Re: NewBB v 5.1.0 b 6

Re: NewBB v 5.1.0 b 6

NewBB v 5.1.0 b 6

Re: XOOPS 2.5.11 search user is not working

Re: oledrion

Re: oledrion

Re: oledrion

Re: oledrion

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}