Erik Luppes

Forum Replies Created

Viewing 5 posts - 1 through 5 (of 5 total)
in reply to: Bulk Import causes Database Crash #70547

Erik Luppes
Participant

I’m using PHP Version 5.5.38
innodb_buffer_pool_size = 512Mb (this was 128Mb on my first try, I have increased it to 512Mb, with no luck)

Since the pool size is <1Gb my pool instances is the default 1
I have 2Gb SWAP configured, 800Mb used.
Real memory 1.45 GB used / 3.62 GB total
CPU load averages 0.03 (1 min) 0.06 (5 mins) 0.05 (15 mins)

in reply to: Bulk Import causes Database Crash #70478

Erik Luppes
Participant

I’m not using a CSV, i’m using the Import files from Server method:

The DB server logfile (relevant part from the time of the crash) is in my first post.
Also the DB is not restarting, it is crashing, making all sites hosted on my server unresponsive.
I have to start my DB server manually after the crash.

in reply to: Bulk Import causes Database Crash #70157

Erik Luppes
Participant

I am the serveradmin ๐Ÿ˜‰ trying to solve this.

Running on a server with 2vCPU cores, 4Gb Memory.

On IDLE load my server uses :
CPU load averages 0.37 (1 min) 0.16 (5 mins) 0.15 (15 mins)
Real memory 1.46 GB used / 3.62 GB total
Virtual memory 635.97 MB used / 1.95 GB total

Using MariaDB MySQL. I already tried to enlarge the mysql buffer pool size from 128Mb to 1Gb, with no luck.
Also did a predefined setting om MySQL form a medium server to heavy (This is an option within Virtualmin, what I use to manage my server), but still without luck.

Is there any logging or a verbose mode within WPDM when doing a Bulk Import ? So I can see what is happening ?


Erik Luppes
Participant
This reply has been marked as private.
in reply to: Bulk Import causes Database Crash #70065

Erik Luppes
Participant

Well the problem is that they were not imported, so there was also nothing to remove.
I ended up adding the downloads 1 by 1.
To bad that the Bulk Import causes the database crash, I think Importing less then 10 files a time isn’t really Bulk Import.

Viewing 5 posts - 1 through 5 (of 5 total)