Re: MySQL 3.23.56 Memory Usage Problem

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 *

Cannot create InnoDB table

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

Re: TINYINT(1) vs ENUM?

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,

Error compiling 3.23.53

-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

Disable autocommit by default

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

Transaction History Logging

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 *

InnoDB Assertion Error

) 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

Re: Foreign keys in mysqldump?

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: Msql-Mysql install problem...

s') mail clients is extremely hard to follow. Thanks, Phili

Re: Pre-release of MySQL 3.23.50

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 *

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

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

Optimizing InnoDB tables

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

Re: Qoute

: $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

Disable replication from command line

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)

Re: innodb rollbacks

;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

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

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'

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, b

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.').

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 t

Re: MySQL: Problem Installing on RH 7.3

#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

Re: Deleting foreign keys with Innodb tables

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] -

Re: MySQL: Problem Installing on RH 7.3

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

InnoDB and table optimization?

| 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

Re: MySQL Web Site Changes

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

Re: fulltext indexes for innodb?

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/

Re: InnoDB??

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

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

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.

Re: compile problems on Solaris8

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]

Re: Hacked Servers

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

Keeping track of database changes

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://

Re: New binary installation problems.

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

Default 1 == Default 16777216 ?

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

Re: Default 1 == Default 16777216 ?

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

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 Inter

Default 1 == Default 16777216?

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

Re: Default 1 == Default 16777216?

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

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: : > : > mysql>create table test_default ( testint int not null default 1 ); : > mysql>desc t

Re: MySql forum or newsgroup

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

Re: MySql forum or newsgroup

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] --

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

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

InnoDB still gives poor analysis to the optimizer

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

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 that is

Re: InnoDB still gives poor analysis to the optimizer

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]

Re: Help! Inserts way too slow in big db

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

Re: Table Locking...

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

Re: Problems in Foreign Key Syntax

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/

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

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

FOREIGN KEYs and ALTER TABLE

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

Re: FOREIGN KEYs and ALTER TABLE

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

Re: FOREIGN KEYs and ALTER TABLE

| 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

Re: innoDB confusion

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

Re: current development

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

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 PROT

Re: quick questions about redhat and mysql

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

Double foreign key references?

#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

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

Re: Double foreign key references?

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

Re: 3.23.52 hangs sometimes

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

Re: MySQL/InnoDB-4.0.4 is released

: 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

More Detailed EXPLAIN

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/