Hi all,
I'd like to clarify on this odd issue. It seems to me that MySQL will
automatically drop database handles, assumably if the handle has not
been used for some time. Is this true? If so, how can I disable timeout?
This is an unexpected behavior, because I have tried MSSQL and Postgre,
Why table locked on delete?
---TRANSACTION 0 476648265, ACTIVE 530 sec, process no 13965, OS thread id
3152999360 updating or deleting, thread declared inside InnoDB 293
mysql tables in use 1,* locked 1*
11090 lock struct(s), heap size 634176, undo log entries 930711
MySQL thread id 16831,
Hi Dave
i did so, but probably in the wrong moment. i got Access denied when i
run the script.
you mean that this should have been the very first step after the upgrade.
suomi
Logan, David (SST - Adelaide) wrote:
Hi,
Did you run the bin/mysql_fix_privilege_tables script? This is
documented
Hi suomi,
From my understanding (and I have just performed it myself about 2 hours
ago on one of my servers), I stopped the server, took a backup of the
data directories, built the new server and put it in place (same as your
rpm step), started the server, ran the fix script as
Hi All.
How can I get to know which constraint fails when Cannot delete or
update a parent row: a foreign key constraint fails error occurs?
Thanks in advance
prp
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hi Dave
tha' sounds great. i 'll try to do the same immediately.
thanks for your help.
suomi
Logan, David (SST - Adelaide) wrote:
Hi suomi,
From my understanding (and I have just performed it myself about 2 hours
ago on one of my servers), I stopped the server, took a backup of the
data
An efficient way to store time is as UNIX_TIMESTAMP (4 bytes) instead of
using DATETIME data type (8 bytes). We were using this technique to save the
time in our database.
Now we need to support millisecond resolution as we need to store data
comming 8 times per second, that is, every 125
Hi again,
it just does not work.
follows the entire dialog:
[EMAIL PROTECTED] /home/myuser/software rpm -U --nodeps
MySQL-server-standard-5.0.18-0.rhel3.i386.rpm
Giving mysqld a couple of seconds to exit nicely
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the
Have you tried it without a password? eg. just --user root Are you able
to connect with the mysql client?
Sorry, I don't know a lot about rpm and how it works as I work on
Solaris and use the .tar.gz versions. Hopefully somebody with
familiarity with rpm can help out here? I'd be interested to
Hello List
I have tried dynamically assigning a database name to a stored proc via
its parameter list:
CREATE STORED PROCEDURE testStoredProc (IN test_db_name CHAR)
BEGIN
SELECT * FROM test_db_name.test_table;
END;
MySQL does not resolve test_db_name to the value
Thanks Michael, That was the solution. This was the first time I've seen that
error and now it makes plenty of sense.
Thanks,
Grant
Michael Stassen [EMAIL PROTECTED] wrote: Grant Giddens wrote:
Hi,
I'm using mysql 4.1.14 and and getting this error:
Column 'asin' in field list is
2006/2/9, Jose Antonio [EMAIL PROTECTED]:
An efficient way to store time is as UNIX_TIMESTAMP (4 bytes) instead of
using DATETIME data type (8 bytes). We were using this technique to save the
time in our database.
Now we need to support millisecond resolution as we need to store data
comming
Hi Dave
i tried a new proceeding, which seems to work:
1.
before upgrading i did:
mysqldump -A --all -uroot -p mysql-backup-before-upgrade-to-5.sql
2.
i moved the present database away.
3.
i did the upgrade as described many messages before.
4.
i created a new database.
5.
[EMAIL PROTECTED]
David Logan wrote:
Michael Lai wrote:
I am currently using MySQL 5.0.15 with mysql-connector-java-3.1.11.
I can access the database from my JSPs with no problem except for one
small issue. After a long delay (usually overnight), when someone
first tries to access the database, I would get
I have tried dynamically assigning a database name to a stored proc via
its parameter list:
CREATE STORED PROCEDURE testStoredProc (IN test_db_name CHAR)
BEGIN
SELECT * FROM test_db_name.test_table;
END;
MySQL does not resolve test_db_name to the value passed in the
parameter, and the
Przemysław Klein [EMAIL PROTECTED] wrote on 02/09/2006 04:24:14 AM:
Hi All.
How can I get to know which constraint fails when Cannot delete or
update a parent row: a foreign key constraint fails error occurs?
Thanks in advance
prp
If you issue a SHOW InnoDB STATUS command, you
Rory McKinley [EMAIL PROTECTED] wrote on 02/09/2006 07:37:17 AM:
Hello List
I have tried dynamically assigning a database name to a stored proc via
its parameter list:
CREATE STORED PROCEDURE testStoredProc (IN test_db_name CHAR)
BEGIN
SELECT * FROM test_db_name.test_table;
I have tried dynamically assigning a database name to a stored proc via
its parameter list:
CREATE STORED PROCEDURE testStoredProc (IN test_db_name CHAR)
BEGIN
SELECT * FROM test_db_name.test_table;
END;
MySQL does not resolve test_db_name to the value passed in the
Since upgrading from 4.x to 5.x we've found table comments to be
truncated at 80 characters.
Is this a configurable option somewhere and I just can't find it in the
manual?
Thanks,
Russell.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
You originally mention your UNION doesn't work but you did not
specify the query. This is a simple or query, or union. You can do
either:
select CaseType_idCaseType,Sizes_idsizes,qty from CaseType_has_Sizes
where (qty=1 and Sizes_idsizes=2) or (qty=1 and Sizes_idsizes=4);
or
select
Hi,
I am trying to convert a Oracle 7 interface (from our Constraint Logic
Programming Platform ECLiPSe) to MySQL. [I guess I should also say that I
don't really have any experience with programming any database API
previously, so please excuse me if this seems to be a basic question]
The
Firstly, the correct syntax for the mysql client is:
mysql -u root -h hostname_or_ip_address -p
and then enter the password you are prompted.
You need to make sure you can connect FIRST, and THEN try replication.
Running replication as root is a bad idea, by the way. Better to set
up a
[EMAIL PROTECTED] wrote:
Rory McKinley [EMAIL PROTECTED] wrote on 02/09/2006 07:37:17 AM:
Hello List
I have tried dynamically assigning a database name to a stored proc via
its parameter list:
snip
snip
Use a prepared statement. Build your SQL statement as a string,
prepare
it, and
Rory McKinley [EMAIL PROTECTED] wrote on 02/09/2006 03:06:41 PM:
[EMAIL PROTECTED] wrote:
Rory McKinley [EMAIL PROTECTED] wrote on 02/09/2006 07:37:17 AM:
Hello List
I have tried dynamically assigning a database name to a stored proc
via
its parameter list:
snip
snip
Hello,
I apologize if this is a common question; I have been working with it
and googling for days, and can't seem to find anyone who has been
trying to do the same thing that I am. Maybe I'm using the wrong
keywords. In any event, I am desperate for help. Here is my problem:
I have a
Jessica,
It think your first mistake is that you are trying to implement many-to-many
relationships directly. Although it is theoretically possible to do so, I've
never seen anyone do it myself. I believe the normal approach is to break
each many-to-many relationship into two one-to-many
Hello all,I'm running into a intermittent and very annoying problem with all of my servers. I'm currently running FreeBSD 4.11, exim-4.51-0, and mySQL 4.1.13. My exim config is setup to have exim do a mySQL lookup in order to determine whether a given user's e-mail is hosted by our e-mail
Sheeri,
Thanks for the help. I tried your sample queries, but they dont really
return what I'm looking for. I think I've found a solution though.
Given the contents of a case, I'm looking for a unique case id, basicially I
want to search for a case if it exists once I've decided the
On Thursday, 9 February 2006 at 17:02:06 -0800, Michael Jeung wrote:
Periodically, exim throws the following error into its panic log:
Feb 9 13:24:51 mx_server_1 exim[69953]: 2006-02-09 13:24:51 failed to expand
${lookup mysql {select distinct domain from email_table where
I tried mysqlbinlog for 5.0.18, but whether I use the --hexdump option
or not, it still aborts with the same error:
ERROR: Error in Log_event::read_log_event(): 'Event too big', data_len:
1635131433, event_type: 109
Could not read entry at offset 1384:Error in log format or read error
This looks
I have a customer who has been in production for a few weeks now having
converted from MyISM to INNODB. We have been experiencing a few problems
with our application. With that said, could you take a look at the info
below from my show INNODB status and let me know if you see any problems
based
What are the problems you've been experiencing? Did you convert all tables?
How big is the database?
On 2/9/06, Shaun Adams [EMAIL PROTECTED] wrote:
I have a customer who has been in production for a few weeks now having
converted from MyISM to INNODB. We have been experiencing a few problems
Hi all,
I have a MySQL server servng low-load applications. Problem is, the
environment is sometimes unstable, leading the entire OS to crash. I
notice that even in low-load situations the MySQL tables can be
corrupted during crashes.
My question is: is there a way for MySQL to flush when
Hi,
If they are MyISAM tables, you can run a FLUSH TABLES statement at a
periodic interval. A good reference is here
http://dev.mysql.com/doc/refman/5.0/en/flush.html
Regards
---
** _/ ** David Logan
*** _/
[EMAIL PROTECTED] wrote:
snip
You were so close! Try it more like this:
SET sSQL=CONCAT('SELECT * FROM ', passed_in_db_name, '.sites WHERE
site_name=?');
PREPARE query_statement from sSQL
snip
Doh!
I cannot believe that I didn't think of that - seems I was being dense
after all!
Thanks
Shaun,
the my.cnf looks ok. You might be able to raise the InnoDB buffer pool size
to 3G, but beware swapping.
SHOW INNODB STATUS looks ok, though it would be more informative if it were
taken during a typical workload.
Free buffers 0
Having free buffers 0 is very normal. Buffers
Ji-Haw,
if the OS crashes do not corrupt files, then InnoDB tables would survive an
OS crash without a problem.
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 InnoDB which also
Heikki Tuuri wrote:
Ji-Haw,
if the OS crashes do not corrupt files, then InnoDB tables would
survive an OS crash without a problem.
Thanks for the reply Heikki. Let me rephrase my problem: the data
remains intact, but I suspect the indexes are corrupted. Basically I
have to run
Foo Ji-Haw wrote:
Heikki Tuuri wrote:
Ji-Haw,
if the OS crashes do not corrupt files, then InnoDB tables would
survive an OS crash without a problem.
Thanks for the reply Heikki. Let me rephrase my problem: the data
remains intact, but I suspect the indexes are corrupted. Basically I
snip
You were so close! Try it more like this:
SET sSQL=CONCAT('SELECT * FROM ', passed_in_db_name, '.sites WHERE
site_name=?');
PREPARE query_statement from sSQL
snip
Yup - got it to work - but it is so much hassle that I might seriously
reconsider having queries run across databases, as
40 matches
Mail list logo