running "Show global status like 'open_tables' we get a value
of 2900.
So my questions are as follows :
1. Why is the table_open_cache used up if there are not even that many
tables.
2. Why does these values differ so much? or do they provide different
info.
e get a value
of 2900.
So my questions are as follows :
1. Why is the table_open_cache used up if there are not even that many
tables.
2. Why does these values differ so much? or do they provide different info.
3. What other reasons can there be for a query to get stuck on "
t to get newest mysql info,
> thank you.
I want to get newest mysql info,
thank you.
information to the mysqld.log file.
I am wondering what other methods would write the debug info to the mysqld.log
file. On the two servers in question my fellow DBA's nor myself did nothing
that would have written debug info.
Are there any internal settings or processes that would
tho...@emdbase.info
> To: mysql@lists.mysql.com
> Subject: [Info] Business db
> Date: Fri, 5 Oct 2012 08:00:37 -0500
>
> Hi,
>
> As entrepreneurs we are always looking for effective ways to land new
> clients. By acquiring new clients, we are able to increase sales, build
Hi,
As entrepreneurs we are always looking for effective ways to land new clients.
By acquiring new clients, we are able to increase sales, build credibility and
grow our small businesses. There are proven strategies that work for. Email
marketing is indeed an effective and efficient way to ma
ee if I am setting
myself up for future problems.
Thanks,
Carl
- Original Message -
From: Johan De Meersman
To: Carl
Cc: mysql@lists.mysql.com
Sent: Wednesday, February 16, 2011 6:55 AM
Subject: Re: Replication, log info
On Wed, Feb 16, 2011 at 12:23 PM, Carl
On Wed, Feb 16, 2011 at 12:23 PM, Carl wrote:
> 110216 5:15:20 [ERROR] Error reading packet from server: log event entry
> exceeded max_allowed_packet; Increase
> max_allowed_packet on master ( server_errno=1236)
>
This seems to be the major player, here. I would make sure to increase the
setti
One more bit of information... this is from the error log:
110215 8:19:32 [ERROR] Error reading relay log event: slave SQL thread aborted
because of I/O error
110215 8:19:32 [ERROR] Slave SQL: Relay log read failure: Could not parse
relay log event entry. The possible r
easons are: the master'
: Object audit info
Simply activate the full log ("log" directive in my.cnf) - this will provide
you with logon, logoff and every command sent by every session.
Keep in mind that this is a LOT of data; so you want to keep this on a
separate set of spindles. It will also. obviously, mak
Simply activate the full log ("log" directive in my.cnf) - this will provide
you with logon, logoff and every command sent by every session.
Keep in mind that this is a LOT of data; so you want to keep this on a
separate set of spindles. It will also. obviously, make for some overhead,
but if your
Hi List,
How can i audit every object of the database including database too.
I will give you deep idea about it. Our environment having lots of
application connected to database.
We have created user specific to applications, which has admin rights. Now,
i wanted to monitor/audit information
in
M INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA =
>>> "dbname";
>>> >
>>> > ---Database & Table wise Size in GB---
>>> > SELECT TABLE_SCHEMA AS 'Database', TABLE_NAME AS 'Table',
>>> > CONCAT(ROUND(((DATA_LENGTH + INDEX_LENGT
; =
> > "dbname";
> >
> > Data size, index size & no. of tables, engine type*
> > SELECT s.schema_name,t.engine,
> > CONCAT(IFNULL(ROUND(SUM(t.data_length)/1024/1024,2),0.00),"Mb") as
> > Data_size,
> CONCAT(IFNULL(ROUND(SUM(t.index_
FNULL(ROUND(SUM(t.data_length)/1024/1024,2),0.00),"Mb") as
> Data_size, CONCAT(IFNULL(ROUND(SUM(t.index_length)/1024/1024,2),0.00),"Mb")
> as Index_size,COUNT(table_name) total_tables FROM
> INFORMATION_SCHEMA.SCHEMATA s LEFT JOIN INFORMATION_SCHEMA.TABLES t ON
> s.schem
N_SCHEMA.TABLES t ON
s.schema_name = t.table_schema WHERE s.schema_name not
in("mysql","information_schema","test") GROUP BY s.schema_name,t.engine
order by Data_size DESC;
For top slow queries :-
mysqldumpslow -s c -a -t 5 mysqlslow.log > top10_slow-coun
, then use either mysql_dump_slow or maatkit's mk-query-digest
to parse the log.
-Original Message-
From: PRATIKSHA JAISWAL [mailto:pratikshadjayswa...@gmail.com]
Sent: Monday, August 09, 2010 9:01 AM
To: mysql@lists.mysql.com
Subject: info on mysql
Hi All,
How can i get foll
Hi All,
How can i get following information from database or is there any query for
the same.
(1) mysql server uptime
(2) Total number of users connected to server
(3) Data file information / where it is located through mysql prompt / size
of data file
(4) each Database size
(5) Database I/O info
Jesper,
I dont have a table called innodb_monitor on any of my databases, i gone
through the links which you mentioned here.. but no luck..
Thanks
Anand S
On Wed, Mar 17, 2010 at 5:06 PM, Jesper Wisborg Krogh
wrote:
> On 17/03/2010, at 9:10 PM, Anand kumar wrote:
>
> you are right sir , the va
On 17/03/2010, at 9:10 PM, Anand kumar wrote:
you are right sir , the variables innodb_status_file will write the
"show
innodb status" information on to the file innodb_status.PID ...
however for
me the innodb status is logging into the default error log file...
i dont
have any clue on how
eds.com> wrote:
>
>> anand
>>
>> Do you use innodb engine at all further
>> -D
>>
>> -Original Message-
>> From: sanan...@gmail.com [mailto:sanan...@gmail.com] On Behalf Of Anand
>> Sent: Wednesday, March 17, 2010 3:00 PM
>> To: my
anan...@gmail.com] On Behalf Of Anand
> Sent: Wednesday, March 17, 2010 3:00 PM
> To: mysql@lists.mysql.com
> Subject: Disable innodb status info in err log
>
> Hi All,
>
> Innodb status information is getting logged on to my mysql error log
> file for every 15 seconds,
anand
Do you use innodb engine at all further
-D
-Original Message-
From: sanan...@gmail.com [mailto:sanan...@gmail.com] On Behalf Of Anand
Sent: Wednesday, March 17, 2010 3:00 PM
To: mysql@lists.mysql.com
Subject: Disable innodb status info in err log
Hi All,
Innodb status
Hi All,
Innodb status information is getting logged on to my mysql error log file
for every 15 seconds, can someone help in disabling it ?
Thanks
Anand
unpredictable behavior.
The right column displays the following info:
MySQL
- Server: localhost via TCP/IP
- Server version: 5.1.39-community
- Protocol version: 10
- User: r...@localhost
- MySQL charset: UTF-8 Unicode (utf8)
Web server
- Microsoft-IIS/6.0
- MySQL client version
ail.com]
Sent: 23 September 2009 15:42
To: mysql@lists.mysql.com
Subject: Re: Retrieving info from 2 tbls & ordering it
I think that you can do what you want with a simple union query:
select * from incoming where user_id = 123
union
select * from outgoing where user_id = 123
order by
I think that you can do what you want with a simple union query:
select * from incoming where user_id = 123
union
select * from outgoing where user_id = 123
order by datetime_received, datetime_sent
hth,
Arthur
On Wed, Sep 23, 2009 at 10:02 AM, Warren Windvogel wrote:
> Hi
>
> I have 2tables. 1
Hi
I have 2tables. 1 for incoming & the other for outgoing messages. They
both have columns for the userid & datetime_received/sent. I'd like to
retrieve all records from both tables for a specific user id & order all
the records returned by the two datetime_received/sent fields. Is this
poss
ers
Claudio
2009/4/17 Mihail Vetchinov
> Anybody can tell me about way which will force the mysqld write more
> information into logs (.err file)?
>
> My mysqld restarted every 20-30 minutes without reasonable info in log file
> and I dont understand why it occurs.
>
> I
Anybody can tell me about way which will force the mysqld write more
information into logs (.err file)?
My mysqld restarted every 20-30 minutes without reasonable info in log
file and I dont understand why it occurs.
I see only string "mysqld restarted" and nothing more! :(
Exam
> mysql> show full processlist\G
> *** 1. row ***
> Id: 30127
> User: root
> Host: localhost
> db: NULL
> Command: Query
> Time: 0
> State: NULL
> Info: show full processlist
> *** 2. row *
I also want to know the answer to this question.If it's for me.I'll scan all
the source code manually.But it's too complicated.
On Tue, Oct 7, 2008 at 1:02 AM, Olaf Stein <
[EMAIL PROTECTED]> wrote:
> It specifies the query in the Info field.
> In your case the connec
It specifies the query in the Info field.
In your case the connection is "sleeping", nothing is being executed at the
moment, therefore info is NULL
Olaf
On 10/6/08 11:38 AM, "MaBa.listas" <[EMAIL PROTECTED]> wrote:
> Hello,
> reading the MySQL documentati
---
mysql> show full processlist\G
*** 1. row ***
Id: 30127
User: root
Host: localhost
db: NULL
Command: Query
Time: 0
State: NULL
Info: show full processlist
*** 2. row ***
Id: 30399
User: root
Host: localhost
tement to do a slave configuration.
>
> On Sat, Aug 9, 2008 at 2:32 PM, Brown, Charles <[EMAIL PROTECTED]> wrote:
>
> >
> > Could not initialize master info structure;
> >
> > Can someone help me. I am getting the above message
> >
n someone tell me why I am getting this message whenever I issued a
> > "CHANGE MASTER" command?
> >
> > @4000489f38462d0bedd4 080810 13:49:32 [ERROR] Failed to initialize
> > the master info structure
> >
> >
> > Thanks
> > **
Delete all your relay log ,restart mysqld and use a new change master to
statement to do a slave configuration.
On Sat, Aug 9, 2008 at 2:32 PM, Brown, Charles <[EMAIL PROTECTED]> wrote:
>
> Could not initialize master info structure;
>
> Can someone help me. I am getting
why I am getting this message whenever I issued a
> "CHANGE MASTER" command?
>
> @4000489f38462d0bedd4 080810 13:49:32 [ERROR] Failed to initialize
> the master info structure
>
>
> Thanks
>
> This message is
Can someone tell me why I am getting this message whenever I issued a
"CHANGE MASTER" command?
@4000489f38462d0bedd4 080810 13:49:32 [ERROR] Failed to initialize
the master info structure
Thanks
This message is intended only for the
Could not initialize master info structure;
Can someone help me. I am getting the above message
This message is intended only for the use of the Addressee and
may contain information that is PRIVILEGED and CONFIDENTIAL.
If you are not the intended
do not trust them at all, and that's why I don't know a
whole lot about how to use them :)"
Which is a good enough reason for me to not use them.
On Thu, Feb 28, 2008 at 1:10 PM, Lyons, Jim <[EMAIL PROTECTED]> wrote:
> Jason Pruim wrote:
>
> > I am attempti
Jason Pruim wrote:
> I am attempting to write a PHP application that reads info from a
> MySQL database, and I'm wondering if I can set up a column in one
> table that gets it's info from a field in another table automatically?
> Ie:
> Table1:
> field1
> fiel
ary columns and make the table /column names generic.
>
> Can I ask why? So far, everything I have done with MySQL would seem to
> suggest setting column names so it makes sense what info is stored in
> it? (IE: First Name would go into FName or firstname or namefirst or
> some
ng this e-mail! Thank you
The new table you sent is good, but it is more ideal to remove
unnecessary columns and make the table /column names generic.
Can I ask why? So far, everything I have done with MySQL would seem to
suggest setting column names so it makes sense what info is stored in
it?
> > wrote:
> >> Hi Everyone,
> >>
> >> I am attempting to write a PHP application that reads info from a
> >> MySQL database, and I'm wondering if I can set up a column in one
> >> table that gets it's info from a field in another tabl
On Feb 28, 2008, at 1:29 PM, Rob Wultsch wrote:
On Thu, Feb 28, 2008 at 10:59 AM, Jason Pruim <[EMAIL PROTECTED]>
wrote:
Hi Everyone,
I am attempting to write a PHP application that reads info from a
MySQL database, and I'm wondering if I can set up a column in one
table that get
On Thu, Feb 28, 2008 at 10:59 AM, Jason Pruim <[EMAIL PROTECTED]> wrote:
> Hi Everyone,
>
> I am attempting to write a PHP application that reads info from a
> MySQL database, and I'm wondering if I can set up a column in one
> table that gets it's inf
Hi Everyone,
I am attempting to write a PHP application that reads info from a
MySQL database, and I'm wondering if I can set up a column in one
table that gets it's info from a field in another table automatically?
Ie:
Table1:
field1
field2
field3
Table2:
field4
field5
field
OK, I think we've solved this one.
Procedure:
> [EMAIL PROTECTED] ~]# urpme MySQL-client MySQL MySQL-common
> [EMAIL PROTECTED] ~]# mv /var/lib/mysql /var/lib/mysql.old
> [EMAIL PROTECTED] ~]# urpmi MySQL-client-5.0.27-3mdv2007.1
> MySQL-5.0.27-3mdv2007.1 MySQL-common-5.0.27-3mdv2007.1
This ser
> [EMAIL PROTECTED] jim]# mysqladmin -u [EMAIL PROTECTED] password new_password
> mysqladmin: Can't turn off logging; error: 'Access denied; you need the SUPER
> privilege for this operation'
HUH? What's wrong? :
> [EMAIL PROTECTED] jim]# mysql -u [EMAIL PROTECTED]
> Welcome to the MySQL mon
Thanks for the reference Jay.
Most helpful.
Kerry
-Original Message-
From: Jay Pipes [mailto:[EMAIL PROTECTED]
Sent: 14 December 2006 20:29
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: mysql v5 math a bit out. How do I round the info to become
correct
For exact
For exact calculations, you need to use the DECIMAL data type. See this
section in the manual for the reasons why:
http://dev.mysql.com/doc/refman/5.1/en/precision-math-examples.html
Cheers,
Jay
Kerry Frater wrote:
> I am running a small procedure for set jobs that calculates a running total
>
I am running a small procedure for set jobs that calculates a running total
for me to display. It works fine in most cases but the math concerns me.
I am using 5.0.18 on my Windows PC and the latest 5.x on my Linux server
(both test machines).
The finance table is an InnoDb table.
CreditAmount and
TED]
Sent: Thursday, November 16, 2006 8:41 AM
To: Logg, Connie A.
Subject: RE: More info about 40001 SQL_NO_CACHE
Looks like this may have been fixed in 5.0.25 or above, so if it's the same
bug, you're good to go.
http://bugs.mysql.com/bug.php?id=21288
Howard
-Original Message-
mple yet complicated.
Try to find out what software issued that SQL statement and its intended target.
- Original Message -
From: Connie A. Logg <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Sent: Wednesday, November 15, 2006 11:18:31 PM GMT-0500 US/Eastern
Subject: More info about 4000
This showed up in 'show processlist' and it had had an active time of about 4
days. Numerous other inquiries were hung behind it, although the other
inquiries completed eventually...but they were so slow as to backup the data
base entry code and extraditions for the analysis by several hours.
I'm temping at a warehouse where, apparently, everyone has different
privileges, which only allow them to to run specific reports. However,
the reports, from different individuals, are often contradictory.
I can't imagine why the reports would contradict each other, but,
apparently, this is the s
i am working on a data collection system for an epidemiological study.
the study holds among other things sensitive personal information. the
personal info is stored in ONE table (i am using innodb_file_per_table)
which we encrypt and wipe after the server is shutdown.
the question is, where
>It depends on what the data is being used for. If you want to know
>what address an order was shipped to then you need the historical
>address info. If all you need is the current customer address,
>because, say, you're sending out holiday cards, then you might not
>need to
It depends on what the data is being used for. If you want to know
what address an order was shipped to then you need the historical
address info. If all you need is the current customer address,
because, say, you're sending out holiday cards, then you might not
need to keep an old ad
[snip]
> Well, one reason could be, for example, that the address changes
> over time and they want to know what address the customer was
> when the order was processed.
[/snip]
So you would delete an old customer address in favor of a new one? I
would rather have an 'active/inactive' column with
ers_status` int(5) NOT NULL,
`orders_date_finished` datetime default NULL,
`currency` char(3) default NULL,
`currency_value` decimal(14,6) default NULL,
PRIMARY KEY (`orders_id`)
Why have customer info in both? Delivery and Billing info makes sense,
but why the redundant info in both? Anyone go
>> I wouldn't enter the "delivery" and "billing" info either, but create
>> some sort of "customer_address" table or "order_customer_address"
>> in which records would be inserted if and only if the addresses used
>> for bill
On 5/19/06, Martijn Tonies <[EMAIL PROTECTED]> wrote:
Well, one reason could be, for example, that the address changes
over time and they want to know what address the customer was
when the order was processed.
I agree.
I wouldn't enter the "delivery" and "billin
Bad design that violates basic DB design checks. Redundant information will
become a major problem for you going forward. Unless you have hard and fast
performance issues they require it, just don't do it:-)
Create a single table that contains customer info and reference the information
[snip]
Why have customer info in both? Delivery and Billing info makes sense,
but why the redundant info in both? Anyone got views on this? Do/would
you do it differently, and could you tell us why? Cheers.
[/snip]
It is bad database design IMHO.
--
MySQL General Mailing List
For list
efault NULL,
> `orders_status` int(5) NOT NULL,
> `orders_date_finished` datetime default NULL,
> `currency` char(3) default NULL,
> `currency_value` decimal(14,6) default NULL,
> PRIMARY KEY (`orders_id`)
>
> Why have customer info in both? Delivery and Billing info
) NOT NULL,
`orders_date_finished` datetime default NULL,
`currency` char(3) default NULL,
`currency_value` decimal(14,6) default NULL,
PRIMARY KEY (`orders_id`)
Why have customer info in both? Delivery and Billing info makes sense,
but why the redundant info in both? Anyone got views on this? Do/
ysql@lists.mysql.com
Subject: RE: ~Mysql cluster info~
Hello Jimmy,
Do we have a production release of MYSQL cluster 5.1 ? If yes
please let me know the path from where i can download the same.
Thanks in advance,
Abdul.
On Tue, 2006-03-21 at 07:16 -0600, Jimmy Guerrero wrote:
Hello,
MySQL 5.0 C
ammed Abdul Azeem [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 21, 2006 9:30 PM
> To: Jimmy Guerrero
> Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com
> Subject: RE: ~Mysql cluster info~
>
>
> Hello Jimmy,
>
> Do we have a production release of MYSQL cluster 5.1 ? If y
[EMAIL PROTECTED]
> > Sent: Monday, March 20, 2006 9:33 PM
> > To: mysql@lists.mysql.com
> > Subject: ~Mysql cluster info~
> >
> >
> > Hi,
> >
> > Iam new to clustering in mysql. I went through the reference
> > manual 5.0 and found that the RA
>I installed 5.0 and 5.1-beta on three different system (all are Fedora Core
>4), and each time when I use the command-line client, I can not use the
>familiar up-arrow feature that normally lets you scroll through queries issued
>during previous command-line sessions. My history is completely
t: Monday, March 20, 2006 9:33 PM
> To: mysql@lists.mysql.com
> Subject: ~Mysql cluster info~
>
>
> Hi,
>
> Iam new to clustering in mysql. I went through the reference
> manual 5.0 and found that the RAM memory requirements for
> implementing a cluster is almost twi
Hi,
Iam new to clustering in mysql. I went through the reference manual 5.0
and found that the RAM memory requirements for implementing a cluster is
almost twice the size of the database.
My problem is i have a database which is 55GB. So does it mean that i
need to have 110 GB RAM memory ? Can an
Hi Green & Eugene,
Thanks a lot.
On Fri, 2006-03-10 at 09:57 -0500, [EMAIL PROTECTED] wrote:
> Косов Евгений <[EMAIL PROTECTED]> wrote on 03/10/2006 07:53:37 AM:
>
> > Hm... It seems to me In MySQL there's no such thing as "database owner".
>
> > Or am I missing something?
> >
> > Mohammed A
Косов Евгений <[EMAIL PROTECTED]> wrote on 03/10/2006 07:53:37 AM:
> Hm... It seems to me In MySQL there's no such thing as "database owner".
> Or am I missing something?
>
> Mohammed Abdul Azeem пишет:
> > Hi,
> >
> > How to check for the database owner for a particular database ? The
way
>
Hm... It seems to me In MySQL there's no such thing as "database owner".
Or am I missing something?
Mohammed Abdul Azeem пишет:
Hi,
How to check for the database owner for a particular database ? The way
"show procedure status" command lists the "definer" column, Is there a
command that shows
Hi,
How to check for the database owner for a particular database ? The way
"show procedure status" command lists the "definer" column, Is there a
command that shows the database owner. Similarly, what is the command to
see the owner of a table in a database ?
Thanks in advance,
Abdul.
James Black <[EMAIL PROTECTED]> wrote on 12/08/2005 01:07:15 PM:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> In the manual (http://dev.mysql.com/doc/refman/5.0/en/insert.html) I saw
> this snippet: If you use an INSERT ... VALUES statement with multiple
> value lists
>
> But, I thnk I
Hi James,
INSERT INTO table (a,b,c) VALUES (1,2,3),(4,5,6);
is an example of inserting multiple rows with one insert statement,
instead of these 2:
INSERT INTO table (a,b,c) VALUES (1,2,3);
INSERT INTO table (a,b,c) VALUES (4,5,6);
That should give you enough to work with.
-Sheeri
On 12/8/05,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
In the manual (http://dev.mysql.com/doc/refman/5.0/en/insert.html) I saw
this snippet: If you use an INSERT ... VALUES statement with multiple
value lists
But, I thnk I am missing some information on the syntax of INSERT ...
VALUES.
This may be what
ption trying to
> retrieve parameter info
>
> This fixes my problem. Thanks!. Now to figure out where I got the
> ampersand
> from I thought it was in an example.
>
> On 12/2/05, Jesse Castleberry <[EMAIL PROTECTED]> wrote:
> >
> > Have you tried using "?
ficer"))
>myCmd.Parameters("?tbl").Direction = ParameterDirection.Input
>
> Jesse
>
> - Original Message -
> From: "Rehcra" <[EMAIL PROTECTED]>
> To:
> Sent: Friday, December 02, 2005 2:28 PM
> Subject: DOT.NET Connector and Stored Proc
rameters("&tbl").Direction = ParameterDirection.Input
Dim myAdapter As New MySqlDataAdapter(myCmd)
myAdapter.Fill(Test) '*** raises MySqlException
End Function
"Exception trying to retrieve parameter info for tbl_slct: Parameter 'tbl'
is not defined"
What am I missing?
Thanks,
Steve
I thought I would get around the whole thing by just installing the RPM
instead of compiling. So I downloaded MySQL-devel-4.1.14-0.i386.rpm and
installed it. Then I went to install the DBD-mysql module and got this
error during the compile:
/usr/bin/ld: cannot find -lz
collect2: ld returned 1 ex
Hi all,
there is no conversion done, and mysql will stil be happy to export utf8
(if asked to do so with a set names). So what is the role of the
character set and collation at the database level?From what I understand
the collation is used when you want to order results for example, case
sen
out = new OutputStreamWriter(bout,"UTF-8");
Just wanted to give some info who may help somebody who is not a java
developper (like me!).
If somebody around knows if this has any chance to work or if there is an
other problem please let me
Hi Melanie,
Thanks for the explanation, I will try the SET NAMES to export my XML
file in utf8 (I actually want it to be in utf8)
I'm sorry if this is a basic question, but as I said before I'm kind of
lost with the encodings
I asked almost the same here about a week ago, so I don't think
mysql.com
Subject: Re: character sets.(missing info)
Date: Tue, 08 Nov 2005 19:55:30 +0100
Hi,
if the character_set_client is by default latin1, does that mean that the
java application is sending latin1?or is it changed at runtime?
kind of lost again.
As I understand, the charset of the column
Hi,
if the character_set_client is by default latin1, does that mean that
the java application is sending latin1?or is it changed at runtime?
kind of lost again.
As I understand, the charset of the column/table/database is irrelevant,
there will be no conversion if you query from or inse
sorry i should have put the result of the show variables:
*** 5. row ***
Variable_name: character_set_client
Value: latin1
*** 6. row ***
Variable_name: character_set_connection
Value: la
Then eliminate the subquery and SQL_CALC_FOUND_ROWS will be an option for
you again. If you would like some help refactoring your query, I
volunteer. If I can't help, I know there are several others on the list
just as capable as I (or more so).
Shawn Green
Database Administrator
Unimin Corpora
Very sorry for having troubled all regarding the seemingly stupid rtfm
garnering request for help.
But in my attempt to make the question as simple and succinct as
possible, i forgot to state one EXTREMELY important chunk of information.
I can't use SQLCALCFOUNDROWS because there is a subqry
Jay
There's a short list of SQL & relational tutorials at
http://www.artfulsoftware.com/dbresources.html, and of a few MySQL
resources at http://www.artfulsoftware.com/mysqlinfo.html.
PB
Jay Paulson wrote:
Hi everyone,
Long time reader, first time poster.
I've been using MySQL for
essage-
> > From: Jay Paulson [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, September 06, 2005 10:56 AM
> > To: mysql@lists.mysql.com
> > Subject: Newbie needs info!
> >
> > Hi everyone,
> >
> > Long time reader, first time poster.
> >
>
The DuBois book is a good start: http://www.kitebird.com/mysql-book/
> -Original Message-
> From: Jay Paulson [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, September 06, 2005 10:56 AM
> To: mysql@lists.mysql.com
> Subject: Newbie needs info!
>
> Hi everyone,
>
&
Hi everyone,
Long time reader, first time poster.
I've been using MySQL for some years now and never really did any
advance stuff in it. I mainly do updates, deletes, and selects. My
selects aren't even that complex as I don't have a very good
understanding of the join syntax and exactly wh
Gleb Paharenko wrote:
Hello.
Maybe the output of innodb_monitor won't be truncated.
Create the innodb_monitor table and check if you see
the full output in the .err log. See:
http://dev.mysql.com/doc/mysql/en/innodb-monitor.html
this helps - thanks
--
MySQL General Mailing List
rtunately they are at the bottom of whole report and that is
> problem, because in one of databases I manage lock and transaction info
> is so long, that other information is not displayed at all.
>
> Any advice?
>
> TIA
> Remigiusz
>
--
For technical suppo
1 - 100 of 396 matches
Mail list logo
