Home / Tag Archives: mysql

Tag Archives: mysql

July, 2010

  • 28 July

    Server Maintenance Tips

    Server Maintenance Tips

    Over the course of the past year, we have covered many dedicated server maintenance issues, particularly for servers running Linux. In no particular order, here is a list of some of the more important tips you should remember when taking care of your server. 1. When possible, rely on the …

  • 13 July

    How to Increase MySQL Memory Usage Above 4GB

    Question: My database server is timing out because MySQL seems to hang once it has used up 4GB of RAM, even though the server is equipped with 6GB. How can I make MySQL take advantage of the full 6GB available? Answer: If your current server setup involves a 32-bit architecture …

  • 12 July

    Troubleshooting Database Connections

    database connection error

    When MySQL works correctly, it can be a thing of beauty, but when something goes wrong, it can drive you mad. Here are a few things you can do to troubleshoot connection problems: 1. Make sure your username and password are correct. 2. Double-check the hostname. Although “localhost” works on …

  • 9 July

    How to Delete Tables and Rows in MySQL

    mysql

    As I mentioned in a previous MySQL post, knowing how to quickly perform database tasks from the command line is a good idea if you are a Linux system administrator. Sometimes, it is the easier way to get things done, especially if you are helping another user and need root …

  • 8 July

    How to Search a MySQL Database

    With web-based control panels and web software like phpMyAdmin, you have numerous options available for searching a MySQL Database. If the need should ever arise where those tools are not available, however, it is a good idea to know how to search a database from the command line. To search …

  • 2 July

    MySQL Optimization: Part 2

    1. Query cache – On most servers, there are certain MySQL queries that you and/or your scripts will run more often than others. In fact, you may run the same query hundreds or even thousands of times in a single day. The query_cache setting will save the most used queries …

June, 2010

  • 30 June

    MySQL Server Optimization

    If you are running a dedicated server, optimization is very important to maximize speed, efficiency, and save time and energy. We have already looked at ways to optimize Apache web server, but many dynamic websites also use databases that hold the data for their dynamic web applications. You can accomplish …

  • 2 June

    Joomla Security Tips

    Joomla is a powerful free and open source content management system. It has become very popular, and many web hosting provider offer instant installer scripts that can automatically install Joomla onto a customer’s website. In certain, situations, however, you may prefer to install Joomla yourself. When you do, there are …

May, 2010

  • 19 May

    MySQL Enterprise Released

    Monday, the database giant, Oracle, announced the release of MySQL Enterprise. In addition to the standard, freely available database software, this new packaged version of MySQL will include comprehensive support and monitoring tools. The primary tool available with this release is MySQL Monitor 2.2, which monitors performance and security. Other …

  • 6 May

    SQLite for Your Database Needs

    In the web hosting world, certain database software is commonplace. Most system administrators, even the new ones, have heard of MySQL, MSSQL, and/or PostgreSQL. Using SQL databases typically requires a database server to be running on the system. MySQL, for example, runs as a service in Linux called mysqld, or …

Powered by Namesco
© Copyright InternetBlog.Org.Uk 2024, All Rights Reserved