[SPAM?] Re: [SPAM?] Re: [opencms-dev] maximum file size that OpenCms lets to Upload

[maria.freixes_graells at alcatel.es]

Thanks!!

Claus Priisholm wrote:
> The contents tables are defined to use a mediumblob (which is mysql 
> lingo for 2^24 bytes aka 16 MB). I recall someone that changed this 
> setting, and as I recall it with no bad side effects (scan the mailing 
> archive).
>
> maria.freixes_graells at alcatel.es wrote:
>> Thanks very much Christian, I'll try to investigate more about.....
>> I've the same parameters as yours plus the following that you don't 
>> have:
>>
>> net_buffer_length                 16384
>> select_limit                      1000
>> max_join_size                     1000000
>> secure-auth                       FALSE
>> show-warnings                     FALSE
>>
>> I don't know if it's a problem of mysql....
>> And in the machine I can't find any log of error.
>> Someone knows   WHERE I COULD FOUND SOME INFORMATION OF THE ERROR? IN 
>> WHICH FILE?
>> Thanks again!!
>>
>> Christian Steinert wrote:
>>> maria.freixes_graells at alcatel.es schrieb:
>>>  
>>>> Our value, in the mysql is set properly:
>>>>
>>>>
>>>> Variables (--variable-name=value)
>>>> and boolean options {FALSE|TRUE}  Value (after reading options)
>>>> --------------------------------- -----------------------------
>>>> auto-rehash                       TRUE
>>>> character-sets-dir                (No default value)
>>>> default-character-set             latin1
>>>> compress                          FALSE
>>>> database                          (No default value)
>>>> delimiter                         ;
>>>> vertical                          FALSE
>>>> force                             FALSE
>>>> named-commands                    FALSE
>>>> local-infile                      FALSE
>>>> no-beep                           FALSE
>>>> host                              (No default value)
>>>> html                              FALSE
>>>> xml                               FALSE
>>>> line-numbers                      TRUE
>>>> unbuffered                        FALSE
>>>> column-names                      TRUE
>>>> sigint-ignore                     FALSE
>>>> port                              0
>>>> prompt                            mysql>
>>>> quick                             FALSE
>>>> raw                               FALSE
>>>> reconnect                         TRUE
>>>> socket                            /var/lib/mysql/mysql.sock
>>>> ssl                               FALSE
>>>> ssl-key                           (No default value)
>>>> ssl-cert                          (No default value)
>>>> ssl-ca                            (No default value)
>>>> ssl-capath                        (No default value)
>>>> ssl-cipher                        (No default value)
>>>> table                             FALSE
>>>> debug-info                        FALSE
>>>> user                              (No default value)
>>>> safe-updates                      FALSE
>>>> i-am-a-dummy                      FALSE
>>>> connect_timeout                   0
>>>> max_allowed_packet                67107840
>>>>
>>>>     
>>>
>>>
>>> Dear Maria,
>>>
>>>
>>> Sadly max_allowed_packet is the only of these parameters that I know 
>>> about.
>>>
>>> For a 20MB file your setting should be enough now.
>>> Apart from this I really don't know. I have not yet come across this
>>> problem - I don't have such big files on opencms.
>>>
>>> Anybody here who had a similar problem?
>>>
>>> Sorry...
>>> Ch.
>>>
>>>   
>>> ------------------------------------------------------------------------ 
>>>
>>>
>>>
>>> _______________________________________________
>>> This mail is sent to you from the opencms-dev mailing list
>>> To change your list options, or to unsubscribe from the list, please 
>>> visit
>>> http://lists.opencms.org/mailman/listinfo/opencms-dev
>>
>> _______________________________________________
>> This mail is sent to you from the opencms-dev mailing list
>> To change your list options, or to unsubscribe from the list, please 
>> visit
>> http://lists.opencms.org/mailman/listinfo/opencms-dev
>>
>