Collect Code-Level Performance Tracing
Retrace collects an amazing amount of details about what is happening at the code level within your application. It is a gold mine for developers who are trying to troubleshoot bugs and look for ways to optimize their code.
- Web request length and context details
- SQL queries
- Log statements and exceptions
- Interaction with dozens of dependencies like NoSQL, caching, etc
- External HTTP web service calls
Source: Retrace Application Performance Management (APM) – Stackify
Your mission control center for PHP application performance
Tideways saves you time by taking the guesswork out of your app’s backend performance. Gain detailed insights, spot performance bottlenecks, and get real-time error detection alerts.
Source: Mission control center for PHP application performance | Tideways
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.