Problems with over 14 million recipient in 6.2

[bla2508]

Hey guys,

I'm new to openemm and have a question. I want to send Admin and test mail but I cant it says only that I have 0 Recipients, but my database contains around 14 millions recipients and some test and admin recipients. The first mailing that i've send had 2.4 million recipients and had no problems. Now i've importet some more and can't send anymore. My server has got 4 Cpu and 4 gb memory the harddisk have enough place. The average load is usually not over 0.5.
Now my question is is there any limit of the database or could it be a timeout or something for openemm?
I've tuned the configs to import 20 million recipients.

My data

Ubuntu 64 bit on xen

OpenEmm 6.2

Sorry for my bad english

[maschoff]

There are no limits in the software. But you should have a look at the log and resources like heap space to detect problems.

[bla2508]

Thanks for your fast help.

I've changed the java options in the openemm.sh from
default JAVA_OPTIONS="-Xms256m -Xmx512m -XX:MaxPermSize=256m -Xss256k"
to JAVA_OPTIONS="-Xms512m -Xmx1024m -XX:MaxPermSize=256m -Xss2048k"

and i've found in the log that mysql want more buffer size. Ive increased this value too.
After restart of OpenEmm i tested the mailing and i see the same problem that no messages were send.
I have looked again in the recipients table there are 3 admin mailing accounts.

Greets from Germany, Berlin!

[bla2508]

Now i can send new Mailings!

The Problem was the mysql one Table was damaged after a Repair it works.
The only Problem that i have i dont know what table engine the customer_1_binding_tbl is?
Myisam or Innodb

after the Repair it becomes an Innodb but all others are Myisam is that right?

Thanks for your Answers

[maschoff]

All OpenEMM tables use MyISAM by default. But the install guide lists some suggestions when to use InnoDB.

[bla2508]

Thank you for this information!