You should be able to do this by:
1) Stopping the server cleanly
2) Removing the log files
3) Restarting the server with the new log file sizes set in your .cnf
Chris
Dathan Vance Pattishall wrote:
Trying to increase my innodb_log_file_size I get this message
031027 16:01:02 InnoDB: Data file
Description:
It is possible to get into a situation where foreign key constraints
on a replication slave have different labels to the same foreign key
constraint on the master. This normally causes replication to fail when
a drop of a foreign key on the master is attempted (although
You're getting a distinct on just the prod_num in the first query, but
are requesting distinct prod_num, description, line, and content in the
second one: if any of those last three columns are different between
rows, you will see ones additional to the count you get in the first
query. You
. For now, if anyone could shed some light I'd be most
appreciative.
Regards,
Chris Tucker
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
You're running a join on table two which will result in the following set (if
you remove the group by and sum()s):
ABCCORP 500, 150, 350 (from table 1, row 1, join table 2, row 1)
ABCCORP 500, 50, 300 (from table 1, row 1, join table 2, row 2)
ABCCORP 500, 50, 250 (from table 1, row 1, join
Upgrading to 4.0.13 will allow you to drop foreign keys. The innodb manual has
info:
http://innodb.com/ibman.html
Chris
Joe Gaffney wrote:
Can someone help with trying to remove a foreign key constraint from a
table. Each time I run the alter table statement to drop the foreign key I
get the
You say you are using replication. In this situation, if you make an update to
the master (using ALTER...) that takes a long time, this will get serialized
into the binary log as normal and block all subsequent queries from executing on
the slave until it has completed. One of the issues with
The pager option can be used to accomplish this (if you don't mind having things
running through, e.g., less). When I need to do this I just do:
mysql \P less -S
mysql my query here
You'll get unwrapped output (the -S option to less tells it to truncate rather
than wrap over-long lines).
You
wrote:
That works with \G switch , but without the \G switch Istill get it
wrapped
wish I can remeber the switch
On Tue, 3 Jun 2003, Chris Tucker wrote:
The pager option can be used to accomplish this (if you don't mind having things
running through, e.g., less). When I need to do this I just do
wish I remebered the swithc for that
On Tue, 3 Jun 2003, Chris Tucker wrote:
What platform are you on? If you're on windows you probably won't have less
installed, in which case you'll need to either (a) install it or (b) use a
different pager (not sure what you'll have with windows, you'd have
Read the Foreign Key section of the InnoDB manual
(http://innodb.com/ibman.html#InnoDB_foreign_keys): it explains why you may get
an error code 150. Particularly:
Both tables have to be InnoDB type and there must be an index where the
foreign key and the referenced key are listed as
:38PM -0700, Chris Tucker wrote:
Hi,
I'm running into an issue on MySQL 4.0.12 (not tested on other
releases) using an InnoDB table type, where an update query is
getting written to the query log but never being propogated as far
as the binlog. The query is also not updating the DB, though
according
You should probably also take a look at your error log (dbmaster.err)...it'll
tell you in much more detail why mysqld ended rather than continued running as
expected. Often this will be something as simple as your directory permissions
not being set right on your data dir...
Chris
Nick
Alternatively, use InnoDB Hot Backup: http://www.innodb.com/hotbackup.html
This will let you take a real-time backup of your InnoDB tables without
taking the server down.
Chris
Rafal Jank wrote:
Dnia Wed, 28 May 2003 12:57:59 +0200
Jarek Jarzebowski [EMAIL PROTECTED] zezna/a co nastpuje:
Hi,
more details on what happens between the query log being
written and the bin log being written (a rough process flow of what happens in
the DB internals) that would be of great help (even if just to improve my
knowledge of this stuff).
Thanks in advance,
Chris Tucker
--
MySQL General Mailing
Version 5.5: Thu May 30 14:51:26 PDT
2002; root:xnu/xnu-201.42.3.obj~1/RELEASE_PPC Power Macintosh powerpc
Distro:
MacOS 10.1.5
MySQL version:
3.23.51
On Thursday, September 19, 2002, at 06:55 PM, Chris Tucker wrote:
I'm having some trouble with a sizable (but certainly not huge
Hi,
I'm having some trouble with a sizable (but certainly not huge)
multi-row insert statement. I can successfully execute the query with
up to 7365 rows, but any more and it fails (ERROR 2006: MySQL server has
gone away). More complete info:
Total working query size: 1047426 bytes
, kayamboo wrote:
Thanks a lot Chris
It worked for me.
But I refered somewhere , that using excessive index will eat up resources.
So is it mandatory to use index even if I am not using them for something
like search?
regards
Kayamboo Suresh
- Original Message -
From: Chris
You need to escape the ' mark in your string. The query should be:
update vbooth_data set optionText='Not at all, I''m waiting for the
other shoe to drop' where (pollID=34 AND voteID=3);
Note the '' within the string: the first tick escapes the second one.
If you're more comfortable with
I can't have a wildcard for the user statement below?
Thanks
-Original Message-
From: Chris Tucker [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 25, 2002 6:58 PM
To: Adam Ryan
Cc: [EMAIL PROTECTED]
Subject: Re: Allowing a whole class C to access mysql server?
GRANT
Actually, you should be able to get the data in one query: in general,
any time you are doing a restriction on some value being in a set of
values (such as order_id not in some list built from a subselect) you
can rewrite the query using LEFT OUTER JOIN's. In this case, the
solution would be
GRANT SELECT ON db.* TO user@'192.168.1.0/255.255.255.0'
should do the trick: you just specify the IP you want to allow and the
netmask to apply to it after the /. You could also use:
GRANT SELECT ON db.* TO user@'192.168.1.%'
as documented in the manual
(http://www.mysql.com/doc/en/GRANT.html).
22 matches
Mail list logo
