First – run mysqltuner: Here is what you should do. First run this query This will give you the RIBPS, Recommended InnoDB Buffer Pool Size (in GB)based on all InnoDB Data and Indexes with an additional 60%. After the restart, run mysql for a week or two. Then, run this query: This will give you … Read more
CentOS 7 minimal systems, use the commands “ip addr” and “ip link” to find the details of a network interface card. To know the statistics use “ip -s link”. To view the details of the network interface cards, enter the following commands: To view the statistics of your network interfaces, enter the command: OR How … Read more
Timestamped bash history logging may be a great idea for logging changes. An example would look like this: This can be done by adding 2 lines to the root .bashrc file or as a custom file in /etc/profile.d/ folder: then a single line added to /etc/rsyslog.conf: After this all commands will be logged to the … Read more
https://mover.io/
UPDATE wp_options SET option_value = replace(option_value, ‘http://www.oldurl’, ‘http://www.newurl’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’; UPDATE wp_posts SET guid = replace(guid, ‘http://www.oldurl’,’http://www.newurl’); UPDATE wp_posts SET post_content = replace(post_content, ‘http://www.oldurl’, ‘http://www.newurl’); UPDATE wp_postmeta SET meta_value = replace(meta_value,’http://www.oldurl’,’http://www.newurl’); mysql> UPDATE wp_options SET option_value = replace(option_value, ‘http://www.oldurl’, ‘http://www.newurl’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’; Query … Read more
Source: https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=2109922 Virtual machine loses network connectivity intermittently In the Windows Event Viewer (Expand Windows Logs and select System), you see entries similar to: Intel(R) 82574L Gigabit Network Connection Network link is disconnected or Intel(R) 82574L Gigabit Network Connection Network link has been established at 1Gbps full duplex This issue would occur in these environments: The … Read more
Or from command line
https://www.digitalocean.com/community/tutorials/how-to-measure-mysql-query-performance-with-mysqlslap
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