PUBLIC MARKS with tags admin & database

MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability. Within seconds, it will display statistics about your MySQL installation and the areas where it can be improved. It’s key to remember that MySQLTuner is a script which can assist you with your server, but it is not the solution to a badly performing MySQL server. The best performance gains come from a thorough review of the queries sent to the server, and an evaluation of the MySQL server itself. A qualified developer in your application’s programming or scripting language should be able to work with a MySQL database administrator to find improvements for your server. Once the server and application are optimized well, you may need to consider hardware upgrades to the physical server itself. This is a really useful tool for helping to optimize MySQL performance.Understanding the various my.cnf variables and how they affect performance can seem really complicated but this tool takes some of the pain away and makes it easier to understand the effects of each variable.It is especially useful to be able to see the global memory usage, memory usage per thread and the maximum possible memory usage - that is really valuable information that is otherwise complex to calculate.

I'm pleased to present you with part one of a two part series on creating a photo site using PHP, jQuery, and AJAX. Originally, I intended to fit the entire tutorial into one screencast, but that quickly became a pipe dream as I realized that there was simply too much to cover. Nevertheless, even if you only watch this first video, you should learn a great deal. We'll be retrieving images from a database, creating a simple login form with authentication, and will then allow for our database to be asynchronously updated. Sounds good? If so, let's get into it.

What's Sqliteman? The best developer's and/or admin's GUI tool for Sqlite3 in the world. No joking here (or just a bit only) - it contains the most complette feature set of all tools available.

Domain Technologie Control (DTC) is a GPL control panel for hosting. Using a web GUI for admin and accounting all hosting services, DTC can delegate the task of creating subdomains, email, and FTP accounts to users for the domain names they own. DTC manages a MySQL database containing all the hosting information. It has support for many programs (bind 8 and 9 and compatibles, MySQL, Apache 1.3, php4, qmail, postfix 2, courier, dovecot, proftpd, webalizer, mod-log-sql, etc.) through config files and/or MySQL plugins (when the service is non-critical). It can also generate backup scripts, calculation scripts, and config files using a single system UID/GID and monitor all traffic accounting per user and per service. Since version 0.12, DTC is fully skinable and translated into several languages (Chinese, English, Spanish, French, Dutch, German, Italian, Russian, Hungarian, Romanian and Polish).

以 Ajax 方式管理 database，難道會是 phpMyAdmin 的強敵？