I noticed that all mysql client programs i have (cmd line tool mysql and own
applications) block when the connection to a server is physically cut.
1. make connection
2. do some querys
3. line cut
4. mysql_ping() or mysql_query() block the application forever
a strace from mysql cli-tool shows th
Heikki,
I recreated the tablespace more than a week ago, set datafile size to 10M:autoextend and its size
hasn't changed since the first data import, so the problem was indeed caused by corrupted datafile.
It's great that you added more debug logging, because the weirdest thing about the problem
Hi!
I am wondering if there is a way using SQL to make a pattern file (I'm not
sure exactly what to call it) of the sort following, which keeps track of
people in programs of different kinds, by months of the year. A given file
can be set up as below examining only 1 type of program (that is wha
At 06:10 PM 11/21/2004, you wrote:
Hi all,
I've got a rather odd performance problem with concurrent queries here. My
query regrettably always needs to do a full table scan - really can't be
helped. So my
idea was to cache the data in a HEAP table to get maximum performance out
of it and it work
I'm referring to the MySql server v.4.1.5 that I'm using now, as
compared to the newer release of v.4.1.7
Paul DuBois wrote:
At 20:09 -0700 11/22/04, Steve Grosz wrote:
I'm using 4.15 currently, and it seems to be very stable. I noticed
that a v4.17 or something has come out recently.
Versions
At 20:09 -0700 11/22/04, Steve Grosz wrote:
I'm using 4.15 currently, and it seems to be very stable. I noticed
that a v4.17 or something has come out recently.
Versions 4.15 and 4.17 of what? You're asking us whether it's worth
upgrading without specifying what it is you're asking about?
Do you
I'm using 4.15 currently, and it seems to be very stable. I noticed
that a v4.17 or something has come out recently.
Is it worth upgrading? Can I just install the new version without
damaging my current databases or are there specified steps? Where would
I find them if there are?
Thanks,
St
This is my favorite advanced MySQL book. It's by Jeremy Zawodny (looks
after MySQL installations for Yahoo.com) (fix the link if it wordwraps
in this email):
http://www.amazon.com:80/exec/obidos/ASIN/0596003064/kieranwebobje-20?
creative=327641&camp=14573&link_code=as1
-Kieran
___
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
William R. Mussatto wrote:
> Mark Matthews said:
>
>>-BEGIN PGP SIGNED MESSAGE-
>>Hash: SHA1
>>
>>William R. Mussatto wrote:
>>
>>
Tried it and now I get connection timed out after three tries. I'm
running the testbed using the tomcat
Just out of curiosity
I recently turned this up from a 4 to a 16 to see what would choke.
Nothing did. Matter of fact it seems like my load went down quite a
bit.
Is there something
wrong with leaving it this way?
Since it should be really simple tasks on
Xeon processors shouldn't it be
UPDATE: Here's what i could figure out till now
A look with a hex editor showed me that there was a change from "0B" to
"0A" and "07" to "20" in the
corrupted files compared with the original ones.
Somebody had the same problem
--
MySQL General Mailing List
For list archives: http://list
I have a small file that calls a search function at Findwhat in case Mysql
locally overloads. I just put on a new partner who looks like they may call
my server 40 million times a month.
I know there is some way to put a file into Ram for super fast response.
Question is how do I do this?
Will i
I see guys talk about
doing the math to determine how many apache servers you need. How much ram
you have or have left.
My question is how do
you determine how much your MySql can handle?
I am running a dell
dual 2.8 with 2 gig of ram Raid 5
Whats the max
connections MySql can han
hello,everyone
"Communication failure during handshake. Is there a server running on
localhost:3306?"
is what mean,how to solove this problem??
thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mark Matthews said:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> William R. Mussatto wrote:
>
>>>Tried it and now I get connection timed out after three tries. I'm
>>> running the testbed using the tomcat buried in netbeans. Cut and
>>> pasted the example from the on line docs. Put the
Hassan Schroeder said:
> William R. Mussatto wrote:
>
>>>Tried it and now I get connection timed out after three tries. I'm
>>> running the testbed using the tomcat buried in netbeans.
>
> Frankly, the whole concept of running a server from "within" an IDE
> sounds so sketchy to me -- but I'm defi
Yup, Thanks a lot.
This is exactly the solution what i want.
Thank you very much. :)
- Original Message -
From: "Kardos András" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 23, 2004 5:20 AM
Subject: Re: Direct connection to mysql database
> You can use one DSN, an
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
William R. Mussatto wrote:
>>Tried it and now I get connection timed out after three tries. I'm
>>running the testbed using the tomcat buried in netbeans. Cut and pasted
>>the example from the on line docs. Put the jar in the WEB-INF/lib
>>dirctory
I believe I have read or skimmed all of the posts to this group with
"Lock", "wait" and "timeout" in their body over the past year (172) with
no answers in sight (if I missed a post, please let me know).
I am unable to figure out what is causing this problem that is 100%
reproducible on a 4.0.2
Sasha,
Plugs from authors are interesting, but plugs from readers are what
really sell a book. I will check it out though. Thank you for the
response.
Jonathan
>>>Sasha Pachev <[EMAIL PROTECTED]> 11/19/04 5:36 pm >>>
Jonathan Duncan wrote:
>I have the MySQL first edition book by Paul. St
On Mon, Nov 22, 2004 at 03:49:52PM -0800, Emmett Bishop wrote:
> I need to snag a copy of MySQL 4.0.20 for Windows. Is
> there somewhere on the MySQL I can grab older
> versions?
http://downloads.mysql.com/
--
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://list
William R. Mussatto wrote:
Tried it and now I get connection timed out after three tries. I'm
running the testbed using the tomcat buried in netbeans.
Frankly, the whole concept of running a server from "within" an IDE
sounds so sketchy to me -- but I'm definitely not an IDE kinda guy :-)
Have y
I need to snag a copy of MySQL 4.0.20 for Windows. Is
there somewhere on the MySQL I can grab older
versions?
Thanks,
T
__
Do you Yahoo!?
Meet the all-new My Yahoo! - Try it today!
http://my.yahoo.com
--
MySQL General Mailing List
For li
Warning!! Make sure the php module will handle the new password scheme in
4.1. DBD::mysql from AS will not. There are work arounds. I'm having to
fall back to 4.0 because I can't get .jsp to work with 4.1 database (no
connection).
GH said:
> What I have been asking for... is that the upgrade do
Hello Group,
I'm desperatly trying to set up a mysql test-environment on my Windows
XP Sp1 system.
Therefore I dumped out the database on a RedHat Linux Server (both are
MySQL 3.23.56) and imported this dump
into the same MySQL DB on the windows System (using mysqldump -u root -p
--opt --all-dat
On Monday 22 November 2004 04:15 pm, Santino wrote:
I can confirm it anyway: I think we have a bug.. Unless someone else see
something, might want to take this to bugs.mysql.com
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 578 to server version: 4.1.7-log
At 15:23 +0100 22-11-2004, Sergei Golubchik wrote:
Hi!
On Nov 22, Dilipan Sebastiampillai wrote:
I moved a db from 4.0.18 to 4.1.7 and I realise that the SAME sql query
using LEFT JOIN gives me different result.
The result from 4.0.18 does s real LEFT JOIN but 4.1.7 differs
sometimes and I don
Hello,
I wondering about Subqueries X Joins.
What is the fastest technic?
I´ve read the Manuals and I found some texts saying Joins are faster
and other saying Subqueries are faster.
Well, if both so. When Subqueries are faster and when Joins are faster?
If this question has been answered befor
Carlos,
- Original Message -
From: "Carlos Augusto" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, November 22, 2004 10:37 PM
Subject: Innodb corrpution. Very Urgent
Hello, i=B4m having a problem with a large database...
at ibdata1.My ibdata1 is corrupted and i saw
What I have been asking for... is that the upgrade does not tell me
*HOW* to install this upgrade. WHich file I should download etc I
do not see this under the UPGRADE section... That is what I have been
asking
Also, it says on the manual (section 2.10) ""It is a good idea to
rebuild and r
Eric Yeh wrote:
Hello,
I am a new user of MySQL and have a simple question I was hoping the list could
help me with.
I have been a long time Sybase user and am now looking at converting some of my
scripts to MySQL. I ordinarily run scripts as batch from the command line, and
parse the results
Hello,
I am a new user of MySQL and have a simple question I was hoping the list could
help me with.
I have been a long time Sybase user and am now looking at converting some of my
scripts to MySQL. I ordinarily run scripts as batch from the command line, and
parse the results in a proprietar
Hello, i´m having a problem with a large database...
at ibdata1.My ibdata1 is corrupted and i saw other postings and all of
them asks to use mysqldump, but in my case there´s a problem...
I can´t run mysqld since ibdata1 is corrupted.
Those anyone have a tip for me?
in logfile says that mysqld can
Hi Folks,
I've been running a website on php/mysql database for about a year now.
I typically enter data using the phpmyadmin package. The other day I
attempted to add some data but it appeared to phpmyadmin that there were
no tables in my database. I connected to mysql using the commandline
Everything has a limit. Sometimes it's just ridiculously high that it
might as well be infinity. This is not the case with open files. I'm
not sure if MySQL has it's own limit or if it is constrained by the
operating system, like it is with file size. Max open files is a
function of the OS, not
First you are using two distinct queries where you should be using two
"related". Specifically, add SQL_CALC_FOUND_ROWS to your first query
that retrieves data, then issue a query to see how many rows you would
have had if you hadn't specified a LIMIT:
SELECT FOUND_ROWS()
The second query sh
Hello.
For direct connection you may use MySQL APIs. See:
http://dev.mysql.com/doc/mysql/en/MySQL_APIs.html
Probably this link also will be helpful:
http://dev.mysql.com/doc/mysql/en/Without_DSN.html
>Hi, all
>
>I would like to know is there anyway where i can connect to the mysql
Hi.
I have database structure of about 45 tables, and a separate database for
each of the 100+ users.
Everything has been working nicely for quite some time.
When I wrote a function that looped through all the DBs and ran some
queries, MySQL hung and I got "too many open files" in my .err-file.
(
William R. Mussatto said:
> Mark Matthews said:
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> William R. Mussatto wrote:
>>> Keith Ivey said:
>>>
William R. Mussatto wrote:
>I've been googling for 1/2 hr w/o any answers. sorry if I've missed
> the obvious.
>Pr
Hello,
I have a problem with poor performance when I execute select
from 50.000 records. I have a test that retrieve page by page
(20 records per page) all data from a table. It means I'm executing
2500 selects in the cycle for retrieving each page and I'm retrieving
also time duration of some o
Please, MySQL doesn´t understands the following special escape sequence: ' \s' ?
I want spaces in the export.
How to do?
Greetings.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
Hi!
I need to use SQL to count some sequences. We have taken a short
snapshot of 1 year for people registered in programs. So we have data in
a table like so:
ID m1 m2 m3 m4 m5 m6 m7m8 m9 m10 m11 m12
The "m1", "m2", "m3" refers to month 1, month2, month3, etc.
The data fo
Hi all,
I have am in trouble with connecting remotely to my MySQL Server Linux
machine. I have installed the latest RPM (4.1.7) on a Linux Fedora Core
3 machine. I have created root account and everything seems to be OK.
The only problem is that I can not connect to my MySQL Server remotely
fro
Hi GH,
apart of the contents of the mentioned documents and hints, there is
nothing else. Just start the new server in place of the old server with
the same options unless told otherwise in the mentioned documents.
Am Mo, den 15.11.2004 schrieb GH um 15:06:
> when I go to both 2.10 Upgrading MySQ
Hi!
On Nov 22, Dilipan Sebastiampillai wrote:
> I moved a db from 4.0.18 to 4.1.7 and I realise that the SAME sql query
> using LEFT JOIN gives me different result.
> The result from 4.0.18 does s real LEFT JOIN but 4.1.7 differs
> sometimes and I don't want that.
>
> I think it comes from an
On 22 Nov 2004 at 9:34, James Sherwood wrote:
> Hello,
>
> I have installed mysql but did not install it as a service.
>
> All I do is runmysqld-max-nt.exe
>
> Now I need it to run as a service. It is on a win2003 machine.
>
> Can I make it run as a service once I already have it installed.
>> I am moving a table from a 3.23.56 db to a 4.1.7 db. I currently only
>> testing to see if I can. So far, I have been able to create the receiving
>> table, but not be able to insert the data. (The only difference I see when
>> using phpMyAdmin is the collation column on the 4.1.7 server)
...
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
William R. Mussatto wrote:
[snip]
> Tried it and now I get connection timed out after three tries. I'm
> running the testbed using the tomcat buried in netbeans. Cut and pasted
> the example from the on line docs. Put the jar in the WEB-INF/lib
> di
While what I'm working on is only a test database, I'd
like to see what I can preserve.
I used a data dumping program to create records in my
database. However I'm not sure how I messed up , but
here is the problem.
I have 1016 records in a particular table. The first
column is a Primary ID Int
Hello,
I have installed mysql but did not install it as a service.
All I do is runmysqld-max-nt.exe
Now I need it to run as a service. It is on a win2003 machine.
Can I make it run as a service once I already have it installed.
I cannot lose data and do not want to do a mysqldump, uninstall
On Monday 22 November 2004 13:10, Dayakar might have typed:
> Hello list,
> I am getting the following error when i am loading data (Tab seperated
> data) into a table which has reference to a primary key table. There is
> data in the primary key table, but still this error is being thrown.
>
> ERR
Hello list,
I am getting the following error when i am loading data (Tab seperated data)
into a table which has reference to a primary key table. There is data in the
primary key table, but still this error is being thrown.
ERROR 1216: Cannot add or update a child row: a foreign key constraint f
I moved a db from 4.0.18 to 4.1.7 and I realise that the SAME sql query
using LEFT JOIN gives me different result.
The result from 4.0.18 does s real LEFT JOIN but 4.1.7 differs
sometimes and I don't want that.
I think it comes from an 'optimization' how can I make a query
without using t
Hi, all
I would like to know is there anyway where i can
connect to the mysql database without add the odbc dsn ?
which i want to direct access to the mysql
database.
i wish to create 1 dsn, and by using this dsn, i
able to access all database,
even able to create/delete the mysql database
Hello.
You may use something like:
prepare stmtl from 'select * from ren1 where yo like concat("%",?,"%")';
set @a='1';
execute stmtl using @a;
Nathan Coast <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Is it possible to modify parameters passed to prepared statements?
>
> e.g.
>
Hello.
To which version have you upgraded exactly? have you installed from
ports or a binary version or compiled from source? What configure
options have you specified? You may use some recomendations from:
http://dev.mysql.com/doc/mysql/en/Crashing.html
First, enable logging to dete
* * * * * * * * * * * * * * * AntiVir ALERT * * * * * * * * * * * * * * *
AntiVir has detected the following in a mail from your address:
Worm/MyDoom.AE
The mail was not delivered.
Please remove any potential malicious software from your computer before
sending a new mail with attachm
57 matches
Mail list logo
