How to filter MySQL slow queries using pt-query-digest
Kedar
The pt-query-digest is my go-to tool in order to perform slow query analysis, improve query performance and thus overall MySQL performance. In this blog post, I’m going to highlight the…
Browsing Tag
Database
4 posts
Java termwork connect Access Database and operations
Prologue: Long back there were golden days of post graduation in the “great” DDIT (Now Dharamsinh Desai University), Nadiad. Assignments, termwork and journals or everything similar was in demand –…
Steps to Move Copy Rename MySQL Database
Moving, copying or renaming database is a very basic activity. I have just noted a few commands for reference to quickly follow the required operation. 1. Rename database on Linux…
In the world of NoSQL-Hands on Mongodb-1
I’m hearing a lot of “NoSQL” these days. To really understand how (and) does it works, I decided to give a try on MongoDB. MongoDB (hu*mongo*us) is an open source,…
2 responses to “In the world of NoSQL-Hands on Mongodb-1”
I learnt atleast what the hack MongoDB is!
Nice writings. Keep posting more technical articles..
Phpmoadmin not working for me
I tried a lot but Phpmoadmin was not working for me. My problem was as follows:
I have wamp – c:\wamp
I’ve installed mongodb – c:\mongodb\…
Installed mongodb as a windows service
Set environment variable Path
Installed Microsoft Visual C++ 2008 SP1 Redistributable Package (x86)
so the php_mongo extension is now visible-enable in php extensions.
Updated php.ini and restarted wamp
Things looks fine here.
Further I copied phpmoadmin.php to wamp\www\MongoAdmin\phpmoadmin.php
I’m still receiving error “PHP cannot access MongoDB, you need to
install the Mongo extension for PHP. Instructions and driver download: vork.us/go/tv27”
The error in log:
PHP Warning: PHP Startup: mongo: Unable to initialize module
Module compiled with module API=20090626, debug=0, thread-safety=1
PHP compiled with module API=20060613, debug=0, thread-safety=1
These options need to match
in Unknown on line 0
PHP Installed Extensions:
Array ( [0] => bcmath [1] => calendar [2] => com_dotnet [3] => ctype
[4] => session [5] => filter [6] => ftp [7] => hash [8] => iconv [9]
=> json [10] => odbc [11] => pcre [12] => Reflection [13] => date [14]
=> libxml [15] => standard [16] => tokenizer [17] => zlib [18] =>
SimpleXML [19] => dom [20] => SPL [21] => wddx [22] => xml [23] =>
xmlreader [24] => xmlwriter [25] => apache2handler [26] => gd [27] =>
mbstring [28] => mysql [29] => mysqli [30] => PDO [31] => pdo_mysql
[32] => pdo_sqlite )
The solution to PHPMoAdmin Not working
Kristina Chodorow spot the correct problem:
Module compiled with module API=20090626, debug=0, thread-safety=1
means you’re using a module compiled with the 5.3 API.
The only 5.2 PHP driver binaries are built with VC6 and it looks like you’re
running VC8 (you can check in phpinfo(), search for “VC”). It would be
fairly easy to setup an automatic build for 5.2+VC8, but I can’t until
Monday.
The compiled version for 5.2 PHP driver built in VC6 is available here:
http://downloads.mongodb.org/mongo-latest-php5.2vc6ts.zip
See:- groups.google.com/group/mongodb-user/browse_thread/thread/8e0e65dd62c60422/68d6a3b717724dfb#68d6a3b717724dfb