Am 09.02.2010 16:27, schrieb andy knasinski:
I've used the general and slow query log in the past, but I am trying to
track down some queries from a compiled app that never seem to be
hitting the DB server.
My guess is that the SQL syntax is bad and never get executed, but I
don't see any relate
I currently have a dedicated database server with 8 GBs of RAM and 8 1.60
GHz processors. The tables on my databases are almost exclusively InnoDB,
except for 2-3 tables that are MyISAM and used for logging purposes (lots of
INSERT DELAYED statements). I have the following settings in my my.cnf,
I'm not positive if the general log captures all invalid queries but
it does capture at least some.
I was asked the same question a few months back and checking to make
sure that manually issued invalid queries are logged (IIRC).
Could it be that the queries are never even making it to the database
Unfortunately, I'm using a commercial application and trying to debug
as to why some data does and does not get updated properly.
On Feb 9, 2010, at 2:57 PM, mos wrote:
I do something like that in my compiled application. All SQL queries
are sent to a single procedures and executed there.
At 09:27 AM 2/9/2010, andy knasinski wrote:
I've used the general and slow query log in the past, but I am trying
to track down some queries from a compiled app that never seem to be
hitting the DB server.
My guess is that the SQL syntax is bad and never get executed, but I
don't see any related
A simple way to do this is to truncate the date and then GROUP BY it. So if
you have 2009-08-08, and you want a subset on month, then just truncate the
day-part: 2009-08-00 on the whole column, and SELECT DISTINCT so you have a
subset. You can use this subset then to join the dates, GROUP BY and
SELECT ID, check_no, amount FROM payables UNION SELECT ID, check_no, amount
FROM paychecks;
Regards,
Gavin Towey
-Original Message-
From: Richard Reina [mailto:rich...@rushlogistics.com]
Sent: Tuesday, February 09, 2010 9:23 AM
To: mysql@lists.mysql.com
Subject: query help
I am trying
I am trying to write a query that merges 2 columns from different tables and
show them as one column of data. Something like the following.
payables
ID |check_no| amount|
3 |3478| 67.00 |
4 |3489| 98.00 |
8 |3476| 56.00 |
paychecks
ID |check_no| amount
23 |3469|498.00 |
I've used the general and slow query log in the past, but I am trying
to track down some queries from a compiled app that never seem to be
hitting the DB server.
My guess is that the SQL syntax is bad and never get executed, but I
don't see any related queries in the general query log. Does
MySQL Galera Multi-Master Replication
http://forge.mysql.com/wiki/MySQL_Galera_Multi-Master_Replication
This Thursday (February 11th, 14:00 UTC), Seppo Jaakola & Alex Yurchenko
will talk about MySQL Galera Multi-Master Replication. Galera provides
synchronous multi-master replication and uses a ce
Hi experts,
I have blob filed, which contains the image.
I am using BV6.0 as my front end application. And i have some pre-defined
[defined by me] .rpt file. Along with the details, i would like to add the
photo on the report.
Can you help how to do this?
Thank you
Regards,
VIKRAM A
11 matches
Mail list logo
