• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 368
  • Last Modified:

run mysql log on wamp

followup to question:

http://www.experts-exchange.com/Database/MySQL/Q_28016743.html

how can i run this software on wamp
0
rgb192
Asked:
rgb192
  • 4
  • 4
  • 2
1 Solution
 
arnoldCommented:
What issue are you having?
Mysql running on Linux, unix, windows, Mac accept and responds to the same queries in the same way.
Similarly for apach, php.

Trying to follow back your chain of question/answers not clear which software you are talking about.
0
 
johanntagleCommented:
@arnold - He's talking about the tool I made:

https://github.com/johanntagle/modified_query_profiler

It's written in Perl and since I've never used Perl on Windows, I don't know if it will work there.

@rgb192 I suggest you just copy your slow query log to your hosted server, and also install my tool there (just click on the "zip" button on the page referred to above to download it then extract to the server).  Create the tables using, create_tables.sql, update line #5 of the query_profiler.pl, then run query_profiler.pl.  This of course assumes your host has the needed perl libraries (DBD::MySQL, DBI).  You don't need to run the last step (profile_queries.sql), just take a look at the populated tables for the queries you want.
0
 
arnoldCommented:
Windows has/often uses activeperl
Most things written in Perl can be run on windows.
Phpmyadmin is another option if not suggested in prior comments.
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
johanntagleCommented:
If that's the case assuming activeperl and the needed libraries are installed the same instructions apply.

@arnold - maybe you can point rgb192 to instructions re installing and using activeperl
0
 
arnoldCommented:
http://www.activestate.com/activeperl

The version comes as an MSI package and includes DBI, DBD, Mysql modules.
0
 
rgb192Author Commented:
>>(just click on the "zip" button on the page referred to above to download it then extract to the server

I may be able to install on the server,
but my shared hosting lamp does not allow logging mysql commands


http://www.activestate.com/activeperl/downloads

can this work for wamp

I cant get xampp working on my computer (unless I remove wamp -- which would take hours of troubleshooting to remove and bring back)
0
 
arnoldCommented:
You have all you need installed.
Install perl from activeperl.
or http://strawberryperl.com/ 
Most open source tools can be obtain individually.
Presumably the XAMMP console can only be obtained from xammp

Only you can answer the question whether it is worth while to spend some time uninstalling what you currently have in favor of something new.

Does your hosted lamp provide access to phpmyadmin?  Does that reference some suggestions?
Installing activeperl or the other perl option.
You can use johanntagle tools on your local WAMP setup
presumably your local setup includes all the data that exists on your hosted setup
with http://jmeter.apache.org/ this way you can mimic the access to your hosted site using your local data and local resources.

Presumably that is your goal:
Optimize the responsiveness of the database to queries while minimize impact on system resources.

You might want to use jmeter during offhours to baseline your hosted environment.
0
 
johanntagleCommented:
i may be able to install on the server,
but my shared hosting lamp does not allow logging mysql commands

That's why I said "just copy your (local) slow query log to your hosted server"
0
 
johanntagleCommented:
Hi I learned about configuring mysql to do the slow query logging straight to a database table and posted an update to your other question here:

http://www.experts-exchange.com/Database/MySQL/Q_28016743.html#a38866685

So no more need to use my tool, at least for what you originally wanted to do (see which statements were run by an application)
0
 
rgb192Author Commented:
thanks

almost worked

this is the new question:

http://www.experts-exchange.com/Database/MySQL/Q_28030458.html
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now