[NOT A BUG] Big problem with the data base

mmpo · 2012-10-07 16:37:51

i have a Big problem with the data base after update now is consuming so much resource , i send you a emails with more detaels.

Thank you

symtab · 2012-10-08 06:34:06

It should be consuming less resources after the update.

mmpo · 2012-10-08 15:55:06

I have a notification of my shared hosting say me if i dont fix that prontly they suspend my acount so how i can solve that ?

symtab · 2012-10-08 18:45:59

Upgrade to a dedicated server. The database in 1.0.2 is less intensive compared to version < 1.0, unless you had some special modifications done to the 1.0rc4 version.

mmpo · 2012-10-09 04:19:47

rememeber my site is from avs

symtab · 2012-10-09 07:10:35

There is not much i can do. I need mysql access (via a console and with root) so that i can see the process list. I need the slow query list (which only the admin can enable). If i see which queries are slow i can optimize. There shouldnt be any slow queries (this has been checked on several ocasions/servers).

mmpo · 2012-10-10 01:37:47

I send you a email with this detaels

Nuevolab · 2012-10-10 12:25:20

mmpo wrote:

I have a notification of my shared hosting say me if i dont fix that prontly they suspend my acount so how i can solve that ?

You can't expect that website on shared server with some solid growing traffic is enough for all tasks, especially for mysql.
One server is for 100-200 different users, while dedicated is for you only.
So this happens often that hosting company suspends shared accounts that use too much resources.

mmpo · 2012-10-11 01:30:34

i was my site with so much traffic in a shared host and dont happend nonthing, this issue is apper after the updates.

mmpo · 2012-10-11 02:38:11

we see the problem is when the user join to a category url for example http://www.ismytube.com/amateur/ if the user dont join here the site load fine. We think about a error on comunication of the script with this section of the data base.

Adrian can you help me please.?

mmpo · 2012-10-11 12:56:31

thank you for you help boys , the problem has been fixed

symtab · 2012-10-11 13:26:46

What was the problem?

mmpo · 2012-10-11 16:03:54

1) the category send 2 queries to the data base and this take so long time this we fix.
2) The code don close the process correctly (Dont is solved if you can help me with this )

symtab · 2012-10-12 06:15:03

1. I will check the query, but its not slow on my sites, so the url is http://www.domain.com/amateur/?
2. The script closes the mysql connection. This is however a myth, because the mysql connection is closed automatically by php, unless you use persistent connections.

mmpo · 2012-10-13 18:12:10

I dont not what is the problem if you can check on my server I'll be grateful because i am so bored with this problem. Let me know and i will send the login

mmpo · 2012-10-13 18:35:47

check this
FluxBB bbcode test

symtab · 2012-10-13 19:03:29

I'm really sorry, but i cannot check anything on a shared server. I can guarantee you that the mysql connections are closed (and even if the script wouldnt close the connections, this open connections thing is a total myth, php automatically closes the mysql connections, unless you use persistent connections). If you would be on a dedicated server i could install the xdebug profiler extension and we would know exactly what is happening.

mmpo · 2012-10-14 01:45:51

what log you need see for i try get from my support managet host? I send you more detaels to your emails.

Last edited by mmpo (2012-10-14 04:31:30)

mmpo · 2012-10-14 05:40:07

More detaels for you can help me to solved the problem

FluxBB bbcode test

Eri · 2012-10-14 07:32:51

hmm i am using RC4 and everything is ok

symtab · 2012-10-14 09:16:11

Everything is ok in 1.0 also. Nothing changed to influence this (NOTHING has changed in the way our script handles the database connection, some tables were optimized, but only after testing). There is no way to close a table. You close the mysql connection, not the table.

mmpo · 2012-10-14 13:11:44

yes of course in any part some mysql connection dont is close and its the problem that my server manage notice me for this i want you review that. I think that i dont need a dedicate server at this time because if i fix this problem the site will be rum so fast because on cpu usage is taking only 4% . memory too so little the only problem is with the entery process and its for mysql connection is not close correctly.

mmpo · 2012-10-14 13:14:53

Eri wrote:

hmm i am using RC4 and everything is ok

On the version that you have i never have this problem.

symtab · 2012-10-14 18:00:18

Like i said before, its impossible for me to debug. The code closes the connection. Here's the function that does it:

    public static function close()
    {
        session_write_close();

        if (isset(self::$instances['database'])) {
            self::$instances['database']->close();
        }

        while(ob_get_level()) {
            ob_end_flush();
        }

        self::$running  = FALSE;
    }

It is called for every file, once the script finishes. This is the same in RC4 and 1.0.*.

With a dedicated server i can install a debugging extension and after that i can test and i see exactly what happens. On a shared hosting i cannot do anything.

mmpo · 2012-10-14 18:04:49

i and tranfering the site to a dedicate i will tell you the login.

Adult Script Pro Community Forums

#1 2012-10-07 16:37:51

[NOT A BUG] Big problem with the data base

#2 2012-10-08 06:34:06

Re: [NOT A BUG] Big problem with the data base

#3 2012-10-08 15:55:06

Re: [NOT A BUG] Big problem with the data base

#4 2012-10-08 18:45:59

Re: [NOT A BUG] Big problem with the data base

#5 2012-10-09 04:19:47

Re: [NOT A BUG] Big problem with the data base

#6 2012-10-09 07:10:35

Re: [NOT A BUG] Big problem with the data base

#7 2012-10-10 01:37:47

Re: [NOT A BUG] Big problem with the data base

#8 2012-10-10 12:25:20

Re: [NOT A BUG] Big problem with the data base

#9 2012-10-11 01:30:34

Re: [NOT A BUG] Big problem with the data base

#10 2012-10-11 02:38:11

Re: [NOT A BUG] Big problem with the data base

#11 2012-10-11 12:56:31

Re: [NOT A BUG] Big problem with the data base

#12 2012-10-11 13:26:46

Re: [NOT A BUG] Big problem with the data base

#13 2012-10-11 16:03:54

Re: [NOT A BUG] Big problem with the data base

#14 2012-10-12 06:15:03

Re: [NOT A BUG] Big problem with the data base

#15 2012-10-13 18:12:10

Re: [NOT A BUG] Big problem with the data base

#16 2012-10-13 18:35:47

Re: [NOT A BUG] Big problem with the data base

#17 2012-10-13 19:03:29

Re: [NOT A BUG] Big problem with the data base

#18 2012-10-14 01:45:51

Re: [NOT A BUG] Big problem with the data base

#19 2012-10-14 05:40:07

Re: [NOT A BUG] Big problem with the data base

#20 2012-10-14 07:32:51

Re: [NOT A BUG] Big problem with the data base

#21 2012-10-14 09:16:11

Re: [NOT A BUG] Big problem with the data base

#22 2012-10-14 13:11:44

Re: [NOT A BUG] Big problem with the data base

#23 2012-10-14 13:14:53

Re: [NOT A BUG] Big problem with the data base

#24 2012-10-14 18:00:18

Re: [NOT A BUG] Big problem with the data base

#25 2012-10-14 18:04:49

Re: [NOT A BUG] Big problem with the data base

Board footer