Skip to main content

Home/ Groups/ MySQL
Rss Feed
Sort By: Most Recent | Popular Filter: All | Bookmarks | Topics Simple Middle
1More

MYSQL HOW-TO - 0 views

www.cs.columbia.edu/...index.htm mysql
shared by Ken Wei on 17 Apr 07 - Cached
  • If you want multiple databases, you can either set up different users for them or grant their privileges to the same user.
1More

MySQL AB :: Advanced MySQL Replication Techniques - 0 views

dev.mysql.com/...dvanced-mysql-replication.html mysql
shared by Ken Wei on 08 Apr 07 - Cached
  • 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.
2More

MySQL AB :: Using the New MySQL Query Profiler - 1 views

dev.mysql.com/...using-new-query-profiler.html mysql
shared by Ken Wei on 07 Apr 07 - Cached
  • 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.
« First ‹ Previous 41 - 60 of 100 Next › Last »
Showing 20▼ items per page