[snip]
For the life of me I cannot remember how to make a query like this and
what
it is called.
I know it is fairly basic though.
Table 1
Product_id Product_Name
Table 2
Category_id, Category_name
Table 3
Product_id, Category_id
Each product can have one or more categories.
So I want a
Devart
Email: i...@devart.com
Web: http://www.devart.com
FOR IMMEDIATE RELEASE
CONTACT INFORMATION:
Julia Samarska
jul...@devart.com
12-Jul-10
More Tools to Work with MySQL Databases Provided by dbForge Studio!
With dbForge Studio for MySQL, Devart continues its initiative to produce
Hi;
Perhaps I have a conflict of terms here, but my googling mysql data
dictionary turned up material that didn't seem to correspond with my
problem. In python I can create dictionaries:
my_dict = {'1': 'one', '2': 'two'}
Now, I would like to create the equivalent of an enum in which I could
No such thing in SQL
On Mon, Jul 12, 2010 at 10:39 AM, Victor Subervi
victorsube...@gmail.com wrote:
Hi;
Perhaps I have a conflict of terms here, but my googling mysql data
dictionary turned up material that didn't seem to correspond with my
problem. In python I can create dictionaries:
[snip]
Perhaps I have a conflict of terms here, but my googling mysql data
dictionary turned up material that didn't seem to correspond with my
problem. In python I can create dictionaries:
my_dict = {'1': 'one', '2': 'two'}
Now, I would like to create the equivalent of an enum in which I could
On 7/8/2010 11:29 PM, Miguel Vaz wrote:
Hi,
I am having some uncertainty while designing the following structure:
I have two sets of data:
* arqueology sites (can be natural):
id
name
description
id_category
id_period
x
y
* natural sites (can be arqueological also - bear with me -, so
Hi All
I am trying to find out how to see the exact query being
run.
When running show processlit, I get a lot of processes that
have been running for a VERY long time.
I a trying to find out exactly what query it is that is
being run ,
A data dictionary, as the term is generally used, is what is contained
in INFORMATION_SCHEMA. It is meta data describing the types and names
and structure of the data within a given domain.
Python's concept of a dictionary is what other language call a hash
(perl), an associative array (awk,php)
SHOW FULL RPOCESSLIST
will show you the full text of the running queries.
- md
On Mon, Jul 12, 2010 at 11:39 AM, Machiel Richards machi...@rdc.co.zawrote:
Hi All
I am trying to find out how to see the exact query being
run.
When running show
I had a look and all of these just say sleep as the command.
Machiel Richards
MySQL DBA
Relational Database Consulting
RDC_Logo
From: Michael Dykman [mailto:mdyk...@gmail.com]
Sent: 12 July 2010 5:43 PM
To: Machiel Richards
Cc: mysql@lists.mysql.com
Subject: Re: finding exact query
Am I correct in assuming that your application does connection pooling? If
so, then these long lasting, idle threads are normal.
If there is no connection pooling, then this might be a symptom of a problem
with your application server not letting go of processes properly.
- md
On Mon, Jul 12,
mmm... I am not sure about the connection pooling... Fairly new to the site.
What I do know is that they run a couple of web servers that connect to the
MySQL database and are currently experiencing some performance and
connection problems.
There are a lot of processes that have been
Hi, Shawn,
Thanks for replying. What i meant is that i would also like to create a
table with site types, where i would have a listing of possible sites,
like arqueology, natural, etc. and maybe use it to redirect the queries
instead of having to hardcode the table name when i need to list a
What are they running on those web servers? PHP? if so, which is of the
several PHP interfaces to MySQL are they using? (Zend Enterprise does some
smart connection pooling). Java-based applications tend to use connection
polling more often than not.
You should find out to determine if those
Table 1
Product_id | Product_Name
1| Product A
2| Product B
3| Product C
Table 2
Category_id | Category_Name
1 | Admin
2 | Marketing
3 | Support
4 | IT
Table 3
If you have lots of sleeping processes the chances are you have a poorly
written app that is not closing its database connections. Those sleeping
processes are just connections waiting for another command from the
application or whatever else initiated them.
The sleeping processes will not show
In my.cnf, check wait_timeout value , default is 4800. Make it to
wait_timeout = 60
Thus, the connections will automatically be closed after waiting for 60
seconds.
On Mon, Jul 12, 2010 at 11:51 PM, John Daisley
daisleyj...@googlemail.comwrote:
If you have lots of sleeping processes the
get mytop
_
From: Machiel Richards [mailto:machi...@rdc.co.za]
Sent: Monday, July 12, 2010 8:40 AM
To: mysql@lists.mysql.com
Subject: finding exact query being run
Hi All
I am trying to find out how to see the exact query being
run.
When
18 matches
Mail list logo