Re: Problem starting up mysql

I installed mysql 4.0.14 binary distribution on RedHat 8.0 following the instructions in the manual. But I can't get it to work. Please help. When I start mysql using the command: shell bin/mysqld_safe --use=mysql the following message shows: Starting mysqld daemon with databases

Re: Table corruption using DISABLE/ENABLE KEYS

Hi! On Sep 09, [EMAIL PROTECTED] wrote: I'm using MySQL v4.0.12 on Redhat Linux 9.0 I have a python script (using the MySQLdb module) that inserts a large batch of records to several MyISAM tables. The largest table (named 'log') has 20 columns. A single column defines the primary key.

replication blues

Hi everyone, So, back to the problems with auto_increment columns and replication problems. I have noticed this problem always occures when using INSERT SELECT syntax with an auto_increment key simple example: CREATE TABLE test1 (value INT); INSERT INTO test1 SET value=1; INSERT INTO

Re: INNODB data porting problem.

Hi , It seems there's a problem while the database is getting dumped coz it gives an error saying that it was unable to create a particular .frm file. Can't seem to figure out the reason. Any help would be really welcome. Could there be a possible problem because of the foreign key constraints

Re: Unable to Create DB Connection

Scott D. Spiegler [EMAIL PROTECTED] wrote: I am using the binary distribution of mySQL for Windows-2000 and am not able to connect to the DBserver. I used the Setup executable to install the application. I verified that the my.ini file was created and contained appropriate information. But,

replication BUG

I have 2 servers: one asd master, second as a slave 1) I start master 2) start slave 3) stop slave 4)start slave 5)stop slave 6)start slave and i have errors as below. C:\mysql4\binmysqld-max-nt --defaults-file=../my_slave.cnf --standalone --c onso le 030909 18:23:19 InnoDB: Started 030909

Re: INNODB data porting problem.

Barry [EMAIL PROTECTED] wrote: It seems there's a problem while the database is getting dumped coz it gives an error saying that it was unable to create a particular .frm file. Can't seem to figure out the reason. Any help would be really welcome. Could there be a possible problem because

Re: Upgrade from 3.22 to 4.0

David B. Held [EMAIL PROTECTED] wrote: Egor Egorov [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] [...] Do you lose all your databases and tables or tables of the database 'mysql'? Do you have databases directories and files of tables in these dirs? Never mind. Apparently,

Re: Problem with MySQL 4.0.14 - Server Crash

[EMAIL PROTECTED] wrote: I upgrade try to upgrade from MySQL 4.0.12 to 4.0.14 in Linux but it doesn't work. MySQL always crashs with error 11 Segmentation fault. I don't know why but I try to dump database (about 200,000 lines) and install MySQL 4.0.14 windows version and try to import

Re: INNODB data porting problem.

In that case I have to write the foreign key checks all over again in the new DB. Also doen't it create the a MyISAM DB when we remove the foreign key checks. What I am looking at is an exact replica of the INNODB database. Is it possible ? Regards Barry - Original Message - From:

MySQL C API

Hello All, I am trying to compile a Ansi-C program using the MYSQL_STMNT* mysql_prepare(...) function, but the function can't be found.. I have the following MySQL rpm's installed on my Linux machine, have I missed anyone? MySQL-client-4.0.14-0.i386.rpm MySQL-devel-4.0.14-0.i386.rpm

RE: MySQL C API

whats the error u get? -Original Message- From: Håkan Medin [mailto:[EMAIL PROTECTED] Sent: 10 September 2003 10:31 To: [EMAIL PROTECTED] Subject: MySQL C API Hello All, I am trying to compile a Ansi-C program using the MYSQL_STMNT* mysql_prepare(...) function, but the function can't

Re: Problem with MySQL 4.0.14 - Server Crash

Hi! On Sep 10, Victoria Reznichenko wrote: [EMAIL PROTECTED] wrote: I upgrade try to upgrade from MySQL 4.0.12 to 4.0.14 in Linux but it doesn't work. MySQL always crashs with error 11 Segmentation fault. I don't know why but I try to dump database (about 200,000 lines) and install

Re: Backing up all MySQL DBs

On Tue, Sep 09, 2003 at 06:47:52AM -0700, Will Glass-Husain wrote: There's also # backup databases for dbname in `echo 'show databases;' | mysql -u$dbuser -p$dbpassword` do echo Backing up database $dbname... $destdir/backup.log mysqldump -u$dbuser

INDEXes on BLOB Columns

If I: ADD COLUMN Text (BLOB) And then INDEX (Text(10)) Will that index be beneficial if I am search for 10 characters only or anything 10 characters or less? Thanks in advance! Best Regards, Andrew Sql, query -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: [SQL] foreign key from a table to the *same* table

Alberto, you are probably using an old version of InnoDB. http://www.innodb.com/ibman.html#InnoDB_foreign_keys A deviation from SQL standards: if ON UPDATE CASCADE or ON UPDATE SET NULL recurses to update a table for which there already is an update operation in the stack of cascaded

IF, THEN ELSE statement

I am trying to update/insert a record into the table depending on whether it exists in the table or not. Something along the lines of... IF (SELECT id FROM myable WHERE id=myid) INSERT INTO mytable(id,name) VALUES (myid, myname) ELSE UPDATE mytable SET name=mynewname WHERE id =

Re: IF, THEN ELSE statement

See the REPLACE command: http://www.mysql.com/doc/en/REPLACE.html --- I am trying to update/insert a record into the table depending on whether it exists in the table or not. Something along the lines of... IF (SELECT

AW: IF, THEN ELSE statement

Hi Rob, i think to use REPLACE would do, if there is a unique index on myid: REPACE mytable (myid, myname) VALUES (myid, mynewname); The Manual say in chapter 6.4.8: REPLACE works exactly like INSERT, except that if an old record in the table has the same value as a new record on a UNIQUE index

RE: MySQL C API

Håkan- The prepared statement capability isn't available until 4.1 (I believe). Best of luck, Regards, Rick -Original Message- From: Håkan Medin [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 4:31 AM To: [EMAIL PROTECTED] Subject: MySQL C API Hello All, I am trying to

Configuration File Creation - Automatic or manual?

All, A little confused about what creates configuration (my.cnf) files. I'm running MacOS X 10.2 (Jaguar) running MySQL 4.0.x. I was looking for the global and server level configuration files in the following directories: Global - /etc/my.cnf Server - /mysql/data/my.cnf I was unable to locate

Suboptimal index-usage with FULLTEXT-search

Hi! I'm running a large web application with MySQL 4.0.14. The application is performing searches in a large table (500.000 rows). The WHERE-clause for these searches sometimes is a combination of different columns in the table, and I have noticed some very sub-optimal index-usage when the search

IP Address Conversion

All - We're using MySQL under Linux to store data collected during network tests. One of our columns store the integer representation (in network byte order) of an IP address. Is there any current support in MySQL (or future planned support) to convert from the integer representation of an IP

Re: IP Address Conversion

Hi, On Wed, Sep 10, 2003 at 09:07:30AM -0400, Mark Riehl wrote: All - We're using MySQL under Linux to store data collected during network tests. One of our columns store the integer representation (in network byte order) of an IP address. Is there any current support in MySQL (or future

Re: IP Address Conversion

Have you seen the functions INET_NTOA() anf INET_ATON)? http://www.mysql.com/doc/en/Miscellaneous_functions.html All - We're using MySQL under Linux to store data collected

Re: Suboptimal index-usage with FULLTEXT-search

Hi! On Sep 10, Tobias Lind wrote: Hi! I'm running a large web application with MySQL 4.0.14. The application is performing searches in a large table (500.000 rows). The WHERE-clause for these searches sometimes is a combination of different columns in the table, and I have noticed some very

RE: Unable to Create DB Connection

Did you set up a my.ini file in your Windows directory? If so, what is in the file? -Original Message- From: Scott D. Spiegler [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 10:24 AM To: Christensen, Dave; '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: RE: Unable to

MySQL ssl Q

Hey, I am trying to test mysql moniter ssl connection. I've compiled ssl support into MySQL server and client, and I am using version 4.0.14. In my.cnf global file, I have --ssl-cert, --ssl-ca, --ssl-key set for the server and the client. I grant some users to use require ssl, but I am

Re: MySQL C API

At 10:30 +0200 9/10/03, Håkan Medin wrote: Hello All, I am trying to compile a Ansi-C program using the MYSQL_STMNT* mysql_prepare(...) function, but the function can't be found.. This function is one of those use for handling prepared statements. They're not available until 4.1, as indicated

Re: Configuration File Creation - Automatic or manual?

Adam: You create the configuration files ... the MySQL distribution has samples (my-huge.cnf, my-large.cnf, etc.) which you should edit to make sure settings are appropriate for your needs. Gerald Jensen - Original Message - From: Fortuno, Adam [EMAIL PROTECTED] To: [EMAIL PROTECTED]

FW: MySQL database help

-Original Message- From: Watter [mailto:[EMAIL PROTECTED] Sent: den 10 september 2003 17:45 To: [EMAIL PROTECTED] Subject: MySQL database help Dear Sir, I know your email add. from mysql.com. If you know how to solve this problem, please teach me. your reply will be

ERROR 1030: Got error 127 from table handler

/usr/local/mysql/bin/perror 127 Error code 127: Unknown error 127 127 = Record-file is crashed I've been getting this allot lately from mysql-3.23.54-57. Things that are not the cause: - mySQL has not been improperly shut down - threads are not being killed off Pattern emerged: High

RE: ERROR 1030: Got error 127 from table handler

hows u're disk space? -Original Message- From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] Sent: 10 September 2003 19:11 To: [EMAIL PROTECTED] Subject: ERROR 1030: Got error 127 from table handler /usr/local/mysql/bin/perror 127 Error code 127: Unknown error 127 127 =

RE: ERROR 1030: Got error 127 from table handler

FilesystemSize Used Avail Use% Mounted on /dev/sda5 97G 9.0G 82G 10% Plenty of disk space. ---Original Message- --From: Tom Roos [mailto:[EMAIL PROTECTED] --Sent: Wednesday, September 10, 2003 10:23 AM --To: Dathan Vance Pattishall; [EMAIL PROTECTED]

Re: ERROR 1030: Got error 127 from table handler

What kernel are you running? Also, try increasing the max open tables. That might help. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: Dathan Vance Pattishall [EMAIL PROTECTED] To: 'Tom Roos' [EMAIL PROTECTED]; [EMAIL PROTECTED]

RE: ERROR 1030: Got error 127 from table handler

I'm running RedHat 7.3 distro with 2.4.18-4smp #1 SMP The table in questions is -rw-r-1 mysqlmysql8.9k Jul 26 00:23 hasit.frm -rw-r-1 mysqlmysql994M Sep 10 09:59 hasit.MYD -rw-r-1 mysqlmysql681M Sep 10 09:59 hasit.MYI my my.cnf

Re: INDEXes on BLOB Columns

At 5:29 -0400 9/10/03, Andrew Kuebler wrote: If I: ADD COLUMN Text (BLOB) And then INDEX (Text(10)) Will that index be beneficial if I am search for 10 characters only or anything 10 characters or less? Thanks in advance! If those characters occur at the beginning of column values, yes. -- Paul

Re: ERROR 1030: Got error 127 from table handler

Are you running linux and is it SMP? Kernel version plz.. On Wed, 10 Sep 2003, Dathan Vance Pattishall wrote: /usr/local/mysql/bin/perror 127 Error code 127: Unknown error 127 127 = Record-file is crashed I've been getting this allot lately from mysql-3.23.54-57. Things that are not

Re: Problems with compiling MySQL

OK Daniel, thanks for your tips. They made the errors dissapear...but a new one appeared in return : again, the configure is going fine. Here's what I typed on the command line: # CFLAGS=-O3 # CXX=gcc # CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti # export CFLAGS CXX

Re: ERROR 1030: Got error 127 from table handler

On Wed, Sep 10, 2003 at 10:11:15AM -0700, Dathan Vance Pattishall wrote: /usr/local/mysql/bin/perror 127 Error code 127: Unknown error 127 127 = Record-file is crashed I've been getting this allot lately from mysql-3.23.54-57. Things that are not the cause: - mySQL has not been

Re: ERROR 1030: Got error 127 from table handler

I have been getting the same error every so often. It is only on a machine that does about 900 queries per second average. I am running a 2.4.20 kernel with MySQL 4.0.14. This only happens with MYISAM tables and only ones with high INSERTs and SELECTs. It seemed to get better after increasing

RE: ERROR 1030: Got error 127 from table handler

Well I don't feel that 4.0.x is mature enough for my environment quite yet, although some replication features are actually needed (2 threads are better then one). I might do a small deploy for some search system and even ratio of write / read systems. Yahoo uses 4.0.x right? Have any show

Re: Problem with MySQL 4.0.14 - Server Crash

Victoria, Thanks. -- __ Sign-up for your own personalized E-mail at Mail.com http://www.mail.com/?sr=signup CareerBuilder.com has over 400,000 jobs. Be smarter about your job search http://corp.mail.com/careers -- MySQL General Mailing

MySQL 4.0.15 has been released

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL 4.0.15, a new version of the popular Open Source/Free Software Database, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://www.mysql.com/downloads/ and mirror sites.

Re: ERROR 1030: Got error 127 from table handler

On Wed, Sep 10, 2003 at 11:01:00AM -0700, Dathan Vance Pattishall wrote: Well I don't feel that 4.0.x is mature enough for my environment quite yet, although some replication features are actually needed (2 threads are better then one). I might do a small deploy for some search system and

installation question...missing 'host.frm'

I am trying to install: mysql-standard-4.0.14-sun-solaris2.8-sparc.tar on a Solaris 8 system. I am getting this message in the .err file: 030910 11:05:41 mysqld started 030910 11:05:41 InnoDB: Started 030910 11:05:41 Fatal error: Can't open privilege tables: Can't find file:

How identify long running query etc?

Using MySQL and InnoDB, are there system tables or other tools that I can use to see which statements that are executing have consumed the most CPU time and find out which user, transaction and/or connection those statements belong to? If I identify a user that is causing a problem is there a way

Mysql bug

Hello, I can't connect to mysql, the message is : can't connect problem with /var/lib/mysql.sock or something like that (sorry i forgot to write it and actually also have problems to connect with ADSL to internet under Linux so i send you this from windows). Can you help me ? Thanks.

How to enable General Query_log?

Dear list friends: I`d like to get your help about this issue. I have a Linux box RedHat 7.3 running the MySQL v3.23.56. In this box I`m running a TACACS server for authenticating my users to access to cisco routers. TACACS is using a Mysql database where i configured the user accounts,

RE: How identify long running query etc?

mysqladmin proc mysqladmin kill ${Id} // The id that is causing the problem ---Original Message- --From: Bill Todd [mailto:[EMAIL PROTECTED] --Sent: Wednesday, September 10, 2003 11:51 AM --To: MySQL List (E-mail) --Subject: How identify long running query etc? -- --Using MySQL and

RE: Mysql bug

Not a bug look /etc/my.cnf Your default sock file might be in /tmp and the client is configure to look at /var/lib/mysql ---Original Message- --From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] --Sent: Tuesday, September 09, 2003 2:08 PM --To: [EMAIL PROTECTED] --Subject: Mysql bug --

RE: installation question...missing 'host.frm'

Craig, Errno 13 indicates that you have some permission issues. Check the data directories you've set up to make sure that they are owned by the user/group mysql. -Original Message- From: Craig A. Finseth [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 1:42 PM To: [EMAIL

FW: upgrade from 3.22 to 3.23 File Not Found

All, I have an older installation mysql 3.22 (hpux 10.20) that I'm trying to get to 4.0 but first I must go to 3.23. When going to 3.23 I get an error indicating File not found or can't open after a couple of queries are run. I've looked at the documentation and determined that I must have a

How to enable General Query_log?

Dear list friends: I`d like to get your help about this issue. I have a Linux box RedHat 7.3 running the MySQL v3.23.56. In this box I`m running a TACACS server for authenticating my users to access to cisco routers. TACACS is using a Mysql database where i configured the user accounts,

Foreign key update?

I see there is a way to DELETE or NULL a cascade, but is there a way to UPDATE? Here's what I mean. Given these rough table schemas. I'd like to be able to UPDATE the company_code in the company_table, and have it update the same rep_company_code in the rep_table. Ie. So a company has a certain

RE: Foreign key update?

What most data structures do is use foreign keys to the unique numerical id column, in your case, company_id. That way, if the company code changes, the id does not, and therefore, no issues on update... -Original Message- From: Daevid Vincent [mailto:[EMAIL PROTECTED] Sent:

Re: installation question...missing 'host.frm'

Errno 13 indicates that you have some permission issues. Check the data directories you've set up to make sure that they are owned by the user/group mysql. Thank you. That was the problem. The host.frm really threw me. Craig -- MySQL General Mailing List For list archives:

MySQL/InnoDB-4.0.15 is released

Hi! InnoDB is a MySQL table type which provides transactions, row level locking, foreign key constraints, and a non-free hot backup tool. InnoDB is included in all MySQL-4.0 and MySQL-4.1 downloads from http://www.mysql.com. MySQL-4.0 is the stable version which is recommended for production

How to enable General Query_log?

Dear list friends: I`d like to get your help about this issue. I have a Linux box RedHat 7.3 running the MySQL v3.23.56. In this box I`m running a TACACS server for authenticating my users to access to cisco routers. TACACS is using a Mysql database where i configured the user accounts,

mysqldev user ?

All, I recently updated the RPM files on my Linux box to 4.0.15 ... During the update, I received the following error : warning: user mysqldev does not exist - using root warning: user mysqldev does not exist - using root Can someone please explain to me what this user is and what it's

How To Create Users In MySQL?

I have the MySQL-3.23.55 installed in my PC. Therefore, I am the DBA without the required DBA knowledge. First, how do I create users in the MySQL database? Second, how do I grant table creation privilege to users? Is GRANT ALL PRIVILEGES ON databasename TO someuser IDENTIFIED BY 'somepassword';

Is the table cache used with InnoDB?

I cannot tell from the Reference Manual whether the table cache is used with the InnoDB database engine or not? It sounds like it only applies to tables that are stored in separate disk files. Is the table cache used by InnoDB? Bill -- MySQL General Mailing List For list archives:

Re: mysqldev user ?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Wed, 10 Sep 2003, Jason Frisvold wrote: I recently updated the RPM files on my Linux box to 4.0.15 ... During the update, I received the following error : warning: user mysqldev does not exist - using root warning: user mysqldev does

RE: How To Create Users In MySQL?

not to respond with, 'read the manual', but There is an entire section of the manual devoted to user management, I would start at www.mysql.org click on the documentation link on top, and start there... (user account management is :

Re: Problems with compiling MySQL

People, I've found the solution. It appears that the math_iso.h is a header file provided by SUNWlibm. Installed the package and tried again. It doesn't fail at the same point. At this moment, the make is still running, so far so good. Cheers, Andy OK Daniel, thanks for your tips. They

Re: mysqldev user ?

Jason- Login as root then issue grant statements on the priveleges to assign to the new user http://www.mysql.com/doc/en/Adding_users.html -Martin - Original Message - From: Jason Frisvold [EMAIL PROTECTED] To: mySQL Listserv [EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 1:23 PM

Re: Is the table cache used with InnoDB?

Bill, - Original Message - From: Bill Todd [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Wednesday, September 10, 2003 11:39 PM Subject: Is the table cache used with InnoDB? I cannot tell from the Reference Manual whether the table cache is used with the InnoDB database

Re: How identify long running query etc?

On Wed, Sep 10, 2003 at 11:50:43AM -0700, Bill Todd wrote: Using MySQL and InnoDB, are there system tables or other tools that I can use to see which statements that are executing have consumed the most CPU time and find out which user, transaction and/or connection those statements belong to?

Re: mysqldev user ?

On Wed, 2003-09-10 at 16:36, Lenz Grimmer wrote: -BEGIN PGP SIGNED MESSAGE- warning: user mysqldev does not exist - using root warning: user mysqldev does not exist - using root This is a warning, not an error. Did the install continue? Where exactly did you get this message? Does

How to enable General Query_log?

Dear list friends: I`d like to get your help about this issue. I have a Linux box RedHat 7.3 running the MySQL v3.23.56. In this box I`m running a TACACS server for authenticating my users to access to cisco routers. TACACS is using a Mysql database where i configured the user accounts,

More problems during make of mysql

Hello people, here I am, again... I run into the next problem during the make. It runs for quite some time, when suddenly these messages appear: ld: fatal: library -lrt: not found ld: fatal: library -ldl: not found ld: fatal: library -lpthread: not found ld: fatal: library -lthread: not found

Re: Foreign key update?

Daevid Vincent [EMAIL PROTECTED] wrote: I see there is a way to DELETE or NULL a cascade, but is there a way to UPDATE? ON UPDATE CASCADE, ON UPDATE SET NULL. Look at: http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html Here's what I mean. Given these rough table

Re: Innodb crash under Win2000

Rafa, I analyzed now the latest hex dumps. The first error looks like that the peco/lincompras index ArtPrvFec tree is broken. The child page number is 0x041d, but the parent has a pointer to page 045d. In the error printout below the secondary index record contains a primary key column

record_rnd_buffer_size

http://www.mysql.com/doc/en/SHOW_VARIABLES.html states that record_rnd_buffer_size When reading rows in sorted order after a sort, the rows are read through this buffer to avoid a disk seeks. Can improve ORDER BY by a lot if set to a high value. As this is a thread-specific variable, one should

How to enable General Query_log?

Dear list friends: I`d like to get your help about this issue. I have a Linux box RedHat 7.3 running the MySQL v3.23.56. In this box I`m running a TACACS server for authenticating my users to access to cisco routers. TACACS is using a Mysql database where i configured the user accounts,

RE: Unable to Create DB Connection

Hi Dave, --- Christensen, Dave [EMAIL PROTECTED] wrote: Did you set up a my.ini file in your Windows directory? If so, what is in the file? I found the problem about why I was not able to get my WinMySQLadmin tool to start the service. My my.ini contents are below this email the password x'd

Re: How to enable General Query_log?

At 17:07 10/9/2003 -0400, [EMAIL PROTECTED] wrote: Hi, Notice the option syntax --log: /usr/local/mysql/libexec/mysqld --log=/usr/local/mysql/var/mysqlquery.log -uroot 030910 20:03:54 InnoDB: Started /usr/local/mysql/libexec/mysqld: ready for connections. Version: '4.0.15-debug-log' socket:

how to do a random ORDER BY in a SELECT statement

I am querying a table and using the following statement: SELECT * FROM financial_affiliates WHERE state = 'wa' AND category = '3' ORDER BY name I would like to ORDER BY RANDOM - is there an easy way to do that. Thanks. -Doug

Question about InnoDB and external locking

Hi All; First of all, I think this will probably be a question for Heikki. If I remember correctly, InnoDB and the MySQL external locking flag are unrelated as InnoDB tables are unaffected by external locks. Now the question: is it possible for two MySQL servers to access the same tablespace in

Re: how to do a random ORDER BY in a SELECT statement

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Doug -- ...and then Comcast said... % % I am querying a table and using the following statement: % % SELECT * FROM financial_affiliates WHERE state = 'wa' AND category = '3' ORDER BY name % % I would like to ORDER BY RANDOM - is there an easy way

Re: how to do a random ORDER BY in a SELECT statement

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Doug, et al -- ...and then David T-G said... % % ...and then Comcast said... % % % % I would like to ORDER BY RANDOM - is there an easy way to do that. % ... % I don't know if you can select random() like you can select count() but % perhaps you

FULLTEXT feature requests

The only reason that we are unable to use a stock build of mysql is because 1) we use GWS_FREQ as our GWS_IN_USE, not GWS_PROB 2) we have a custom stopword list Is there any reason that these two settings, like FT_MIN_WORD_LENGTH, cannot be moved to runtime-configurable params? Obviously,

RE: how to do a random ORDER BY in a SELECT statement

Comcast, Simply order by the random function, RAND(). For example: SELECT aff.* FROM financial_affiliates AS aff WHERE aff.state = 'wa' AND aff.category = '3' ORDER BY RAND(); Regards, Adam -Original Message- From: Comcast [mailto:[EMAIL PROTECTED] Sent: Wednesday,

Re: Getting the primary key in an update query

* Daniel Rossi Hi there i was wondering if there was anyway to determine the primary key field instead of explicitly setting it in an update sql query ? for instance i'd like to go update table *** where primarykey=1 instead of where id=1 as the primary key is named differentrly for each

Re: record_rnd_buffer_size

At 3:33 PM -0700 9/10/03, Dathan Vance Pattishall wrote: http://www.mysql.com/doc/en/SHOW_VARIABLES.html states that record_rnd_buffer_size When reading rows in sorted order after a sort, the rows are read through this buffer to avoid a disk seeks. Can improve ORDER BY by a lot if set to a high

RE: Foreign key update?

Thanks Victoria for the pointer. I should have looked there first. Duh! Now for the help... I tried: ALTER TABLE rep_table ADD FOREIGN KEY (`rep_company_code`) REFERENCES `company_table` (`company_code`) ON UPDATE CASCADE; But get ERROR 1216: Cannot add a child row: a foreign key constraint

RE: Foreign key update?

Well, okay I just answered part of my own solution... SET FOREIGN_KEY_CHECKS=0; ALTER TABLE rep_table ADD FOREIGN KEY (`rep_company_code`) REFERENCES `company_table` (`company_code`) ON UPDATE CASCADE; SET FOREIGN_KEY_CHECKS=1; Allowed that to happen. I'm afraid to try the self referencing

Re: FULLTEXT feature requests

Hi Shane, - Original Message - From: Shane Allen Sent: Wednesday, September 10, 2003 7:16 PM Subject: FULLTEXT feature requests The only reason that we are unable to use a stock build of mysql is because 1) we use GWS_FREQ as our GWS_IN_USE, not GWS_PROB Why is that exactly...? To

Re: Getting the primary key in an update query

that works cheers Roger Baklund [EMAIL PROTECTED] 09/11/03 10:48am * Daniel Rossi Hi there i was wondering if there was anyway to determine the primary key field instead of explicitly setting it in an update sql query ? for instance i'd like to go update table *** where primarykey=1

set auto commit

when is it a good time to do the set auto commit=0 , while doing the update or insert query or sometime before that in the application ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]