macbre

#!/bin/bash
APP_DIR=$HOME/Wikia/git/app
I18N_FILE=$1

STRINGS=`./get_msg_keys.php ${I18N_FILE}`
STRINGS_COUNT=`./get_msg_keys.php ${I18N_FILE} | wc -l`

echo "Checking i18n strings in $I18N_FILE ($STRINGS_COUNT strings in English)..."

NOT_USED=0

macbre

sudo echo 'ATTR{idVendor}=="12d1", ATTR{idProduct}=="1037", SYMLINK+="libmtp-%k", MODE="660", GROUP="disk", ENV{ID_MTP_DEVICE}="1", ENV{ID_MEDIA_PLAYER}="1"' >> /etc/udev/rules.d/69-libmtp.rules
sudo apt-get install mtp-tools jmtpf

macbre

sudo echo 'ATTR{idVendor}=="12d1", ATTR{idProduct}=="1037", SYMLINK+="libmtp-%k", MODE="660", GROUP="disk", ENV{ID_MTP_DEVICE}="1", ENV{ID_MEDIA_PLAYER}="1"' >> /etc/udev/rules.d/51-android.rules
sudo apt-get install mtp-tools jmtpf gmtp

macbre

• http://www.dell.com/support/home/pl/pl/pldhs1/product-support/product/latitude-14-7480-laptop/configuration
• https://certification.ubuntu.com/hardware/201610-25180/

Processor	
Intel Intel(R) Core(TM) i7-7600U CPU @ 2.80GHz
Video	
Intel Unknown
Ethernet	
Intel Ethernet Connection (4) I219-LM

macbre

# elecena.pl
# Log entries analized: 1227179
mysql:shops	_select	mq/request.php	0.0166	QPS: 0.1205
mysql:products	run	ShopsUpdateScript	0.0065	QPS: 0.0476
sphinx:parameters	newFromCode	Parameters	0.0788	QPS: 0.5734
mysql:parameters	exists	Parameters	0.0221	QPS: 0.1608
sphinx:parameters	getSimilar	Parameters	0.0092	QPS: 0.0666
currency.php	_	mysql:currencies	0.0001	QPS: 0.0008
sphinx:products	getLastChanges	StatsController	0.0002	QPS: 0.0017
mysql:producers	_select	mq/request.php	0.0824	QPS: 0.5996

macbre

# Query digest for "image_review" table, found 7220 queries
dataware:image_review	getImageReviewFiles	UpdateImageReview	0.97	cron, median time: 38.70 ms, count: 322200
dataware:image_review	isTop200	UpdateImageReview	1.00	cron, median time: 18.00 ms, count: 333400
Wikia\Tasks\Tasks\ImageReviewTask	addToQueue	dataware:image_review	0.04	task, median time: 86.19 ms, count: 11900
dataware:image_review	isTop200	Wikia\Tasks\Tasks\ImageReviewTask	0.04	task, median time: 40.29 ms, count: 12700
UpdateImageReview	updateDatawareFile	dataware:image_review	0.05	cron, median time: 64.90 ms, count: 15600
dataware:image_review	selectImagesForList	ImageReviewDatabaseHelper	0.03	ap, median time: 57.70 ms, count: 9900
dataware:image_review	countImagesByState	ImageReviewDatabaseHelper	0.02	ap, median time: 48.80 ms, count: 5700
dataware:image_review	refetchImageListByTimestamp	ImageReviewHelper	0.01	ap, median time: 44.25 ms, count: 5000
ImageReviewHelper	updateImageState	dataware:image_review	0.01	ap, median time: 77.35 ms, cou

macbre

# Query digest for "/extensions/wikia/Forum" path, found 296763 queries
local:wall_related_pages	getArticlesRelatedMessgesIds	WallRelatedPages	0.49	ap, median time: 73.31 ms, count: 2613800
local:revision	fetchFromConds	Revision	1.00	ap, median time: 39.20 ms, count: 5368000
local:page	newFromID	Title	0.91	ap, median time: 30.49 ms, count: 4909900
local:wikicities_cN	idFromName	User	0.64	ap, median time: 28.99 ms, count: 3424800
local:revision	getFirstRevID	ArticleComment	0.58	ap, median time: 25.01 ms, count: 3113100
local:comments_index	getTotalThreads	Forum	0.00	ap, median time: 151.40 ms, count: 21500
local:comments_index	entriesFromIds	CommentsIndex	0.21	ap, median time: 41.70 ms, count: 1136400
local:page	newFromIDs	Title	0.21	ap, median time: 35.60 ms, count: 1135400
local:comments_index	getThreads	Wall	0.05	ap, median time: 35.69 ms, count: 262100

macbre

# Query digest for "events_local_users" table, found 1995 queries
backend:events_local_users.pl	events_local_users.pl:651 (INSERT)	specials:events_local_users	0.98	job, median time: 1107.85 ms, count: 93800
backend:events_local_users.pl	events_local_users.pl:646 (DELETE)	specials:events_local_users	1.00	job, median time: 731.80 ms, count: 95500
backend:events_local_users.pl	events_local_users.pl:699 (DELETE)	specials:events_local_users	0.01	job, median time: 1072.79 ms, count: 900
specials:events_local_users	getUsersForGroup	WikiaApiQueryAllUsers	0.01	ap, median time: 211.94 ms, count: 1400
specials:events_local_users	getTopEditors	WikiService	0.02	ap, median time: 144.91 ms, count: 1500
specials:events_local_users	events_local_users.pl:223 (SELECT)	backend:events_local_users.pl	0.03	job, median time: 55.10 ms, count: 3300
backend:events_local_users.pl	events_local_users.pl:646 (DELETE)	specials:events_local_users	0.00	task, median time: 652.29 ms, count: 100
specials:events_local_users	getTopWikisFromDb	Favo

macbre

#!/bin/bash
WIKICITIES_PARAMS=`dbparams.pl --name wikicities`

for VAR_NAME in `mysql $WIKICITIES_PARAMS --batch --disable-column-names -e 'select cv_name from city_variables_pool'`
do
	# echo "Checking ${VAR_NAME}.."

	# check the usage in the config
	# WIKIA_CONFIG_ROOT=/usr/wikia/slot1/current/config
	COUNT=`ack-grep --no-filename -i --php "$VAR_NAME" $WIKIA_CONFIG_ROOT -c`

macbre

env/
*.swp