Is this possible with MYSQL using the innodb engine? If so, what is
the command/process to make this happen.
Thanks in advance,
~
Clyde Lewis
Database Administrator
Lewis - DBA wrote:
Is this possible with MYSQL using the innodb engine? If so, what is
the command/process to make this happen.
Thanks in advance,
~
Clyde Lewis
Database Administrator
~
Clyde Lewis
Database Administrator
This will be not that easy as there is a large array of different
users accessing the DBA at different time during the day/night.
CL
t 11:58 AM 8/3/2007, Edward Kay wrote:
-Original Message-
From: Clyde Lewis - DBA [mailto:[EMAIL PROTECTED]
Sent: 03 August 2007 16:55
To: MySQL
log file and not knowing which database
the changes are associated with while attempting to reapply the changes.
Thanks in advance
~
Clyde Lewis
Database Administrator
the insert or update that is giving foreign key
fail error, know the position just before this sql and recovery till that
position and then recovery from position after this sql still till the end
of file.
regards
anandkl
On 6/20/07, Clyde Lewis - DBA [EMAIL PROTECTED] wrote:
Guys,
I'm
,
~
Clyde Lewis
Database Administrator
Guys,
I have the following table that contains some information about a
cars. I'm trying to write a query to determine:
the number of make(name of car), number of models per make(name of
car) and the average number of models/make(name of car) sold in a
particular period.
The two queries
be the best idea.
Again, thanks.
CL
At 06:39 PM 3/15/2007, Alex Greg wrote:
On 3/14/07, Clyde Lewis [EMAIL PROTECTED] wrote:
System Configuration: Sun Microsystems sun4u Sun Fire E2900
System clock frequency: 150 MHZ
Memory size: 65536 Megabytes
CPU: 12 @ 1200 MHz
I'm looking for a tool
machine. Any help of ideas would be greatly appreciated with
this decision.
Thanks in advance,
***
Clyde Lewis
Database Administrator
General Parts, Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
not currently aware of how to move for forward.
Release: 4.1.20
OS: Solaris 10
Thanks in advance,
***
Clyde Lewis
Database Administrator
General Parts, Inc.
919-227-5100
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
in this position please submit your resume,
salary requirements, and a paragraph highlighting your
skills/experience as it pertains to this job
to [EMAIL PROTECTED]
***
Clyde Lewis
Database Administrator
General Parts, Inc.
Hello,
How can I find the foreign keys for a table? I would like to be able
to find, for any table, the columns that are foreign keys and what
tables/columns the foreign keys are related to. Basically what I am
trying to do is this. My developers want to allow logical deletes of
data. I don't
wrote:
show create table tablename?
-Original Message-
From: Clyde Lewis [mailto:[EMAIL PROTECTED]mailto:[EMAIL PROTECTED]
Sent: Tue 11/14/2006 10:16 AM
To: MySQL List
Subject: Find foreign key for a table
Hello,
How can I find the foreign keys for a table? I would like to be able
A little confused as to why MySql is swapping when there is more than
enough real memory still available on the server. I'm having a
serious problem with a production server running out of swap space
and in turn causing mysql to crash with the following error message.
According to the TOP
. If someone can point me in the right direction, it would be
greatly appreciated.
Thanks in advance,
***
Clyde Lewis
Database Administrator
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
select right and use him?
Clyde Lewis [EMAIL PROTECTED] escreveu na mensagem
news:[EMAIL PROTECTED]
All,
Does MySQL have an option where the database can startup in READ-ONLY
mode? The idea is to have the server running with users connected, but
now allowing any updates to me applied
(prtStkQty 0)
Thanks in advance
***
Clyde Lewis
Database Administrator
General Parts, Inc.
919-227-5100
Is there a command in mysql that will return the row number. I
tried rownum and rownum()
Excellent explanation. Thanks again.
CL
At 02:00 PM 1/25/2006, [EMAIL PROTECTED] wrote:
Clyde Lewis [EMAIL PROTECTED] wrote on 01/25/2006 01:41:30 PM:
Is there a command in mysql that will return the row number. I
tried rownum and rownum()
No, rows do not exist in the base data
Hello,
I'm trying to get a handle on who is making what changes in my database,
but cannot seem to find user/account info in the bin-logs besides the
actual update that was made. Is there a way in which MySQL logs not only
the changes, but also the user account that updated a record in the
You could copy the entire mysql directory structure to an isolated area
on disk. This will involve stopping the instance though.
Luke Vanderfluit wrote:
Hi.
I'm using 4.0.18 and for legacy reasons I can't upgrade that.
However I'm upgrading the database to a new schema.
I want to copy the
Guys,
Our production database had a table that was suddently dropped a
mystery. I need to find out if there is a way to find the user account
that performed this function. No one is taking ownership and I need to
know if there is a way to find out.
Thanks in advance
--
MySQL General
I did check the binlog and saw that the command ran along with the
timestamp. Is there a way to figure out who ran the command?
[EMAIL PROTECTED] wrote:
Clyde Lewis [EMAIL PROTECTED] wrote on 09/26/2005 02:44:40 PM:
Guys,
Our production database had a table that was suddently dropped
Does anyone know of a straght forward approach to migrate a
mysql(4.1.11) Schema to Oracle(9i release 2).
Also, please provide any best practices.
Thanks in advance.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hey guys,
I'm looking for any best practices or a formula that is commonly used in
setting the value for thread concurrency in the configuration file.
I have 24 instances running on a sun 2900 server with 32GB or ram.
Here is a sample of my configuration file.
#use this line mfor mysql 4.1
What are the consequences of cancelling(stopping) the drop index on
table command if any at all?
The process is running on a 9GB table and need to stop the process (dev
environment).
Thanks in advance.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Guys,
I have a huge table to which I'm attempting to update the foreign key
and index. It is taking me more than 20 hrs to complete the process and
would like to know if someone can point me in the right direction.
Please let me know of any additional information that I should provide.
`) |
+---++-++-++-+-+--+---++-+-++---+--++---+
1 row in set (0.11 sec)
[EMAIL PROTECTED] wrote:
Clyde Lewis [EMAIL PROTECTED] wrote on 08/29/2005 01:47:11 PM:
Guys,
I have a huge table to which I'm attempting to update the foreign key
and index. It is taking me more than 20 hrs to complete
Does anyone have any experience using multiple my.cnf files on a single box?
If so, how is the my.cnf specified during startup and shutdown? I need
multiple my.cnf files to test ibbackup software because it does not
currently support using mysqld_multi.
CL
--
MySQL General Mailing List
For
I used mysqldump with the -t option to only dump the raw data. I'm in the
process of importing the dump to a new database with seed data loaded. I'm
attempting to override the existing dataset but continue to get the
following message when the import encounters a duplicate entry: Duplicate
entry
I'm in need of a hotbackup solution that supports multiple instances on the
the same server. Currently, I'm dumping the databases nightly and would
like to know if anyone know of an alternative. I've tested innodb, but have
not had any success getting it to work with more than one
. I'm still testing and have not yet purchased support, but
thought that I could get some feedback from this list. Any help would be
greatly apprecciated in helping me move forward with this testing.
***
Clyde Lewis
DBA
General Parts
(919)227-5100
[EMAIL PROTECTED]
--
MySQL
I'm in the process of testing this backup utility and need to know if anyone
have any experience using it as their primary
backup solution.
Any help would be greatly appreciated.
Thanks in advance.
***
Clyde Lewis
DBA
General Parts
(919)227-5100
[EMAIL PROTECTED]
--
MySQL
33 matches
Mail list logo