Not able to upload 100k list

[dante]

Hi,

When uploading a list of 100k or more It always shows some server error.
The file uploads till 100% but then the page doesn't load and shows error. I have to split the list into 35k each so then it works.

I have bigger lists around 500k - 2M and can't imagine uploading each by splitting them into tons of small pieces.

Where is the upload limit option?(If any).

 

[twisted1919]

It always shows some server error.

What error ?

 

[dante]

What error ?

This:
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, root@localhost and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Apache/2.2.15 (CentOS) Server at clickmailserver.com Port 80

 

[twisted1919]

Okay, so your server is not able to handle uploading and processing that many at once and this is why you need to split your big list into smaller lists.
What is your settings from backend > settings > import/export ? (screenshot).
Also, what's your server specs (ram/cpu)?

 

[dante]

Okay, so your server is not able to handle uploading and processing that many at once and this is why you need to split your big list into smaller lists.
What is your settings from backend > settings > import/export ? (screenshot).
Also, what's your server specs (ram/cpu)?

Its a VPS:

OpenStack KVM
2 vCore(s)
2.4 GHz
8 GB RAM
40 GB SSD
Local RAID 10

 

[twisted1919]

That looks good, please see https://kb.mailwizz.com/articles/mysql-mariadb-optimisations/ and increase the timeout values on your web server.

 

[dante]

That looks good, please see https://kb.mailwizz.com/articles/mysql-mariadb-optimisations/ and increase the timeout values on your web server.

thanks I'll have a look

 

[dante]

That looks good, please see https://kb.mailwizz.com/articles/mysql-mariadb-optimisations/ and increase the timeout values on your web server.

can you tell which values should I increase to what?

Also, when I run "/etc/my.cnf" on cmd I get
Permission denied

So I should edit it via filezilla

 

[frm.mwz]

can you tell which values should I increase to what?

Also, when I run "/etc/my.cnf" on cmd I get
Permission denied

So I should edit it via filezilla

try with
sudo nano /etc/my.cnf

 

[dante]

try with
sudo nano /etc/my.cnf

This is my "my.cnf" file.

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

This doesn't have anything like the link twisted posted above.

Also do I need to edit "php.ini" ??

 

[twisted1919]

This doesn't have anything like the link twisted posted above.

Which means you have to add

Also do I need to edit "php.ini" ??

most likely yes, increase the timeout values and memory limit.

 

[dante]

Which means you have to add


most likely yes, increase the timeout values and memory limit.

will do it and see how it goes

 

[Guillermo Dewey]

Its a VPS:

OpenStack KVM
2 vCore(s)
2.4 GHz
8 GB RAM
40 GB SSD
Local RAID 10

tks for the post I was getting all crazy looking into php and .htaccess values until realized there was a setting on the app level

cheers