| |
|
|
|
Use MyProfiler to :
Monitor the performance of an instance MySql .
Troubleshoot problems in MySql by capturing events on a production system and replaying them on a test system. This is useful for testing or debugging purposes and allows users to continue using the production system without interference.
Audit and review activity that occurred on an instance of SQL Server. This allows a security administrator to review any of the auditing events, including the success and failure of a login attempt and the success and failure of permissions in accessing statements and objects.
Get a full list of the statements executed on your server and the time of execution. This helps shared hosts to charge the users by usage .
Helps you detect bottlenecks and determine high usage days and hours on your server .
Use the Index tuning wizard to determine the best organization of indexes on your databases .The index tuning wizard allows gives u a recommendation on creating the indexes in your tables .
Tracing :
In the tracing window you will see the events that occur on your server .MyProfiler captures the following events : SQL Queries -Login attempts-Shutdown-Connection terminating2)Logging :
MyProfiler allows you to log the events that occur on your server to a text file or a MySql table. You can set limitation on the size of the text file or the number of rows of the table to avoid extreme growth .When you choose the logging to a mysql table you can use this workload as an input to the index tuning wizard to analyze the best index structure on your database .
3)Index tuning wizard :
The Index Tuning Wizard allows you to select and create an optimal set of indexes and statistics for a MySql Server database without requiring an expert understanding of the structure of the database, the workload, or the internals of MySQL Server.The wizard will recommend the best mix of indexes for a database. |
| « read more about MyProfiler 1.0 |
|
|
RECOMMENDED DOWNLOADS IN THIS CATEGORY
|
|
|
|
| » DTM Migration Kit 1.04.20
|
| Most companies running multiple databases have to deal with complex data migration issues. After all, importing, exporting or migrating data between different sources is very complicated and time consuming, especially if these data sources store data in d ... |
|
| DTM soft | 1039KB | Win 98/ME/2000/XP | $140 | Downloads: 1207 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » DTM DB Stress 1.02.10
|
| DTM DB Stress is a utility for stress testing the server parts of information systems and applications, as well as DBMSs and servers themselves. This tool allows you to create and configure a continuous set of requests to the server of the OLAP (query exe ... |
|
| DTM soft | 910KB | Win 98/ME/2000/XP | $140 | Downloads: 1281 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » SQL Uniform Lite 1.8.0
|
| SQL Uniform is a database client, graphical user interface (GUI), a helper application to relational databases of various types regarding query, maintenance, data comparison, export (convert), import. It supplies the databases with helper applications po ... |
|
| SQL Uniform Software Team | 16637KB | Win 95/98/ME/NT/2000/XP | 0 | Downloads: 1261 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » EMS PostgreSQL Manager Lite 3.2
|
| EMS PostgreSQL Manager Lite is a light and easy-to-use freeware graphical tool for PostgreSQL administration. PostgreSQL Manager works with any PostgreSQL versions up to 8.0 and supports all of the latest PostgreSQL features including tablespaces, named a ... |
|
| EMS Software Development | 10516KB | Win 95/98/ME/NT/2000/XP | | Downloads: 1196 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » UncleOra for Oracle 1.31
|
| UncleOra for Oracle is a fast multi-threaded SQL and PL/SQL tool with a script library and an advanced grid for developers and database administrators. Features: script library; SQL and PL/SQL editor; single, multiple and for update statement execution; ... |
|
| IT ALMA | 2689KB | Win 95/98/ME/NT/2000/XP | $129.00 | Downloads: 1284 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Mexico Postal Code Database (Premium Edition) September 2005
|
| Mexico postal codes database one month subscription service. The database includes postal code, city name, colony name, state abbreviation, state name, latitude and longitude in Mexico. The complete database contains over 58,000 precise records with 28,00 ... |
|
| ZIPCodeWorld.com | 25KB | Win 3.x/95/98/ME/NT/2000/XP/CE | $349.95 | Downloads: 1307 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » SQLite Analyzer 3.0.4
|
| Are you not thrilled about how difficult it is to process SQLite databases? Don’t you just wish there were a graphic user interface utility that could handle all SQLite database management issues quickly and easily? If the answer to either of these ques ... |
|
| KRASLabs | 2986KB | Win 95/98/ME/NT/2000/XP | $60 | Downloads: 1231 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Aqua Data Studio 4.5.2
|
| Aqua Data Studio is a SQL editor and developer tool that allows developers to easily create edit and execute SQL scripts as well as browse database structures. Aqua Data Studio provides an integrated database environment with a single consistent inferface ... |
|
| AquaFold, Inc | 50822KB | Win 95/98/ME/NT/2000/XP | $149 | Downloads: 1487 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Invoice SI 4.38
|
| Invoice SI invoicing software is an easy-to-learn invoice program, with ALL the features you need for small to medium business invoicing, and for a very modest price. Use it just for invoicing and generating invoices or to run your entire business. Sof ... |
|
| Marr Software | 9966KB | Win 2000/XP | $5 | Downloads: 1312 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Pro-Repair PRI 5.34
|
| ProRepair lets you easily enter, store, and access a variety of information. All of your data is secure, centrally located, and easily formatted to run custom reports so that you can put the valuable information you collect to good use. From Organizatio ... |
|
| Marr Software | 9966KB | Win 2000/XP | $5 | Downloads: 1228 |
| Date added: Sep 22, 2005 |
» Details |
|
|
|
|
| » General SQL Parser 0.9.1
|
| Create parser for different databases such as MSSQL,Oracle to deal with different sql dialects. Syntax check, give the error token, position and hint message. Pretty print SQL statements with lots of configurable parameters, make it more readable. Modify ... |
|
| SQLParser.com | 1699KB | Win 95/98/NT/2000/XP | 0 | Downloads: 1229 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » EMS PostgreSQL Manager Professional for Windows 3.2
|
| EMS PostgreSQL Manager is a powerful tool for PostgreSQL Database Server administration and development. PostgreSQL Manager works with any PostgreSQL versions up to 8.0 and supports all of the latest PostgreSQL features including tablespaces, argument nam ... |
|
| EMS Software Development | 12196KB | Win 95/98/ME/NT/2000/XP | $195.00 | Downloads: 1288 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Downtime Manager 4.9
|
| DownTime Manager keeps track of your equipment downtime.Use it for industry,fleet maintenance computers,etc.Easily track downtime and find the problems areas with equipment.Plots downtime by month,type of downtimeand what shift the downtime occured. DownT ... |
|
| Nhuntsoftware | 4928KB | Win 95/98/ME/NT/2000/XP | 0 | Downloads: 1216 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Tool for Organizing Your Schemas (TOYS) 1.0.30
|
| A Microsoft Windows tool for comparing, synchronizing and documenting Oracle database schemas. The tool facilitates taking snapshots of the database structure (meta-data) and saving these snapshots as XML files. Snapshots can be compared to determine what ... |
|
| Impact Systems Pty Ltd | 1852KB | Win 98/ME/NT/2000/XP | 0 | Downloads: 1221 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » MARS 2.5 b20050824
|
| MARS is an application for Windows that saves time and money by making it easy to define single or packages of Access reports or queries, schedule and run them automatically, and send the reports to print, fax, disk, ftp or email in a number of standard f ... |
|
| ChristianSteven Software Ltd | 73086KB | Win NT/2000/XP | $49.95 | Downloads: 1324 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » KronoLog 1.050825
|
| August, 2005 KronoLog: The Information Manager for the Information Age River Edge, NJ (August 31, 2005) - Whistling Cow announces the upgrade of KronoLog to Version 1.050825, a powerful information manager for the information age. Designed for the Windows ... |
|
| Whistling Cow | 16708KB | Win 98/ME/NT/2000/XP | $79.95 | Downloads: 1210 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Connect4 SQL Designer 1.0.9
|
| Connect4 SQL Designer provides developers with an advanced, yet simple to use End User Visual SQL Query Design Tool. It is a 100% .Net based component for implementation within your .Net applications. Use SQL Designer to add end user query design capabili ... |
|
| Connect4 | 2442KB | Win 98/NT/2000/XP | $249.00 | Downloads: 1297 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » DTM SQL editor 2.02.77
|
| DTM SQL editor is a set of powerful database management tools that allow you to achieve two goals: to have unified access to different types of databases and to have a set of solutions that makes processing your data easy. DTM SQL editor gives database us ... |
|
| DTM soft | 1380KB | Win 98/ME/2000/XP | $125 | Downloads: 1265 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » EMS MySQL Manager 3.4
|
| EMS MySQL Manager is a powerful tool for MySQL Database Server administration and development. MySQL Manager works with any MySQL versions from 3.23 to 5 and supports all of the latest MySQL features including views, stored procedures and functions, InnoD ... |
|
| EMS Software Development | 13885KB | Win 95/98/ME/NT/2000/XP | $135.00 | Downloads: 1196 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » EMS MySQL Manager Professional for Windows 3.4
|
| EMS MySQL Manager is a powerful tool for MySQL Database Server administration and development. MySQL Manager works with any MySQL versions from 3.23 to 5 and supports all of the latest MySQL features including views, stored procedures and functions, InnoD ... |
|
| EMS Software Development | 13885KB | Win 95/98/ME/NT/2000/XP | $135.00 | Downloads: 1169 |
| Date added: Sep 22, 2005 |
» Details |
|
|
|
|
| |
