Re: Apache::DBI - consistently encountering about a .00667% error rate

2024-10-10 Thread Perrin Harkins
DBI is supposed to install the driver when you call connect(), although that does mean any code loaded there isn't shared in memory. My question would be, did you get any actual failed responses in your load test, or just these error log messages? If all the requests succeeded, then I would suspec

Re: Apache::DBI - consistently encountering about a .00667% error rate

2024-10-10 Thread Tim Lank
Thanks Ed. I'll add it and see if it helps. My load testing phase is already completed, but I may get a chance to retest next year. On Thu, Oct 10, 2024 at 6:32 AM Edward J. Sabol wrote: > On Oct 7, 2024, at 5:55 PM, Tim Lank wrote: > > I have the following in my startup.pl: > > use CGI qw(:a

Re: Apache::DBI - consistently encountering about a .00667% error rate

2024-10-10 Thread Edward J. Sabol
On Oct 7, 2024, at 5:55 PM, Tim Lank wrote:I have the following in my startup.pl:use CGI qw(:all);use CGI::Carp 'fatalsToBrowser', 'carpout';use List::Util 'shuffle';CGI->compile(':all');Apache::DBI->connect_on_init  ("DBI:mysql:holidayshop",I don't know if it will help or not, but, before the abo

Re: Apache::DBI - consistently encountering about a .00667% error rate

2024-10-10 Thread Tim Lank
Nothing glaring turned up in the logs when DBI debugs were turned on. Along the lines of what Mithun conveyed, I did add this to the /etc/my.cnf and it has seemed to cut the amount of errors in half or less from 6-8 down to 2 or 3 per run. [mysqld] default-authentication-plugin=mysql_native_passw