Skip to main content

Profiling Slow Query in Mongodb

To monitor slow queries which are run in a mongodb database, profile attribute need to be set. There are three profiling levels: 0, 1 and 2. Add the following line into mongo.conf:
profile=1
Value 0 disables profiling. Value 1 enables the system to detect and record slow queries which take more time than given threshold value. If the attribute is set to 2, information of all queries are recorded. 

To monitor whole database, mongo.conf file could be edited. Set profile attribute to 1 or 2 and then restart mongod service :
>sudo service mongod restart.
From now on, profiling is enabled. Slow query profiling data of each database will be stored in the collection named db.system.profile.

If you don't want to monitor all databases but some, profiling level could be set for only these ones.
Select the database:
>use mydb
Set profiling level:
>db.setProfilingLevel(1)
{ "was" : 0, "slowms" : 100, "ok" : 1 }
Slowms key refers to lower time threshold value which is 100 ms as default. It could be set by giving parameter to setProflingLevel function:
>db.setProfilingLevel(1, 200)
{ "was" : 1, "slowms" : 100, "ok" : 1 }
Now, the threshold is set to 200 ms.

To clear system.profile collection, profiling needs to be stopped. Just set the level to 0. Then, call db.system.profile.remove(). Now, the collection is empty and profiling could be restarted.
Labels:
Location: Turkey

Comments

Post a Comment

Popular posts from this blog

Migration from Proxmox to Openstack

I needed to migrate virtual machines in proxmox to openstack. VMs are in raw format. I needed to take some actions for a succesfull migration. I have perform all actions on Ubuntu 12.04 with virt-manager. qemu-kvm is installed. Here is the list of actions that I took: First, close the machine and copy the image file into your Ubuntu. Convert raw image to qcow2 format: qemu-img convert -O qcow2 image1.raw image1.qcow2 You need the image in qcow2 format for compatibility with openstack platform.  Open the converted image in virt-manager. Before opening, edit disk options. Under ' advanced options ' section, select ' qcow2 ' as ' storage forma t '. Start the virtual machine. You should see the login screen soon. (If you don't set storage format, vm will not find a bootable device. )   If everything is ok so far, close the vm. Take qcow2 image and upload it into glance. It may take time depending on size of it. After this process is completed, open a
Post a Comment
Read more

Integration of MuPDF Project as a Library into an Android Studio Project

I have needed to use MuPDF library in my android project. After some research, I have seen that there are many integration tutorials but, but integrated projects are developed on Eclipse. For projects on AndroidStudio+Gradle, there is no example. I mean there is no specific example which exactly refers to this issue. So, after achieving my goal, I want to share the steps publicly so that it can be reused by others.
27 comments
Read more

Xposed - How to hook a method with primitive-type parameter

Xposed Framework is a great tool to take actions which Android SDK doesn't provide for developers. One of the great hacks that you can do is hooking a method. You can see parameters given to a method, with many other properties of it. There are some tutorials on Internet, but in this tutorials, they show hooking method without parameters or with class parameters. Its code is: findAndHookMethod("com.android.settings.Settings", lpparam.classLoader, "updateHeaderList", List.class, new XC_MethodHook() { @Override protected void beforeHookedMethod(MethodHookParam param) throws Throwable { //your code } });
6 comments
Read more