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.

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…

Bookmarks for 27 lug 2012 through 30 lug 2012

These are my links for 27 lug 2012 through 30 lug 2012:

  • Rex V: an AJAX Regular EXpression eValuator – – This site is a Regular Expression evaluator for several different regular expression systems:
    PHP PCRE
    PHP Posix
    Perl
    Python
    Javascript
    Node.JS
  • calligrafia.org » il sito dell’Associazione Calligrafica Italiana – […] Nel settembre 1991 a Milano, un gruppo di calligrafi fonda l'Associazione calligrafica Italiana. Da allora il programma dell'Associazione è cresciuto con successo anche grazie ai contatti mantenuti con altre associazioni calligrafiche all'estero (in Europa e in America) garantendo così scambi di informazioni e soprattutto la possibilità di avvalersi della collaborazione di insegnanti di riconosciuta competenza. In questi anni l'ACI ha sicuramente ottenuto successi e risultati. Oramai la calligrafia è praticata anche in Italia, sono state organizzate mostre e avviati contatti con biblioteche e scuole[…]
  • Rajiv’s blog – I was in charge of scaling Dropbox for a while, from roughly 4,000 to 40,000,000 users. For most of that time we had one to three people working on the backend. Here are some suggestions on scaling, particularly in a resource-constrained, fast-growing environment that can’t always afford to do things “the right way” (i.e., any real-world engineering project ;-). If people find this useful, I’ll try to come up with more tips and write a part 2.

Bookmarks for 25 lug 2012 from 14:52 to 15:47

These are my links for 25 lug 2012 from 14:52 to 15:47:

  • Disaster: LVM Performance in Snapshot Mode – MySQL Performance Blog – In many cases I speculate how things should work based on what they do and in number of cases this lead me forming too good impression about technology and when running in completely unanticipated bug or performance bottleneck. This is exactly the case with LVM
    Number of customers have reported the LVM gives very high penalty when snapshots are enabled (leave along if you try to run backup at this time) and so I decided to look into it.
  • Netexpertise » Mysql Ultra-Fast Backup with LVM – It is generally good practice to respect the two following points when backing up databases. The backup has to be:
    consistent
    fast
    Consistency is easily achieved putting a read lock on all tables beforehands. However, this isn’t always applied, and WILL definately lead to a database integrity problem at some stage.
    Once a lock has been set on the database, the backup has to be as quick as possible, all write instructions being held in the queue.
  • MIME and HTML in Email – How to encapsulate HTML in an email message and send via sendmail

Bookmarks for 24 lug 2012 from 17:16 to 17:32

These are my links for 24 lug 2012 from 17:16 to 17:32:

  • Five Tips for a Better sendmail Configuration – O’Reilly Media – Unix vendors bundle sendmail with the operating system and ship it out preconfigured. It is very easy to install the OS and use the sendmail configuration delivered with the system. Don't be fooled by this apparent simplicity. In the long run, it is better to take charge of your fate. Creating a custom sendmail configuration using current software and features selected for your environment will give you better performance, reliability, security, and maintainability. Here are some tips to get you started on building a better sendmail configuration.
  • Epoch Converter – Unix Timestamp Converter – Epoch & Unix Timestamp Conversion Tools
  • mylvmbackup – mylvmbackup is a tool for quickly creating backups of a MySQL server's data files. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, creates a snapshot of the volume containing the MySQL data directory, and unlocks the tables again. The snapshot process takes only a small amount of time. When it is done, the server can continue normal operations, while the actual file backup proceeds.

Bookmarks for 18 lug 2012 through 19 lug 2012

These are my links for 18 lug 2012 through 19 lug 2012:

  • Generate large amount of test data « my two cents – I’m using the dictionary on linux systems to generate test data. The shell script below generates test data for MySQL, but similar concepts can be used for other database systems as well.
  • JQueryin | Switching Apache from Prefork to Worker MPM in RHEL / CentOS 5.x / Fedora 13 – I’m going to outline the process of switching from Apache’s default installation of MPM Prefork to that of MPM Worker. I will also be covering the proper installation of FastCGI (mod_fcgid) to further improve your server performance. This guide is ideally intended for individuals running on low-memory VPS servers as memory consumption will likely be far lower with the Worker MPM because it spawns threads as opposed to forking child processes. If you’re intentionally reading this article, you’re probably aware of the performance benefits gained.
  • Free PDF Reader – Sumatra PDF – Sumatra PDF is a free PDF, eBook (ePub, Mobi), XPS, DjVu, CHM, Comic Book (CBZ and CBR) reader for Windows.

    Sumatra PDF is small, portable and starts up very fast.

    Simplicity of the user interface has a high priority.