RE: How to capture MySQL queries sent to server?

: RolandoLogicWorx redwa...@logicworks.net -Original Message- From: mos [mailto:mo...@fastmail.fm] Sent: Friday, May 15, 2009 6:09 PM To: mysql@lists.mysql.com Subject: How to capture MySQL queries sent to server? I'm running Windows XP and I'd like to capture the SQL commands that ar

How to capture MySQL queries sent to server?

I'm running Windows XP and I'd like to capture the SQL commands that are sent to the MySQL server. Is there a way to do this on Windows? TIA Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Sorting MySQL queries

On 2006-11-06 Dotan Cohen wrote: > > Make a second column that only contains > >ALTER TABLE table ADD cooked_subject; > >UPDATE table SET cooked_subject = ereg_replace('^(a|the) ', '', subject); > >(I don't know how the regular expression function was called exactly but > > you get t

Re: Sorting MySQL queries

On 06/11/06, Christian Hammers <[EMAIL PROTECTED]> wrote: On 2006-11-06 Dotan Cohen wrote: > I have a list of subjects, such as "Linux", "Open Source", and "the > World Wide Web". The subjects are stored in MySQL and being retrieved > via php. I currently organize them alphabetically with MySQL's

Re: Sorting MySQL queries

On 2006-11-06 Dotan Cohen wrote: > I have a list of subjects, such as "Linux", "Open Source", and "the > World Wide Web". The subjects are stored in MySQL and being retrieved > via php. I currently organize them alphabetically with MySQL's "ORDER > BY ASC" argument, however, if there is a precedi

Sorting MySQL queries

I have a list of subjects, such as "Linux", "Open Source", and "the World Wide Web". The subjects are stored in MySQL and being retrieved via php. I currently organize them alphabetically with MySQL's "ORDER BY ASC" argument, however, if there is a preceding "the " or "a " then that is considered

Re: MySQL Queries within Oscommerce

"AM COMS" <[EMAIL PROTECTED]> wrote on 02/22/2006 09:16:24 AM: > Has anyone here had any experience with Oscommerce? > > I am having problems with the style of queries they have used or am I just > seeing things the wrong way! > > andrew > Sorry! I have never used it. Shawn Green Database Ad

MySQL Queries within Oscommerce

Has anyone here had any experience with Oscommerce? I am having problems with the style of queries they have used or am I just seeing things the wrong way! andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROT

Re: bash powered MySQL Queries

On Mon, Jan 31, 2005 at 06:57:58PM +, Edward Macnaghten wrote: > 1 - The output is not cluttered with headers, and a means exist to > easily separate fields when there is more than one column or row in the > query. The mysql --batch option should take care of that for you. -Jason Martin --

Re: bash powered MySQL Queries

Thank you all for your replies. I think that ShellSQL is really the thing I am looking for. With kind regards Andy On Sun January 30 2005 23:50, Andy wrote: > Hi all > > I just wanted to know what would be the easiest way to retrieve simple data > from a MySQL database from a bash script. >

Re: bash powered MySQL Queries

Forgive me for blowing my own trumpet here. The advantage with ShellSQL over this method is 1 - The output is not cluttered with headers, and a means exist to easily separate fields when there is more than one column or row in the query. 2 - The connection is persistant, whereas running "mys

Re: bash powered MySQL Queries

On Sun, 30 Jan 2005, Andy wrote: > Hi all > > I just wanted to know what would be the easiest way to retrieve simple data > from a MySQL database from a bash script. I do this a lot - just construct the query and dump it into a file from within the script, eg: echo "select * from widgets

Re: bash powered MySQL Queries

>I just wanted to know what would be the easiest way to retrieve simple data >from a MySQL database from a bash script. Easiest way I've used to do it is: mysql

Re: bash powered MySQL Queries

Edward Macnaghten wrote: Funny you should mention that May I guide you to my recent announcment of ShellSQL 0.7 - web page at http://www.edlsystems.com/shellsql - a utility to do just as you want (I think) released under GPL. It must be good - I wrote it myself :-) SELECT * FROM /dev/zero IN

Re: bash powered MySQL Queries

Funny you should mention that May I guide you to my recent announcment of ShellSQL 0.7 - web page at http://www.edlsystems.com/shellsql - a utility to do just as you want (I think) released under GPL. It must be good - I wrote it myself :-) Yours Eddy Andy wrote: Hi all I just wanted to know

bash powered MySQL Queries

Hi all I just wanted to know what would be the easiest way to retrieve simple data from a MySQL database from a bash script. With kind regards Andy -- --- Registered Linux user number 379093 --- -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscri

Re: Hung MySQL queries

up - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php - Original Message - From: ""Joakim Ryden"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Thursday, December 02, 2004 8:35 AM Subject: Hung M

Hung MySQL queries

Hey everyone - I just migrated a database from one server to another (4.0.18 official RPM on RH ES 3) and now on the new server I'm running into a problem where queries hang in state "statistics" as shown by 'mysqladmin processlist'. I tried to see if there was something wrong with the queries the

RE: What's Faster? MySQL Queries or PHP Loops?

lto:[EMAIL PROTECTED] Sent: Friday, September 10, 2004 10:49 AM To: Peter Lovatt; Brent Baisley; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: What's Faster? MySQL Queries or PHP Loops? I've been meaning to follow up on this post. Can either Peter or someone expand and provide an

RE: What's Faster? MySQL Queries or PHP Loops?

K :) > > HTH > > Peter > > > > > -Original Message- > > From: Brent Baisley [mailto:[EMAIL PROTECTED] > > Sent: 08 September 2004 19:01 > > To: [EMAIL PROTECTED] > > Cc: [EMAIL PROTECTED] > > Subject: Re: What's Faster? MySQL

RE: What's Faster? MySQL Queries or PHP Loops?

t; > > -Original Message- > > From: Brent Baisley [mailto:[EMAIL PROTECTED] > > Sent: 08 September 2004 19:01 > > To: [EMAIL PROTECTED] > > Cc: [EMAIL PROTECTED] > > Subject: Re: What's Faster? MySQL Queries or PHP Loops? > > > > > > I

Re: What's Faster? MySQL Queries or PHP Loops?

I use foxpro to do similar loops I've found that I get 10 queries per second on large tables, when connecting once, and issuing individual select statements via odbc. It is much faster if you can narrow the recordset into an array within php, and spool through that, unfortunatly I deal with 250+

Re: What's Faster? MySQL Queries or PHP Loops?

I never thought of the return only the query"ing" part. My predicament is I have a search form that queries a table with about 7 joins. It returns it via a Dreamweaver recordset aka SQL query. So based on what you said below , regarding the number of users, this is a bad way to go. Stuart -

Re: What's Faster? MySQL Queries or PHP Loops?

The end result will be the same, it's just a matter of the structure the data will have when handed to PHP for processing to display. It can be retrieved bit by bit and broken up into multiple lists or joined and summarized by MySQL into one list. One list will make the PHP loop simpler, smalle

RE: What's Faster? MySQL Queries or PHP Loops?

ECTED] > Subject: Re: What's Faster? MySQL Queries or PHP Loops? > > > I would try not to query MySQL on each iteration of the loop. While a > dozen or so queries may not make a noticeable difference, hundreds or > thousands may. It's not a scalable technique, whether

Re: What's Faster? MySQL Queries or PHP Loops?

I'm confused about this response and am facing a similar situation. First, regarding the subject, what is the difference between a PHP or whatever loop and a SQL query. All the app code is doing is collecting the request and handing it back to the database. The DBMS still has to retrieve the da

Re: What's Faster? MySQL Queries or PHP Loops?

I would try not to query MySQL on each iteration of the loop. While a dozen or so queries may not make a noticeable difference, hundreds or thousands may. It's not a scalable technique, whether you need to scale it or not. Even if it's only 100 iterations, what if you have 10 people accessing t

Re: What's Faster? MySQL Queries or PHP Loops?

You're talking about a difference of milliseconds, tops. Use whatever solution gives you the cleaner, easiest-to-maintain code. Don't worry about a couple milliseconds. http://c2.com/cgi/wiki?PrematureOptimization -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

What's Faster? MySQL Queries or PHP Loops?

Here's the scenario... First, my HTTP Server (Apache), PHP Server and MySQL Server are on the same machine - an Apple Xserve. Second, I've got a page with a long repeat region reflecting a recordset queried out of a MySQL table. The region also displays information obtained from fields in a re

Re: Optimise two mysql queries to one query

dr zoidberg wrote: Hello, $a = mysql_query("Select a,b FROM t WHERE category=1") while($a) { $x = $a[a]; //some echo //another query $b = mysql_query("Select * FROM t WHERE subcategory=$x") while ($b) { //some echo } } Not tested and might need some tweaking in the where clause, but should be at

Optimise two mysql queries to one query

Hello, $a = mysql_query("Select a,b FROM t WHERE category=1") while($a) { $x = $a[a]; //some echo //another query $b = mysql_query("Select * FROM t WHERE subcategory=$x") while ($b) { //some echo } } Poent is thet I have menus, parents with childes (childes are not parents) and I want to display

MySQL queries proxy

Does anybody know the product able to serialize multiple similar queries coming from different sources to the one SQL server? Could be nice to have something as a SQL proxy with cashing pool, expiration, etc to put the main server load down and release his resources. Thanks in advance for an

RE: mysql queries with numbers

m: Taylor Lewick [mailto:[EMAIL PROTECTED] > Sent: Monday, July 28, 2003 6:00 PM > To: [EMAIL PROTECTED] > Subject: mysql queries with numbers > > > Question for everyone, I have a database with about 30-60 days > worth of information. Much of it numerical. > Can and should I

mysql queries with numbers

Question for everyone, I have a database with about 30-60 days worth of information. Much of it numerical. Can and should I use SQL to run quereis that will return me the high/low and average for the time frame, as well as standard deviation, or should I just get all of the info into an array vi

MySQL queries, dynamic???

Is there any way to dynamically create columns non programatically? As in pure sql queries? This is what I am doing now: SELECT SQL_BUFFER_RESULT ORDERHEADER.ID_CUSTOMER AS 'Acct #', CUSTOMER.Company AS 'Company', SALESLEVEL.Name AS 'Client Type', DATE_FORMAT(ORDERHEADER.AvailableAt, '%b') AS

MySQL Queries

Setup : MySQL 3.23.42 Perl 5.6.0 DBI 10.32 I’m trying to do a few different queries where the table name needs to be dynamic. I’ve tried the following : $dbquery = $dbhandler->prepare_cached(“SELECT id, target FROM ? where somedata=?”); $dbquery->execute($tablename,$somedata); But I keep gett

MySQL Queries

Setup : MySQL 3.23.42 Perl 5.6.0 DBI 10.32 I’m trying to do a few different queries where the table name needs to be dynamic. I’ve tried the following : $dbquery = $dbhandler->prepare_cached(“SELECT id, target FROM ? where somedata=?”); $dbquery->execute($tablename,$somedata); But I keep gett

Adding that MySQL queries stats stuff to the bottom of emails?

I'm always seeing stuff like: MySQL 3.23.41-max: up 9 days, processed 115,312,654 queries (140/sec. avg) On the bottom of emails. My question is HOW do you add this to emails? Thanks lots David Ayliffe ([EMAIL PROTECTED]) Running Windows 2000 Advanced Server (SP2) Also running Suse Linux 7.1

Re: are MySQL Queries limited to they ahdere to Ansi SQL?

On Saturday 18 August 2001 14:37, Darragh Duffy wrote: > > Hi Folks > > below is a seltion of queries all doing very similar things I have run all > on Oracle 7 and 8i and all work fine. but only number 2 works in MySQL. So > does this suggest that MySQL is not fully compliant with Ansi SQL? > >

are MySQL Queries limited to they ahdere to Ansi SQL?

Hi Folks below is a seltion of queries all doing very similar things I have run all on Oracle 7 and 8i and all work fine. but only number 2 works in MySQL. So does this suggest that MySQL is not fully compliant with Ansi SQL? The problem seems to lie in the fact that the embedded select does

Re: MySQL queries optimizations

On Sat, May 19, 2001 at 09:54:36PM +0200, Jocelyn Fournier wrote: > Hi, > > Assuming I have a INT type column named "numeropost", is this faster > to write a query with "WHERE numeropost=12" instead of "WHERE > numeropost='12'", or is this exactly the same speed ? It would take just 5 minutes to

MySQL queries optimizations

Hi, Assuming I have a INT type column named "numeropost", is this faster to write a query with "WHERE numeropost=12" instead of "WHERE numeropost='12'", or is this exactly the same speed ? Thanks ! Jocelyn Fournier Presence-PC www.presence-pc.com

RE: Stale mysql queries

; -Original Message- > From: Mattias Segerdahl [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 02, 2001 1:17 PM > To: Mysql > Subject: Stale mysql queries > > > Hi folks, > > I got a strange problem, we're running a webhosting company and > during peekhour

Stale mysql queries

Hi folks, I got a strange problem, we're running a webhosting company and during peekhours, mysql really hits the cpu peek. I do believe there is one or more clients that are running high loads of querys without actually closing them, or perhaps even running querys that dosn't timeout. Is there