Using Sysbench to Benchmark MySQL 5.7

So, you want to see how many connections your database can take before it gives up? It’s better to know ahead of time when you might expect performance issues than to wait until your service goes down. One of the most common tools around for performance testing is sysbench. I’ve used sysbench with MySQL 5.5…

Read More

Screen 202: Making Screen a Little More User Friendly

By now you’ve learned the basics of using screen from my previous posts. You may be wondering how to keep track of what you have running in each of your screen sessions. With this post we’ll show you how to add a little more context to screen that will allow you to more easily see what…

Read More

Screen 201: 7 Ways to Change Your View When Using Screen

In a previous post I detailed the basic usage of GNU Screen. Below I will cover how to customize screen to make it easier to use and more convenient for you. If you’ve used screen at all you know out-of-the-box it can be a bit plain and quirky. In fact, it’s virtually impossible to distinguish a…

Read More

Screen 101: Use Screen to Manage SSH Sessions

If you’re not a Linux power-user then you probably have never heard of Screen, in fact, I would hazard to say most Linux users probably have never heard of this utility. You don’t need to be a Linux desktop user (I’m not) to find Screen useful. I typically use it when running a script that…

Read More

Sysbench 1.x Fundamentals

Sysbench is the hammer frequently used to benchmark servers and services. Within the past year sysbench version 1 was released and with it came some syntax and usage changes. Unfortunately, there’s not a lot of documentation out there for using Sysbench so I had to learn the hard way. The best way to learn more…

Read More