Search Results for "mysql database scripts"

"It's not a tool, which fixes a problem, but the fool using it!" (Jörg Stryk) The M7 bunch of scripts should help the EXPERIENCED Troubleshooter to quickly identify bottlenecks and to develop/implement appropriate solutions. "With great power comes great responsibility" (Uncle Ben)

Cinemagoer is a Python package useful to retrieve and manage the data of the IMDb movie database about movies, people, characters and companies. Platform-independent, it can retrieve data from both the IMDb's web server and a local copy of the whole db.

LightProfiler – application for performance analysis of the Oracle databases. It generates detailed resource profile for extended SQL trace files (10046 event), containing information about consuming of response time (by events, by cursors, etc.), data files usage, error analysis (SQL, PL/SQL) and much more. Also it contain tools for additional processing of trace files (extract session data, splitting files) and for management of database's sessions (disconnecting, tracing, monitor...

Mad for DB - The Migration Advisor for DataBases - analyzes the differences between two database schemas, automatically finds out which changes require individual migration effort and advises migrators which concrete datasets need fixing.

JARep is a reporting tool for application performance data, extracted from a performance measuring tool like JAMon API. The data is then stored in a database. Via a webapp or a Swing application you can view the performance over time. See SVN source.

MySQL log analyzer and profiler. Extracts the most popular queries grouping them by their normalized form and shows the statistics for each group. Helps developers to recognize most frequently run queries to be able to optimize overall db performance.

A fully automated database benchmark suite that prints tabular and graphic results for multiple tested disciplines, given JDBC database connections. Some free open source database engines are included.

ViennaProfiler allows to compare execution times of full programs or parts of a program. Execution times are stored in a MySQL database and conveniently analyzed via a web-interface. A C++ client API is provided, other languages can also be used.

Simple monitoring utility to help optimizing a (MySQL) database server. Run the utility for a time to record queries on the database. Generate reports while the utility is running or afterwards. Reports are available as text or excel-sheets.

Maatkit (formerly MySQL Toolkit) contains essential command-line tools for MySQL. It is now hosted at http://code.google.com/p/maatkit/ instead of Sourceforge. Please do not use the forums here; use http://code.google.com/p/maatkit/ instead.

This tool will analyze your MySQL binary log (binlog) files. (Requires mysqlbinlog). Query speed, distribution, and size are reported.

mda4eclipse is a domain-driven and model-driven development eclipse plugin. Its purpose is to present a way of using different project sites to work together and establish a shared development environment.

Elvyx is a tool designed to monitor and profile the jdbc activity on java projects. This jdbc profiler has a server with a built-in db and a client to improve the experience.

gen_names populates customer/invoice tables with random (but realistic looking) data. The data has been gathered from various sources including census and local council web sites. It is supposed to be used to road test various DBMS solutions.