In this tutorial we will explain how to install LiteCart on an Ubuntu 14.04 VPS with Nginx, PHP-FPM and MySQL. LiteCart is a free e-commerce, feature rich e-commerce solution. The framework is constructed to be lightweight and easy for developers to modify and build upon. LiteCart relies on the latest HyperText standard HTML 5, the latest CSS 3 for styling, the jQuery framework for client-side dynamics, and the popular web scripting language PHP for server-side dynamics. REQUIREMENTS We will be using our SSD 1 Linux VPS Hosting plan for this tutorial. UPDATE THE SYSTEM Make sure your server is fully […]

In a previous post I took the new JSON datatype and functions for a test drive, using sample data provided by SF OpenData. Today I will extend that example to include indexing.

Introducing Generated Columns

MySQL 5.7 introduces a new feature called generated columns.…

In this post i show you how to use autocomplete with multiple select option by jquery I think you will did autocomplete for single option using jquery ui plugin but in this post you can learn multi selection autocomplete using jquery ui In bellow preview you can see how will output of your multis

In this tutorials we have learn how to configer a Elastic search in our local systemfollow this step and easily configer an Elastic Searchstrong classstep1 Step 1 Installing Java strongBefore installing OpenJDK with APT update the list of available packages for installation on y

One of GitHub’s niche features is the ability to access a Git repository on GitHub using Subversion clients. Last year we re-architected a large portion of the Subversion bridge to work with our changing infrastructure.

The Problem

A key part of the Subversion bridge is a mapping between Git commits and Subversion revision numbers. The mapping is persisted so that we can produce a consistent view of the repository. A bit of the mapping is exposed via a custom SVN property, git-commit. For example, you can see that revision 2504 of phantomjs is an SVN representation of Git commit 2837f28.

$ svn propget --revprop -r 2504 git-commit https://github.com/ariya/phantomjs
2837f28c739f823f2eff061c8e41cf47654b8016

During the initial development of the Subversion bridge, we chose to store the mapping …

In this blog post, we’ll discuss JSON document fast lookup with MySQL 5.7.

Recently I attended Morgan Tocker’s talk on MySQL 5.7 and JSON at FOSDEM, and I found it awesome.

I learned some great information from the talk. Let me share one of them here: a very useful trick if you plan to store JSON documents in your MySQL database and want to retrieve the documents from some attribute’s values. So let’s look at how to do JSON document fast lookup with MySQL 5.7!

In this short example, I show you how we can speed up this type of search using JSON functions and virtual columns.

This our test table:

Table: test_features
Create Table: CREATE TABLE …

TL;DR summary: sysbench development has slowed down over the last years, resulting in users looking for workarounds for missing features and limitations. However, things are going to change with more active development and many features and fixes planned for the next version. This is the first post in a series to describe all those improvements.

sysbench started as an ad-hoc project inside the High Performance team in MySQL AB. In fact, the very first version was a single large C source file Peter Zaitsev sent me when I had to look into a Linux kernel 2.6 regression (TODO: find that email for my memoirs when I retire).

The original version didn't have all the features I needed for that task, so I started hacking on it, adding the missing bits and refactoring the code to simplify adding new features. …

TL;DR summary: sysbench development has slowed down over the last years, resulting in users looking for workarounds for missing features and limitations. However, things are going to change with more active development and many features and fixes planned for the next version. This is the first post in a series to describe all those improvements.

sysbench started as an ad-hoc project inside the High Performance team in MySQL AB. In fact, the very first version was a single large C source file Peter Zaitsev sent me when I had to look into a Linux kernel 2.6 regression (TODO: find that email for my memoirs when I retire).

The original version didn't have all the features I needed for that task, so I started hacking on it, adding the missing bits and refactoring the code to simplify adding new features. …

TL;DR summary: sysbench development has slowed down over the last years, resulting in users looking for workarounds for missing features and limitations. However, things are going to change with more active development and many features and fixes planned for the next version. This is the first post in a series to describe all those improvements.

sysbench started as an ad-hoc project inside the High Performance team in MySQL AB. In fact, the very first version was a single large C source file Peter Zaitsev sent me when I had to look into a Linux kernel 2.6 regression (TODO: find that email for my memoirs when I retire).

The original version didn't have all the features I needed for that task, so I started hacking on it, adding the missing bits and refactoring the code to simplify adding new features. …

If you read my last In Brief post, you may have tried setting up a cron job to run mysqldump nightly, gone back to check the results the following day and found a zero byte file where you expected to see a dumpfile.

-rw-rw-r--  1 forge forge    0 Mar  5 00:00 dump-nightly.sql

Don't worry! The backup still ran, but Forge does some auto-magic output redirection that had me guessing for a little while.

The Magic Of 2>&1

When I saw that my sql file was zero-length, I started trying to track down what went wrong. First stop was Forge's log file for the job in the web console. Viewing this showed that mysqldump had run just fine.

-- MySQL dump 10.13  Distrib 5.7.10, for Linux (x86_64)
--
-- Host: localhost    Database: 
-- …