Gossamer Forum: Products: Gossamer Links: Discussions: Build with SSH and MySQL

Jul 5, 2010, 2:48 AM

MJ_

User (236 posts)

Jul 5, 2010, 2:48 AM

Post #1 of 16

Shortcut

Build with SSH and MySQL

Hi,

I use SSH to build the pages.

My problem is that SSH is stopped after xx minutes.
It is perhaps a problem of configuration on server SQL.
　
You think that it is possible to configure the file my.cnf to avoid the interruption?

Thanks, Mick

Jul 5, 2010, 5:00 AM

Andy

Veteran / Moderator (17366 posts)

Jul 5, 2010, 5:00 AM

Post #2 of 16

Shortcut

Re: [MJ_] Build with SSH and MySQL In reply to

Do you get an error? Something like "MySQL Server has gone away" .. or it simply just stops running?

Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

Jul 5, 2010, 5:06 AM

MJ_

User (236 posts)

Jul 5, 2010, 5:06 AM

Post #3 of 16

Shortcut

Re: [Andy] Build with SSH and MySQL In reply to

Hi Andy,

It simply just stops running.

An idea ?

Thanks, Mick

Jul 5, 2010, 5:08 AM

Andy

Veteran / Moderator (17366 posts)

Jul 5, 2010, 5:08 AM

Post #4 of 16

Shortcut

Re: [MJ_] Build with SSH and MySQL In reply to

Is it a dedicated server?

Also, try timing it - and see if it stops at exactly the same time. Some servers cut perl scripts off when they run too long (or their load gets too high)

Cheers

Andy (mod)
andy@ultranerds.co.uk

Jul 5, 2010, 9:27 AM

MJ_

User (236 posts)

Jul 5, 2010, 9:27 AM

Post #5 of 16

Shortcut

Re: [Andy] Build with SSH and MySQL In reply to

My host confirms that there is no limit.

But, it does not give me a solution. :(

My file my.cnf :

[mysqld]
tmp_table_size = 1M
query_cache_size = 1M
skip-locking
key_buffer_size = 12M
max_allowed_packet = 1M
table_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 128K
max_binlog_cache_size = 1M
max_join_size = 1M
max_seeks_for_key = 2M
max_write_lock_count = 512K
myisam_max_sort_file_size = 1M

innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
innodb_log_file_size = 10M
innodb_log_buffer_size = 4M
innodb_flush_log_at_trx_commit = 1

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

Mick

Last edited by:

MJ_: Jul 5, 2010, 9:45 AM

Jul 5, 2010, 9:50 AM

Andy

Veteran / Moderator (17366 posts)

Jul 5, 2010, 9:50 AM

Post #6 of 16

Shortcut

Re: [MJ_] Build with SSH and MySQL In reply to

If you enabled debugging in Setup > Misc Options and then run it from SSH, where does it stop?

Cheers

Andy (mod)
andy@ultranerds.co.uk

Jul 23, 2010, 3:41 AM

MJ_

User (236 posts)

Jul 23, 2010, 3:41 AM

Post #7 of 16

Shortcut

Re: [Andy] Build with SSH and MySQL In reply to

Hi Andy,

My host has just answered me.

It made several tests and it does not find a problem. :(

It recommends to me to add a timeout on script.

You think that it is possible with SSH ?

Thanks,

Mick

Jul 23, 2010, 3:48 AM

Andy

Veteran / Moderator (17366 posts)

Jul 23, 2010, 3:48 AM

Post #8 of 16

Shortcut

Re: [MJ_] Build with SSH and MySQL In reply to

Mmm, have you tried increasing max_allowed_packet = 1M to maybe 4mb or 8mb? I know that shouldn't be the problem, but sometimes it can cause it (when large queries/ large amounts of data come back)

Cheers

Andy (mod)
andy@ultranerds.co.uk

Jul 23, 2010, 3:49 AM

Andy

Veteran / Moderator (17366 posts)

Jul 23, 2010, 3:49 AM

Post #9 of 16

Shortcut

Re: [MJ_] Build with SSH and MySQL In reply to

..amd WOW, it too 20 odd days to get a reply????? Crazy

Andy (mod)
andy@ultranerds.co.uk

Jul 23, 2010, 4:03 AM

MJ_

User (236 posts)

Jul 23, 2010, 4:03 AM

Post #10 of 16

Shortcut

Re: [Andy] Build with SSH and MySQL In reply to

Hi Andy,

I will suggest to him.
I hope that it will not give me an answer in September. ;)

If not, it would be possible to use one timeout ?
It would be certainly faster for me!

Thanks,
Mick

Jul 23, 2010, 4:07 AM

Andy

Veteran / Moderator (17366 posts)

Jul 23, 2010, 4:07 AM

Post #11 of 16

Shortcut

Re: [MJ_] Build with SSH and MySQL In reply to

Quote:

I hope that it will not give me an answer in September. ;)

Lets hope not ;)

Quote:

If not, it would be possible to use one timeout ?
It would be certainly faster for me!

I'm not really sure what he is suggesting? Appart from adding some "sleep" statements after all the mySQL queries, I'm not sure what else to suggest (and thats assuming its MySQL thats stopping, and not the perl script itself)

Cheers

Andy (mod)
andy@ultranerds.co.uk

Jul 23, 2010, 4:18 AM

MJ_

User (236 posts)

Jul 23, 2010, 4:18 AM

Post #12 of 16

Shortcut

Re: [Andy] Build with SSH and MySQL In reply to

In fact, it recommends to me to add a timeout every two minutes and to start again script.

I will contact GT to obtain their opinion.

Thanks,

Mick

Jul 23, 2010, 5:35 AM

Andy

Veteran / Moderator (17366 posts)

Jul 23, 2010, 5:35 AM

Post #13 of 16

Shortcut

Re: [MJ_] Build with SSH and MySQL In reply to

Mmm, well thats a bit stupid! You should really look at moving hosts - a perl script should be allowed to run as long as possible (as long as it doesn't use too much CPU/RAM, and doesn't go on for say xx many hours... not minutes!)

Andy (mod)
andy@ultranerds.co.uk

Jul 23, 2010, 7:12 AM

MJ_

User (236 posts)

Jul 23, 2010, 7:12 AM

Post #14 of 16

Shortcut

Re: [Andy] Build with SSH and MySQL In reply to

Hi Andy,

You can say to me if LSQL uses innodb ?
It is activated in the file my.cnf...

Thanks,
Mick

Jul 23, 2010, 8:55 AM

MJ_

User (236 posts)

Jul 23, 2010, 8:55 AM

Post #15 of 16

Shortcut

Re: [Andy] Build with SSH and MySQL In reply to

I think that I found a solution by increasing tmp_table_size and max_allowed_packet.

Thanks Andy, it seems that you put to me on the good track. :)

Mick

Jul 23, 2010, 9:24 AM

Andy

Veteran / Moderator (17366 posts)

Jul 23, 2010, 9:24 AM

Post #16 of 16

Shortcut

Re: [MJ_] Build with SSH and MySQL In reply to

Hi,

Good to hear - hope that works for you :)

Cheers

Andy (mod)
andy@ultranerds.co.uk