anshumgupta.net
Anshum's Blog: Information Retrieval and all things related: September 2009
http://www.anshumgupta.net/2009_09_01_archive.html
Anshum's Blog: Information Retrieval and all things related. Primarily stuff related to Search Engines. Apache Solr/Lucene and more. Monday, September 7, 2009. Lucid Gaze - Tough Nut! One Stop Solution to a lot of statistical analysis for lucene internals is the all new lucid gaze for Lucene. Perhaps it has been around for a while for Solar and I'm left to wonder. dude.where's the documentation? Lucene core jar from Lucid imagination [ Here. RamUsageEstimator estimator = new RamUsageEstimator();. The fol...
ventcafe.blogspot.com
Vent Cafe: When relatives try to make a fool out of me
http://ventcafe.blogspot.com/2006/07/when-relatives-try-to-make-fool-out-of.html
Write me your vent or repent at bridalbeer at yahoo.com. I will post it. Others will comment. Saturday, July 08, 2006. When relatives try to make a fool out of me. I hate it when people fight over small things.When relatives try to make a fool out of me. What do you get out of a fight except bitterness and broken relations. Can't people be understanding, giving and caring. You can comment on this. Http:/ jayant7k.blogspot.com. Note: Jayant is a software engineer based in Delhi. He's 26.
mysqldbadmin.blogspot.com
mysql administration: June 2010
http://mysqldbadmin.blogspot.com/2010_06_01_archive.html
Wednesday, June 30, 2010. Mysql hack - altering huge tables. You have a huge mysql table - maybe 100 GB. And you need to run alter on it - to either add an index, drop an index, add a column or drop a column. If you run the simple mysql "alter table" command, you will end up spending ages to bring the table back into production. Here i have created a simple table to show this hack process. You can assume that this table has billions of rows and is more than 100GB in size. CREATE TABLE `testhack` (. Mysql...
mysqldbadmin.blogspot.com
mysql administration: May 2010
http://mysqldbadmin.blogspot.com/2010_05_01_archive.html
Monday, May 31, 2010. Great tip for Windows users – Uninstall Programs from Command Line. Below is some information on how to use WMIC. Open the command prompt. Input WMIC and press Enter. You should see something like wmic:root cli. Type in the following command and press enter: product get name. To uninstall a program type: product where name=”Your program name” call uninstall. When you are prompted type y to confirm the uninstall and press Enter. Thursday, May 20, 2010. Mastering the art of indexing.
mysqldbadmin.blogspot.com
mysql administration: November 2011
http://mysqldbadmin.blogspot.com/2011_11_01_archive.html
Friday, November 18, 2011. Drop all tables in one command. Drop all tables in one shot:. Mysql - user=xxxx - password=xxxx -BNe "show tables" database name tr ' n' ',' sed -e 's/,$/ ' awk '{print "SET FOREIGN KEY CHECKS = 0;DROP TABLE IF EXISTS " $1 ";SET FOREIGN KEY CHECKS = 1;"}' mysql - user=xxxx - password=xxxx database name. Subscribe to: Posts (Atom). Percona Live Europe featured talk with Alexander Krasheninnikov — Processing 11 billion events a day with Spark in Badoo. Scaling up your MySQL server.
mysqldbadmin.blogspot.com
mysql administration: September 2010
http://mysqldbadmin.blogspot.com/2010_09_01_archive.html
Saturday, September 11, 2010. Change PuTTYs Default Scrollback Values. 1 Go to Run (Win R), type regedit. 2 In the registry editor, press Ctrl F. To bring up the search box and search for SimonTatham. 3 Expand the result SimonTatham PuTTY Sessions. 4 Select a session for which scrollback value need to be changed. Scroll down on the right pane until you find the value ScrollbackLines. 5 Double click on ScrollbackLines. 6 Press OK and you are done. Launch PuTTY and observe the default settings.
mysqldbadmin.blogspot.com
mysql administration: December 2009
http://mysqldbadmin.blogspot.com/2009_12_01_archive.html
Wednesday, December 23, 2009. Extracting a single table from a huge mysqldump file. Someday you may find yourself in a situation where you want to restore a single table of your MySQL database. Hopefully this is in a lab situation or on a personal development box somewhere – but even if it is production you need not fear. There are plenty of articles about. Restoring your entire database. First, you have to know where in your mysqldump output you want to begin your extraction, and where you want to end i...
mysqldbadmin.blogspot.com
mysql administration: Drop all tables in one command
http://mysqldbadmin.blogspot.com/2011/11/drop-all-tables-in-one-command.html
Friday, November 18, 2011. Drop all tables in one command. Drop all tables in one shot:. Mysql - user=xxxx - password=xxxx -BNe "show tables" database name tr ' n' ',' sed -e 's/,$/ ' awk '{print "SET FOREIGN KEY CHECKS = 0;DROP TABLE IF EXISTS " $1 ";SET FOREIGN KEY CHECKS = 1;"}' mysql - user=xxxx - password=xxxx database name. Subscribe to: Post Comments (Atom). Percona Live Europe featured talk with Alexander Krasheninnikov — Processing 11 billion events a day with Spark in Badoo.
SOCIAL ENGAGEMENT