-Original Message-
From: Per Jessen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 02, 2008 7:51 AM
To: mysql@lists.mysql.com
Subject: Re: Performance problem - MySQL at 99.9% CPU
Gunnar R. wrote:
I am thinking about buying a new dual core box (with IDE disks?), but
I have
: Performance problem - MySQL at 99.9% CPU
Hello,
I am running a community site mainly based on phpBB. It has about 9.300
registered users, 650.000 posts and about 200.000 visitors/month (12
mill
hits). The SQL database is about 700MB.
It's all running on a couple of years old Dell box with two P4
phorum_message is about 500MB in size. The problem is that
such a query often starts to hang in the Sorting result phase. This
can take up to minutes and during this time problems really start: more
and more such queries are coming in, each of them hanging for the same
reason too and after a few
and SCSI disks, with Linux and Apache.
The last year the server has been having huge performance problems, and
MySQL (5.0.45) seems to be the problem. It's almost constantly running at
99.9% CPU (measured using 'top').
I know the hardware isn't too hot, but either way I am a bit confused
of years old Dell box with two P4 Xeon 1.7Ghz
CPUs, 1GB of RAMBUS memory and SCSI disks, with Linux and Apache.
The last year the server has been having huge performance problems, and
MySQL (5.0.45) seems to be the problem. It's almost constantly running at
99.9% CPU (measured using 'top').
I know
huge performance problems, and
MySQL (5.0.45) seems to be the problem. It's almost constantly running at
99.9% CPU (measured using 'top').
I know the hardware isn't too hot, but either way I am a bit confused by
the
fact that I can't seem to get MySQL to run smoothly. Is this just too big
BY datestamp DESC LIMIT 3
The table phorum_message is about 500MB in size. The problem is that
such a query often starts to hang in the Sorting result phase. This
can take up to minutes and during this time problems really start: more
and more such queries are coming in, each of them hanging
Hallo,
folgendes Szenario:
Tabelle Sales (s) mit jede Menge Abverkaufsdaten.
ArtikelNr,Kassenbon,HändlerID,Datum
Jetzt sollen alle zu einem gekauften Artikel ebenfalls augelistet
werden, d.h. was wurde mit dem Artikel zusätzliche gekauft
Bisher habe ich das mit PHP gemacht, nur macht jetzt
in English. Alternatively, you might ask your
question on this list: http://lists.mysql.com/mysql-de
2. How can you more efficiently use MySQL in this scenario? It depends
on exactly what you're trying to do. If you can describe the problem
rather than exactly what you're trying to do, we may
On Wed, Dec 12, 2007 at 05:11:43PM -0800, Ed Reed wrote:
I've found a glaring problem with the latest ODBC connector. Data
types have been changed and data is no longer being read correctly.
That's not quite correct -- data types are now actually being read
correctly. They were wrong before
I've found a glaring problem with the latest ODBC connector. Data types have
been changed and data is no longer being read correctly.
I'm running MySQL 5.1.16 on Netware. My apps are VB6 and VBA using ADO. The
following query produces different data types depending on the version of the
ODBC
: Tomas Hylander [EMAIL PROTECTED]
To: Martin Gainty [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Monday, November 26, 2007 1:38 AM
Subject: Re: Problem with a Procedure
Hi!
I must say I cant see how this would help me. I know the tabels isnt
empty since when running in query browsern I get
: Tomas Hylander [EMAIL PROTECTED]
To: Martin Gainty [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Monday, November 26, 2007 1:38 AM
Subject: Re: Problem with a Procedure
Hi!
I must say I cant see how this would help me. I know the tabels isnt
empty since when running in query browsern I
Hi
Running of mysql actually isn't exact problem.
When I try to run mysql command, it gave me ERROR 1045 (28000): Access
denied for user 'ODXX@'localhost' (using password NO (or YES)) and i cannot
run mysql command.
I did the following operation and mysql worked on vista.
I stoped mysql
Hi,
I want to copy some databases to a new server and I have tried to backup
my databases with mysqldump in the old server, then copy those files to
the new server and recover them with mysqldump again. The problem is
that when doing,
mysqldump -u root -p mydb mydb_backup.sql
the message
Hi ,
U Can try using this option.
Login into database
Type as :-
\. /tmp/mydb_backup.sql
Hope this will help you out.
-Original Message-
From: Alicia Amadoz [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 28, 2007 5:27 PM
To: mysql@lists.mysql.com
Subject: Problem
. The
problem is that when doing,
mysqldump -u root -p mydb mydb_backup.sql
the message that appears is
-- MySQL dump 10.11
If mydb_backup.sql is the dump file, try:
mysql -u root -p mydb mydb_backup.sql
mydb_backup.sql is populated with sql statements that need to be ran
using mysql
and Sender
does not endorse distribution to any party other than intended recipient.
Sender does not necessarily endorse content contained within this
transmission.
Date: Fri, 23 Nov 2007 11:10:47 +0100
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Problem with a Procedure
not endorse distribution to any party other than intended
recipient. Sender does not necessarily endorse content contained within this
transmission. Date: Fri, 23 Nov 2007 11:10:47 +0100 From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com Subject: Problem with a Procedure Hi! Hope you
can help me
Hi!
Hope you can help me with this one.
Im trying to learn this with stored procedures and optimize my databases.
Can someone point what wrong with this?
--
Ryan,
show slave status after it stops copying should give you some type of
error information about the failure. What does it show?
Keith
Ryan Klein wrote:
I am having an issue that I cannot determine the cause. We have a
master server that is actually a production server and a slave
I am having an issue that I cannot determine the cause. We have a master server
that is actually a production server and a slave server that is a fall back but
after around 10 days, it stops coping data and the servers fall out of sync.
Here is my my.cnf file for the master server:
key_buffer
From: B. Keith Murphy [mailto:[EMAIL PROTECTED]
show slave status after it stops copying should give you some type of
error information about the failure. What does it show?
In addition to the error, what do the following fields show?
Slave_IO_Running
Slave_SQL_Running
i have one problem with Arabic text. I have created database with charaterset
utf8. when i insatal sql file all the content which is arabic that content
stored as arabic. but when i retrieve this content it is display something like
ASCII value(ÙعاÙÙSØ© ادارة اÙÙ^Ù,ت).
one more thing
Hi, I have built a site with Dreamweaver and I have a problem with a
query.
I am trying to pass a parameter from one page to another to drill
down. Basically, I have one product entry that is in multiple
categories on my website. So, say it's a dress, it is therefore
related to category
Dear Mat,
Your mail is not very clear. But I have a feeling that using '%' wildcard in
the like operand should help you
Regards,
Ravi.
On 11/14/07, Matthew Stuart [EMAIL PROTECTED] wrote:
Hi, I have built a site with Dreamweaver and I have a problem with a
query.
I am trying to pass
i have one problem with Arabic text. I have created database with
charaterset utf8. when i insatal sql file all the content which is arabic
that content stored as arabic. but when i retrieve
When you retrieve this content, how are you viewing it? - browser? terminal?
For the browser
Developer
Edition [x86] is a wonderfully simple install.
~mm
Thanks again
Martin--
- Original Message -
From: Michael Monaghan [EMAIL PROTECTED]
To: Bharat [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Wednesday, November 14, 2007 9:39 AM
Subject: Re: Arabic text storing problem
Hi,
Thanks for the link
Is there standalone jar/zip Just for auto_ef
Also see Perl module Encode::Guess. There are others out there as well.
Regards,
Jeremy
--
high performance mysql consulting
www.provenscaling.com
--
MySQL General Mailing List
For list archives:
;
END;;
DELIMITER ;
On Nov 6, 2007, at 11:11 PM, Lucky Wijaya wrote:
Hi, my name is Lucky from Indonesia. I build an database application
using Delphi 7 MySQL as the RDBMS. Now, I'm having problem in
creating trigger in MySQL. Here is the code of the trigger:
CREATE TRIGGER
Hey all,
So I decided to start fresh on a test machine just to see if I could get
french characters working.
These are my steps:
Freshly Installed Mysql 5.0.45
Configure the MySql Server now
Detailed Configuration
Developer Machine
Multifunctional Database
Online Transaction Processing
Enable
Indonesia. I build an database application
using Delphi 7 MySQL as the RDBMS. Now, I'm having problem in
creating trigger in MySQL. Here is the code of the trigger:
CREATE TRIGGER DEL_TB_INSTRUKSI AFTER DELETE ON Tb_Instruksi
FOR EACH ROW
BEGIN
DELETE FROM Tb_Stuffing WHERE No_Instruksi
Hi James,
set these and try again
set session collation_database=latin1_swedish_ci;
set session character_set_database=latin1;
regards
anandkl
On 11/9/07, James Sherwood [EMAIL PROTECTED] wrote:
Hey all,
So I decided to start fresh on a test machine just to see if I could get
french
Wijaya wrote:
Hi, my name is Lucky from Indonesia. I build an database application
using Delphi 7 MySQL as the RDBMS. Now, I'm having problem in
creating trigger in MySQL. Here is the code of the trigger:
CREATE TRIGGER DEL_TB_INSTRUKSI AFTER DELETE ON Tb_Instruksi
FOR EACH ROW
BEGIN
DELETE FROM
Hello,
We are trying to upgrade from 4.0 to 5 and we are not having any luck on the
character sets.
We need to use French characters for some things.
We have tried setting utf8 for everything we can find but the characters
still show all screwed up..
I have read the manual regarding all
Subject: Re: Character encoding problem
James Sherwood wrote:
Hello,
We are trying to upgrade from 4.0 to 5 and we are not having any luck on
the character sets.
We need to use French characters for some things.
We have tried setting utf8 for everything we can find but the characters
still
]
To: mysql@lists.mysql.com
Sent: Wednesday, November 07, 2007 6:16 PM
Subject: Re: Character encoding problem
Hello,
Thanks for the info,
For the dump, I would imagine that it is latin1 as mysql 4.x is defaulted
to that I beleive.
Is there a way to dump it to utf8?
--James
- Original
PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, November 07, 2007 7:37 PM
Subject: Re: Character encoding problem
Hello,
After I dump the database in and change everything to utf8(or if I try to
dump and make them all utf8 on the dump) I get an incorrect string
value error when trying to put
James Sherwood wrote:
Hello,
Thanks for the info,
For the dump, I would imagine that it is latin1 as mysql 4.x is
defaulted to that I beleive.
Is there a way to dump it to utf8?
You can convert it using iconv:
Hi, i need of help for a serios problem.
We have installed mysql 5 and we are using InnoDB engine. OS is CentOS
5, x86.
Our problem is this.
We get this message in the log:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
ERROR 2002
To: mysql@lists.mysql.com
Subject: Please help to solve a serios problem
Hi, i need of help for a serios problem.
We have installed mysql 5 and we are using InnoDB engine. OS is CentOS
5, x86.
Our problem is this.
We get this message in the log:
ERROR 2002 (HY000): Can't connect to local MySQL
Message-
From: Ali Nebi [EMAIL PROTECTED]
Sent: Nov 6, 2007 9:24 AM
To: mysql@lists.mysql.com
Subject: Please help to solve a serios problem
Hi, i need of help for a serios problem.
We have installed mysql 5 and we are using InnoDB engine. OS is CentOS
5, x86.
Our problem is this.
We
help to solve a serios problem
Hi, i need of help for a serios problem.
We have installed mysql 5 and we are using InnoDB engine. OS is CentOS
5, x86.
Our problem is this.
We get this message in the log:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/lib
- Original Message -
From: Russell E Glaue [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, November 06, 2007 8:55 PM
Subject: Re: Please help to solve a serios problem
The mysql.sock location '/var/lib/mysql/mysql.sock' attempted to be used
by your
Hi, my name is Lucky from Indonesia. I build an database application using
Delphi 7 MySQL as the RDBMS. Now, I'm having problem in creating trigger in
MySQL. Here is the code of the trigger:
CREATE TRIGGER DEL_TB_INSTRUKSI AFTER DELETE ON Tb_Instruksi
FOR EACH ROW
BEGIN
DELETE FROM
, 2007, at 11:11 PM, Lucky Wijaya wrote:
Hi, my name is Lucky from Indonesia. I build an database application
using Delphi 7 MySQL as the RDBMS. Now, I'm having problem in
creating trigger in MySQL. Here is the code of the trigger:
CREATE TRIGGER DEL_TB_INSTRUKSI AFTER DELETE ON Tb_Instruksi
is Lucky from Indonesia. I build an database application
using Delphi 7 MySQL as the RDBMS. Now, I'm having problem in
creating trigger in MySQL. Here is the code of the trigger:
CREATE TRIGGER DEL_TB_INSTRUKSI AFTER DELETE ON Tb_Instruksi
FOR EACH ROW
BEGIN
DELETE FROM Tb_Stuffing WHERE
Running on our systems, we have had the replica load data and then
started. The longest delta was about 28 hours behind the master. The
slave status faithfully reported how far behind the master it was, when
the slave was started, even as it was loading its relay-logs from the
master which
Hi Yves,
I have a problem with my foreign keys. I have the following two tables:
CREATE TABLE keylist (
KeylistId INTEGER NOT NULL,
UserId INTEGER NOT NULL,
PRIMARY KEY (KeylistId, UserId));
CREATE TABLE user (
UserId INTEGER NOT NULL PRIMARY KEY,
AdditionalKeylist
On 04.11.2007 21:10 CE(S)T, Martijn Tonies wrote:
Now I have added this foreign key constraint:
ALTER TABLE user ADD FOREIGN KEY (AdditionalKeylist) REFERENCES
keylist (KeylistId) ON DELETE SET NULL;
This cannot work. The column in KEYLIST to which you are
pointing should have a unique
On Sat, 3 Nov 2007, bob b wrote:
Good to hear that you found the problem.
The only remaining puzzle is why the replica reported that it was up to date
when it was several binlogs behind.
Possibly the replica was always caught up with the last entry from the very
slow link.
Perhaps you
Christopher E. Brown wrote:
On Sat, 3 Nov 2007, bob b wrote:
So, a slave is down for 8hrs. It comes online and pulls the binlog in
120 seconds. The seconds behind master does not reflect 8hrs, but how
many seconds (at current processing rate) before the slave finishes the
relay logs.
The
),
the slave always reported zero seconds behind.
This is on servers with less than 1% CPU used.
The actual problem was not with writing the binlog, or the slave SQL
thread, but the actual transfer of the binlog across the network.
After days of running, the slave would be many Gigs behind
Hi,
I have a problem with my foreign keys. I have the following two tables:
CREATE TABLE keylist (
KeylistId INTEGER NOT NULL,
UserId INTEGER NOT NULL,
PRIMARY KEY (KeylistId, UserId));
CREATE TABLE user (
UserId INTEGER NOT NULL PRIMARY KEY,
AdditionalKeylist INTEGER
of a keylist.KeylistId, there was e.g.
a MessageReadAccessKeys.MessageId referencing message.MessageId.
First, this makes 5 more tables and second, I doubt that it would solve
my non-unique foreign key problem.
What I need is to store those keys for several tasks, object types and
instances of them.
What I would like
Hi,
I have a script which updates a mysql table. When I run this script the
update in not happening.
But if I stop mysql and start in safe mode as follows
mysqld_safe --skip-grant-tables --user=root
then the update script is running properly.
Why it is not happening in the non safe mode.
behind.
In short, everything looks fine.
What happens is that the master - slave binlog feed runs very slow (no
more than abount 10 writes/sec).
So, afer a few days the slave is still reporting zero seconds behind, and
it is zero seconds behind the relay log.
The problem is that while
Hello,
I've a problem with mutated vowels like öäü by using the mysql client.
Nothing happens if I type ö,ä or ü. The input seems to be ignored.
OS is Solaris 9 Sparc 32 Bit. MySQL Version 5.0.45 (I tried the source and
binary version.)
By typing in the shell (csh, ksh) or using the vi
Hello,
I found the solution by my own:
set meta-flag on
set convert-meta off
set output-meta on
Regards,
Spiker
--
GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS.
Alle Infos und kostenlose Anmeldung: http://www.gmx.net/de/go/freemail
--
MySQL General Mailing List
For list
Hi-
I'm using the command 'mysqlimport -u usr -ppassh -h mysqlserver -P 3306 -v
db --local $workdir/$filename'to import a table into mysql from a file
$filename.
The data in $filename looks something like:
test test
where there is a blank space between the two 'test's to represent an empty
qt4x11 wrote:
Hi-
I'm using the command 'mysqlimport -u usr -ppassh -h mysqlserver -P 3306 -v
db --local $workdir/$filename'to import a table into mysql from a file
$filename.
The data in $filename looks something like:
test test
where there is a blank space between the two 'test's to
We just added the ulimit line.
Hope that helps.
Keith
- Original Message -
From: Paul Halliday [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, October 11, 2007 3:02:27 PM (GMT-0500) America/New_York
Subject: open_files_limit problem.
I am trying to change this value
I am trying to change this value and it doesn't seem to work.
Looking at the processes I have:
mysql 21752 0.0 0.1 1652 1092 p3 I 3:50PM 0:00.01
/bin/sh /usr/local/bin/mysqld_safe
--defaults-extra-file=/var/db/mysql/my.cnf --user=mysql
--datadir=/var/db/mysql
is
corrupted (you can check this by running 'mysqlbinlog' on the relay
log), a netwo
rk problem, or a bug in the master's or slave's MySQL code. If you want
to check the master's binary log or slave's relay log, you will be able
to know
their names by issuing 'SHOW SLAVE STATUS' on this slave. Error_code
)
071008 9:07:13 [Note] Slave I/O thread: Failed reading log event,
... snip ...
their names by issuing 'SHOW SLAVE STATUS' on this slave. Error_code: 0
071008 12:15:33 [ERROR] Error running query, slave SQL thread aborted.
Fix the problem, and restart the slave SQL thread with SLAVE START. We
,
... snip ...
their names by issuing 'SHOW SLAVE STATUS' on this slave. Error_code: 0
071008 12:15:33 [ERROR] Error running query, slave SQL thread
aborted. Fix the problem, and restart the slave SQL thread with
SLAVE START. We stopped
at log 'mysql-bin.000105' position 893425700
Any help or ideas
(to use full text indexes, say), I think
the checksums are different. But you may not have that problem.
I believe your assertion about temp tables is correct, according to
this:
http://dev.mysql.com/doc/refman/5.0/en/reset-slave.html
Good luck,
Dan
-Original Message-
From: Frank Bottone
Hi Baron,
The answers are as below
I have not upgraded the server. Done tuning on my.cnf on innodb parameters.
No i have not change the storage engine from MYISAM to INNODB
Regards,
Krishna
On 9/28/07, Baron Schwartz [EMAIL PROTECTED] wrote:
Krishna Chandra Prajapati wrote:
Hi All,
I
Krishna Chandra Prajapati wrote:
Hi All,
I am using mysql-client 5.0.15 on fedora system. Server is a Debian box with
mysql 5.0.32
After getting connected to the server(192.168.1.7) using the command below
mysql -h 192.168.1.7 -D dip -u dip -p
When a record deleted from a table on server
Hi All,
I am using mysql-client 5.0.15 on fedora system. Server is a Debian box with
mysql 5.0.32
After getting connected to the server(192.168.1.7) using the command below
mysql -h 192.168.1.7 -D dip -u dip -p
When a record deleted from a table on server (192.168.1.7) Then that changes
are not
Hi all,
I've a server where between 1-2 there comes a high load from less than
1k queries there's a jump to 60+k queries. It all started after adding
more RAM to the server.
Anyone seen this before ?
Regards,
Toke Herkild
--
MySQL General Mailing List
For list archives:
)
Any ideas? I have googled this for almost an hour now and never had this
problem on other installs.
--
Dave
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, September 24, 2007 5:24 AM
To: MySQL General
Subject: Problem with characters
I have a new setup with mySql version 4.1 and myODBC version 3.51
running on Windows 2k3 standard
In the database we have something like And this is £200 and when we
write this out in ASP we get And this is ?200 The same
From: Critters [mailto:[EMAIL PROTECTED]
Sent: Monday, September 24, 2007 5:24 AM
To: MySQL General
Subject: Problem with characters
I have a new setup with mySql version 4.1 and myODBC version 3.51
running on Windows 2k3 standard
In the database we have something like And this is £200
I found that using version 5.1 of the ODBC connector solved our problem with
Chinese characters. It might solve the problem with the pound sterling sign.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX
:
Internal connections work fine, and the outside connections also worked
like a charm until now. I didn't change anything in my config! And SSL
is not the problem either (works fine with the same certificates on the
other servers).
When I restart MySQL it accepts outside connections for a moment
I'm noticing, that the problem lies with my server getting blocked,
because of too many bad tries.
Could that be, that after some time, this is not shown as an error
anymore, and the client just waits there forever?
It seems that I'm only getting blocked when the load is high on the
server
I am running this query:
SELECT group_post_mod_option.option_id,
group_post_mod_option.option_name,
COUNT(group_post_moderation.group_post_moderation_option) AS count
FROM group_post_mod_option
LEFT OUTER JOIN group_post_moderation ON
(group_post_mod_option.option_id
Naz,
That query logic runs without a error on the server I have to hand
(5.0.37), but it has three issues:
(i) unless there is an exceptionless 1:1 relationship between
group_post_mod_option.option_id and group_post_mod_option.option_name,
results for the latter column will be meaningless
Hi All,
There are many user accessing the production server and making a lots of
mistake, running wrong query (It occurs by mistake if they don't pay
attention) . There is any tools or script which can set autocommit=0;
whenever any user logged in. OR done some thing wrong which can be revert
Not quite what you're after but you might like to use...
http://dev.mysql.com/doc/refman/5.0/en/safe-updates.html
-Original Message-
From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED]
Sent: 13 September 2007 15:30
To: MySql
Subject: PROBLEM
Hi All,
There are many user
I have never seen this kind of behavior from MySQL but I have seen it
in the application layer (what language/framework are you using) when
an application, written with little thought to the implications of
race conditions or multi-processing considerations gets put under
load.
On 9/13/07,
Mathieu Bruneau wrote:
I never tried the falcon engine, but could it be that mysql is running
out of file descriptor ?
That's less likely with Falcon than with engines that put each
table and index in its own file. By default, Falcon tables share
a single tablespace.
Regards,
Ann
--
connect with the mysql client,
but any command that you would type would freeze
(never come back).
It would be interesting to get a stack trace at that
point. We do have tests that create that many tables,
so the problem is going to take some thought.
I will try to re-run the same job, enabling
I have re-run and job and I was able to repeat the
problem.
Find attached the mysql server error log with all the
tarces.
Could you please help ?
Thanks,
Mariella
--- Mariella Petrini [EMAIL PROTECTED]
wrote:
Hi All,
I have started using MySQL 6.0.2 with Falcon on
Linux
with Debian
it. Don't know if
falcon use file handle per table or not tough...
--
Mathieu Bruneau
aka ROunofF
===
GPG keys available @ http://rounoff.darktech.org
Mariella Petrini a écrit :
I have re-run and job and I was able to repeat the
problem.
Find attached the mysql server error log with all the
tarces
If Debian is limited to create files over 8k, it can be the reason of the
problem.
Falcon seems not create data file for tables, but still create .frm files
for each tables.
--
Jaemyung Kim
2007/9/9, Mathieu Bruneau [EMAIL PROTECTED]:
I never tried the falcon engine, but could
I don't think that is the problem.
I have been able to create over a 1,000,000 of tables with MySQL 5.1.21 and
different storage engines with the same environment (I had already ulimit set).
Thanks,
Mariella
Mathieu Bruneau [EMAIL PROTECTED] wrote: I never tried the falcon engine, but
could
approximately 8,500 empty tables mysqld server was
still alive, you could connect with the mysql client,
but any command that you would type would freeze
(never come back).
I will try to re-run the same job, enabling
falcon_debug_mask and see if I can get more info and
repeat the problem.
Mariella
part.
Can you please let me know what could be wrong in this query?
--
View this message in context:
http://www.nabble.com/Problem-creating-a-Trigger-tf4392021.html#a12522149
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http
?
--
View this message in context:
http://www.nabble.com/Problem-creating-a-Trigger-tf4392021.html#a12522149
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com
Hi,
Thank you so much for the prompt response. Those comments were good to be
kept in mind always.
I actually realised the mistake I was making as soon as I posted the problem
here. So I managed the solve the problem.
However I have another problem which I need your ideas.
I have a table where
Hi,
However I have another problem which I need your ideas.
It's better to create a new thread when you want to discuss a new
problem.
I have a table where prices for a few stock tickers are inserted. I have
another temp table which holds the prices for the max trade date. I have a
trigger
But on the second record I get this message:
DBD::mysql::st execute failed: Duplicate entry 'pjongjang' for key 1
Whats wrong with it? The character set and collation set is defined as
utf8, so mysql should see a difference between ö and o.
Regards
Marten
It's not problem of charset
Actually I fixed the problem by generating a whole new set of SSL
certificates!
Thanks for the help!
Regards,
Samy
[EMAIL PROTECTED] schrieb:
Hey,
This morning the default timespan of ssl certificates took my servers
down...
Everything was running fine, but this morning the SSL encrypted
Hi
two tables gi_t and gi
gi_t holds 5 records. gi holds ca. 1500.
I need all from gi for each in gi_t ie LEFT JOIN!!!
but this:
SELECT gi.id AS id, overskrift,gidata FROM gi_t LEFT JOIN gi ON
gi_t.id=gi.gitref WHERE bladref=137
gives the same as
SELECT gi.id AS id, overskrift,gidata FROM
Hi list!
I've a problem with transaction
I initiate a transaction with start transaction. Soon i execute
following query:
* update t1 set t=12; and by I complete I execute rollback but when I do
it I obtain the following thing:
non-transactional Some changed tables couldn't be rolled back
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 05, 2007 10:39 AM
To: mysql@lists.mysql.com
Subject: Left join problem
Hi
two tables gi_t and gi
gi_t holds 5 records. gi holds ca. 1500.
I need all from gi for each in gi_t ie LEFT JOIN!!!
but this:
SELECT gi.id AS id, overskrift
Hi,
I've a problem with transaction
I initiate a transaction with start transaction. Soon i execute
following query:
* update t1 set t=12; and by I complete I execute rollback but when I do
it I obtain the following thing:
non-transactional Some changed tables couldn't be rolled back
Hi,
two tables gi_t and gi
gi_t holds 5 records. gi holds ca. 1500.
I need all from gi for each in gi_t ie LEFT JOIN!!!
but this:
SELECT gi.id AS id, overskrift,gidata FROM gi_t LEFT JOIN gi ON
gi_t.id=gi.gitref WHERE bladref=137
gives the same as
SELECT gi.id AS id,
701 - 800 of 8646 matches
Mail list logo