ryone else.
Humbly embarrassed,
Shawn
Forwarded Message
Subject: Re: Something strange here...
Date: Wed, 14 Jun 2017 14:04:02 -0400
From: shawn l.green
Organization: Oracle Corporation
To: Chris Knipe
Hello Chris,
On 6/13/2017 5:42 PM, Chris Knipe wrote:
Hi all,
Can someone
2017/06/13 17:42 ... Chris Knipe:
Can someone explain to me why this is happening please:
mysql> SELECT * FROM CustomerDetails WHERE Username=’blah’\G
*** 1. row ***
EntryID: F83D4109-DCA8-426F-98B1-00B4AF117ACB
Username: bla
Hi all,
Can someone explain to me why this is happening please:
mysql> SELECT * FROM CustomerDetails WHERE Username=âblahâ\G
*** 1. row ***
EntryID: F83D4109-DCA8-426F-98B1-00B4AF117ACB
Username: blah
AccountVolume: 0
1 row i
en log out, and log back in with the root pw.
Good luck.
-Original Message-
From: Ajay Garg [mailto:ajaygargn...@gmail.com]
Sent: May-25-15 11:24 AM
To: Mailing-List mysql
Subject: Very strange issue while trying to login remotely
Hi All.
I have two servers, 1.2.3.4 and 5.6.7.8
I wish to
it will not prompt for a password with the '-p'
try this:
mysql --host 5.6.7.8 -uroot db_name -p
I assume you do have a password set?
On Mon, May 25, 2015 at 11:24 AM, Ajay Garg wrote:
> Hi All.
>
> I have two servers, 1.2.3.4 and 5.6.7.8
> I wish to login remotely FROM 1.2.3.4 onto 5.6.7.8.
>
Sorry,
The user had multiple passwords set up in mysql.user table.
Clearing the "other" passwords solved the issue.
Sorry for the inconvenience.
Thanks and Regards,
Ajay
On Mon, May 25, 2015 at 8:54 PM, Ajay Garg wrote:
> Hi All.
>
> I have two servers, 1.2.3.4 and 5.6.7.8
> I wish to login
Hi All.
I have two servers, 1.2.3.4 and 5.6.7.8
I wish to login remotely FROM 1.2.3.4 onto 5.6.7.8.
a)
On 5.6.7.8,
mysql> show grants for 'root'@'%';
+-+
| Grants for root@% |
+
uns on InnoDB backend.
>
> Also, changed the subject to be more specific.
>
>
> On Sat, Sep 6, 2014 at 2:26 PM, Ajay Garg wrote:
> > Hi all.
> >
> >
> > We are facing a very strange scenario.
> >
> > We have two mysql-instances running on the same machi
Sorry, forgot to specify the engine.
The table runs on InnoDB backend.
Also, changed the subject to be more specific.
On Sat, Sep 6, 2014 at 2:26 PM, Ajay Garg wrote:
> Hi all.
>
>
> We are facing a very strange scenario.
>
> We have two mysql-instances running on the same
> Cc: mysql@lists.mysql.com
> Subject: Re: Strange Replication Behavior
>
> I believe the master.info and relay-log.info are only on the slaves and
> are specific to each slave (as each slave could be at a different point
> in the bin-log.)
>
> Thanks,
>
> Carl
&g
I believe the master.info and relay-log.info are only on the slaves and are
specific to each slave (as each slave could be at a different point in the
bin-log.)
Thanks,
Carl
On Jul 25, 2012, at 2:22 PM, Richard Reina wrote:
> I am trying to setup a new slave server and when I go to the master
I am trying to setup a new slave server and when I go to the master to
copy over master master.info and relay-log.info they seem to be
missing? Not in /var/lib/mysql and could not find it with #: find /
-name master.info
The master server has been setup for years and already has three
slaves repli
Hello Lay,
On 2/22/2012 07:05, Lay András wrote:
Hi!
I have a table:
CREATE TABLE IF NOT EXISTS `test` (
`id` int(11) NOT NULL auto_increment,
`cucc` varchar(255) character set utf8 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `test` (`id`, `cucc
Hi!
I have a table:
CREATE TABLE IF NOT EXISTS `test` (
`id` int(11) NOT NULL auto_increment,
`cucc` varchar(255) character set utf8 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `test` (`id`, `cucc`) VALUES
(1, 'egyszer'),
(2, 'ketszer'),
(3, 'ketszer'
Thanks, it seems to be working now. I just discovered "WITH ROLLUP". It made me
very
happy on this project...
On 2/8/12 2:54 AM, Arthur Fuller wrote:
I'm not sure your method isn't working, but try changing changing the "to date" part to
"< '2012-02-08' " and see what you get.
HTH,
Arthur
I'm not sure your method isn't working, but try changing changing the "to
date" part to "< '2012-02-08' " and see what you get.
HTH,
Arthur
I am having a problem with select results that I don't understand. It seems to
be tied up with a GROUP BY statement. Forgive the complexity of the SQL, I
inherited some problematic data structuring.
If I use this statement:
SELECT lu_rcode_bucket.bucket AS 'BUCKET',
CP_PKG.value AS 'PRODU
Try searching for a row that has a login_date of '-00-00 00:00:00'
- Derek
On Sep 9, 2011, at 8:52 AM, umapathi b wrote:
> Any update from anybody ?
>
>
> -- Forwarded message --
> From: umapathi b
> Date: Thu, Sep 8, 2011 at 4:28 AM
> Su
Any update from anybody ?
-- Forwarded message --
From: umapathi b
Date: Thu, Sep 8, 2011 at 4:28 AM
Subject: Re: strange mysql update ..
To: Ananda Kumar
Cc: mysql@lists.mysql.com
Here is the o/p after the update ..
user_id: 16078845
drivers_license
Nice Rik!
On Thu, Sep 8, 2011 at 3:19 PM, Rik Wasmus wrote:
> > I fired the update statement in a wrong way ..like this ..
> >
> > update user_info set login_date='2011-08-05 04:15:05' and user_id
> =16078845
> > limit 1 ;
> > ( I forgot to use where . instead of where I used and )
> > update us
> I fired the update statement in a wrong way ..like this ..
>
> update user_info set login_date='2011-08-05 04:15:05' and user_id =16078845
> limit 1 ;
> ( I forgot to use where . instead of where I used and )
> update user_info set login_date='2011-08-05 04:15:05' where user_id
> =16078845 limit
Here is the o/p after the update ..
user_id: 16078845
drivers_license: TEST1140DL
login_date: 2011-06-19 11:20:07
course_id: 1011
regulator_id: 10840
test_info:
completion_date: 2011-06-19 11:37:16
print_date: NULL
passwor
Can you lets us know what is the output of
select * from user_info where user_id=16078845;
On Thu, Sep 8, 2011 at 1:02 PM, umapathi b wrote:
> I wanted to change the login_date of one user . The original data of that
> user is like this ..
>
> select * from user_info where user_id = 16078845 \G
I wanted to change the login_date of one user . The original data of that
user is like this ..
select * from user_info where user_id = 16078845 \G
*** 1. row ***
user_id: 16078845
drivers_license: TEST1140DL
login_date: 2011-06-
quot;
> To: mysql@lists.mysql.com
> Sent: Thursday, 4 August, 2011 4:17:50 PM
> Subject: strange warnings after upgrade...
>
> We just upgraded our mysql from 5.0.32 on debian lenny, to 5.1.49 on
> debian squish.
>
> I wasn't told that it was doing an incremental version up
We just upgraded our mysql from 5.0.32 on debian lenny, to 5.1.49 on
debian squish.
I wasn't told that it was doing an incremental version upgrade, i was
under the impression it was just going from 5.0.32 to 5.0.8x.
Anyways, I am getting some weird issues now, that is filling up the
syslog, and i
On 31.03.11 12.52, Andrew Braithwaite wrote:
Hi,
Mysql> select curdate() + interval 6 month - interval 6 month;
+-+
| curdate() + interval 6 month - interval 6 month |
+-+
| 2011-03-30
Hi,
Mysql > select curdate() + interval 6 month - interval 6 month;
+-+
| curdate() + interval 6 month - interval 6 month |
+-+
| 2011-03-30 |
+-
5,'anakin');
insert into test_nkomp_admin3 (host_id,admin_id) values
(6,'luke'),(6,'yoda');
mysql> select * from test_nkomp_admin where host_id=6 and admin_id="yoda" ;
Empty set (0,00 sec)
mysql> select * from test_nkomp_admin2 where host_id=6 and admin_id=
d=6 and admin_id="yoda" ;
+-+--+
| host_id | admin_id |
+-+--+
| 6 | yoda |
+-+--+
1 row in set (0,00 sec)
mysql> select * from test_nkomp_admin3 where host_id=6 and admin_id="yoda" ;
+-+--+
| host_id | admin
gregor kling [mailto:gregor.kl...@dvz.fh-giessen.de]
Sent: Thursday, October 28, 2010 1:54 PM
To: mysql@lists.mysql.com
Subject: strange behavior in mysql-server 5.1.49 and 5.1.51
Hello list,
I fight a strange behavior in mysql versions 5.1.49 and 5.1.51 -
maybe a fight against myself ;-)
The fo
egor kling [mailto:gregor.kl...@dvz.fh-giessen.de]
Sent: Thursday, October 28, 2010 1:54 PM
To: mysql@lists.mysql.com
Subject: strange behavior in mysql-server 5.1.49 and 5.1.51
Hello list,
I fight a strange behavior in mysql versions 5.1.49 and 5.1.51 -
maybe a fight against myself ;-)
The following query wor
Hello list,
I fight a strange behavior in mysql versions 5.1.49 and 5.1.51 -
maybe a fight against myself ;-)
The following query works exactly as assumed in version 5.1.41 with
the given testbed:
select * from test_nkomp_admin where host_id=6 and admin_id="yoda";
/* version 5.1
Hello list,
I fight a strange behavior in mysql versions 5.1.49 and 5.1.51 -
maybe a fight against myself ;-)
The following query works exactly as assumed in version 5.1.41 with
the given testbed:
select * from test_nkomp_admin where host_id=6 and admin_id="yoda";
/* version 5.1
In the last episode (Sep 18), Victor Subervi said:
> Can someone please explain to me why Passengers.weight comes up null for
> the last value sometimes, and other times it comes up with the value 155??
Passengers id 1 through 3 have a weight of NULL in the Passengers table, and
passenger 4 has a
Hi;
Can someone please explain to me why Passengers.weight comes up null for the
last value sometimes, and other times it comes up with the value 155??
mysql> select p.id, c.id, p.name, p.weight, m.amount, p.round_trip,
c.first_name, c.middle_name, c.last_name, c.suffix, c.sex, p.confirmation,
m.t
In regards to this issue, I submitted a bug.
http://bugs.mysql.com/56157
nixofortune wrote:
Hi ALL,
I just start using Workbench 5.2.26 CE and this is a problem I have.
When I try to run a query with a case statement, columns with datetime
Type shown as "BLOB" in output window.
To see the out
Hi ALL,
I just start using Workbench 5.2.26 CE and this is a problem I have.
When I try to run a query with a case statement, columns with datetime Type
shown as "BLOB" in output window.
To see the output data I have to right click inside of the cell, choose
"Open Value in Viewer" and see text.
Exa
sorry I went to sleep CEST here,
its created by default by MySQL
Cheers!
Claudio
On 8/1/2010 2:15 AM, Corey wrote:
On Saturday 31 July 2010 5:11:33 Claudio Nanni wrote:
login as root and remove 'empty' user ,issue:
delete from mysql.user where user='';
flush privileges;
mysql authenti
sorry I went to sleep CEST here,
its created by default by MySQL
Cheers!
Claudio
On 8/1/2010 2:15 AM, Corey wrote:
On Saturday 31 July 2010 5:11:33 Claudio Nanni wrote:
login as root and remove 'empty' user ,issue:
delete from mysql.user where user='';
flush privileges;
mysql authenti
On Saturday 31 July 2010 5:11:33 Claudio Nanni wrote:
> login as root and remove 'empty' user ,issue:
>
> delete from mysql.user where user='';
> flush privileges;
>
> mysql authentication system is logging you on as 'empty' user.
>
> you will be ok after that ;)
>
Man, thanks a ton! That wa
login as root and remove 'empty' user ,issue:
delete from mysql.user where user='';
flush privileges;
mysql authentication system is logging you on as 'empty' user.
you will be ok after that ;)
Claudio
On 8/1/2010 2:02 AM, Corey wrote:
On Saturday 31 July 2010 4:58:36 Claudio Nanni wrote:
On Saturday 31 July 2010 4:58:36 Claudio Nanni wrote:
> after login to mysql issue:
>
> select user();
> and
> select current_user();
> and post output
> you will see they dont match.
>
/usr/local/mysql/bin/mysql -h localhost -u scripts -p
Enter password:
Welcome to the MySQL monitor. Command
after login to mysql issue:
select user();
and
select current_user();
and post output
you will see they dont match.
Claudio
On 8/1/2010 1:47 AM, Corey wrote:
On Saturday 31 July 2010 4:40:14 chaim rieger wrote:
Another thing I just noticed
In your first example you are using localhost, w
On Saturday 31 July 2010 4:40:14 chaim rieger wrote:
> Another thing I just noticed
>
> In your first example you are using localhost, which probably means you are
> connecting via network
>
> The second option you don't define a host, which means you're prolly using
> socket connection
Oh, whoo
Another thing I just noticed
In your first example you are using localhost, which probably means you are
connecting via network
The second option you don't define a host, which means you're prolly using
socket connection
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
On Saturday 31 July 2010 4:30:00 chaim rieger wrote:
> Just a stab but what's the max connect set to ?
>
Thanks a ton for the quick response - I'm at wits end, been working on
this for hours!
max_connections is set to 0.
(but it is also set to 0 on another server, which largely follows the
same
Just a stab but what's the max connect set to ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hello - I'm only moderately familiar with mysql; the following issue has me
stumped.
I just noticed that some scripts on one of my client's servers suddenly
started failing due to being no longer able to log into the mysql db.
I have not touched the mysql config on that machine in months.
The
Steven,
On Wed, Jun 16, 2010 at 9:09 AM, Steven Staples wrote:
> Baron,
>
> Out of curiosity, do you (or anyone else) know what could be an issue with
> upgrading to even 5.0.93? or even the 5.1 branch?
>
> There are a lot of stored procedures/functions, as well as the fact that it
> is being re
il.com [mailto:baron.schwa...@gmail.com] On Behalf
> Of Baron Schwartz
> Sent: June 15, 2010 4:56 PM
> To: mysql@lists.mysql.com
> Subject: Re: Strange GREATEST() result in 5.0.32
>
> Steven,
>
> On Tue, Jun 1, 2010 at 11:15 AM, Steven Staples wrote:
> > Hello all
> >
> >
Steven,
On Tue, Jun 1, 2010 at 11:15 AM, Steven Staples wrote:
> Hello all
>
> I have a stored procedure that probably does a lot more than it should, but
> it works fine on my test server (which is running 5.0.67). When I moved it
> over to the production server, (which is running 5.0.32 and I
uting the
Query/Calling the Procedure.
Regards,
VR Venugopal Rao
--- On Fri, 28/5/10, Manasi Save
wrote:
From: Manasi Save Subject: Strange behavior by MySQL Stored ProcedureTo:
mysql@lists.mysql.comDate: Friday, 28 May, 2010, 5:44 PM
Dear All, I have one stored procedure
Which inserts data into
> > >
> > >-Original Message-
> > >From: Machiel Richards [mailto:machi...@rdc.co.za]
> > >Sent: 02 June 2010 9:41 AM
> > >To: mysql@lists.mysql.com
> > >Subject: Strange errors / messages on slave server
> > >
> > &
mailto:machi...@rdc.co.za]
> >Sent: 02 June 2010 9:41 AM
> >To: mysql@lists.mysql.com
> >Subject: Strange errors / messages on slave server
> >
> >Good day all
> >
> >
> >
> > I hope someone can assist me with this.
> >
> >
> >
>
Wed, Jun 2, 2010 at 2:22 PM, Jerry Schwartz wrote:
> >-Original Message-
> >From: machiel.richards [mailto:machiel.richa...@gmail.com]
> >Sent: Wednesday, June 02, 2010 3:56 AM
> >To: mysql@lists.mysql.com
> >Subject: RE: Strange errors / messages
>-Original Message-
>From: machiel.richards [mailto:machiel.richa...@gmail.com]
>Sent: Wednesday, June 02, 2010 3:56 AM
>To: mysql@lists.mysql.com
>Subject: RE: Strange errors / messages on slave server
>
>Hi All
>
> Just one other note on this issue ex
ocedure} method.
Please check the same or let us know how you are executing the
Query/Calling the Procedure.
Regards,
VR Venugopal Rao
--- On Fri, 28/5/10, Manasi Save
wrote:
From: Manasi Save Subject: Strange behavior by MySQL Stored ProcedureTo:
mysql@lists.mysql.comDate: Friday, 28 May, 2010, 5:44
: Machiel Richards [mailto:machi...@rdc.co.za]
Sent: 02 June 2010 9:41 AM
To: mysql@lists.mysql.com
Subject: Strange errors / messages on slave server
Good day all
I hope someone can assist me with this.
While doing the normal routine daily health checks on one of
Good day all
I hope someone can assist me with this.
While doing the normal routine daily health checks on one of
our clients' servers I came across some strange behaviour from the slave
server. (two servers setup in master / slave replic
Hello all
I have a stored procedure that probably does a lot more than it should, but
it works fine on my test server (which is running 5.0.67). When I moved it
over to the production server, (which is running 5.0.32 and I never thought
to check that the versions were the same before) it works a
: Strange behavior by MySQL Stored Procedure
To: mysql@lists.mysql.com
Date: Friday, 28 May, 2010, 5:44 PM
Dear All,
I have one stored procedure Which inserts data into one table.
But sometimes it does not insert record. This happens when I called it from
java application. But If I called same
mysql Version :- 5.1.42-community-log
mysql Connector/J Version :- mysql-connector-java-5.1.6-bin.jar
Sample Java Code Which Calls stored procedure :-
//get the connection to database
Connection dbConnection = getConnection();
//create the call for procedure
String procedureCallStmtStr =
Hello Manasi,
If possible can you please send in the code that you mentioned (procedure or
trigger).
Please give a detailed technical explanation explaining the query which you
used from command line and the query used in the procedure. Please mention
the table structure, show table status and fe
2010/5/28 Manasi Save :
[...]
> Or am I doing something wrong?
probably;
you better send us another e-mail writing at least:
- mysql version you are using
- mysql Connector/J version you are using
- piece of java code you are using to call the stored procedure
- source of the stored procedure (or
Dear All,
I have one stored procedure Which inserts data into one table.
But sometimes it does not insert record. This happens when I called it from java
application. But If I called same query from mysql command line. It executes
successfully.
Also I have one procedure which only retrieves d
So, as a followup, I ran mysqldump on the actual server (with the output
directed over AFP to another machine on the network) -- as opposed to running
mysqldump on the destination server and connecting to the databases over TCP/IP
(both are running 5.1.39 PPC 64-bit). *That* dump file imported O
Except that, in my case, both machines are running 5.1.39. Mac "OS X" PPC
64-bit. I tried importing another, different dump file of the same database,
and this time mysql returned a different error:
Sat Nov 21 13:16:20 -- Minas-Tirith :: mysql -u root -p < dump_file.sql
Enter password:
ERROR
There is a bug in mysqldump that prevents mysql from version 5.0.80 from
importing dumps from a old version of mysqldump.
I had this verified by MySQL support.
You can have a look at this bug: http://bugs.mysql.com/bug.php?id=41486
Cheers
Claudio
2009/11/21 René Fournier
> It's just odd, bec
It's just odd, because that error was on 5.0. I'm running 5.1.39 -- surely
enough time for the MySQL devs to fix it right?
Could it be with extended inserts that the max statement length is greater than
the default 16MB max allowed packet? I'm increasing that value to 256 MB and
going to try ag
> From: René Fournier [mailto:m...@renefournier.com]
> Sent: Friday, November 20, 2009 8:31 AM
> To: mysql
> Subject: Strange problem with mysqldump / automysqlbackup (ERROR 1300)
>
> I've been using automysqlbackup 2.5 for years on a particular database, and
> it's
Have you tried dumping that table manually using mysqldump on the command line
to confirm it's not an issue with automysqlbackup?
Regards,
Gavin Towey
-Original Message-
From: René Fournier [mailto:m...@renefournier.com]
Sent: Friday, November 20, 2009 8:31 AM
To: mysql
Subject: St
8 character string: '?03422'
Sure enough, I look at the line in dump_file.sql, which should contain two
unsigned ints, and two unsigned small ints:
[...],(32562206,1228?03422,1641,135),[...]
And yup, there's a question mark in the middle of the second unsigned int, for
some
Hi All,
I am facing a strange error in my NDB Cluster database. When I am trying
to insert record in one table using mysql command line. But when I try to
insert record in same table using my java application it is getting
inserted properly.
Through command-line I am getting following error
Andrew Carlson said:
>
> I know this is basic, but check that you recreated the indexes after you
> reloaded the snapshot. That has bit me before.
I used myisamchk -r on the large table, and it has made a huge difference.
I had used myisamchk before to check the table and got no complaints.
M
Perhaps some clues here: I started taking the problem query apart to see
what slows things down. I found a culprit, but I don't understand:
mysql> select count(*) from Crumb where customer_id=380 and Actual_Time BETWEEN
'2009-06-01 00:00' AND '2009-06-02 00:00' and ErrorCode = 0;
+--+
| c
I'm working in an environment where I have two similar servers, one
running "production" the other for "development". They're not very
dissimilar - both run 4.1.20-log, both run CentOS 4.
The development server has a cut-down snapshot of the production
database, and it's where we ... well, develop
Hi,
I am having problem migrating a arabic vbulletin database from a remote
server to my server, as it shows strange characters , or what we call
charset or encoding issue and I have not been able to get past and fix it.
On my server
mysql> show variables like &#
Nicolas Sebrecht a écrit:
> mysql> CREATE DATABASE dbtest;
> mysql> DELIMITER $$
> mysql> DROP PROCEDURE IF EXISTS `dbtest`.`test`$$
> mysql> CREATE PROCEDURE `dbtest`.`test` (newf VARCHAR(130))
> -> BEGIN
> -> SET newf = REVERSE( SUBSTRING_INDEX( REVERSE (newf) , '/', 1));
> -> END$$
Hello,
I need help since I fail to set up a basic stored procedure.
Here are the executed commands and the error I get:
mysql> CREATE DATABASE dbtest;
mysql> DELIMITER $$
mysql> DROP PROCEDURE IF EXISTS `dbtest`.`test`$$
mysql> CREATE PROCEDURE `dbtest`.`test` (newf VARCHAR(130))
->
tance
FROM stations
ORDER BY `distance` ASC
LIMIT 0 , 30
So basically distance is calculated then I just want to order on
this, however this is what I get out
distance
9.6201
5.1337
12.508
3.5312
2.3165
So I'm confused, what strange kind of ordering is that?
Any help much appreciated,
Oliver
liaojian_163 schrieb:
> thank you Sebastian!
> I have re-created the table.there are not any problems in the table.
>
> if the table is new,need to rebuild de indexes?
no
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:
ednesday, April 23, 2008 2:11 PM
Subject: Re: a strange problem
> liaojian_163 schrieb:
>> hi,all.
>> In my mysql server,I have a strange problem.
>> can someone help me?
>> Thank you.
>>
>> mysql> select id,classid,newstime from phome_e
liaojian_163 schrieb:
> hi,all.
> In my mysql server,I have a strange problem.
> can someone help me?
> Thank you.
>
> mysql> select id,classid,newstime from phome_ecms_zhichang where classid=41
> and id >2500 order by id desc limit 10;
> +--+-
I don't think that the limit cause the stange problem.
thank you anyway.
- Original Message -
From: "Phil" <[EMAIL PROTECTED]>
To: "liaojian_163" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, April 23, 2008 3:46 AM
Subject: Re: a strange problem
>
Not knowing your msqyl version, perhaps it's the form of your LIMIT clause.
try LIMIT 0,10 instead.
Phil
2008/4/22 liaojian_163 <[EMAIL PROTECTED]>:
> hi,all.
> In my mysql server,I have a strange problem.
> can someone help me?
> Thank you.
>
> mysql>
hi,all.
In my mysql server,I have a strange problem.
can someone help me?
Thank you.
mysql> select id,classid,newstime from phome_ecms_zhichang where classid=41
and id >2500 order by id desc limit 10;
+--+-+-+
| id | classid | ne
> It's possibly a DNS problem (reverse DNS exactly).
You know, I'm feeling a bit stupid here... That was indeed the problem,
as the new server hadn't been moved on DNS yet.
I put the IP address into the windows hosts file on the DB server, and
the problem cleared up immediately.
Thanks!
-Doug
It's possibly a DNS problem (reverse DNS exactly).
Best regards.
OK folks, I'm kind of stumped; looking into things a bit more, but
thought I'd hit the list and see if anyone had any suggestions for a
rock to look under, in case I'm missing it...
DB Server: Windows 2003, 8-way CPU, lots of RAM, MySQL 4.1.22-nt binary
from MySQL
Current Production web server: Li
Hello,
Marten, in my experience, these are most often temporary files leftover
from an incomplete operation.
They might be from a long-running query that was canceled, or from a
table repair operation that errored out or was interrupted.
In my experience it is safe to delete them, provided
Marten, in my experience, these are most often temporary files leftover from
an incomplete operation.
They might be from a long-running query that was canceled, or from a table
repair operation that errored out or was interrupted.
In my experience it is safe to delete them, provided you take care
Hello,
I was wondering why the partition is almost full, since the databases
aren't very big. Then I noticed these files in the database directory:
-rw-rw 1 mysql mysql4310560 Dec 24 10:13 #sql_10d4_0.MYD
-rw-rw 1 mysql mysql 1024 Dec 24 10:13 #sql_10d4_0.MYI
-rw-rw
At 03:49 PM 2/7/2008, [EMAIL PROTECTED] wrote:
Thanks very much. The default mysql behavior is a little
unusual. What is the parameter in my.cnf to control the cache
size before forcing a flush. I waited for 2 mininutes second
before the output came out without the -q option. My server
is fast e
Thanks very much. The default mysql behavior is a little
unusual. What is the parameter in my.cnf to control the cache
size before forcing a flush. I waited for 2 mininutes second
before the output came out without the -q option. My server
is fast enough to read in more than 2 GB data during this
In the last episode (Feb 07), [EMAIL PROTECTED] said:
> I just stumbled on this hard to explain problem. Below
>
> select * from BigTable (BigTable has 5 million rows)
>
> takes forever to even print out the first row. as you could see from
> the sql, it is supposed to print out some rows ri
Hello:
I just stumbled on this hard to explain problem. Below
select * from BigTable (BigTable has 5 million rows)
takes forever to even print out the first row. as you could see
from the sql, it is supposed to print out some rows right away
regardless of server config in my.cnf. What is
Evening,
Could someone explain the result of the Query 2? Query 2 does a GROUP
BY avgOctets, but still there are duplicate avgOctets in my result
set! Boxplot(octets,"AVG",0) is a UDF which returns REAL values. In
this case, the real values have no decimals.
The only reasonable explanation I could
Hi,
Have you tried changing the date format like
delete from TelecomAccountPosting where LocID=19014 and InvDate='2008-01-15';
I know it shouldn't matter but I have had similar issues due to the date
format.
Also are you sure there are 3773 records matching this criteria - according to
your t
On Tue, 2008-01-22 at 11:23 +1100, Chris wrote:
> > Why is it saying 'Impossible WHERE noticed after reading const tables'?
>
> http://dev.mysql.com/doc/refman/4.1/en/explain.html
> MySQL has read all const (and system) tables and notice that the WHERE
> clause is always false.
>
> ie - no rows
1 - 100 of 792 matches
Mail list logo
