load slow ( maybe )

thiva7 · 2011-05-14 01:22:16

i have ~95.000 videos and i "thing" is start my site loading slower.maybe i have internet conection problem.
so u can visit my site and watch 2-3 videos to see if slow realy slow?

MS_DA · 2011-05-14 01:32:45

Yupp it´s loading a bit slow. See white page for some moments befor the clip or category gets loaded. My connection speed it 100 mbit.

thiva7 · 2011-05-14 01:42:03

thank u for your visit to tell me how is work

when i visit categories page photos load slowly

what is rong now? ,

MS_DA · 2011-05-14 02:35:47

Did you check the memory usage and server load of your server ? Is it higher then usual ?

symtab · 2011-05-14 07:34:14

thiva7: for me your site was loading slow from the start, but you have a few other sites on the server that eat CPU (slow queries). I checked this, if i'm not mistaken.

thiva7 · 2011-05-14 11:13:35

i have 2 websites on my server....one is phpmotion script and the other is ASP.

how i can see how much CPU usage have the site(s)?

thiva7 · 2011-05-14 11:21:49

with command i type "top " and i have this result

top - 05:16:20 up 1 day, 14:09, 1 user, load average: 0.20, 0.47, 0.74
Tasks: 159 total, 1 running, 158 sleeping, 0 stopped, 0 zombie
Cpu(s): 6.2%us, 14.0%sy, 0.0%ni, 79.0%id, 0.6%wa, 0.0%hi, 0.2%si, 0.0%st

Mem: 2065560k total, 1991876k used, 73684k free, 297812k buffers
Swap: 4192956k total, 120k used, 4192836k free, 1290500k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
2936 mysql 18 0 128m 29m 4244 S 57.9 1.5 531:29.62 mysqld

i post that one becuse is the only one wich change up to %57 some times

can be that the problem?

Last edited by thiva7 (2011-05-14 11:22:23)

thiva7 · 2011-05-14 12:22:52

ok i have open ssh cliend and i have command "top" ok?

and im in admin panel and i delete videos wich i dont want ( and im watching usage on ssh cliend same time )i do that becuse in admin panel video session is much more slow than on front of site.

so......

when i delete videos from admin panel i have

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND

2936 mysql 15 0 129m 30m 4244 S 100.3 1.5 550:32.71 mysqld
30528 celebsxv 39 19 4152 1728 944 R 84.7 0.1 0:53.87 webalizer
30268 root 15 0 2428 1064 788 R 1.0 0.1 0:02.00 top
461 root 10 -5 0 0 0 S 0.7 0.0 8:22.16 kjournald
30430 root 16 0 0 0 0 D 0.3 0.0 0:02.31 pdflush
30639 xporn4u 16 0 34364 13m 5736 S 0.3 0.7 0:00.12 php
1 root 15 0 2160 648 556 S 0.0 0.0 0:01.26 init
2 root RT -5 0 0 0 S 0.0 0.0 0:00.06 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/0
4 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/0
5 root RT -5 0 0 0 S 0.0 0.0 0:00.27 migration/1
6 root 34 19 0 0 0 S 0.0 0.0 0:00.01 ksoftirqd/1
7 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/1
8 root RT -5 0 0 0 S 0.0 0.0 0:00.17 migration/2
9 root 34 19 0 0 0 S 0.0 0.0 0:00.01 ksoftirqd/2
10 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/2
11 root RT -5 0 0 0 S 0.0 0.0 0:00.33 migration/3

Last edited by thiva7 (2011-05-14 12:24:21)

symtab · 2011-05-14 12:34:56

You already have 100.000 videos. In order to make the admin work very very fast, with that much videos, i would need to add a lot of mysql keys, which is not good (its good, until you reach a number).

Here is a query from your other site:

mysql> describe SELECT * FROM videos WHERE approved='yes' AND public_private = 'public' ORDER BY RAND() LIMIT 1;
+----+-------------+--------+------+---------------+------+---------+------+-------+----------------------------------------------+
| id | select_type | table  | type | possible_keys | key  | key_len | ref  | rows  | Extra                                        |
+----+-------------+--------+------+---------------+------+---------+------+-------+----------------------------------------------+
|  1 | SIMPLE      | videos | ALL  | NULL          | NULL | NULL    | NULL | 24559 | Using where; Using temporary; Using filesort | 
+----+-------------+--------+------+---------------+------+---------+------+-------+----------------------------------------------+
1 row in set (0.07 sec)
mysql> SELECT * FROM videos WHERE approved='yes' AND public_private = 'public' ORDER BY RAND() LIMIT 1;
...
1 row in set (1.75 sec)

There are a lot of slow queries on your other site, just use mysql with show processlist and you will see. When you delete videos in the admin, there cannot be any load, because everything uses keys. The only load on mysql is when you browse through videos in admin. That cannot be optimized (for all possible combinations of admin video search i would need a mysql key, and that is not good).

thiva7 · 2011-05-14 12:52:50

i do not understund much thing

so the problem is my other site on server wich use much more CPU ???

MS_DA · 2011-05-14 13:26:52

Well i reboot my server if it´s slower then usual and this always helps a lot.

You simply can do this with the command "reboot now" [FreeBSD] if you have full root access . This will not solve any slow queries but good speed will be back for a time

symtab · 2011-05-14 15:22:46

Mostly yes, like i said mysql has no reason to be slow when you delete videos (every query that is used during the delete video process is optimized). It could be slow when you search for videos in the admin panel.

thiva7 · 2011-05-15 00:02:31

so if i close the other site...this will stop it??

symtab · 2011-05-15 09:15:34

Lets try it, but i assume you dont want to stop your other site, since its a running site, which would make you money. If you want to test and see if the site is still slow after you close the other site, then at least we could find out from where the slow part is comming and fix the problems.

thiva7 · 2011-05-16 14:46:25

i have close the other site ....... you can visit pls and tell me if is faster?

symtab · 2011-05-16 15:11:40

It seems a little faster, let me add some more optimizations (i planned on doing this for the final version, but its about mysql keys, so i can add it now).

Adult Script Pro Community Forums

#1 2011-05-14 01:22:16

load slow ( maybe )

#2 2011-05-14 01:32:45

Re: load slow ( maybe )

#3 2011-05-14 01:42:03

Re: load slow ( maybe )

#4 2011-05-14 02:35:47

Re: load slow ( maybe )

#5 2011-05-14 07:34:14

Re: load slow ( maybe )

#6 2011-05-14 11:13:35

Re: load slow ( maybe )

#7 2011-05-14 11:21:49

Re: load slow ( maybe )

#8 2011-05-14 12:22:52

Re: load slow ( maybe )

#9 2011-05-14 12:34:56

Re: load slow ( maybe )

#10 2011-05-14 12:52:50

Re: load slow ( maybe )

#11 2011-05-14 13:26:52

Re: load slow ( maybe )

#12 2011-05-14 15:22:46

Re: load slow ( maybe )

#13 2011-05-15 00:02:31

Re: load slow ( maybe )

#14 2011-05-15 09:15:34

Re: load slow ( maybe )

#15 2011-05-16 14:46:25

Re: load slow ( maybe )

#16 2011-05-16 15:11:40

Re: load slow ( maybe )

Board footer