simpatico, quanto un dito nel culo

Archivio tag: mysql

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.

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.

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.

Speeding up Magento with APC or Memcached – Tutorials – Magebase – We often hear complaints about how Magento is slow and performs poorly. Developers know, however, that performance is relative and that we can do a number of things to speed up a Magento site. This article will focus on configuring and using APC and/or Memcached. We have a resources section at the end of this article with links to more performance optimization techniques.

The options obviously also depend on the specific hosting arrangement. I will assume for the purposes of this article, that you have control over your hosting server and are able to install the necessary add-ons and make configuration changes to Apache and PHP. If you are on a shared environment, you may have to check with your hosting support if you can apply the tips from this article. But, you know that you should at least be on a VPS if you are running Magento.

Speed up Magento with simple config tweaks – At Ionata we’ve been using Magento for quite a while now and the more sites we added, the slower our server seemed to become. Magento is quite a big chunk of software and can take up a lot of resources. However after doing some research and carefully tweaking our server configurations, we were pretty amazed to find performance gains of several hundred percent only by changing some settings.

In this post you’ll find a summary of settings that can boost the speed and responsiveness of your Magento installation. Optimisation can be done for PHP, MySQL, Apache and Magento itself.

Apache 2 Basic Configuration on Unix-Like Systems | Nettuts+ – The Apache server is a service that runs in the background, waiting for requests from clients connecting to the ports it listens to, in order to take action. Apache either responds to those requests, or leaves related notes in its log files. Its behavior is controlled through its configuration, using what is known as directives (among other things). We’ll discuss the most basic directives in this article.

Nginx+PHP(FPM)+MySQL+Memcache+eAccelerator on Debian6 | Qi Yang – I recently rebuild my linux image on Linode, so I have to reinstall the LEMP stack again from ground. Last time was probably more than a year ago, with the help of many tutorials from google. So this time I decide to write what I did step by step for my reference in the future […]

Magento caching, APC, eAccelerator Memcached, files, sqlite, Vanish, what’s the … happen? | Alex Paradise – Magento is slow! It’s how start most of the article about Magento cache optimization. Yes, Magento is slow and this because of the way the code is written, extreme object oriented. Stackoverflow say “It is written in an Enterprise Java idiom” and there are right. Anyway, we can’t change anything about it and in one side that let us lot of flexibility.
So, Magento IS SLOW! And what’s can we do? There is many thing to do, many, many. But the most important one is to work around the cache. I am searching for a cache solution and found so much different stuff like APC, eAccelerator, memcached, tmpfs, varnich, lighthttpd, nginx and so on… I will try to explain the different possibilities if found while my research and finished by the one I will implement[…]

MySQL-Galera cluster with HAproxy – Sébastien han – When I started working on Open Stack, I had to investigate about the HA of the nova component. Unfortunatly the nova configuration needed a single entry point to connect to the MySQL database. The solution that came to me was to use HAProxy on top of my existing Galera cluster…