Explain mysql statement
Or from command line
admin
Test Mysql Database with mysqlslap
https://www.digitalocean.com/community/tutorials/how-to-measure-mysql-query-performance-with-mysqlslap
Sync Date on CentOS 6 VM servers
My VM on ESXi have all different dates. Here is how toset them the same. First, you’ll need to install NTP. For Debian or Ubuntu, that would be this command: For Redhat or CentOS, you’ll need to use this one: Then you’ll want to edit the /etc/ntp.conf file, which is quite possibly already filled out … Read more
Drown Attack
Check your Site at https://drownattack.com/#test or run the following: http (replace IP with your server ip) postfix or other email MTA Check your version To protect against DROWN, server operators need to ensure that their private keys are not used anywhere with server software that allows SSLv2 connections. This includes web servers, SMTP servers, IMAP … Read more
Find Out Hard Disk Specs on Linux
Find your drives SDA is the primary hdparm Command Open the terminal and type the following OR
Left Join on mysql
SQL LEFT JOIN Syntax or: PS! In some databases LEFT JOIN is called LEFT OUTER JOIN. Example: You have a surveys table and a services table and the id’s are both client_id