Re: TINYINT(1) vs ENUM?

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, etc. * Philip Molter * Texas.Net Internet * http://www.texas.net

Cannot create InnoDB table

. 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.net/ * [EMAIL PROTECTED] -- MySQL General Mailing List

Re: MySQL 3.23.56 Memory Usage Problem

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 * Texas.net Internet * http

InnoDB Assertion Error

itself, but that should be allowed, no? Thanks for any assistance. Philip * Philip Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php

Transaction History Logging

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 * http://www.texas.net/ * [EMAIL PROTECTED

Disable autocommit by default

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 PROTECTED

Error compiling 3.23.53

] Error 1 make[2]: Leaving directory `/tmp/mysql-3.23.53/strings' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/tmp/mysql-3.23.53' make: *** [all-recursive-am] Error 2 sql, query * Philip Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED

More Detailed EXPLAIN

, 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/ * [EMAIL PROTECTED

Re: MySQL/InnoDB-4.0.4 is released

and : 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 Molter

Re: 3.23.52 hangs sometimes

. * 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 request

Re: Deleting foreign keys with Innodb tables

your posts rejected because you didn't use one of *two* keywords. * Philip Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: MySQL: Problem Installing on RH 7.3

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/ * [EMAIL PROTECTED

Re: MySQL: Problem Installing on RH 7.3

, 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.texas.net/ * [EMAIL PROTECTED

Replication from InnoDB - MyISAM

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.'). * Philip Molter

Re: Replication from InnoDB - MyISAM

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 to replicate : one

Keyfile size

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.texas.net/ * [EMAIL

Re: Keyfile size

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't find any documentation about

Re: Keyfile size

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, but I can't find any

Re: innodb rollbacks

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.texas.net/ * [EMAIL

Disable replication from command line

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) http

Re: Qoute

: newsgroup='$group'); : $sth - execute; Try: $sth = $dbh-prepare( 'SELECT expiration FROM newsgroups WHERE newsgroup=?' ); $sth-execute( $group ); ... * Philip Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED

Optimizing InnoDB tables

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 PROTECTED

Re: Upgrade of mySQL on a Red Hat 7.2 - box

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.texas.net/ * [EMAIL PROTECTED

Re: Pre-release of MySQL 3.23.50

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 * Texas.net

Re: Msql-Mysql install problem...

. Thanks, Philip sql, query, mysql * Philip Molter * Texas.net Internet * http

Re: Foreign keys in mysqldump?

for 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

Re: Double foreign key references?

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 it's

Re: Double foreign key references?

(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) http://lists.mysql.com/ (the list archive

Re: quick questions about redhat and mysql

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 verified for the specific RedHat version. * Philip

Double foreign key references?

: 150) mysql * 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

Disabling foreign keys

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 PROTECTED

Re: current development

, : 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 check: http

Re: innoDB confusion

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 we can recreate just fine. * Philip Molter * Texas.net Internet * http

Re: FOREIGN KEYs and ALTER 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://www.mysql.com/manual.php

Re: FOREIGN KEYs and ALTER TABLE

select * from parent; ++-+ | id | id2 | ++-+ | 10 | 0 | | 20 | 0 | ++-+ 2 rows in set (0.00 sec) mysql select * from child; +--+---+ | id | parent_id | +--+---+ |5 |10 | +--+---+ 1 row in set (0.00 sec) * Philip Molter

FOREIGN KEYs and ALTER TABLE

. * 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 request

Re: MyISAM/InnoDB/Oracle comparison, and a InnoDB table locking question

these 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/ * [EMAIL PROTECTED

Re: Problems in Foreign Key Syntax

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/ (the list

Re: Table Locking...

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/ (the list archive

Re: Help! Inserts way too slow in big db

. 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 PROTECTED

Re: InnoDB still gives poor analysis to the optimizer

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

Re: InnoDB still gives poor analysis to the optimizer

, 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] - Before posting

InnoDB still gives poor analysis to the optimizer

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. * Philip Molter * Texas.net Internet

Re: How Huge of your mySQL database or table in your former Instance

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/ * [EMAIL PROTECTED

Re: MySql forum or newsgroup

. 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 PROTECTED

Re: MySql forum or newsgroup

* 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] - Before posting, please check

Re: Default 1 == Default 16777216?

On Wed, Dec 12, 2001 at 02:35:15PM +0200, Sinisa Milivojevic wrote: : Philip Molter writes: : Description: : : When I do this: : :mysqlcreate table test_default ( testint int not null default 1 ); :mysqldesc test_default; : : I get

Re: Default 1 == Default 16777216 ?

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 Internet * http

Default 1 == Default 16777216?

correctly? How-To-Repeat: See above Fix: Don't know. I'm looking for verification that the problem exists. Submitter-Id: submitter ID Originator: Philip Molter Organization: Texas.Net MySQL support: none Synopsis: Default 1 == Default 16777216 Severity: serious Priority: medium

Re: Default 1 == Default 16777216?

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 PROTECTED

Default 1 == Default 16777216 ?

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) http://lists.mysql.com

Re: Default 1 == Default 16777216 ?

if there 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/ * [EMAIL PROTECTED

Re: New binary installation problems.

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/ * [EMAIL

Keeping track of database changes

, 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://lists.mysql.com

Re: Hacked Servers

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. * Philip Molter * Texas.net

Re: compile problems on Solaris8

. That would be where I would start. * 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

Re: java.util.Date, jdbc, and DATETIME

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.net * http

Re: InnoDB??

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 check: http://www.mysql.com

Re: fulltext indexes for innodb?

: (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/ * [EMAIL PROTECTED

Re: MySQL Web Site Changes

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.php (the manual) http://lists.mysql.com