--+-+
| 2013-06-27 13:21:34 | 2013-06-27 13:21:34 |
+-+-+
1 row in set (0.00 sec)
Cliff's notes: set timestamp = 0;
On 6/26/13 6:10 PM, "Andy Wallace" wrote:
We've
to 0 might clear the problem?
>>>>>
>>>>>
>>>>>
>>>>> On 6/27/13 10:31 AM, Stillman, Benjamin wrote:
>>>>>
>>>>>> Timestamp is a session variable, so it must have been set to something
>>>>>> other than 0 (137222803
27 13:20:48 |
>>>> +-+-+
>>>> 1 row in set (0.00 sec)
>>>>
>>>>
>>>> mysql> set timestamp = 0;
>>>> Query OK, 0 rows affected (0.00 sec)
>>>>
>>>>
>>>
Ok, I appreciate the Einsteinian and Vonnegut humor... just wanted to say. Still
have the problem though. 8-(
On 6/27/13 9:51 AM, Nick Khamis wrote:
Just out of curiosity, is the hardware stationed, or traveling close
to the speed of light (i.e., 18,000 miles per second)? Sorry I could
not help
Just out of curiosity, is the hardware stationed, or traveling close
to the speed of light (i.e., 18,000 miles per second)? Sorry I could
not help it
N.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Well, that begs the question - will restarting the MySQL server instance
tonight fix
the current problem? We do have a plan in place to test and eventually deploy
a more
recent version of MySQL (5.6?), but for now, I have to support 1000's of
customers.
My fingers are crossed.
On 6/27/13 12:2
Hi,
On 06/27/2013 08:19 PM, Andy Wallace wrote:
Benjamin -
Unfortunately:
mysql> show global variables like 'timestamp';
+---++
| Variable_name | Value |
+---++
| timestamp | 1372238834 |
+---++
1 row in set (0.00
| sysdate() |
+-+-+
| 2013-06-27 13:21:34 | 2013-06-27 13:21:34 |
+-+-+
1 row in set (0.00 sec)
Cliff's notes: set timestamp = 0;
On 6/26/13 6:10 PM, "Andy Wallace" wrote:
We've been having some
-+-+
| now() | sysdate() |
+-+-+
| 2013-06-27 13:21:34 | 2013-06-27 13:21:34 |
+-+-+
1 row in set (0.00 sec)
Cliff's notes: set timestamp = 0;
On 6/26/13 6:10 PM,
liff's notes: set timestamp = 0;
On 6/26/13 6:10 PM, "Andy Wallace" wrote:
>We've been having some issues with one of our MySQL servers lately, and
>currently
>the dang thing is "stuck". For at least the last hour, NOW() is returning
>the same
>
---+-+
>> | now() | sysdate() |
>> +-+-+
>> | 2013-06-27 13:21:34 | 2013-06-27 13:21:34 |
>> +-+-----+
>> 1 row in set (0.00 sec)
>>
>>
>
| sysdate() |
>>>> +-+-+
>>>> | 2013-06-26 02:27:14 | 2013-06-27 13:20:48 |
>>>> +-+-+
>>>> 1 row in set (0.00 sec)
>>>>
r MySQL servers lately, and
currently
the dang thing is "stuck". For at least the last hour, NOW() is returning
the same
value:
mysql> select now();
+-+
| now() |
+-+
| 2013-06-26 02:27:14 |
+-+
The system
4 |
+-+
1 row in set (0.00 sec)
On Wed, Jun 26, 2013 at 4:18 PM, John Meyer
wrote:
Well, if you want to get unstuck in time, maybe you need to call Billy
Pilgrim ;-)
Andy Wallace wrote:
We've been having some issues with one of our MySQL servers lately, and
currently
t
y Wallace" , "mysql list"
>
> Sent: Thursday, 27 June, 2013 1:36:31 AM
> Subject: Re: NOW() is stuck...
>
> Random I-can't-sleep thought: you wouldn't be testint this in a
> single
>
--
Unhappiness is discouraged and will be corrected with kitten pictures.
s lately, and
>> currently
>> the dang thing is "stuck". For at least the last hour, NOW() is returning
>> the same
>> value:
>>
>> mysql> select now();
>> +-+
>> | now() |
>> +-+
Well, if you want to get unstuck in time, maybe you need to call Billy
Pilgrim ;-)
Andy Wallace wrote:
We've been having some issues with one of our MySQL servers lately,
and currently
the dang thing is "stuck". For at least the last hour, NOW() is
returning the same
value:
my
0 PM
> To: mysql list
> Subject: NOW() is stuck...
>
> We've been having some issues with one of our MySQL servers lately, and
> currently the dang thing is "stuck". For at least the last hour, NOW() is
> returning the same
> value:
>
> mys
We've been having some issues with one of our MySQL servers lately, and
currently
the dang thing is "stuck". For at least the last hour, NOW() is returning the
same
value:
mysql> select now();
+-+
| now() |
+-+
| 2
er is handling
> the
> load from the queries and database. So far we don't notice any issues with
> stuck commits on the new server, but it's only handling minimal load
> outside
> of amavis queries. We would like to run this on the original system,
> because
>
status data to reach at
> conclusion.
>
Okay. This is not during a time of incident. Another server is handling the
load from the queries and database. So far we don't notice any issues with
stuck commits on the new server, but it's only handling minimal load outside
of amavis
:
> All too frequently, I see commits stuck in this database. What can I do to
> speed that up? Or, abort if it takes more than 40 seconds? This query here
> for example appears to take 443 seconds so far.
>
> From mysqladmin processlist:
>
> Id| User | Host | db | Command
le once it gets to this stage, AFAIK.
On Mon, Jan 12, 2009 at 5:05 PM, Scott Edwards wrote:
> All too frequently, I see commits stuck in this database. What can I do to
> speed that up? Or, abort if it takes more than 40 seconds? This query here
> for example appears to take 443
All too frequently, I see commits stuck in this database. What can I do to
speed that up? Or, abort if it takes more than 40 seconds? This query here
for example appears to take 443 seconds so far.
From mysqladmin processlist:
Id| User | Host | db | Command |Time | State | Info
14010
Now that was fun and educational. :-)
I like the third approach, but theres an added problem to the whole thing.
This query is just a part of a bigger search.
The tables, job and color and other fields, which will also be searchable. I
am trying to automate the whole process, i mean, the user see
Three solutions, the first one is not recommended I just showed it for
fun -- I think the last one is the most efficient:
mysql> show create table job \G
*** 1. row ***
Table: job
Create Table: CREATE TABLE `job` (
`job_id` int(10) unsigned
Sorry i replied from a different address. Heres the reply with some editing:
Got it to work perfectly, thanks, although it takes some time (CILS has
>150.000 records). There was no need for unique since all the results are
already surprisingly unique.
Thank you, it was a different way of doing th
Got it to work perfectly, thanks, although it takes some time (CILS has
>150.000 records). There was no need for unique since all the results are
already surprisingly unique.
Thank you, it was a different way of doing things. Well, different to me, at
least. :-)
In the meantime, i found an altern
Hopefully your CILS table is not too many rows...
select * from JOB, CILS as cyan, CILS as magenta
where cyan.num_of = JOB.num_of
and magenta.num_of = cyan.num_of
and cyan.color = 'cyan'
and magenta.color = 'magenta'
or something not unlike that...
You may want UNIQUE JOB.id_enc
Hi,
I am trying to solve a problem that i have been stuck for a few days, i hope
you guys can shed some light on this.
I have two tables: enc and cils
JOB:
id_enc
num_of
name
CILS:
id_cil
num_of
color
each "JOB" is composed of severals "CILS" (i know i should link tables u
MarisR さんは書きました:
>> 2) ERROR 1018 (HY000): Can't read dir of '.' (errno: 24)
>> to fix the problem i have to reboot the entire server.
>
> Maybe check out file system consistency, check logs.
>
Yes. create new partition, and move /var/lib/mysql/ to new partion.
It may avoids OS dependent file pro
Marco mangione wrote:
Hello,
i have a strange problems appeared 2 week ago'.
During the night with no apparently strange task mysql hang and if i try to
do some query i have as result:
1) big timeout... or directly no response
2) ERROR 1018 (HY000): Can't read dir of '.' (errno: 24)
to fix the
Marco
2) ERROR 1018 (HY000): Can't read dir of '.' (errno: 24)
It seems The current process(mysqld?) can't read current environment.
#define EMFILE 24 /* Too many open files */
you have to resolve the environment any of resource below..
CPU(dual core/quad core)
memory(need more d
Hello,
i have a strange problems appeared 2 week ago'.
During the night with no apparently strange task mysql hang and if i try to
do some query i have as result:
1) big timeout... or directly no response
2) ERROR 1018 (HY000): Can't read dir of '.' (errno: 24)
to fix the problem i have to reboot
hi All,
Last month, one of the our server got stuck but We could n't find the
reason. Here I have attached the OS(Red Hat Enterprise Linux AS relese 4)
message log. I think issue may be in MySQL.
We are using MySQL Server version: 5.1.12-beta MySQL Community Server (GPL)
So if you can please
Afternoon everyone,
Not been on here for a while, works been to hectic and this thing called
life keeps getting in the way ;^)
--
Regards,
Phil
Afternoon everyone,
Sorry, don't you hate the fact that the tab key submits your emails on
web clients!?
Anyway please ignore that last partial email, I've got myself stuck with
some SQL. What it boils down to is...
SELECT
wordgroup.Title AS `Keyword Group`,
site.Site_na
> insert into user (user,host) values ('jeff','localhost');
> flush privileges;
> grant all on databaseName.* to jeff;
jeff = [EMAIL PROTECTED]
not [EMAIL PROTECTED]
So in your statement you should have used...
grant all on databaseName.* to [EMAIL PROTECTED];
>select user,host from
I'm apologize for posting an apparently simple question, but I'm stuck. I'm
trying to get my java application to connect to mysql on the same server.
The server is redhat with mysql 5.1.11. I'd done this with mysql 4.x in the
distant past.
I add a user with the command:
Thank you. This is a very promising answer. I don't know that we want to
drop the table if we don't have to, but knowing that we can restart the DB
without the rollback operation is a boon! We could certainly do a mysqldump
of just that table (which works fine, we continue to run nightly backups
Hello.
Here is described the possible way of how to force the rollback
(you can kill the mysqld process and set innodb_force_recovery to 3 to
bring the database up without the rollback, then DROP the table that is
causing the runaway rollback):
http://dev.mysql.com/doc/mysql/en/forci
Thanks for the questions, hopefully this will help: InnoDB, yes. It's
version 4.1.11, not replicated.
I am familiar with KILL. It is definitely something I CAN do, but not
necessarily something I SHOULD do at this point in time. Usually when you
kill a process while it's running, it will roll b
INNODB I assume?
Replicated environment?
What version of mysql?
See KILL in the SQL manual.. if you do a show processlist you can get the
pid and you might be able to kill it.
I believe that it's safe to do a KILL on an DELETE but any decision you make
her is your own...
That's a LOT of data
Here's the situation. I have a table of about 900 million rows, consisting
of a bigint and an int in each row. There's an index on the bigint. The
table is referenced in a SELECT in other DB operations roughly 15 or 20
times per day.
We're under tight deadlines and some operations on the table
Victor Pendleton wrote:
From your previous posts I know you are very competent so no disrespect
intended. Was the slave data reloaded from the master, and the master.info
reset? What does the master.info log say?
I copied over all the data from the master to the slave with
rsync, did "LOCK TABLES
PM
To: mysql@lists.mysql.com
Subject: Re: Slave stuck at "registering"
Victor Pendleton wrote:
> Can you see the slave thread on the master when you do a show processlist
> from the master?
Yes. It shows up with the command as "Sleep", nothing in the
"State"
Victor Pendleton wrote:
Can you see the slave thread on the master when you do a show processlist
from the master?
Yes. It shows up with the command as "Sleep", nothing in the
"State" column, and NULL in the "Info" column. It hangs around
for a while until "Time" reaches a little over 500, and
Can you see the slave thread on the master when you do a show processlist
from the master?
-Original Message-
From: Keith Ivey [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 05, 2005 1:48 PM
To: mysql@lists.mysql.com
Subject: Slave stuck at "registering"
I'm trying to set
I'm trying to set up replication over the Internet -- something
I've done successfully many times before. But this time I'm
having problems I haven't run into before, and I'm wondering if
they're related to firewall settings or network problems or just
something I'm overlooking.
For the slave
Ankur G35 Saxena wrote:
All I had to do was rpm -Uvh --nodeps
I have the MySQL AB RPMs running on Red Hat 9 just fine. I didn't have
to force them at all.
I suspect you had to force it because you had MySQL installed already.
The problem is, the Red Hat package is called "mysql", whereas the M
Hello.
> Hi, I am trying to install the latest version of MySQL(i am not sure
> 4.0.23?
Use 4.1.10a. See:
http://dev.mysql.com/downloads/
> Hi, I am trying to install the latest version of MySQL(i am not sure
> 4.0.23? currently in the office). The RH9 comes with some 3.2.xx
> vers
Thanks for helping brian, While I was going through some sites where
people had posted some trouble, I found this guy who had successfully
installed the server, client and dev package.
All I had to do was rpm -Uvh --nodeps
I am not sure of the --nodeps, but i think it was there, but in any
event,
Hi, I am trying to install the latest version of MySQL(i am not sure
4.0.23? currently in the office). The RH9 comes with some 3.2.xx
version, I try to run rpm -U to upgrade but that doesnt work, I try to
install it doesnt work and I try to remove mysql that doesnt work
either. I went to Add and Re
admin and create new db/users/tables with it.
3/ I hope that installing php from source would be a solution.
Best regs and thx,
Rik
Op maandag 11 oktober 2004 00:44, schreef Michael Stassen:
> rik wrote:
> > Hello all
> >
> > Sitting stuck in an upgrade to mysql 4.1, I thought
rik wrote:
Hello all
Sitting stuck in an upgrade to mysql 4.1, I thought this mailing list would be
a good idea to get help.
I've a php4/mysql application developed on a windows xp machine. Right now I
want to migrate this app to my linux machine. Since the app uses subqueries,
I ne
Hello all
Sitting stuck in an upgrade to mysql 4.1, I thought this mailing list would be
a good idea to get help.
I've a php4/mysql application developed on a windows xp machine. Right now I
want to migrate this app to my linux machine. Since the app uses subqueries,
I need to upgrade
Howdy Folks,
Got a bit of a hassle. After some broken tries (got impatient) to
change the type of large table's column I found that, when I finally
got the patience, my disk went full and cancelled the operation again.
Since MySQL copies the table before such operation, my ibdata1 file
(using Inno
thanks scott,
i've uninstalled and reinstalled and i'm a happy guy!
huge thanks!!
jt
_
Watch LIVE baseball games on your computer with MLB.TV, included with MSN
Premium!
http://join.msn.com/?page=features/mlb&pgmarket=en-us/go/on
on 04/14/2004 09:00 PM, the amazing jt at [EMAIL PROTECTED] wrote:
> scott thanks for the help...but how do i know its uninstalled...i don't
> think it worked.
>
> this is what comes up for me:
>
> rm: /usr/local/mysql: No such file or directory
>
> is this correct if it's uninstalled or not??
scott thanks for the help...but how do i know its uninstalled...i don't
think it worked.
this is what comes up for me:
rm: /usr/local/mysql: No such file or directory
is this correct if it's uninstalled or not??
_
Tax headache? MS
on 04/14/2004 06:47 PM, the amazing jt at [EMAIL PROTECTED] wrote:
> would someone please part with how to uninstall mysql 4.0.18 from mac OS X.
>
> i screwed my installation up...well actually i believe i should have
> installed a prior version...but regardless i have a strong desire to use
> my
would someone please part with how to uninstall mysql 4.0.18 from mac OS X.
i screwed my installation up...well actually i believe i should have
installed a prior version...but regardless i have a strong desire to use
mysql...but at the moment i've hit a brick wall.
please tell me how to uninst
Try something like is:
select a.Name as PL_Name,b.Name as PC_Name,c.Name as PA_Name from
(select * from table1,table2 where table1.ID=table2.PL) a,
(select * from table1,table2 where table1.ID=table2.PC) b,
(select * from table1,table2 where table1.ID=table2.PA) c
where a.description=b.description
Wait, I see it now :)
-Original Message-
From: Luc Foisy
Sent: Wednesday, April 07, 2004 10:45 AM
To: [EMAIL PROTECTED]
Subject: RE: stuck with simple query. Plz have a look
I would like to ask a question here, just for my own knowledge. What is actually the
difference between
= Table1-1.PL
LEFT JOIN Table1 Table1-2 ON Table1.ID = Table1-2.PC
LEFT JOIN Table1 Table1-3 ON Table1.ID = Table1-3.PA
-Original Message-
From: Jim Page - EMF Systems Ltd [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 07, 2004 10:09 AM
To: gerald_clark
Cc: [EMAIL PROTECTED]
Subjec
[EMAIL PROTECTED]>
Subject:Re: stuck with simple query. Plz have a look
Forgive me, but it would be a cartesian product if there were no where
condition, I agree? It would return (size Table1)x(size Table2)^3 rows,
definitely not what Tariq wants. The query I supplied will r
Forgive me, but it would be a cartesian product if there were no where
condition, I agree? It would return (size Table1)x(size Table2)^3 rows,
definitely not what Tariq wants. The query I supplied will return (size
Table2)x(1)^3 rows won't it? Or am I missing the point?
Jim
> >SELECT ta.Name,tb.Na
Jim Page - EMF Systems Ltd wrote:
SELECT ta.Name,tb.Name,tc.Name,Description
FROM Table2,Table1 ta,Table1 tb,Table1 tc
WHERE ta.ID=PL AND tb.ID=PC AND tc.ID=PA;
Should work
Jim
(This email has been scanned for viruses by www.emf-systems.com)
I t may work, but it may consume all ram and di
SELECT ta.Name,tb.Name,tc.Name,Description
FROM Table2,Table1 ta,Table1 tb,Table1 tc
WHERE ta.ID=PL AND tb.ID=PC AND tc.ID=PA;
Should work
Jim
(This email has been scanned for viruses by www.emf-systems.com)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To uns
Looks like I trod on original post - forgot to add RE: to subject. Sorry
about that!
Jim
(This email has been scanned for viruses by www.emf-systems.com)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SELECT ta.Name,tb.Name,tc.Name,Description
FROM Table2,Table1 ta,Table1 tb,Table1 tc
WHERE ta.ID=PL AND tb.ID=PC AND tc.ID=PA;
Jim
(This email has been scanned for viruses by www.emf-systems.com)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
We have two tables
Table1:
-
ID |Name
1 |name1
2 |name2
3 |name3
4 |name4
Table2:
---
PL | PC
I finally got it working like I wanted it :-)
SELECT DISTINCT t1.softid,
IF( t1.nameofcd LIKE '%test%' OR t2.nameofsoftware LIKE
'%test%', t1.nameofcd, '') AS nameofcd,
IF( t2.nameofsoftware LIKE '%test%', t2.nameofsoftware,
'') AS nameofsoftware
You are totally right!
"Harald Fuchs" <[EMAIL PROTECTED]> schreef in bericht
news:[EMAIL PROTECTED]
> In article <[EMAIL PROTECTED]>,
> "Timon Berkowitz" <[EMAIL PROTECTED]> writes:
>
> > Hi there,
> > Sorry for being a little bit confusing, but de criterias has to be AND.
>
> > So it has to be li
What I ment is this :-)
Table1 consists out of the following fields and data
+--++
| softid | nameofcd |
+--++
| 1 | test cd 1 |
| 2 | software cd 2 |
| 3 | software cd 3 |
| 4 | test cd 2 |
+
To: [EMAIL PROTECTED]
Sent: Tuesday, March 30, 2004 12:34 PM
Subject: Re: Difficult query and am kinda stuck how to continue can
someone help?
Hi there,
I have tried that query it works, but not good enough
When you add in Table2 another row with softid 1 and without the string
&#
matches the string 'test'
>
> so if your table2 had (6, 2, 'test'), where table1.nameofcd for softid=2
> does not contain 'test', do you want it in your result?
>
> PB
> - Original Message -
> From: Timon Berkowitz
> To: [EMAIL PROTEC
s not contain 'test', do you want it in your result?
PB
- Original Message -
From: Timon Berkowitz
To: [EMAIL PROTECTED]
Sent: Tuesday, March 30, 2004 12:34 PM
Subject: Re: Difficult query and am kinda stuck how to continue can
someone help?
Hi there,
I have
Hi there,
I have tried that query it works, but not good enough
When you add in Table2 another row with softid 1 and without the string 'test' in it
like this :
softid| nameofcd
1test cd 1
2utils cd 1
3test cd 2
4bac
Hi there,
I have a hard question, don't know if its possible to solve my query.
I have set up two tables like this
Table1:
softid (integer) (unique)
nameofcd (string)
softid| nameofcd
1test cd 1
2utils cd 1
3test cd 2
4b
Michael Handiboe <[EMAIL PROTECTED]> wrote:
>
> I have the MySQL Reference Manual (the brown book), 1st Edition,
> and it is a mighty fine book.
>
> On p256, I follow the examples, but for a user who's supposed
> to have access to a single database ('cabs') with the following
> privileges:
>
>
Hello List Meisters.
I have the MySQL Reference Manual (the brown book), 1st Edition,
and it is a mighty fine book.
On p256, I follow the examples, but for a user who's supposed
to have access to a single database ('cabs') with the following
privileges:
SELECT, REFERENCES, INDEX, ALTER
I couldn't get the LOCAL option to work; even when I started mysql with
the --local-infile argument. After reading around in the manual I decided
to grant myself the FILE privilege since I am the only user on my computer
where I am teaching myself mysql.
On Friday, July 4, 2003, at 12:08 PM, Pa
At 11:27 -0500 7/4/03, Richard Grubb wrote:
I have mysql 3.23.49 on Mac OS-X 10.1.5 and am going through the
tutorial in the "MySQL Reference Manual" in Chapter 3.
I get an empty set with the following command:
SELECT * FROM pet WHERE birth >= "1998-1-1";
I have tried many variations which all
On Friday, July 4, 2003, at 12:27 PM, Richard Grubb wrote:
SELECT * FROM pet WHERE birth >= "1998-1-1";
Try: SELECT * FROM pet WHERE birth >= "1998-01-01";
You need 2 characters for the day and month fields.
___/
/
__/
/
/
Ed Leafe
http://leafe.com/
http://opentech.leafe
I have mysql 3.23.49 on Mac OS-X 10.1.5 and am going through the tutorial
in the "MySQL Reference Manual" in Chapter 3.
I get an empty set with the following command:
SELECT * FROM pet WHERE birth >= "1998-1-1";
I have tried many variations which all give either the empty set or
incorrect resu
Hi, you may try:
SELECT DISTINCT portlet.*
FROM portletAssignment PortletAssignment,
portlet LEFT JOIN UserTabAssignment UTA
ON (portlet.name=UTA.portlet_fk AND UTA.user_fk = 'guest' AND
UTA.portal_FK = 'mysqlPortal' AND UTA.tabNumber = 0 AND
UTA.subtabName = 'firstSubtab'
Hi
I am having trouble to convert the following query with a sub query to use
a join, any advice I would be most grateful
Select Distinct portlet.* from portlet, portletAssignment PortletAssignment
where PortletAssignment.Group_FK in ('group1', 'group2')
AND portlet.name not in (
SELECT
. I think that every time it has happened
the query has been issued from phpMyAdmin and then the kill has been issued
from the command line. I'm wondering if this or some bug in php or
phpMyAdmin is causing confusion.
Failing any way to avoid these stuck queries in the first place, is the
Hi ,
if you used SUSE , why didn't you just install the
mysql-packages distibuted there with yast.
It's very easy and I never had a problem with it.
It is also possible to install foreign packages with yast later ,
if you want to udate your mysql-server later.
The problem is , that SUSE is not ver
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 11 Feb 2003, J. A. Tovey wrote:
> i am having no end of problems with installing mysql (any 3.23.*
> version) on linux.
>
> i started off on SuSe and received different errors, I am now trying
> with mandrake,
>
> The current error is that I h
Um - you would only ./configure if you have downloaded the source tarball - you have
the linux binary so you need to follow the instructions for binary installation.
DC
\"J. A. Tovey\" <[EMAIL PROTECTED]> wrote:
>
> hi,
>
> i am having no end of problems with installing
> mysql (any 3.23.* ver
hi,
i am having no end of problems with installing
mysql (any 3.23.* version) on linux.
i started off on SuSe and received different
errors, I am now trying with mandrake,
The current error is that I have downloaded the
mysql.3.23.55-pc-linux-i686.tar.gz
and done the following:
tar -zxvf mysq
V4.0.9
How can I use the mysqld.sym file via gdb? It doesn't like the format.
Copying the stacktrace into another file where I have to edit out a
bunch of junk from gdb for resolve_stack_dump is a bit slow.
It seems that two processes have hung for a while. All the slots have
filled up even thoug
It´s happen exactly the same with me. Do you have some suggestion to
solve this?
I'm on Linux Redhat 7.2 and MySQL v. 3.23.41
I can make connections from the server... including the use of other
hostnames for test purposes. All my PHP/MySQL sites are up and running.
I can access the databas
There is a really strange thing happening with mysql 3.23.52.
mysql is getting stuck in a select query, the query is a straight join between table
a,b and c
The problem arises when i give condition to search c.nId for 2 values then it is
taking large amount of time to excute this query and is
Hello John,
Monday, October 14, 2002, 3:36:20 AM, you wrote:
JH> I'm on Linux Redhat 7.2 and MySQL v. 3.23.41
JH> Number of processes running now: 1
JH> mysqld process hanging, pid 8617 - killed
JH> 021013 20:08:43 mysqld restarted
JH> /usr/libexec/mysqld: ready for connections
[]
Download t
I'm on Linux Redhat 7.2 and MySQL v. 3.23.41
I can make connections from the server... including the use of other
hostnames for test purposes. All my PHP/MySQL sites are up and running.
I can access the database through phpMyAdmin.
I cannot connect from a client app such as Mascon. I notice that
toby,
Saturday, July 27, 2002, 10:21:50 AM, you wrote:
t> i ve a lil problem
t> i run this query n get a result set
[skip]
t> what should i do ?
I think your question is more suitable for php mailing list.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
"");
i get all the records in $row[2]
but i want jst 1
what should i do ?
how should i go about it ?
plx plx help
m stuck ...
:(
thnx a million . billion
stuck
toby
_
Send and
1 - 100 of 119 matches
Mail list logo
