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
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
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
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
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
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
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
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
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:
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:
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
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
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
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
-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
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
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
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) =
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
-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
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
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
- 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
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:
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
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
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
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
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:
***
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
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
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:
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
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
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
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.
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
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
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
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
I have this SQL statement:
CREATE TABLE rooms (
idSERIAL,
room_name TEXT UNIQUE,
location TEXT,
last_updated TIMESTAMP DEFAULT
CURRENT_TIMESTAMP NOT NULL,
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
42 matches
Mail list logo