Tristan Rivoallan's Bookmarks tagged → View Popular
You are here: Diigo Home > Tristan Rivoallan's Bookmarks
Racker Hacker » MySQLTuner v0.9.1
MySQLTuner is a high-performance MySQL tuning script written in perl that will provide you with a snapshot of a MySQL server’s health. Based on the statistics gathered, specific recommendations will be provided that will increase a MySQL server’s efficiency and performance. The script gives you automated MySQL tuning that is on the level of what you would receive from a MySQL DBA.
more fromrackerhacker.com
Johan Andersson's Blog: Dimensioning Toolkit for MySQL Cluster
This blog presents a new toolkit to assist in Dimensioning of MySQL Cluster.
The toolkit consists of two parts:
1. ndb_record_size
2. a spreadsheet to assist in calculating the amount of storage needed etc.
more fromjohanandersson.blogspot.com
Kazuho at Work: Implementing Timeline in Web Services - Paradigms and Techniques
In this blog article, I will describe two methods: push and pull, of implementing such a timeline, from their basic design to tuning techniques. SQL (that would work fine with MySQL) would be used in the article, but the prcinples would never change whatever storage (relational or specially designed) is being used.
more fromlabs.cybozu.co.jp
MySQL Workbench » Blog Archive » Using Schema Synchronization in MySQL Workbench OSS Edition
As you can see in the MySQL Workbench Edition feature grid, Live Schema Synchronization is a Standard Edition feature only. But that does not mean that you cannot make use of the same functionality in the OSS Edition in an offline scenario - which is even more preferable in some cases.
more fromdev.mysql.com
Tools | MySQL Performance Blog
This page contains links to various tools we found helpful to use in practice.
Some tools are written by us, others by third parties, yet another ones may be shipped with your operating system you just need to find they are there.
more fromwww.mysqlperformanceblog.com
SourceForge.net: Monolith - MySQL DBA Console
Monolith MySQL DBA Console schedules & automates backups for MySQL databases. It monitors an unlimited number of servers for performance trending and tuning recommendations. Many history graphs are utilized for trending purposes.
more fromsourceforge.net
Join-fu: The Art of SQL Tuning - Jay Pipes
I created a new slide deck with some new material on LEFT-join-fu and managing many-to-many relationships that folks might find handy. Below are the slides in OpenOffice Impress and PDF format. Enjoy.
more fromjpipes.com
MySQL :: MySQL Workbench for Database Change Management
MySQL Workbench contains a number of database change control features that you may not have noticed at first, so let me introduce them to you and show you why they can be a big help when it comes to managing change in your databases.
more fromdev.mysql.com
MySQL :: MySQL 5.1 Reference Manual :: 15 MySQL Load Balancer
The MySQL Load Balancer is an application that communicates with one or more MySQL servers and provides connectivity to those servers for multiple clients. The MySQL Load Balancer is logically placed between the clients and the MySQL server; instead of clients connecting directly to each MySQL server, all clients connect to the MySQL Load Balancer, and the MySQL Load Balancer forwards the connection on to one of the MySQL servers.
more fromdev.mysql.com
pero on anything » Blog Archive » Presentation Slides: Introduction to HSCALE
Today, I held a presentation in front of all developers and support engineers of our technical department about database partitioning, MySQL Proxy, HSCALE and the progress we are making.
more frompero.blogs.aprilmayjune.org
Colin Charles Agenda » Blog Archive » Services Oriented Architecture with PHP and MySQL
Joe Stump, Lead Architect, Digg. Slides should make its way at Joe’s website soon enough.
Mainly works on the backend, makes sure its scalable, can all the Digg buttons be served, et al.
Application layer is loosely coupled from your data. Whole point of SOA? You can put a service in front of the DB, and move between DB’s if required.
They do use MySQL, but its pretty vanilla.
more fromwww.bytebot.net
Mark's stream of verbiage: Improve reliability and maintainability by using stateless connections
MySQL application developers have some problems with connection state. There is a lot of state which can be used associated with a single connection
* Transactions (autocommit, uncommitted work, when a transaction was started, isolation level)
* Temporary tables
* Session variables which affect behaviour
* Other session variables
If you can avoid all of these, then you can benefit from transparent auto-reconnection and transparent connection reuse / pooling etc.
more frommarksverbiage.blogspot.com
Geeking with Greg: Replication, caching, and partitioning
very insteresting article and comments.
more fromglinden.blogspot.com
Brian "Krow" Aker's Idle Thoughts - The Death of Read Replication
more fromkrow.livejournal.com
Arjen's Journal - Hierarchies in SQL? OQGRAPH engine backend preview
wouldn't it be nice if a hierarchy (or even a full-on graph, like social networks have) could just be managed cleanly relationally?
This is something Kim and I have been dabbling with. The engine is called OQGRAPH (OQ for Open Query) now because just graph caused some symbol conflict hassles. Anyway, following is a brief demo of how it works.
more fromarjen-lentz.livejournal.com
Synchronize MySQL Databases — SyncSQL.com
Creates MySQL 4.1+ schema diffs.
more fromsyncsql.com
Rational Relational: Two MySQL Monitoring Tools and a Hidden Knowledge Base
In this post, I'd like to mention two monitoring tools, and one knowledge base.
more fromblog.shlomoid.com
il corra » MySQL Administrator useful InnoDB graphs
Here is a simple configuration file (XML) for MySQL Administrator client.
In addition to the the default graphs I added some new pages containing the most important status variables to monitoring and evaluate the performance of InnoDB.
more fromblog.pandiani.com
Notation: * = Private bookmark and comment|… = Clipping [?] | … = Public highlight [?]
