Forum Replies Created
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)
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.
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 ?
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.