If you want multiple databases, you can either set up different users for
them or grant their privileges to the same user.
MySQL Performance Blog - 0 views
MySQL Performance Blog » MySQL: Followup on UNION for query optimization, Que... - 0 views
MySQL Performance Blog » ORDER BY … LIMIT Performance Optimization - 0 views
MySQL Performance Blog » Descending indexing and loose index scan - 0 views
MYSQL HOW-TO - 0 views
MySQL Performance Blog » Covering index and prefix indexes - 0 views
Using the Ruby MySQL Module - 0 views
MySQL AB :: Advanced MySQL Replication Techniques - 0 views
-
Fixing these two misfeatures is exactly the purpose of this article. Using features introduced in MySQL 5.0 and 5.1, it is possible to build a replication system where all nodes act as master and slave at the same time, with a built-in fail-over mechanism.
Advanced MySQL Replication Techniques - 0 views
"Streaming" MySQL slave deployment - 0 views
MySQL AB :: Articles about MySQL - 0 views
MySQL AB :: Using the New MySQL Query Profiler - 1 views
-
When it comes to overall performance, it's important to remember that the #1 contributor is always a good database design. The second highest contributor to performance is well-tuned SQL code.
-
But a better day has come along in MySQL 5.0.37 with the inclusion of the SQL Profiling utility. This interactive diagnostic aid allows a developer or DBA to gain insight into where a set of SQL code spends its time and the resources it is using.
A couple of useful mysqldump options - 0 views
MySQL AB :: MySQL Workbench - 0 views
« First
‹ Previous
41 - 60 of 100
Next ›
Last »
Showing 20▼ items per page
