Simple SQL statements debugging with MySQL global general_log variable turned ON
and a standalone php script that display the relevant SQL statements that are sent by a specific Moodle instance, filtered by the instance admin db username.
PHP Script: github/nadavkav/gist/nadavkav/mysql_statements_monitoring.php
Dynomite and the target storage engine run on the same node. Clients connect to Dynomite, and requests are proxied to either the storage engine on the same node or to Dynomite processes running on other nodes.
Dynomite, inspired by Dynamo whitepaper, is a thin, distributed dynamo layer for different storage engines and protocols. Currently these include Redis and Memcached. Dynomite supports multi-datacenter replication and is designed for high availability.
The ultimate goal with Dynomite is to be able to implement high availability and cross-datacenter replication on storage engines that do not inherently provide that functionality. The implementation is efficient, not complex (few moving parts), and highly performant.
מקור: Netflix/dynomite: A generic dynamo implementation for different k-v storage engines
Also, checkout (alternatives?):
What are Chartlets?
Chartlets are tiny charts without grids or legends, like Sparklines. They’re perfect for conveying simple relationships or trends, especially when space is scarce.
Chartlets uses the HTML5
<canvas> element for fast performance and is only 2.8k when minified and gzipped. It has no dependencies.
<canvas class=”chartlet” data-type=”line” data-colors=”#ffcc00 #ff66cc” data-range=”0 10″ data-sets=”[1 5 3 9 4] [4 3 9 7 2]” width=”100″ height=”55″ data-opts=”stroke:2 shape:smooth cap:circle”></canvas>
שילוב מנגנון הגרפים לעיל בשאילתות SQL ב configurable reports block
מקור: Chartlets: Tiny charts for tablet and mobile web apps
Bi-Directional Replication for PostgreSQL (Postgres-BDR, or BDR) is the first open source multi-master replication system for PostgreSQL to reach full production status, developed by 2ndQuadrant and assisted by a keen user community. BDR is specifically designed for use in geographically distributed clusters, using highly efficient asynchronous logical replication, supporting anything from 2 to more than 48 nodes in a distributed database.
מקור: Postgres-BDR | 2ndQuadrant
Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server. Adminer is available for MySQL, PostgreSQL, SQLite, MS SQL, Oracle, Firebird, SimpleDB, Elasticsearch and MongoDB.
מקור: Adminer – Database management in a single PHP file
Yorker, Moodler and developer Marcus Green not only offers comprehensive training on the Java programming language. In his examulator.com portal, he shows us a visualization of the database that po…
מקור: Visualize The Extent of Moodle 3.1 Data Model With This Tool | Moodle News
SQL Fiddle. How does it work? The Schema DDL that is provided is used to generate a private database on the fly. If anything is changed in your DDL (even a single space!), then you will be prompted to generate a new schema and will be operating in a new database. All SQL queries are run within a transaction that gets immediately rolled-back after the SQL executes. This is so that the underlying database structure does not change from query to query, which makes it possible to share anonymously online with any number of users (each of whom may be writing queries in the same shared database, potentially modifying the structure and thus — if not for the rollback — each other’s results). As you create schemas and write queries, unique URLs that refer to your particular schema and query will be visible in your address bar. You can share these with anyone, and they will be able to see what you’ve done so far. You will also be able to use your normal browser functions like ‘back’, ‘forward’, and ‘reload’, and you will see the various stages of your work, as you would expect.
mtop (MySQL top) is an open source real time MYSQL Server monitoring program written in Perl language that shows queries which are taking longer time to process and kills those longer queries after certain number of specified time. Mtop program enable us to monitor and identify performance and related issues of MySQL Server from the command line interface similar to Linux Top Command.
Mtop includes zooming feature that display query optimizer information of a running queries and killing queries, it also shows statistics of server, configuration information and some useful tuning tips to optimize and improve MySQL performance.
Please check some of the following features offered by Mtop program.
- Display real time MySQL server queries.
- Provides MySQL configuration information.
- Zooming feature to display process query.
- Provides query Optimizer information for a query and ‘killing’ queries.
- Provides MySQL tuning tips.
- Ability to save output in a .mtoprc configuration file.
- Provides Sysadmin recommendation page (‘T‘).
- Added queries/second to main header.
- Added per second info to stats screen.
פורסם ב: Install Mtop (MySQL Database Server Monitoring) in RHEL/CentOS 6/5/4, Fedora 17-12.
A PHP/MySQL free (moodle format) Course you can download and install.
This class is to teach the basics of using PHP server side scripting and MySQL database to create dynamic websites for personal or business use. This course was entered in the Cool Course Competition 2010.
פורסם ב: Moodle.net.
Moodle’s profiling tool
When your software is too slow, you need measurements to tell you which are the slow bits. Tools that do that are called profilers. One of the better profiling tools for PHP is called XHProf. The good news is that it has already been integrated into Moodle, and there is documenation about getting it working. Basically, you just need to install a PHP extension and turn on some options under Admin -> Development -> Profiling.
ב: Tim’s blog: Performance-testing Moodle.