Archivio tag: mysql

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.

Bookmarks for 25 set 2012 through 26 set 2012

These are my links for 25 set 2012 through 26 set 2012:

  • Magento – Optimizing MySQL for Magento (getting better performance) – General Forum – eCommerce Software for Growth – This is more a tips & tricks post based on our recent experiences on www.shoebacca.com

    (original post 2008, updated until 2010)

  • pfSense – Squid + Squidguard / Traffic Shapping Tutorial | HowtoForge – Linux Howtos and Tutorials – In this tutorial I will show you how to setup pfSense 2.0.1 up as a Internet Gateway with Squid Proxy / Squidguard Filtering. I will also show you have to configure some extra features of pfSense like and traffic shapping with squid. This type of configuration would be useful for people who want to set up wireless hot spots or Internet cafe's etc.
  • 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.

Bookmarks for 31 lug 2012 through 2 ago 2012

These are my links for 31 lug 2012 through 2 ago 2012:

  • Magento optimization Howto – Welcome to this Magento hardcore performance howto, I hope it will be useful.
  • 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[…]
  • Do you have any tips for making WorldClient run faster? – Question:

    Do you have any tips for making WorldClient run faster?

  • 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…