Rik,
Your Crystal Ball was right! How did I miss that? You get the brownie point for
the day. Thanks!
I knew it wasn't version discrepancy because workbench ssh's into the DB, and
the script does as well, so it is running it on the native client in both
cases. My sysadmin was saying it was ver
> When I run this query in workbench:
> select c.acc_number 'Accession Number', e.DateExam 'MBI Exam Date',
> s.ExamDate 'SJH Exam Date' from chestcon_log c
> left join exams e on CONCAT("000",c.acc_number) = e.LastWordAccNum
> left join sjhreports_ s on c.acc_number = s.AccessionNumber
> WHERE
> c
On 2/13/2012 10:18 AM, James W. McNeely wrote:
When I run this query in workbench:
select c.acc_number 'Accession Number', e.DateExam 'MBI Exam Date', s.ExamDate
'SJH Exam Date'
from chestcon_log c
left join exams e on CONCAT("000",c.acc_number) = e.LastWordAccNum
left join sjhreports_ s on c.ac
2011/10/10 09:19 -0400, Brandon Phelps
If this column(s) is/are a character type now, then you would need to have the
values in quotes.
Note that because of implicit conversion if they had numberic values no error
would be reported, but maybe the equality would not be exact.
That query looks fine. What error are you getting if you execute the query
from the CLI? Also is it possible that the s_id or owed columns are no longer
numeric data types? If this column(s) is/are a character type now, then you
would need to have the values in quotes.
-Brandon
On 10/10/20
Hello all.
I have recently finished my migration from an older server to a newer
server running RHEL 6. The MySQL version went from 5.0.77 to 5.1.52.
In my application, this query used to work just fine:
$paid_query = mysql_query("UPDATE $table_name SET owed = 0 WHERE s_id
= $student");
Where t
(multi versioning concurrency control).
In addition, can you tell us what you get from:
mysql> select version();
mysql> select @@tx_isolation;
Thanks.
Tachu® wrote:
I'm having some weird issues that might be common but im not sure.
I have a very write intensive innodb table that
> select version();
mysql> select @@tx_isolation;
Thanks.
Tachu® wrote:
I'm having some weird issues that might be common but im not sure. I
have a very write intensive innodb table that sometimes i do an insert
and then do a select for the row i just inserted and it wont show up.
I´d just like to know why do you wanna do a select in a record which was
just inserted.
Could you explain a little more?
""Tachu®"" escreveu na mensagem
news:339ce61f-848a-4c83-b566-ef0e176e6...@gmail.com...
> I'm having some weird issues that might be common b
I'm having some weird issues that might be common but im not sure. I
have a very write intensive innodb table that sometimes i do an insert
and then do a select for the row i just inserted and it wont show up.
this is on the same host its not replication lag but on the same host.
t(*) as 'Count' from logins WHERE player = 'player1';
Count
-
12
or:
select count(*) as 'Count' from logins;
Count
-
54
Regards,
Andy
Darryle Steplight wrote:
Hi G,
There is nothing weird about your results. When you do a Count(*)
without a GROUP BY(som
- Original Message -
From: "Darryle Steplight" <[EMAIL PROTECTED]>
To: "MySql" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, September 09, 2008 6:59 PM
Subject: Re: Weird problem with mysql_query
Hi G,
There is nothing weird about your results. When y
Hi G,
There is nothing weird about your results. When you do a Count(*)
without a GROUP BY(someColumn) you are essentially asking MySQL how
many rows are present in the table. But when you do use Group By
someColum , you are asking MySql how many rows do I have of
"someColumn" . I
We are running MySql version 5.0.45-Debian_1ubuntu3.1-log Debian etch
distribution under Ubuntu.
If I submit the following query via mysql_query it acts as if the where is not
there:
select count(*) as 'Count' from logins where player = 'aqwert';
this returns:
Count
143578160
Submitting
Hi folks -
I've searched the web in vain to try to find anyone else with this
problem. My computer will intermittently start having all "SHOW
FIELDS" queries take 2 seconds. Not 1. Not 3. Always 2. The problem
appears suddenly for no apparent reason - sometimes immediately after
restarting the com
[EMAIL PROTECTED] schrieb:
Hi,
I did a select on a primary key..
Select max(account_id) from mytable;
-- it gave me a value X
I did a select with order by
Select account_id from mytable order by account_id desc limit 3
-- it gave me a value of Y ( Y is the ri
Hi,
I did a select on a primary key..
Select max(account_id) from mytable;
-- it gave me a value X
I did a select with order by
Select account_id from mytable order by account_id desc limit 3
-- it gave me a value of Y ( Y is the right value )
I was wonderin
Hi dante, all,
[EMAIL PROTECTED] wrote:
[[...]]
In a nutshell, i need a query intelligent enough to make a query to table_Out,
see if theres a match for 'id_tA', if there is one, retrieve field "ref",
otherwise go look in table_In and retrieve "ref" from there.
Is it too complicated (impossib
Hi,
Dont know if my last post got to the list, but since then my problem got a bit
more complicated. I know how to solve it using two or more queries, but was
wondering if it would be possible using only one:
tableA
id_tA numof descr
1 0809 john
2 0808 peter
table_out
id_tOut
Baron Schwartz schrieb:
> On Dec 13, 2007 4:18 PM, Daniel Mikic <[EMAIL PROTECTED]> wrote:
>
>> Baron Schwartz wrote:
>>
>> Hi,
>>
>> On Dec 13, 2007 3:53 PM, Daniel Mikic <[EMAIL PROTECTED]> wrote:
>>
>>
>> Hi, i hit a wei
On Dec 13, 2007 4:18 PM, Daniel Mikic <[EMAIL PROTECTED]> wrote:
>
> Baron Schwartz wrote:
>
> Hi,
>
> On Dec 13, 2007 3:53 PM, Daniel Mikic <[EMAIL PROTECTED]> wrote:
>
>
> Hi, i hit a weird behavior:
>
> select date(null); #result is null
> s
Baron Schwartz wrote:
> Hi,
>
> On Dec 13, 2007 3:53 PM, Daniel Mikic <[EMAIL PROTECTED]> wrote:
>
>> Hi, i hit a weird behavior:
>>
>> select date(null); #result is null
>> select if(date(null) is null, 1, 2); #result is 2 (not null)
>> selec
Hi,
On Dec 13, 2007 3:53 PM, Daniel Mikic <[EMAIL PROTECTED]> wrote:
> Hi, i hit a weird behavior:
>
> select date(null); #result is null
> select if(date(null) is null, 1, 2); #result is 2 (not null)
> select if(date(null) is not null, 1, 2); #result is 1
>
>
Hi, i hit a weird behavior:
select date(null); #result is null
select if(date(null) is null, 1, 2); #result is 2 (not null)
select if(date(null) is not null, 1, 2); #result is 1
I use mysql version 5.0.32-Debian_7etch1-log.
Is this a bug and if not, can anyone explain why?
Thanks,
Daniel
We are getting a weird DROP DATABASE error
>>>>>>>>>
2007-06-10 11:25:41 db 527 DEBUGDROP DATABASE BCS
OperationalError: (1051, "Unknown table
'assignments,chemo,choicelists,dia,forms
,horm,id,permissions,qhistory,qnotes,qstates,questionnaires,r'
Thanks Jerome.
With the high number of "aborted_clients", it seems like you might have
networking issues:
http://dev.mysql.com/doc/refman/5.0/en/communication-errors.html
Dan
On Tuesday 15 May 2007 02:56, Dan Buettner wrote:
> Hi JM -
>
> Can you send us a few things?
>
> 1 - the exact error message you get
the error code it produced is (110) which according to perror is connection
time out..
> 2 - the output of "SHOW VARIABLES;" from a mysql session
+---
DB the server won't respond immediately
causing the conenct to time-out..
Does your script start with an information_schema query? The frist one
of those is painfully slow with MySQL.
Did you try set_time_limit( 0 )?
PB
-
JM wrote:
after trying it again ang again.. maybe for the 5th t
Hi JM -
Can you send us a few things?
1 - the exact error message you get
2 - the output of "SHOW VARIABLES;" from a mysql session
3 - the output of "SHOW STATUS;" from a mysql session
What have you tried so far in terms of troubleshooting that has been
unsuccessful?
Any recent changes on the
after trying it again ang again.. maybe for the 5th time.. PHP will now be
able to connect..
On Monday 14 May 2007 22:34, JM wrote:
> Hi,
>
> Im using MySQL-5.0.19-0 and for some reason when ever PHP connects to
> the
> DB the server won't respond immediately causing the conenct to time-o
Hi,
Im using MySQL-5.0.19-0 and for some reason when ever PHP connects to
the DB
the server won't respond immediately causing the conenct to time-out.. No
firewall issues and no network related issues. The only thing that I noticed
is that the server's average load is 60%.
Thanks,
Ok the Query i am trying to run is very long with many joins it is only run a
couple of times every two weeks for payroll.
It worked well on 4.1alpha and we have now upgraded to 5.0.24a-log
Running on 64 Bit AMD Linux
Each section of the query works correctly and if i run only a two or 3 day
s
more
than a few hours of experience with the MySQL codebase can see some possible
pitfalls in this fix.
Thx
ImRe
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: 23 November 2006 12:14
> To: 'mysql@lists.mysql.com'
> Subject: Weird error
Hi,
I am trying to use stored functions through the prepared statement C API. I
have one application that issues relatively long running queries, while the
other is doing some inserts, updates, and short queries. If the second
application somehow calls a stored function (either directly through
In the last episode (Aug 31), Renald Buter said:
> On 12:27 Thu 31 Aug , Duncan Hill wrote:
> > On Thursday 31 August 2006 12:21, Renald Buter wrote:
> > > The problem is that a simple 1-table query shows different
> > > answers depending on whether you select 1 or 2 columns.
>
> *blush*
>
>
On 12:27 Thu 31 Aug , Duncan Hill wrote:
> On Thursday 31 August 2006 12:21, Renald Buter wrote:
>
> > The problem is that a simple 1-table query shows different answers
> > depending on whether you select 1 or 2 columns.
*blush*
Of course. I see. How stupid.
Thanks and sorry to have bother
On Thursday 31 August 2006 12:21, Renald Buter wrote:
> The problem is that a simple 1-table query shows different answers
> depending on whether you select 1 or 2 columns.
Relational databases are founded on mathematical set theory. Unless you
specify an ORDER BY stanza in your query, the data
On 11:34 Thu 31 Aug , Renato Golin wrote:
> Renald Buter wrote:
> >Odd, eh? But what's worse, the JOIN between this column and other
> >columns *also* uses this truncated values and the result is bogus.
>
> I wouldn't say odd, as you didn't specified any order I wouldn't rely on
> the order o
Renald Buter wrote:
Odd, eh? But what's worse, the JOIN between this column and other
columns *also* uses this truncated values and the result is bogus.
I wouldn't say odd, as you didn't specified any order I wouldn't rely on
the order of the output. Try ordering things for what you want and
Hello list,
I've found this strange select bug in retrieving rows from a table. I
can best illustrate this with an output of two queries:
mysql> select id,jn from paper_2001 limit 10;
+--+---+
| id | jn|
+--+---+
| 19360350 | 6165 |
| 19360351 | 6165 |
|
mes Sherwood" <[EMAIL PROTECTED]>
Cc: "mysqllist"
Sent: Monday, June 19, 2006 11:56 AM
Subject: Re: Weird error when creating a field
James, that is a "permission denied" OS error.
When you run an alter table command (adding a field) MySQL builds a new
table alongs
James, that is a "permission denied" OS error.
When you run an alter table command (adding a field) MySQL builds a new
table alongside the old, then swaps them. Some file move/rename
perations are associated with that.
I would check that the mysql user on your system has full privileges on
James Sherwood schrieb:
Hello,
Today we tried to create a new field on a table in one of our databases. When
we tried to save the field we get the error:
Error on rename of "./DBNAME/TABLENAME.MYI" to "./DBNAME/#SQL2-210-174.MYI"
(Errorcode: 13)
Has anyone ever seen this before?
Thanks,
Ja
Hello,
Today we tried to create a new field on a table in one of our databases. When
we tried to save the field we get the error:
Error on rename of "./DBNAME/TABLENAME.MYI" to "./DBNAME/#SQL2-210-174.MYI"
(Errorcode: 13)
Has anyone ever seen this before?
Thanks,
James
Vinny <[EMAIL PROTECTED]> wrote on 03/29/2006 03:52:33 PM:
> Hello All,
> I am running across a very weird problem.
> Sometimes when a person paste text from a Worddoc
> into the text field of our webapp, the insert fails. Unfortunately
> I am not seeing the failure in the
R try converting your TEXT field into a LONGTEXT field.
Just a few thoughts...
J.R.
-Original Message-
From: Vinny [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 29, 2006 3:53 PM
To: mysql@lists.mysql.com
Subject: Weird M$ Pasting issue
Hello All,
I am running across a very weird pr
Hello All,
I am running across a very weird problem.
Sometimes when a person paste text from a Worddoc
into the text field of our webapp, the insert fails. Unfortunately
I am not seeing the failure in the logs. There are a lot of factors
to consider. The path to mysql looks like this.
Firefox
t; In practice they are not.
>
> On Sun, 12 Feb 2006, Aaron Axelsen wrote:
>
>
>> To: mysql@lists.mysql.com
>> From: Aaron Axelsen <[EMAIL PROTECTED]>
>> Subject: Weird MySQL Connection Issues
>>
>> I have been experiencing some weird MySQL connect
, theory and practice are the same;
In practice they are not.
On Sun, 12 Feb 2006, Aaron Axelsen wrote:
> To: mysql@lists.mysql.com
> From: Aaron Axelsen <[EMAIL PROTECTED]>
> Subject: Weird MySQL Connection Issues
>
> I have been experiencing some weird MySQL connection issues
I have been experiencing some weird MySQL connection issues lately.
Twice now in that last couple weeks, there have been times where some
mysql applications are working, and others are not working. Both times
the mysql connection limit was rather high. A simple mysql restart has
fixed the
- Original Message -
From: "John Doe" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Sent: Sunday, January 15, 2006 6:15 PM
Subject: Re: Weird behaviour of Load Data
Rhino am Sonntag, 15. Januar 2006 23.53:
I'm getting some odd behaviour
I'm getting some odd behaviour from the 'load data' command which I can't
resolve. For some reason, 'load data' is putting a quotation at the end of
the first column of the table
Here is my table definition:
create table if not exists Ref
(ref_name varchar(30) not null,
ref_org varchar(30) not
r 26, 2005 9:25 AM
Subject: weird innodb foreign key feature
I'm using MySQL Ver 14.7 Distrib 4.1.9, for pc-linux-gnu (i686) on
RedHat Linux 9
and found this weird thing
I create first table
CREATE TABLE `t_keycode` (
`keycode_id` int(11) NOT NULL auto_increment,
`keycode_val
- Original Message -
From: "Ady Wicaksono" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, October 26, 2005 9:25 AM
Subject: weird innodb foreign key feature
I'm using MySQL Ver 14.7 Distrib 4.1.9, for pc-linux-gnu (i686) on
RedHat Linux 9
and f
I'm using MySQL Ver 14.7 Distrib 4.1.9, for pc-linux-gnu (i686) on
RedHat Linux 9
and found this weird thing
I create first table
CREATE TABLE `t_keycode` (
`keycode_id` int(11) NOT NULL auto_increment,
`keycode_val` varchar(255) NOT NULL default '',
`keycode_desc` varcha
I'm using MySQL Ver 14.7 Distrib 4.1.9, for pc-linux-gnu (i686) on
RedHat Linux 9
and found this weird thing
I create first table
CREATE TABLE `t_keycode` (
`keycode_id` int(11) NOT NULL auto_increment,
`keycode_val` varchar(255) NOT NULL default '',
`keycode_desc` varcha
> -Original Message-
> From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 28, 2005 06:30
> To: mysql@lists.mysql.com
> Subject: Re: Weird database files
>
>
> Hello.
>
> > On the master we're still running 4.0.16, the s
ead_log_event(): 'Event too big',
>>>data_len: 1953458240, event_type: 119
>>>ERROR: Could not read entry at offset 66113944 : Error in=20
>>
>>log format
>>
>>>or read error
>>>=20
>>>And then there are the w
ter server. It complains that:
> >
> > ERROR: Error in Log_event::read_log_event(): 'Event too big',
> > data_len: 1953458240, event_type: 119
> > ERROR: Could not read entry at offset 66113944 : Error in
> log format
> > or read error
> >
> &
e master server. It complains that:
> >
> > ERROR: Error in Log_event::read_log_event(): 'Event too big',
> > data_len: 1953458240, event_type: 119
> > ERROR: Could not read entry at offset 66113944 : Error in
> log format
> > or read error
>
> using mysqlbinlog on the master server. It complains that:
>
> ERROR: Error in Log_event::read_log_event(): 'Event too big', data_len:
> 1953458240, event_type: 119
> ERROR: Could not read entry at offset 66113944 : Error in log format or
> read error
>
> An
::read_log_event(): 'Event too big', data_len:
1953458240, event_type: 119
ERROR: Could not read entry at offset 66113944 : Error in log format or
read error
And then there are the weird table files that showed up in the data
directory for the database (all MyISAM):
-rw-rw1 mysq
Yah, I tested in SQL*Plus - one window could see inserts, updates and
deletes that had been committed in another window (in which a commit or
rollback had not been issued). I ran the test again - delete data from a
table in one window and commit the change, and a select in the other
window disp
If you are NOT in autocommit mode, your connection (or the server, it
doesn't matter which) starts a transaction *when you issue your first
command*. Every command you issue on that connection is in that initial
transaction until you EXPLICITLY commit or rollback (or do something else
that comm
I believe you - I'm just a but surprised. I guess I had a singular view
of how a session should work based on Oracle. I would have expected that
until you execute SQL that requires a commit or a rollback, you wouldn't
be in a transaction. Unfortunately, if you have connections that are
read and
David Griffiths wrote:
"No, with the default transaction isolation level, REPEATABLE READ,
that's how it is supposed to work. You've started a transaction in
Window B, so Window B is immune to changes made in Window A until you
finish the transaction in Window B. See the manual for details
h
"No, with the default transaction isolation level, REPEATABLE READ,
that's how it is supposed to work. You've started a transaction in
Window B, so Window B is immune to changes made in Window A until you
finish the transaction in Window B. See the manual for details
http://dev.mysql.com/doc
On Wed, Aug 31, 2005 at 11:18:40PM -0400, Michael Stassen wrote:
> No, with the default transaction isolation level, REPEATABLE READ, that's
> how it is supposed to work. You've started a transaction in Window B, so
> Window B is immune to changes made in Window A until you finish the
> transac
David Griffiths wrote:
I just discovered some weird behaviour with MySQL 4.0 (4.0.24 and
4.0.18) using InnoDB.
If you have two connections to mysql (I use the mysql client), one of
which has autocommit turned on, an the other turned off, a row deleted
from the client with autocommit turned
I just discovered some weird behaviour with MySQL 4.0 (4.0.24 and
4.0.18) using InnoDB.
If you have two connections to mysql (I use the mysql client), one of
which has autocommit turned on, an the other turned off, a row deleted
from the client with autocommit turned on still shows up in the
Actually, it came from Mysql 4.1.1 (not 4.1.3 as I mentioned earlier).
When I do select queries, the data displays just fine, but when I dump,
I get this garbage.
Jeremy Cole wrote:
Hi Steve,
I'm trying to export data from mysql 4.1.3 with mysqldump.
I'm getting weird characters from
Hi Steve,
I'm trying to export data from mysql 4.1.3 with mysqldump.
I'm getting weird characters from the system. Here's what I've discovered
so far:
' becomes ^À^Ù, e.g. didn't becomes didnâ^À^Ùt
- becomes â^À^Ó, e.g. 1-2 becomes 1â^À^Ó2
è becomes è, e.g. Ent
In the last episode (Apr 12), Steve Lefevre said:
> Hey folks --
>
> I'm trying to export data from mysql 4.1.3 with mysqldump.
>
> I'm getting weird characters from the system. Here's what I've discovered
> so far:
>
> ' becomes ^`A^`U, e.g. d
Hey folks --
I'm trying to export data from mysql 4.1.3 with mysqldump.
I'm getting weird characters from the system. Here's what I've discovered
so far:
' becomes ^À^Ù, e.g. didn't becomes didnâ^À^Ùt
- becomes â^À^Ó, e.g. 1-2 becomes 1â^À^Ó2
è becomes è, e.g
Yes, It's pretty obvious now. Thank you all for the help.
Mattias Håkansson
- Original Message -
From: "Gabriel PREDA" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, April 05, 2005 12:15 PM
Subject: Re: Weird Query Result
> Not weird at all...
> As you can see
Mattias Håkansson wrote:
Hello,
I'm using MySQL 4.0.20 on Linux and I am experiencing some problems with a
query result.
I have the following table structure:
mysql> desc gen_Lloyds_vessel;
+-+--+--+-+-++
| Field | Type
Not weird at all...
As you can see it returnet all rows where "iImo" equals 0... that is becuase
of the CAST applied...
iImo is int(11) thus MySQL is casting 'FOOBAR' and the result is 0.
Try:
mysql> SELECT CAST('FOOBAR
Hello,
I'm using MySQL 4.0.20 on Linux and I am experiencing some problems with a
query result.
I have the following table structure:
mysql> desc gen_Lloyds_vessel;
+-+--+--+-+-++
| Field | Type | Null | Key | Def
Check the size of your partition that contains /tmp directory.
Just in case symlink it to a bigger partition. Your temporary table may
be bigger than the available space in /tmp
Luck,
Mihail
Homam S.A. wrote:
Whenever I try to update an ISAM table (through a join
with nother small lookup table, a
Whenever I try to update an ISAM table (through a join
with nother small lookup table, also ISAM), I get the
following error:
Error Code : 1114
The table '#sql_910_0' is full
I read the following in the documentation:
http://dev.mysql.com/doc/mysql/en/full-table.html
But none of the reasons lis
Hello.
Do you use mysql client program from the old release? Use
mysql --version
to check the version.
"Sehn, Timothy" <[EMAIL PROTECTED]> wrote:
> I am running IntranetMySQL (ie. MySQL 4.1.9) and I am getting the =
> strangest error:
>
> mysql> use devmail
> Reading table informa
I am running IntranetMySQL (ie. MySQL 4.1.9) and I am getting the strangest
error:
mysql> use devmail
Reading table information for completion of table and column names You can turn
off this feature to get a quicker startup with -A
Database changed
mysql> select type_name from faq_type;
+--
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Je ÄaÅdo Januaro 27 2005 08:40, Jigal van Hemert skribis:
> > Currently I have a query that is able to return (doing a left join):
> > 'A', 'B', 'E'
> > 'A', 'B', 'F'
> > 'C', 'D', NULL
> > But I need this:
> > 'A', 'B', 'E,F'
> > 'C', 'D', NULL
> > Ca
> Currently I have a query that is able to return (doing a left join):
> 'A', 'B', 'E'
> 'A', 'B', 'F'
> 'C', 'D', NULL
> But I need this:
> 'A', 'B', 'E,F'
> 'C', 'D', NULL
> Can SQL help me in any way here ? or do I have to do it by programming ?
If you use MySQL 4.1 or later take a look at
http
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I'm in need of doing the following.
I have a table, let's say, with a record like this:
1, 'A', 'B'.
2, 'C', 'D'
And then I have another table with records like this:
1, 'E'
1, 'F'.
Currently I have a query that is able to return (doing a left join):
'
07, 2005 3:28 PM
Subject: weird syntax error
> When I use 4.0 on windows I don't get this error but now that i'm using
> 4.1.x I'm getting error 1064 , is BLOB depricated or something ??? Please
> help !
>
> thanks in advance
>
When I use 4.0 on windows I don't get this error but now that i'm using
4.1.x I'm getting error 1064 , is BLOB depricated or something ??? Please
help !
thanks in advance
===
Your MySQL connection id is 97 to server version: 4.1.8-standard
Type 'help;'
On Thu, 2004-12-30 at 16:19 -0700, Sasha Pachev wrote:
> Dale Blount wrote:
> > Hello,
> >
> > I've been fighting this problem for a while, and now it's time to ask
> > the experts. Please also CC me on this, I'm only on the list as a
> > digest.
>
> Dale:
>
> Enable the log-long-format and log
Dale Blount wrote:
Hello,
I've been fighting this problem for a while, and now it's time to ask
the experts. Please also CC me on this, I'm only on the list as a
digest.
Dale:
Enable the log-long-format and log-slow-queries on your server, and see if you
have some hogs that lock your table for a
to 0.05% or so
of the queries (identical) take longer than expected to complete. Most
queries are reported as completing in 0.030 seconds or less as reported
by time(1). The queries I'm having problems with take 5-15 seconds to
complete, but the weird part is that they're the exact same q
Daniel,
- Original Message -
From: "Daniel Andersen" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Tuesday, December 21, 2004 1:04 AM
Subject: Re: Weird load issues
On Mon, 20 Dec 2004 09:29 pm, Heikki Tuuri wrote:
Daniel,
it is simply processing bi
On Mon, 20 Dec 2004 09:29 pm, Heikki Tuuri wrote:
> Daniel,
>
> it is simply processing big SELECT queries. Maybe their optimization
> changed lately? You should tune your queries.
>
> You should also tune InnoDB, because you are running with the default 8 MB
> buffer pool size, and it is reading i
6 AM
Subject: Re: Weird load issues
please post the complete outputs of
SHOW PROCESSLIST;
and
SHOW INNODB STATUS
during such CPU peak.
> Daniel
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which al
> please post the complete outputs of
>
> SHOW PROCESSLIST;
>
> and
>
> SHOW INNODB STATUS
>
> during such CPU peak.
>
> > Daniel
>
> Best regards,
>
> Heikki Tuuri
> Innobase Oy
> Foreign keys, transactions, and row level locking for MySQL
> InnoDB Hot Backup - a hot backup tool for InnoDB which a
No InnoDB here, just some old ISAM tables.
Sorry about my stupidity on this one, I have only myself to blame...
I have a bunch of old-school ISAM tables that need to be converted to
MyISAM, is there any way to do this en-masse?
(I.E. not having to go through each DB in the DBMS and
ALTER TABLE t
Daniel,
- Original Message -
From: "Daniel Andersen" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Friday, December 17, 2004 2:04 AM
Subject: Weird load issues
Hey,
A couple days ago my SQL server started hogging the entire CPU for no
reason
that I can f
Hey,
A couple days ago my SQL server started hogging the entire CPU for no reason
that I can find. I'm running MySQL 4.0.20 on Slackware 9.1 (i think), kernel
version 2.4.22. The process using up all the CPU is the parent process, ie
the top level mysql process that starts all the others.
The
I have a MySQL DBMS running with a mysql DB that apparently is an InnoDB
DB, all other DBs in this DBMS are MyISAM. When I try to upgrade, I get
the following output:
041215 16:41:53 mysqld started
InnoDB: Resetting space id's in the doublewrite buffer
041215 16:41:57 InnoDB: Started; log seque
--- Roger Baklund <[EMAIL PROTECTED]> wrote:
> The WHERE clause describes EACH of the rows you get
> in the result. No
> one row can have a value in the School column equal
> to "Columbia" AND
> "Stamford" at the same time. You should use OR
> instead of AND.
>
Thank you Roger. That is one of
--- [EMAIL PROTECTED] wrote:
> There is nothing weird about that behavior. You
> asked for all of the rows
> where the School column has both of two different
> values at the same time.
I thought joins were difficult to comprehend ;)
> Try an OR instead or use the IN() opera
1 - 100 of 246 matches
Mail list logo
