Network Solution for Windows – Windows system, Linux system, Ubuntu server configuration tip

If you enable slow queries log of MySQL database server, you will notice that from the slow query log file contains only SQL statements and queries that took more than query_time of 10 seconds to execute or run. This is the default value or query time threshold for log_slow_queries function, which is 10 seconds. 10 seconds is way too long for a SQL query to complete, so the value may be too high to capture any meaningful data. You can ...

Other then the ways specified here to reset and change the root password for mySQL database in the case that the password is forgotten or lost, the following instructions explain in details the alternative way at the last part of the guide, where no additional file needs to be created: Login as root to the Windows or Unix-like (Unix, Linux or BSD) machine with the MySQL server. Stop the MySQL server by using either of the following command:Linux: /etc/rc.d/init.d/mysql stop FreeBSD: /usr/local/etc/rc.d/mysql-server.sh stop Open ...

MySQL is a very popular free yet powerful database system. But even in great databases, the tables may get fragmented with overhead due to continuous update, or delete and insert operation on data stored in database. Beside, it’s also possibility that the databases may get corrupted. Thus, performing health check on database and optimize MySQL server regularly is an important task. It’s a bit troublesome if the database administrators have to login to the server or launching the phpMyAdmin to optimize ...

When it comes time to obtain a dedicated server, you essentially have two platforms to choose from: Windows and Linux.  Both systems have their advantages and disadvantages, ranging from costs to application requirements.

Programming Technologies and Database Servers

The major difference between Windows and Linux lies in the applications and development technologies.  If you intend to run software packages such as PHP, Perl and MySQL on your server, Linux would make the best option, as it functions seamlessly ...

One of the longest running debates in the history of technology has been the Windows vs. Linux debate. You may alienate the advocates of one if you say anything good about the other. However, both have their advantages and disadvantages. The Windows vs. Linux debate in the web and server hosting world has also heated up. Let’s look at what each of them has to offer. Advantages of Windows Server Hosting As .NET is a software framework by Microsoft, Windows server hosting ...

The argument of which operating system is better – Windows or Linux – has been on since the very inception of these operating systems and is likely to continue till the day we stop use them. In today’s post, we will look at how they fare as operating systems for the web server. While Linux is cost effective, Windows has a wider reach. Before the Linux lovers get angry on the latter part of the last sentence, let me explain. One ...

The other day, a computer-illiterate friend called me and said, “My son is getting an operating system for the home computer. And it’s not Windows and it’s free!” I smiled. During our conversation he wondered why the world wanted to pay for something when there was an alternative available for free. So, folks, I ask you this, and I will talk about operating systems for servers only. Have you ever wondered why you pay and yet go for Windows when ...