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.
These o
lue
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 "closing
I want to get newest mysql info,
thank you.
nt 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 write
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
...@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
credibility and grow our small
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
On Wed, Feb 16, 2011 at 12:23 PM, Carl c...@etrak-plus.com 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
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 c...@etrak
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
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
: 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, make for some
,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-count_envr.log
For Engine Info of a table and other details :-
Show table status like 'tablename';
Cheers,
Anirudh Sundar
On Mon, Aug 9
by Data_size DESC;
For top slow queries :-
mysqldumpslow -s c -a -t 5 mysqlslow.log top10_slow-count_envr.log
For Engine Info of a table and other details :-
Show table status like 'tablename';
Cheers,
Anirudh Sundar
On Mon, Aug 9, 2010 at 9:31 PM, PRATIKSHA JAISWAL
For Engine Info of a table and other details :-
Show table status like 'tablename';
Cheers,
Anirudh Sundar
On Mon, Aug 9, 2010 at 9:31 PM, PRATIKSHA JAISWAL
pratikshadjayswa...@gmail.com wrote:
Hi All,
How can i get following information from database or is there any
query
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
, 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 following
DESC;
For top slow queries :-
mysqldumpslow -s c -a -t 5 mysqlslow.log top10_slow-count_envr.log
For Engine Info of a table and other details :-
Show table status like 'tablename';
Cheers,
Anirudh Sundar
On Mon, Aug 9, 2010 at 9:31 PM, PRATIKSHA JAISWAL
pratikshadjayswa...@gmail.com wrote
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
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
[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 information is getting logged on to my mysql error log
file for every 15 seconds, can someone help in disabling
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 information is getting
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
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
jes...@noggin.com.auwrote:
On 17/03/2010, at 9:10 PM, Anand kumar wrote:
you are
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
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
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 war...@fontera.comwrote:
Hi
I
: 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 datetime_received
Claudio
2009/4/17 Mihail Vetchinov m.vetchi...@rambler-co.ru
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
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! :(
Example of log
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 connection is sleeping, nothing
. 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
db: this would be my DB
Command: Sleep
*** 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
db: this would be my DB
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 documentation I've run into the show full
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 use
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 use of the Addressee and
may contain
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 the above message
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 use of the Addressee and
may contain information
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
This message is intended only for the use of the Addressee and
may
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
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
field6 = field1
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 info from a field in another table automatically
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 gets it's info
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
field6 = field1
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? (IE: First Name would go
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? (IE: First Name would go
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
field2
field3
Table2:
field4
field5
, 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 attempting to write a PHP application that reads info from a
MySQL database
[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
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 series
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
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
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
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 40001 SQL_NO_CACHE
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-
From: Logg, Connie A. [mailto
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
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 keep an old address
,
`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/would
you
,
`last_modified` datetime default NULL,
`date_purchased` datetime default 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
[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
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
using
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 billing info either, but create
some
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 billing and delivery differ from the normal customer address.
And what happens
` 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 got views
[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 an
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 address
, 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 twice the size of the database.
My problem is i
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
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 twice the size of the database.
My problem is i have a database which is 55GB. So does
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 yes
please let me know the path from where i can
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 Cluster is an in-memory database. Meaning
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
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 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 the database owner. Similarly, what is the command to
see the owner of a table in a database ?
Thanks in advance,
Abdul.
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 the
Косов Евгений [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
show
-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
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
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 am
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 ? instead of ? I'm very new to both MySQL and
Stored Procedures, but I've got
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
-
From: Rehcra [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, December 02, 2005 2:28 PM
Subject: DOT.NET Connector and Stored Procedures: Exception trying to
retrieve parameter info
I'm having a problem getting parameters working.
Mysql 5.0.16
mysql-connector-net-1.0.7
VB.NET 1.1
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
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
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 know!
Thanks to everybody for your help.
melanie
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/table/database is irrelevant
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
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:
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
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
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
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
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,
Long time reader, first time
:[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.
I've been using MySQL for some years now and never really did any
advance stuff in it. I mainly do updates
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
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
, BUFFER POOL AND
MEMORY and ROW OPERATIONS
unfortunately 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
1 - 100 of 378 matches
Mail list logo