Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Build with SSH and MySQL

Quote Reply
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


Quote Reply
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
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Build with SSH and MySQL In reply to
Hi Andy,

It simply just stops running.

An idea ?

Thanks, Mick
Quote Reply
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
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
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
Quote Reply
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
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
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

Quote Reply
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
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
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
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
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
Quote Reply
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
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
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
Quote Reply
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
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
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
Quote Reply
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

Quote Reply
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
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!