jjj

Tune MySQL using MySQLTuner

Every once in a while you see your MySQL showing increased memory footprint. You want to optimize MySQL but you do not know where to start from as first you need to know what all you should be tuning. This where MySQLTuner script can help you. As it’s README says: “_MySQLTuner is a script written…

Read More
jjj

Install Apache Solr on Ubuntu with MySQL Data Import

Apache Solr is an open source enterprise Search platform built in Java. Solr is written in Java and runs as a standalone full-text search server within a Servlet container such as Tomcat. Solr uses the Lucene Java search library at its core for full-text indexing and searching. This article lists all the steps that you…

Read More
jjj

MySQL GROUP_CONCAT function

Lets say there is a table named fictional_characters, that looks like: id          id_novel               character_name 1          1100                        Harry 2          1100                      …

Read More