Re: FreeBSD 4.9 + MySQL 4.0 + LinuxThreads

Alas, when I tried the binary version, it gave me an error that google helped link me to the following: Fatal error 'Can't create gc thread' at line ? in file /usr/src/lib/libc_r/uthread/uthread_create.c (errno = ?) mysqld got signal 6;

Re: Advise on High Availability configuration

No, when we implemented high-availability MySQL servers we used MySQL's inbuilt replication - this has been running here for years now and we have had constant DB availability during that time, even though individual machines have failed now and again. We're using 2 masters 4 slaves with

Re: Advise on High Availability configuration

On Mon, Feb 02, 2004 at 09:17:08AM +0100, A.J.Millan wrote: No, when we implemented high-availability MySQL servers we used MySQL's inbuilt replication - this has been running here for years now and we have had constant DB availability during that time, even though individual machines have failed

Re: Why does MySQL generate internal foreign key id when constrain name

Philip, - Original Message - From: Philip Walden [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Monday, February 02, 2004 3:39 AM Subject: Why does MySQL generate internal foreign key id when constrain name I am using MySQL 4.1.1-1. When I add a named foreign key

ANN: Database Workbench 2.4.2 released

Ladies, gentlemen, Upscene Productions is happy to announce the next version of the popular database development tool: Database Workbench 2.4.2 has been released today! Download a trial at: http://www.upscene.com Features and fixes: http://www.upscene.com/news/20040202.htm Database Workbench

Re: SQL select help required please

I am trying to create a html search results page with the following: SELECT * FROM tbl_allarticles WHERE (fld_headline LIKE'%userinput%' OR fld_summary LIKE'%userinput%' OR fld_body LIKE'%userinput%') AND fld_category LIKE 'catvalue' The above works fine, but the below code is giving me some

Re: Can't create/write to file './pricelists/iiptest.frm'

Louie Miranda [EMAIL PROTECTED] wrote: What is wrong with this? im just trying to copy the table to another table? ## MySQL said: #1 - Can't create/write to file './pricelists/iiptest.frm' (Errcode: 28) ## $ perror 28 Error code 28: No space left on device -- For technical

Re: ORDER BY may remove result rows

[EMAIL PROTECTED] wrote: Description: Instead of ordering rows, ORDER BY may remove rows How-To-Repeat: CREATE TABLE T ( Id INTEGER NOT NULL, Id2 INTEGER NOT NULL, Val FLOAT NOT NULL, Id3 INTEGER NOT NULL, KEY Key2 (Id2, Val), KEY Key3 (Id3) ); INSERT INTO T VALUES(1,3,-12,4);

Re: Performance Problem

Mike, Ronan, You haven't given us much to go on. I´m sorry. Is this application running on a web server? Yes, but in a diferent machine connecting via TCP/IP. 1) How many rows are your queries returning? (on average) and how long does it take? Hmmm... Most of the queries are

Re: Privileges By Groups

Ed Reed [EMAIL PROTECTED] wrote: Is there any way to assign Privileges to databases/tables/fields via Groups rather than user by user? Nope. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __

Re: Performance Problem

Mike, Ronan, If your queries are only returning fewer than a hundred rows, and if every join is indexed, I would have expected it to take only a second or two at most. I´m sorry, but I´m not so good in SQL queries, rather joins. If my queries are taking about 15 seconds instead of

Re: Please help with check syntax

Aaron P. Martinez [EMAIL PROTECTED] wrote: I am trying to set up a table from a script that came with some software Value accounting/CRM and i'm getting a few errors, one of which i can't seem to figure out/fix. My system is RH 3.0 ES with mysql-server-3.23.58-1. I have innodb tables

RE: Advise on High Availability configuration

Hi, OK - I'll try to explain in as much detail as I can.. We have redhat linux apache webservers running our apps with fcgi (which uses persistant DB connections). We have about 8 of these. It's important to understand that our MySQL system is optimised for a read-heavy / write-light site

Re: Query time out during login over network

Chris W [EMAIL PROTECTED] wrote: I have recently installed suse 9.0 linux which has MySQL 4.0.15 as part of the distribution. After I set up my users I was able to use mysqldump and pipe it into mysql on my windows machine running 4.0.16 to dump a database to the suse box. However, now

4.0.17-pc-linux-i686

The daemon will not start because the socket file cannot be created.. permissions are set properly running red hat 9 Thank you, Chris

FULLTEXT Index under InnoDB

Is there any plan to introduce FULLTEXT indices under InnoDB table types? Regards, Hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

AES_ENCRYPT returned value

Hi, What's the best data type to store AES_ENCRYPTed text/password (without any data conversion)? I believe it can't be stored in CHAR or VARCHAR due to implicit internal conversions. Thanks. Hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

any ideas about it

Hi all, I m looking for any function or a work around to fetch numerical data without its sign (-10 -- 10, 10 -- 10). Any ideas? Thanx

Re: commit,buffers

Jamie Murray [EMAIL PROTECTED] wrote: Hi Guys, How can I disable autocommit in the database. Can this only be done per session as opposed to having it done globally at the database level. You can turn off autocommit only per session. Last where can I get a complete list and explanation of

Re: any ideas about it

On Mon, Feb 02, 2004 at 07:16:13PM +0530, Nitin Mehta wrote: Hi all, I m looking for any function or a work around to fetch numerical data without its sign (-10 -- 10, 10 -- 10). Any ideas? ABS() : mysql select abs(-10); +--+ | abs(-10) | +--+ | 10 | +--+

Re: any ideas about it

Nitin Mehta [EMAIL PROTECTED] wrote: Hi all, I m looking for any function or a work around to fetch numerical data without its sign (-10 -- 10, 10 -- 10). Any ideas? There is ABS() function in MySQL: http://www.mysql.com/doc/en/Mathematical_functions.html -- For technical support

Figured it out

Hey, The daemon will not start because the socket file cannot be created.. permissions are set properly running red hat 9 Pounded on it some more and figured out what was going on. It is all good now. Thanks /chris

Re: FULLTEXT Index under InnoDB

Hassan Shaikh [EMAIL PROTECTED] wrote: Is there any plan to introduce FULLTEXT indices under InnoDB table types? Full-text search is in the InnoDB TODO list: http://innodb.com/todo.html But it's a long-term goal. -- For technical support contracts, goto

Re: FULLTEXT Index under InnoDB

At 08:51 AM 2/2/2004, you wrote: Hassan Shaikh [EMAIL PROTECTED] wrote: Is there any plan to introduce FULLTEXT indices under InnoDB table types? Full-text search is in the InnoDB TODO list: http://innodb.com/todo.html But it's a long-term goal. If anyone has the cash to sponsor the

Re: AES_ENCRYPT returned value

At 07:20 AM 2/2/2004, you wrote: Hi, What's the best data type to store AES_ENCRYPTed text/password (without any data conversion)? I believe it can't be stored in CHAR or VARCHAR due to implicit internal conversions. Thanks. Hassan Hassan, I haven't tried it, but can't you use Binary in

Re: 5.0 replication and stored procedure

I can dupicate this everytime. I have just opened a bug. Bill Andrew Braithwaite wrote: Hi, 5.0 is sub-alpha at the moment. If you think there is a problem, go to http://bugs.mysql.com/ Cheers, Andrew -Original Message- From: William Au [mailto:[EMAIL PROTECTED] Sent: Friday 30

Re: Replication with HEAP tables slave insert error

Vinod Panicker [EMAIL PROTECTED] wrote: Hi, Had a query regarding replication with HEAP tables. It seems like I cannot use LOAD DATA FROM MASTER to update the stopped slave with data from the master since it apparently works only for MyISAM tables. Any other way of updating the slave with

query the data of a fulltext index directly from index?

Hello, is there any way to get the fulltext index contents directly? I'm looking for a way to list all indexed words from a column to provide a filter selection. How can I access the index data without walking through all table rows, get the column and tokenize and collect words? Thanks, Alex

RE: Advise on High Availability configuration

Andrew Braithwaite wrote: Each slave keeps a heartbeat to the master and in the event of a failure, changes it's master to master2. So how does this bit work? If one master falls over and slaves move to master two, how do you rebuild master one without downtime? Don't the slaves try and use

Re: query the data of a fulltext index directly from index?

In the last episode (Feb 02), Alexander Bauer said: Hello, is there any way to get the fulltext index contents directly? I'm looking for a way to list all indexed words from a column to provide a filter selection. How can I access the index data without walking through all table rows, get

AUTO_INCREMENT in InnoDB

I can't drop the table. Can't I do without dropping the table? Hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Trouble with correlated subquery

Hello, I am having a problem with this correlated sub query. I get a syntax error at the second SELECT. This is part of a larger query with other aggregated sub queries or I would consider a JOIN instead. I tried running the sub query by itself and it works. I tried LEAST for MIN, same result.

RE: Advise on High Availability configuration

Hello All: Thank you for all the advise provided on this issue. Much appreciate Andrew's detailed answers and alternate solution. I will investigate the Replication method and try to devise some strategy to make sure that the Slave mirrors the Master as closely as possible. Also taking

Re: query the data of a fulltext index directly from index?

Hi! On Feb 02, Alexander Bauer wrote: Hello, is there any way to get the fulltext index contents directly? I'm looking for a way to list all indexed words from a column to provide a filter selection. How can I access the index data without walking through all table rows, get the column

Bug Fix - mysql control center

When adding an entry to an existing table in any database, when pressing the tab button at the last column of any table, the column loses focus and then pressing tab once more makes the window for the table close and the entry is not added to the database ( ie: the focus should wrap around to the

User Variables in SELECT statement and LIKE syntax

These are the statements that are currently giving me the problems. SELECT @main_id:=ID, @FCSecID:=FCSecID, @Periodicity:=Periodicity, @EOP:=EOP FROM main_data_temp WHERE checked=0 ORDER BY fcsecid ASC LIMIT 1; SELECT * FROM actuals WHERE [EMAIL PROTECTED] AND Period LIKE '[EMAIL PROTECTED]'; #

MYSQL (SQL ERROR)

Hi, I'm using Win2k,Apache,PHP(V4) and mysql . When I'm running php page ,noticing error Notice: Undefined variable. Let me know how to fix pl? thx -seena - Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it!

DOES MYSQL HAS CONCEPT OF SYNONYM

Does anyone know if MySQL has the concept of Synonyms, as Oracle does? Raza -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: DOES MYSQL HAS CONCEPT OF SYNONYM

NOT DIRECTLY but if you're using (my)isam you can create softlinks on the underlying filesystem which is a really ugly hack but seems to work. Sid Lane DBA - Site Operations TWCi |-+ | | Ansari, Raza| | | \(GEI,

RE: Oracle Question

-Original Message- From: Ken Brown [mailto:[EMAIL PROTECTED] Sent: Saturday, January 31, 2004 11:45 AM To: '[EMAIL PROTECTED]' Subject: Oracle Question Anyone managed to get oracle forms 6i to talk to MySQL - if so how? I've got ODBC working but it will not connect and the ODBC

mysql command line syntax

Why does the following command, entered as a single line at a bash prompt, prompt me to enter more? mysql -u user -ppass -D database -e 'select field into outfile \'/tmp/field.1\' from mytable where id = 1;' And is there any way to supress the 300 lines of useless usage that accumpanies

LIMIT not working problem

This query is working fine apart from the LIMIT part. I cant see what is wrong with it, I have tried it in different places and still no luck. Does anybody know why its not working? WHERE (fld_headline LIKE'%userinput%' OR fld_summary LIKE'%userinput%' OR fld_body LIKE'%userinput%') AND

RE: Multiple mysql servers with the same datadir

Hi, Andrew. Thank you very much for your explanation. And yes, I actually wanted to mean BDB, instead of DBD. I just checked BDB document. It seems they maintain their own locks. So my two cases will lead to data corruption. I wonder if there are any database management systems implementing

Re: LIMIT not working problem

Limit needs to be the last line in your query Original Message On 2/2/04, 1:55:13 PM, Matthew Stuart [EMAIL PROTECTED] wrote regarding LIMIT not working problem: This query is working fine apart from the LIMIT part. I can't see what is wrong with it, I have tried it in different places

Re: LIMIT not working problem

Matthew Stuart wrote: This query is working fine apart from the LIMIT part. I cant see what is wrong with it, I have tried it in different places and still no luck. Does anybody know why its not working? WHERE (fld_headline LIKE'%userinput%' OR fld_summary LIKE'%userinput%' OR fld_body

mysql deny access to datasource

I am running a web application under tomcat 4.03, and using a database pooling class (below) and all works well. That is until I update a class file. After I update a class file, then I get the error below stating the deny access to datasource. Does anyone know why this happens. I printed to

ERROR 1205: Lock wait timeout exceeded; Try restarting transaction

I did similar insert minutes ago with no problems. Now I try to do the same insert just with differnet parameters and got such error message. insert into users(first_name, last_name) values('john', 'smith'); ERROR 1205: Lock wait timeout exceeded; Try restarting transaction Any ideas how to fix

RE: Multiple mysql servers with the same datadir

Hi, But when runing multiple myisam enable-external-locking database servers with the same NFS datadir, will there be any deadlock problems? I have no experience in this but it sounds like it may cause problems. I wonder if it is possible to use NFS as the storage backend and to provide

PHP AND MYSQL

Hi, Does any one develop any web pages with PHP,Apache,Win2k,Mysql ? If so,can please help me. When I 'm inserting data thru html FORM ,getting error Notice: Undefined variable: like this.Can some one please send some tips pl? Html code: form action=insert.php method=post Software id: input

Re: PHP AND MYSQL

This is probably something for the php list, however, how is REGISTER_GLOBALS set on your server? On or off? It is off by default on newer version of PHP. (has been for a while.) If it is off you need to grab the vars from post like: $softwareid = $_POST[softwareid]; $manufacturer =

Re: PHP AND MYSQL

Seena, I believe that the proper syntax is --- mysql_connect( host, username,password) Also I generrally when passing variables use $_POST['name'] --- $_POST['version'] Good luck, Nestor :-) Seena Blace wrote: Hi, Does any one develop any web pages with PHP,Apache,Win2k,Mysql ? If so,can

RE: Advise on High Availability configuration

Hi, So how does this bit work? If one master falls over and slaves move to master two, how do you rebuild master one without downtime? Don't the slaves try and use Master 1 as soon as it's back online even though its data is out of sync? If master 1 fails and the slaves move to master 2,

RE: PHP AND MYSQL

PHP has changed their superglobals, no longer can you just put a $ infront of the assigned name attribute. (You can change this in the php.ini file, but it's discouraged) Instead use $_GET['name'] Or $_POST['name'] So for $manufacturer $_POST['manufacturer'] -Original Message- From:

[Stats] MySQL List: January 2004

-- Searchable archives for this list are available at http://www.listsearch.com/mysql.lasso --

Re: PHP AND MYSQL

Thank you very much to all. Jason Burfield [EMAIL PROTECTED] wrote:This is probably something for the php list, however, how is REGISTER_GLOBALS set on your server? On or off? It is off by default on newer version of PHP. (has been for a while.) If it is off you need to grab the vars from post

MySql and Oracle Forms 6i

Is there any way of using MySql as a back end to Oracle Forms? Ken Desperately trying to justify not going back to oracle db Brown

FW: starting a crashed mysqld

The RAID that we used to hold our mysql data was crashed a few days ago. Although it is fine now (after switching to the secondary host connector), we can't seem to start the mysqld. We tried to start the server using the various innodb_force_recovery options (1-6) with no luck. Below is the

My.cnf

I have copied my-large.cnf to /etc/my.conf Mysql 4 on OS X server How can I tell these new settings are in effect? What settings were run prior to this file being in place as there was no my.cnf? -- - Scott Haneda

RE: My.cnf

-Original Message- From: Scott Haneda [mailto:[EMAIL PROTECTED] Sent: Monday, February 02, 2004 6:13 PM To: MySql Subject: My.cnf I have copied my-large.cnf to /etc/my.conf Mysql 4 on OS X server How can I tell these new settings are in effect? What settings were run prior

Re: mysql command line syntax

hi, you can try something like this mysql --force -uuser -ppass -Ddatabase -equery.sql where you can put all your SQL commands into to file named query.sql - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 02, 2004 8:38 PM Subject: mysql command

Re: starting a crashed mysqld

Rusma, below it crashes because several data pages are corrupt. You can try starting it on level 6 and dump your tables. Then recreate your InnoDB data files and ib_logfiles and import the table dumps. Since the corruption is extensive, you are probably not able to dump all your data, though.

Re: MySql and Oracle Forms 6i

Someone posted an answer: Oh wow... I can't think of how you'd get that to work without a ton of custom. For starters, you'll have to write your own transactional triggers and intercept every one of Oracle's select, lock, update, insert, delete, like On-Lock, On-Insert, etc. since Forms will want

max key length 500 in myisam index

I've got to create a table that has the following: CREATE TABLE access ( query VARCHAR(255) NOT NULL, INDEX (query) ); and mysql is telling that the max bytes allowed is 500 for key length. The docs say I can change this by recompiling, which I would like to avoid having to do. Is there any

Runtime Error '-214767259'

Hi all, help me pls, I try to connect to Mysql server, but it raise runtime error -214767259, Host C-Xeon is not allowed to connect to this MYsql server thanks a lot - Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it!

Create users : with password

I spend some time to figure how to add users with passwords, but have problem with following: Adding user with password: PROBLEM When I insert users to database: insert into user

Database problem.

I hope you can help me with this: Incorrect information in file: './sarara/searchindex.frm' Error consulta SQL : SHOW KEYS FROM `searchindex` MySQL ha dicho: #1033 - Incorrect information in file: './sarara/searchindex.frm' How can I fix this??? Thanks

InnoDB rollback

I just had a script fail unexpectedly and now I've got a couple hundred thousand undo entries rolling back. Yes, I realize that I should be committing smaller groups--my bad. I was really hoping to restart my server tonight to change some server parameters, but a rollback like this will take

connection problems

I am getting the following log entry when ever I try to connect to mysql from the network. mysqld[2857]: refused connect from 192.168.1.28 This is on an SuSE 9.0 linux box and I haven't enabled any firewall yet so I don't know why this would be happening. Any ideas? Chris W -- MySQL General

RE: Replication with HEAP tables slave insert error

Hi Egor, Thanks for the reply. My responses below - Vinod Panicker [EMAIL PROTECTED] wrote: Hi, Had a query regarding replication with HEAP tables. It seems like I cannot use LOAD DATA FROM MASTER to update the stopped slave with data from the master since it apparently works only

{Virus?} TEST

Warning: This message has had one or more attachments removed Warning: (doc.zip). Warning: Please read the VirusWarning.txt attachment(s) for more information. test This is a message from the MailScanner E-Mail Virus Protection Service

disabling wait_timeout?

Can it be done? I tried to disable this timer with wait_timeout = 0 in my.cnf. That changed the timeout (as reported by mysqladmin variables) from the default 28800 to 1. Tested, it was definitely a one-second timeout :-( As a hack-around, I've currently got it set to ten days.