Archivio tag: mysql

Bookmarks for 2 nov 2012 from 15:23 to 18:09

These are my links for 2 nov 2012 from 15:23 to 18:09:

  • USEFUL ONE-LINE SCRIPTS FOR SED – (Unix stream editor) Dec. 29, 2005
    Compiled by Eric Pement – pemente[at]northpark[dot]edu version 5.5
  • IBM devscan tool – United States – The devscan tool is a supplemental tool used by AIX support personnel to gather debugging data for Storage Area Networks. The package download includes a manual page that is also available on this site at the Usage tab.
  • mysqlreport :: Make easy-to-read MySQL status reports – mysqlreport makes a friendly report of important MySQL status values. mysqlreport transforms the values from SHOW STATUS into an easy-to-read report that provides an in-depth understanding of how well MySQL is running. mysqlreport is a better alternative (and practically the only alternative) to manually interpreting SHOW STATUS.
  • Percona Online Tools – Welcome to Percona's suite of productivity tools for MySQL database administrators and developers. One free account lets you access all of the tools below, and keeps you updated when new tools or enhancements are available. Registration is required.

    Optimize your MySQL Server:
    Leverage our expertise to create a good starting configuration for a MySQL server.
    This tool will walk you through all of the steps necessary to create a ready to use MySQL configuration file in about 5 minutes.

    Analyze an SQL Query:
    Find out when your SQL is potentially buggy, hard for MySQL to optimize, or confusing.
    This tool will analyze your SQL code and warn you when it detects problems that we've encountered while optimizing thousands of queries in real applications.

Bookmarks for 2 nov 2012 from 11:31 to 12:17

These are my links for 2 nov 2012 from 11:31 to 12:17:

Bookmarks for 10 ott 2012 from 00:36 to 00:57

These are my links for 10 ott 2012 from 00:36 to 00:57:

  • miracle2k/emma · GitHub – Emma is a graphical toolkit for MySQL database developers and administrators. It provides dialogs to create or modify MySQL databases, tables, and associated indexes. The results of an executed query are displayed in a resultset where the record data can be edited by the user, if the SQL statemant allows for it. The SQL editor and resultset view are grouped in tabs. Results can be exported to CSV files. Multiple simultaneous opened MySQL connections are possible. Emma is the successor of yamysqlfront.
  • The NanoURL Project | Free Communications software downloads at SourceForge.net – The nanoURL project is essentially a script similar to the one used at tinyurl.com, which takes long URLs and turns them into shorter and more easily-remembered URLs. Web administration interface and installer included!
  • RT: Request Tracker – Best Practical – RT is a battle-tested issue tracking system which thousands of organizations use for bug tracking, help desk ticketing, customer service, workflow processes, change management, network operations, youth counselling and even more. Organizations around the world have been running smoothly thanks to RT for over 10 years.

    RT 4.0 is a major update. It's chock full of new features, enhancements and bug fixes. Don't miss our What's New in 4 series.

    There's no need to wait for a quote or for a sales person to send you a demo. The full, enterprise-ready version of RT is always available at absolutely no cost under an open source license. That means it's yours to use and customize however you'd like. We built RT from the ground up to be easy to adapt to your organization and your needs.

  • Zentyal Linux small business server | Free System Administration software downloads at SourceForge.net – Zentyal is an open source alternative to Windows Small Business Server
  • Resara Server | Free Communications software downloads at SourceForge.net – An easy-to-use, AD compatible Linux domain controller and file server

Bookmarks for 26 set 2012 from 17:24 to 17:48

These are my links for 26 set 2012 from 17:24 to 17:48:

  • Optimizing Magento Performance – Tutorials – Magebase – Performance optimization is a good way out in such situation. Optimizing a website, you should consider providing two factors:

    acceptable pages loading speed;
    acceptable pages loading speed when N people use the same application simultaneously.

  • Magento and Nginx Performance Tuning Services – Magento and Nginx Performance Tuning Services
  • Optimize MySQL settings for Magento database – The Tuning Primer is a shell script that allows you to review the MySQL settings and make adjustments to increase Magento database performance and stability. The script will analyze MySQL statistics and provide you with recommendations on how to fine-tune your MySQL server.

    The uptime of your MySQL should be more than 48 hours for correct script work. Only in this case there will be enough information for analysis. Tuning Primer script is compatible with all versions of MySQL starting from 3.23.