Hello,
I got "Lost connection to MySQL server during query" from time to time when
connecting to MySQL server.
Using following PHP code,
$this -> conn = mysql_connect( $host,
$c_user,
$c_passwd) ;
if
Hi Peter,
I just tried it on a table with 10 rows and it works fine on 4.0.15.
Have you already tried on a small table?
How many rows is your WHERE clause matching when it's not using the
index? Do you know that MySQL won't use an index if it thinks it will
find more than about 30% of all rows?
I had a look at the demo packages - I downloaded the RedHat 9 and
Slackware 9 packages.
I can only speak for myself, but I think you'll get a lot more people
try it out if it doesn't come in a million tiny pieces. that install all
over the system.
I'm running a Gentoo system, and one of the reas
G you guys are very helpful... Anyway posting a reply to my own question. There is
no way to use a timestamp as an
index in a relatively large table. MySQL just does not take it even with explicit
FORCE KEY. Why? - I have no idea.
A workaround I found for this is running a script every minu
If views are not supported in MYSQL, is there any ways to replace it...I change
database from Access to MYSQL, so I need utility such as queries in Access. thanks
*8
Views are not supported in MySQL along with many more feature included in
the ANSI SQL 99 standard
I'm not sure MSDE is meant to replace Jet. Jet is still fine as a small
desktop database. MSDE is probably one of the best kept secrets M$ has. It's
a very capable database engine a bit nobbled so M$ can continue to collect
revenue from full SQL Server licenses. It is supposed to be the same code
b
Jet
-Original Message-
From: Wang Feng [mailto:[EMAIL PROTECTED]
Sent: Saturday, 11 October 2003 4:50 PM
To: Director General: NEFACOMP; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: what's the database behind m$ access?
That works, Emery. Thanks a lot.
Dummy me, I was wrong. Seems tha
In the last episode (Oct 12), Nitin said:
> query cache doesn't cache the data, but the execution plan of the
> query. so, in your example it'll treat both query as same, as both
> are fetching data from same result set. query cache just increases
> the speed of query "execution", that means minimi
>> In the third chapter of the MySQL manual I don't understand the
>> mentioned
>> "shell>". Where must I type in this and the following instructions or
>> what
>> does it mean ?
>> Until now I have found and started the winmysqladmin.exe file. But how
>> to
>> continue ?
My mistake. The "shell" i
Stephan -
> In the third chapter of the MySQL manual I don't understand the mentioned
> "shell>". Where must I type in this and the following instructions or what
> does it mean ?
> Until now I have found and started the winmysqladmin.exe file. But how to
> continue ?
The "shell" is the interacti
At 19:27 +0200 10/12/03, Stephan Wölfel wrote:
In the third chapter of the MySQL manual I don't
understand the mentioned "shell>". Where must I
type in this and the following instructions or
what does it mean ?
Until now I have found and started the
winmysqladmin.exe file. But how to continue ?
For Windows, its the DOS prompt. Go to start/run and type "cmd".
Adam Clauss
[EMAIL PROTECTED]
> -Original Message-
> From: Stephan Wölfel [mailto:[EMAIL PROTECTED]
> Sent: Sunday, October 12, 2003 12:27 PM
> To: [EMAIL PROTECTED]
> Subject: what means "shell" ?
>
>
> In the third c
In the third chapter of the MySQL manual I don't understand the mentioned "shell>".
Where must I type in this and the following instructions or what does it mean ?
Until now I have found and started the winmysqladmin.exe file. But how to continue ?
Stephan
MySQL-Front
http://www.sstienemann.de/mysqlfront/MySQL-Front_2.5_Setup.exe
On Sat, 11 Oct 2003 12:55:29 -0700, cppaddict wrote
> Hi,
>
> I'm just starting out with mysql and would like to know if there are
> any good database diagramming and development tools for mysql.
> Something that would a
query cache doesn't cache the data, but the execution plan of the query. so,
in your example it'll treat both query as same, as both are fetching data
from same result set. query cache just increases the speed of query
"execution", that means minimizes the time taken to actually execute the
query,
Does somebody know, how the LIMIT statement does affect the query caching mechanism of
MySQL 4.x?
Is
select * from examples LIMIT 0,30
and
select * from examples LIMIT 30,30
treated the same, therefore does the caching improve performance or are these queries
considered to be two sepper
Hi all,
I'm running a debian woody with mysql 4.0.12 . Sometimes i get error 11 '
can't create new thead etc '
I search a lot on mysq.com and google but i found this is a problem only
with 2.2 kernels. I've also tried to use lastest mysql-max bineries from
mysql.com and i can't get more than
Hi.
> how about:
>
> select record.*
> from link
> where group_id='x'
> left join record on record.archive_id=link.archive_id
> ?
The problem with this query is that with simple left join, I can search only
by a single group.
If I set x to 3 here, I get all records that belong to group 3. But wha
18 matches
Mail list logo
