Paul's Programming Notes PostsRSSGithub

MySQL IF Statement Affect On Speed

if(`table`.`start`='0000-00-00','',`table`.`start`)

That’s the part of my query that was increasing the execution time by 10x.

I changed it to just `table`.`start` (without the IF statement) and the query was 10x faster.

Failed to connect to socket /var/run/dbus/system_bus_socket

Error: Can’t find out if NetworkManager is running: Failed to connect to socket /var/run/dbus/system_bus_socket: No such file or directory.

The following fixed the problem:

apt-get install dbus

(if you already have dbus installed: sudo service dbus start)

/etc/init.d/network-manager start

What caused the error?:

/etc/init.d/network restart

Could not initialize NMClient

** (process:17986): WARNING **: error: could not connect to NetworkManager

Fix: Try running with sudo.

For example: sudo nm-tool | grep DNS