?
Solved

run mysql log on wamp

Posted on 2013-02-03
10
Medium Priority
?
351 Views
Last Modified: 2013-02-13
followup to question:

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

how can i run this software on wamp
0
Comment
Question by:rgb192
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
  • 2
10 Comments
 
LVL 79

Expert Comment

by:arnold
ID: 38849378
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
 
LVL 24

Expert Comment

by:johanntagle
ID: 38850013
@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
 
LVL 79

Expert Comment

by:arnold
ID: 38850023
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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
LVL 24

Expert Comment

by:johanntagle
ID: 38850026
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
 
LVL 79

Expert Comment

by:arnold
ID: 38850040
http://www.activestate.com/activeperl

The version comes as an MSI package and includes DBI, DBD, Mysql modules.
0
 

Author Comment

by:rgb192
ID: 38851495
>>(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
 
LVL 79

Expert Comment

by:arnold
ID: 38851852
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
 
LVL 24

Expert Comment

by:johanntagle
ID: 38852103
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
 
LVL 24

Accepted Solution

by:
johanntagle earned 2000 total points
ID: 38866688
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
 

Author Closing Comment

by:rgb192
ID: 38885364
thanks

almost worked

this is the new question:

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

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question