We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

mysql warnings and how do I fix them? | Forum

Abbey
Abbey Apr 13 '15
I've had issues with slow load times, I have spoken to my hosting and they have informed me the issues are due to an application on my site which are giving the following warnings

150414 8:18:27 [Warning] Statement may not be safe to log in statement format. Statement: INSERT DELAYED INTO `ow_base_user_online` (`userId`,`activityStamp`,`context`,`id`) VALUES (1,1428952707,1,0)
150414 8:20:20 [Warning] Statement may not be safe to log in statement format. Statement: INSERT DELAYED INTO `ow_base_user_online` (`userId`,`activityStamp`,`context`,`id`) VALUES (11512,1428952820,1,0)
150414 8:20:57 [Warning] Statement may not be safe to log in statement format. Statement: INSERT DELAYED INTO `ow_base_user_online` (`userId`,`activityStamp`,`context`,`id`) VALUES (18261,1428952856,1,0)
150414 8:22:27 [Warning] Statement may not be safe to log in statement format. Statement: INSERT DELAYED INTO `ow_base_user_online` (`userId`,`activityStamp`,`context`,`id`) VALUES (15295,1428952947,1,0)
150414 8:27:32 [Warning] Statement may not be safe to log in statement format. Statement: INSERT DELAYED INTO `ow_base_user_online` (`userId`,`activityStamp`,`context`,`id`) VALUES (17747,1428953252,1,0)
150414 8:28:39 [Warning] Statement may not be safe to log in statement format. Statement: INSERT DELAYED INTO `ow_base_user_online` (`userId`,`activityStamp`,`context`,`id`) VALUES (19159,1428953319,1,0)
150414 8:30:47 [Warning] Statement may not be safe to log in statement format. Statement: INSERT DELAYED INTO `ow_base_user_online` (`userId`,`activityStamp`,`context`,`id`) VALUES (9059,1428953447,1,0)
150414 8:31:48 [Warning] Statement may not be safe to log in statement format. Statement: INSERT DELAYED INTO `ow_base_user_online` (`userId`,`activityStamp`,`context`,`id`) VALUES (8610,1428953508,1,0)
150414 8:32:39 [Warning] Statement may not be safe to log in statement format. Statement: INSERT DELAYED INTO `ow_base_user_online` (`userId`,`activityStamp`,`context`,`id`) VALUES (11131,1428953559,1,0)

Can anyone enlighten me on how to fix this or can offer to fix this for a fee?
dave Leader
dave Apr 13 '15
Warnings and notices do not contribute to slow load times unless you have a kazillion of them with each page load.  Your host is blowing smoke up your wazoo... 


The server process time is only typically a few milliseconds for all the warnings and notices with each page. So unless you have a very very large site and have millions of warnings and notices then it is not going to delay the site enough to even notice. 


Warnings such as those are not going to crash your site. 


Also much of the time this is a host issue and the way they setup and configure their disks and the server.


The best thing you can do to decrease your load time is to  compress your site.  In cPanel use the optimize site option.   


here are some resources for you 


dba.stackexchange.com/questions/25359/mysql-statement-may-not-be-safe-to-log-in-statement-format-warning


dev.mysql.com/doc/refman/5.1/en/binary-log-formats.html



The Forum post is edited by dave Apr 14 '15
Abbey
Abbey Apr 14 '15
Hi, I've optimized my site, via cpanel, I've added more resources, I've been complaining about the slow speed since they moved me to a new server. They say this isn't the issue it's the application shown in the above errors and to contact my developer.

I pay good money for my vps and I think this the slowness is bullshit since before the move my site was great and after not so great.
Abbey
Abbey Apr 14 '15
And thanks for the links, they made some sense..... I may need to read them a few times to get my head round it