Re: Background tasks performed by MySQL?

2005-11-21 Thread Remigiusz Sokołowski
Viktor Fougstedt wrote: Hi, and thank you both for valuable tips. The MySQLd in question runs on a mailserver, and a large amount of processes (Postfix, Maildrop and Squirrelmail) connect to it, run one or two simple queries, and then disconnects. There is only one client that is

Re: Assigment sign not work on Delphi

2005-11-21 Thread Leo
cmiiw, dont you think you are supposed to pass the query as string in delphi??? somewhat like this : querystr:='SELECT @TOTAL:=PRICE * QTY FROM INV_PRODUCT'; mysql_query(@mysqlconnection,PChar(querystr)); ... etc ... so delphi will ignore the second ':=' because it's in a string, not an

Re: Regarding SET FOREIGN_KEY_CHECKS=0;

2005-11-21 Thread Heikki Tuuri
Noga, if SET FOREIGN_KEY_CHECKS=0 affects other connections to the database, that is a serious bug. If you can repeat the problem, please file a bug report to bugs.mysql.com I tested this with 5.0.15, and it worked ok: Connection 1: [EMAIL PROTECTED]:~/mysql-5.0.15/client$ ./mysql test

Need Perfomance / Tuning Help

2005-11-21 Thread Marco Schierhorn
Hey, we´ve a site ( PHP ) where several 1.000 are online at the same time. They´re running many sql statements. Is there a way to find out which statements take a full table scan to optimize them ? And i need some help with configuring the my.cnf. Below you´ll find our one. Which options

Re: SSH tunnel for Mysql

2005-11-21 Thread Gleb Paharenko
Hello. You have not specified what operating system you're using. MySQL manual has some notes for Windows: http://dev.mysql.com/doc/refman/5.0/en/windows-and-ssh.html Jerry Swanson wrote: How to create ssh tunnel for Mysql? TH -- For technical support contracts, goto

Re: SQL_CALC_FOUND_ROWS

2005-11-21 Thread Gleb Paharenko
Hello. data, if may grow, I like the cleanness of the SQL_CALC_FOUND_ROWS, however, currently, it is only saving me code, not performance. Often it is ok to have more complex code to get better performance. You should decide what is important for you - clearness of the code, or speed

Re: Need Perfomance / Tuning Help

2005-11-21 Thread Gleb Paharenko
Hello. Is there a way to find out which statements take a full table scan to optimize them ? See: http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html Marco Schierhorn wrote: Hey, we´ve a site ( PHP ) where several 1.000 are online at the same time. They´re running many

RE: Regarding SET FOREIGN_KEY_CHECKS=0;

2005-11-21 Thread Noga Woronoff
Hi Heikki - I tested the two connections in MySQL 4.0.26 and got the same results as you did: Connection 1: mysql create table t(a int primary key) type = innodb; Query OK, 0 rows affected (0.13 sec) mysql create table t2(a int primary key, foreign key (a) references t(a)) type = innodb; Query

Re: MySQL installation problems.

2005-11-21 Thread Gleb Paharenko
Hello. Is this a clean new install of MySQL, or you have already installed MySQL instance? Please provide more information about your OS version (I guess it is Windows, isn't it?). May be some tips from the manual could be helpful:

Re: Fwd: which release of Mysql is compatible with fedora core3 ?

2005-11-21 Thread Gleb Paharenko
Hello. i have fedora core3 installed on my system. which release of Mysql is compatible with fedora core3 ? MySQL should be suitable for most modern Linux distributions (I'm not sure if FC3 still supported). Use 5.0.15. Have a look here as well:

Perfomance / Optimize ( Full Table Scans ) and Help with my.cnf

2005-11-21 Thread ESV Media GmbH
Hey, we´ve a site ( PHP ) where several 1.000 are online at the same time. They´re running many sql statements. Is there a way to find out which statements take a full table scan to optimize them ? We´ve a cpu percentage of nearly 50 % with only 30 Members online. And i´ve seen that there are

trouble with deleting a user

2005-11-21 Thread ali asghar torabi parizy
hi to all i have a problem when i trying to delet a user by drop user directive *** drop user atp; Can't drop one or more of the requested users *** i add this user by crant: *** GRANT ALL PRIVILEGES ON *.* TO

Re: Regarding SET FOREIGN_KEY_CHECKS=0;

2005-11-21 Thread Heikki Tuuri
Noga, yes, the setting SET FOREIGN_KEY_CHECKS=0 is per session. If it is somehow 'inherited' to another session, that is a serious bug. Best regards, Heikki Oracle Corp./Innobase Oy InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for

RE: Regarding SET FOREIGN_KEY_CHECKS=0;

2005-11-21 Thread Noga Woronoff
Hi Heikki - Thank you. The issue is apparently in the JBoss-MySQL session management in our application. Regards - Noga -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED] Sent: Monday, November 21, 2005 8:16 AM To: Noga Woronoff Cc: mysql@lists.mysql.com; Jim Kan; Kevin

Re: Regarding SET FOREIGN_KEY_CHECKS=0;

2005-11-21 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Noga Woronoff wrote: Hi Heikki - I tested the two connections in MySQL 4.0.26 and got the same results as you did: Connection 1: mysql create table t(a int primary key) type = innodb; Query OK, 0 rows affected (0.13 sec) mysql create

Installation help ...!

2005-11-21 Thread Paul_Swingewood
Hello. I am a complete newbie here and to the world of Linux MySQL. I am trying to create a LAMP server I have installed RedHat Enterprise Linux AS 4 - update 2 on my server and it seems to work ok. I downloaded MySQL 5.0 and now want to install that I read somewhere that I need to

RE: Regarding SET FOREIGN_KEY_CHECKS=0;

2005-11-21 Thread Noga Woronoff
Hi Mark. Thank you. Your explanation describes the situation we are dealing with. I will let our chief architect Jim Kan take it from here. Regards - Noga -Original Message- From: Mark Matthews [mailto:[EMAIL PROTECTED] Sent: Monday, November 21, 2005 8:31 AM To: Noga Woronoff

Index of JOINed table?

2005-11-21 Thread Jonathan Mangin
I have a simple query, (part of a union). calendar is a table of only dates, `date` as PK. sales has a multi-col index on (date, uid). (select calendar.date as date, time_format(time(sales.date),'%H:%i') as time, from calendar left join sales on date(sales.date) =

How to adjust the row id after modifying the tabel

2005-11-21 Thread Xiaobo Chen
Hi, all I follow the example: CREATE TABLE animals ( id MEDIUMINT NOT NULL AUTO_INCREMENT, name CHAR(30) NOT NULL, PRIMARY KEY (id) ); INSERT INTO animals (name) VALUES ('dog'),('cat'),('penguin'), ('lax'),('whale'),('ostrich'); SELECT * FROM animals; The thing is that

re: how am I missing this key

2005-11-21 Thread James Black
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Using mysql 5.0.15 my query gets a result of Unknown column 'i.rid' in 'on clause' There is actually a complete query, but this is a snippet, as the selects with subqueries I don't believe will cause the problem. When I changed c.rid=i.rid to

Re: SSH tunnel for Mysql

2005-11-21 Thread Jerry Swanson
Both Linux computers. On 11/21/05, Gleb Paharenko [EMAIL PROTECTED] wrote: Hello. You have not specified what operating system you're using. MySQL manual has some notes for Windows: http://dev.mysql.com/doc/refman/5.0/en/windows-and-ssh.html Jerry Swanson wrote: How to create

re: how am I missing this key

2005-11-21 Thread SGreen
James Black [EMAIL PROTECTED] wrote on 11/21/2005 09:39:32 AM: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Using mysql 5.0.15 my query gets a result of Unknown column 'i.rid' in 'on clause' There is actually a complete query, but this is a snippet, as the selects with subqueries I

Re: Index of JOINed table?

2005-11-21 Thread Jonathan Mangin
- Original Message - From: Jonathan Mangin [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, November 21, 2005 8:48 AM Subject: Index of JOINed table? I have a simple query, (part of a union). calendar is a table of only dates, `date` as PK. sales has a multi-col index on

dump to more than 1 file

2005-11-21 Thread Tom Brown
is it possible to do a mysql dump to more than 1 file? We will shortly be needing to dump a db that will be in excess of 50gb so will encounter file size issues This is on 4.1.x and rhel 4 thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Index of JOINed table?

2005-11-21 Thread Michael Stassen
Jonathan Mangin wrote: I have a simple query, (part of a union). calendar is a table of only dates, `date` as PK. sales has a multi-col index on (date, uid). (select calendar.date as date, time_format(time(sales.date),'%H:%i') as time, from calendar left join sales on

RE: dump to more than 1 file

2005-11-21 Thread ISC Edwin Cruz
Mysqldump has where condition, you may have to segment your data and dump it in diferents files Mysqldump --where='date between \'dateStart\' and \'dateFinish\' ' (for example) See full documentation at: http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html Regards!! Edwin Cruz

Re: Installation help ...!

2005-11-21 Thread Tom Brown
Hello. I am a complete newbie here and to the world of Linux MySQL. I am trying to create a LAMP server I have installed RedHat Enterprise Linux AS 4 - update 2 on my server and it seems to work ok. I downloaded MySQL 5.0 and now want to install that I read somewhere that I need to

Re: How to adjust the row id after modifying the tabel

2005-11-21 Thread Michael Stassen
Xiaobo Chen wrote: Hi, all I follow the example: CREATE TABLE animals ( id MEDIUMINT NOT NULL AUTO_INCREMENT, name CHAR(30) NOT NULL, PRIMARY KEY (id) ); INSERT INTO animals (name) VALUES ('dog'),('cat'),('penguin'), ('lax'),('whale'),('ostrich'); SELECT * FROM

Re: trouble with deleting a user

2005-11-21 Thread Michael Stassen
ali asghar torabi parizy wrote: hi to all i have a problem when i trying to delet a user by drop user directive *** drop user atp; Can't drop one or more of the requested users *** i add this user by crant: ***

Re: dump to more than 1 file

2005-11-21 Thread sheeri kritzer
The output of mysqldump is standard output, not a file. You can pipe it into another program, or redirect the output to a file, but mysqldump does not make a file. Therefore, there is no option in mysqldump to make more than 1 file. How is your database stored on disk? The documentation Edwin

RE: mysqld crash with archive engine 2gb

2005-11-21 Thread Marc Rossi
David - Sorry for the delayed response. ulimit is unlimited. I am using the RPMs for RH EL3 downloaded from a mirror so I would assumed they have been built to allow 2GB archives. I am most likely going a different route at this point as my query response time is much too slow even with a 1GB

Re: trouble with deleting a user

2005-11-21 Thread Gleb Paharenko
Hello. What version of MySQL are you using? In MySQL 5.0.15 it works fine: mysql GRANT ALL PRIVILEGES ON *.* TO 'atp'@'%' IDENTIFIED BY 'nowayforyou' WITH GRANT OPTION; Query OK, 0 rows affected (0.00 sec) mysql drop user atp; Query OK, 0 rows affected (0.00 sec) See:

Re: upgrade RH 7.3

2005-11-21 Thread Gleb Paharenko
Hello. we would like to upgrade to 4.1.15, which I believe is the current stable release, 5.0.15 is stable as well, and, in my opinion, it is better to upgrade to it (though 4.1.15 of course). Bug database might be helpful to find some RH related issues: http://bugs.mysql.com

Re: mysql_fix_privileges

2005-11-21 Thread Gleb Paharenko
Hello. mysql_fix_privileges usually modifies grant tables to make them compatible with new features of a new version. From my experience MySQL will perfectly run without this. If I do a dump of mysql database will it be enough?meaning if there is any problem during the execution of the

Re: Perfomance / Optimize ( Full Table Scans ) and Help with my.cnf

2005-11-21 Thread sheeri kritzer
I suggest checking out your slow query logs: http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html the queries are logged, so going into a client and running an explain on the slow queries should help you out. -Sheeri On 11/21/05, ESV Media GmbH [EMAIL PROTECTED] wrote: Hey, we´ve a site

MySQL 5.0.16 has been released

2005-11-21 Thread Joerg Bruehe
Hi, MySQL 5.0.16, a new GA/production version of the popular Open Source Database Management System, has been released. The Community Edition is now available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/downloads/ and mirror sites.

Can't materialize a view -- bug?

2005-11-21 Thread Nick Arnett
I'm doing the equivalent of a materialized view in MySQL 5.0.15 and I've hit a strange error. Here's the scenario. CREATE OR REPLACE VIEW x_view AS SELECT [select statement, blah, blah, blah]; DROP TABLE IF EXISTS x_mview; CREATE TABLE x_mview SELECT * FROM x_view; That was all working fine

Re: moving the datadir

2005-11-21 Thread Rajesh Olafson
Thanks Gleb. I get the exact same results when I connect with: # mysql -u=root --- Maybe a different issue but, for some reason I can't connect with # mysql --user=root ^^^ ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) but I can with: # mysql -user=root

UDF

2005-11-21 Thread Ronan Lucio
Hello, I´m using MySQL-4.1.7 and I need to create a UDF. For all I have understood, I need to create it in C/C++ sintaxe. My doubt is: Is it the only way to have UDF server-side in MySQL(4.1.x)? Do I need to learn C/C++ to have a UDF? Thanks, Ronan -- MySQL General Mailing List For list

UPDATE and INDEX updates

2005-11-21 Thread Mike OK
Hi I was wondering how the index process worked internally for UPDATE statements. If I was to set a value for a column with the UPDATE statement but the value was the same, would MySQL re-work the index?? I can check for data change for each column inside of my code before UPDATE but

UNIQUE constraint, proper use

2005-11-21 Thread Ferindo Middleton Jr
I have this SQL statement: CREATE TABLE rooms ( idSERIAL, room_name TEXT UNIQUE, location TEXT, last_updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,

Re: UNIQUE constraint, proper use

2005-11-21 Thread Paul DuBois
At 22:49 -0500 11/21/05, Ferindo Middleton Jr wrote: I have this SQL statement: CREATE TABLE rooms ( idSERIAL, room_name TEXT UNIQUE, location TEXT, last_updated TIMESTAMP