gs is that if you
insert a value that isn't one of your ENUM values (say someone
inserts a '2' instead of a '0' or '1', a blank string ('') is
entered instead. That's no better than someone actually entering
a '2'.
MySQL, SQL, query,
me InnoDB files,
I can create the table just fine. Why does it keep telling me that
it cannot create the table because of "Duplicate key on write or
update"?
The MySQL version os 4.0.15a. The operating system is Solaris 9.
Philip
* Philip Molter
* Texas.Net Internet
* http://www.texas.ne
IA for any suggestions/help!
That's not MySQL causing the problem, that's Linux's memory
management. Of course, in your data below, you have 60MB of used
swap, not 60GB.
If you want to track the issue with Redhat, check out bug 89226 on
their bugzilla website.
* Philip Molter
*
) REFERENCES `tx.contact` (`contact_id`)
) TYPE=InnoDB;
Backing out to the old version works fine. The only glaringly
obvious thing I see there is a table putting a foreign key onto
itself, but that should be allowed, no?
Thanks for any assistance.
Philip
* Philip Molter
* Texas.net Internet
* h
on would probably
be much busier, but for some things, the binlog just doesn't contain
enough information to logically say, "Okay, this is the change that
was made and this was what was changed as a result."
Thanks,
Philip
* Philip Molter
* Texas.net Internet
*
ose spawned
by perl through DBD::mysql?
3) Is there a list of all the possible config options for the
my.cnf file somewhere?
Thanks,
Philip
sql, mysql
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTEC
-x86.s", line 3 : Illegal mnemonic
"strings-x86.s", line 3 : Illegal mnemonic
"strings-x86.s", line 3 : Illegal mnemonic
"strings-x86.s", line 3 : Illegal mnemonic
"strings-x86.s", line 3 : Illegal mnemonic
"st
tch on keys, and
then sift out the rows that don't pass the MOD() or is it going to
join t2 -> t1, sift out the MOD() entries, then join t3 into the
mix on the remaining rows?
sql, query
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
: MySQL-Max.
:
: Release 4.0.4-beta is mainly a bug fix release.
Will the bugfixes for this release (not necessarily the new/updated
features) be backported to the 3.23.x series? Given that MySQL 4
isn't marked as stable yet, many of us using InnoDB no doubt still
use 3.23.x.
* Philip M
).
Do some more research.
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
at handled this. Check the RH bug reports.
The fix is simply to change owner/groups on the necessary
files/directories.
But Trond can give you specifics. It still may be user error. :)
: I do have the /var/lib/mysql/mysql.sock file...
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [
riber only. I realize that
it may discourage some people from asking for help, but it's
definitely more discouraging to have your posts rejected because
you didn't use one of *two* keywords.
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
-
#x27;s the RPMs from RH, have you tried /etc/init.d/mysqld start?
That's the standard way of starting services on RH. Have you looked
in /var/log/mysqld.log for any errors?
* Philip Molter
* Texas.net Internet
* http://www.t
committed transactions.
: - Original Message -
: From: "Philip Molter" <[EMAIL PROTECTED]>
: Newsgroups: mailing.database.mysql
: Sent: Monday, July 15, 2002 5:55 PM
: Subject: Replication from InnoDB -> MyISAM
:
:
: > I have a 3.23.51 server with InnoDB tables. I want t
there shouldn't
be an issue with invalid data appearing in my MyISAM tables. Can
I expect any problems with this setup?
sql, query, stupid filter (perhaps the filter can be expanded to
look for common MySQL words, like 'MyISAM, InnoDB, 3.23.x etc.').
On Mon, Jul 08, 2002 at 09:50:43AM -0500, Dan Nelson wrote:
: In the last episode (Jul 08), Philip Molter said:
: > I have a MySQL server that has hit it's keyfile size limit
: > (apparently 64M). I can't believe that a value this low would be the
: > absolute limit, b
On Mon, Jul 08, 2002 at 09:38:56AM -0500, Paul DuBois wrote:
: At 8:45 -0500 7/8/02, Philip Molter wrote:
: >I have a MySQL server that has hit it's keyfile size limit (apparently
: >64M). I can't believe that a value this low would be the absolute
: >limit, but I can'
I have a MySQL server that has hit it's keyfile size limit (apparently
64M). I can't believe that a value this low would be the absolute
limit, but I can't find any documentation about increasing this
size. How do I do it?
* Philip Molter
* Texas.net Internet
* http://www.texa
;s a pain in the
ass using the InnoDB table monitor simply because it dumps so much
output into the log files. There are times when we just want to
grab the status at a particular moment, like how one would do SHOW
TABLE STATUS or SHOW PROCESSLIST.
* Philip Molter
* Texas.net Internet
* http://www
auses MySQL to not start up.
Thanks,
Philip
MySQL, SQL, database
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
: $sth = $dbh -> prepare ("SELECT expiration from newsgroups WHERE
: newsgroup='$group'");
: $sth -> execute;
Try:
$sth = $dbh->prepare( 'SELECT expiration FROM newsgroups WHERE newsgroup=?' );
$sth->execute( $gro
E?
I ask because I have a long-running database and as records are
getting inserted and deleted, system CPU usage is slowly climbing,
presumably because MySQL is doing more work to look up information.
Thanks,
Philip
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROT
tandard installation methods rather than
using the outside RPMs.
It'd be great if MySQL released RPMs specifically for RedHat systems
that integrate with the system according to the standards that RH
has defined for their various versions.
* Philip Molter
* Texas.net Internet
* http://www.texa
d gcc compiler
: we used couldn't compile with an alternative glibc library).
Does this affect people who compile MySQL on their own on Linux?
If I have my RH7.2 box and I compile my own version of MySQL, am
I going to hit these memory corruption issues?
sql, query, mysql
* Philip Molter
*
s') mail clients is extremely hard to
follow.
Thanks,
Phili
taking the time to implement that.
Speaking of InnoDB development, what is the status on the InnoDB
backup utility?
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
-
Before posting, please check
ld2)
references test_bk(fld));
Query OK, 0 rows affected (0.01 sec)
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
On Fri, Jan 25, 2002 at 01:25:10PM -0600, Philip Molter wrote:
: I have a table with two fields that reference the same field in
: another table. Is this allowed (I'm not sure if it is). mysql
: 3.23.46 allows this, but apparently, mysql 3.23.47 does not. Create
: it with just one key and
#x27;t create table './test/test_fk.frm' (errno: 150)
mysql>
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the ma
y
difference I can see is that RH's compiles it to work with different
(read: standard RH) filesystem layouts, uses the standard RH
initialization files, and has some RH-tuned config files. They're
not patching the source at all, and my understanding is that the
compile options are verifi
Is there a way to disable foreign keys temporarily? Specifically,
I'm running 3.23.47 with InnoDB tables, and I need to periodically
dump and reload a table that has foreign key dependencies on it.
Thanks,
Philip
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROT
is missing,
: cascading deletes and this stuff.
With InnoDB, FK support is in the 3.23.x branch. That's a stable branch.
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
-
Before posting, please
a big deal if
it doesn't. That's why God gave us backups, after all.
I know oftentimes, when we're doing testing with very large tables,
rather than go through the hassle of cleaning stuff out, we just
drop the .frm files, which causes InnoDB to "lose" the tables.
Then
| parent_id |
+--+---+
|5 |10 |
+--+---+
1 row in set (0.00 sec)
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
-
Before posting, please check:
http://www
CREATE every table in the key chain
to get it done properly. Is that how that's supposed to work?
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
-
Before posting, please check:
http://w
ready.
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To re
things? What is
a "big enough" log file? Honestly, on a lot of stuff, I'm just
guessing, but it takes a lot of time to fiddle with values, clean
out the database, and then shove in 1 million rows to see the
results.
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [
don't quote me on that.
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
drawbacks, just differences.
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (t
n listings.
What version of MySQL are you using, what kind of system are you
running on, and what kind of table handler (MyISAM, InnoDB, BDB,
etc.) are you using for this table?
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL
NALYZE TABLE
isn't an option under InnoDB (although sometimes, it appears to
help).
This stuff is shifting back and forth, and it's *VERY FAR* off when
it shifts the wrong way. My question is "Why?"
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
On Mon, Dec 17, 2001 at 10:03:58PM -0600, Philip Molter wrote:
: Is there any upcoming fix for this recurring problem? The table
: handler is just giving poor data to the optimizer and the optimizer
: is making bad decisions because of it. It appears to come and go,
: depending on data that is
k around .41 or .42.
This isn't really something a bug report can be filed on, because
it seems to be the result of a varying data group and InnoDB's
corresponding analysis, but if there's some bit of data that will
help short of the data in my database, I'll gladly pass it on.
*
tables with details ?
:
: How about a table with 260 million rows? We've got one that is very,
: very quick for indexed selects.
How quick is it for inserts? And what table type?
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
*
ss they follow both, which is even more time-consuming). Is
that a *better* form of support? I would argue no, and since a
solution is easily envisioned, why wouldn't one choose to go with
it?
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
--
pport. There's
already archives of the mailing list, and it sounds like what people
want is the functionality of the mailing list without the inbox
clutter.
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL
On Wed, Dec 12, 2001 at 02:35:15PM +0200, Sinisa Milivojevic wrote:
: Philip Molter writes:
: > >Description:
: >
: > When I do this:
: >
: > mysql>create table test_default ( testint int not null default 1 );
: > mysql>desc t
ly an endism problem.
You are correct, sir. It's an endian issue.
Hopefully, that can get fixed in either the next release or in my
build process somewhere.
MySQL, database, and other spam-detection words.
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL
that
I'm just not doing correctly?
>How-To-Repeat:
See above
>Fix:
Don't know. I'm looking for verification that the problem exists.
>Submitter-Id:
>Originator: Philip Molter
>Organization: Texas.Net
>MySQL support: none
>Synopsis: Default 1 == Def
tried using 0x1, and the default is still set to 16777216 (and
values get input with that value as well).
Can anyone else verify that this is the case? I'm seeing it both
with MyISAM tables and InnoDB tables, so I doubt it's a table
handler.
* Philip Molter
* Texas.net Inter
e was an
: 'endism' problem.
No, the client is on the same machine as the database.
MySQL, database, and help
Maybe that will get me by the spam-filter.
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [
mething obvious that
I'm just not doing correctly?
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
ht
t how redhat does things. They're crazy like that. They
also have more money than you or I, so they can do what they please.
You should have an /etc/my.cnf file. You can edit the location of
various files/directories in that file.
* Philip Molter
* Texas.net Internet
* http://www.texas.net
y on each table, including timestamps of
said changes.
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://
nd copying
the mysql/ tables, though. They're probably tainted.
The only way you're going to be sure that your box is safe is if
you wipe and reinstall. Most hacker kits will install backdoors
and exploitable holes. Using a hacked server is just a risk to
everything you do.
* Phili
g dealt with is very simple. Perhaps, for some reason, that
simple program isn't being compiled correctly. Test and see.
That would be where I would start.
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
mp( 4, new Timestamp( myDate.getTime() ) );
The JDBC standard is for setDate() to store only DATE information. To
set the entire timestamp, you need to use setTimestamp, which takes a
java.sql.Timestamp instance. You can still fetch with getDate( int ),
though.
* Philip Molter
* DataFoundry.
ance is incredible.
It's young, though. Bugs are still being found and not everything is
implemented perfectly yet.
* Philip Molter
* DataFoundry.net
* http://www.datafoundry.net/
* [EMAIL PROTECTED]
-
Before posting, please
e done it the near future
: (unless a customer would like to pay for the feature, of course).
How much would such a feature cost? Would the MySQL development team
implement that or Heikki?
* Philip Molter
* DataFoundry.net
* http://www.datafoundry.net/
27;s put in the word 'MySQL' to get around the spam filters.
Thanks,
Philip
* Philip Molter
* DataFoundry.net
* http://www.datafoundry.net/
* [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual
| pt.logtype,plf.type
||1 | |
+---++--+-+-+-+--+-+
Thank you in advance for any insights,
Philip
* Philip Molter
* DataFoundry.net
* http://www.datafoundry.net/
* [EMAIL PROTECTED]
-
Before posting, please check:
h
61 matches
Mail list logo