s
WHERE id = X'36a461c81cab4016' << 16 | X'9791f49ad65a3728';
Unfortunately, this makes the query much slower.
I have now worked around this in another way, but I'd like to know if there
is a way of doing this?
Thanks,
/Martin Koch
Hi! I have a simple question.
Mysql version is 5.0.87
I have some merged tables. Can I alter 1 table and change a table comment? Is
it legal?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Dear List,
I have one mysql 4.1.11 running wich just shows
2 Processes.
Other mysql environments I do have show more than
10 Processes.
I don't have no clue where this difference comes from.
The Only significant difference I see on `show variables`
with thees two servers are:
<10 PID`s Server
with innoDB. But writing
>> somthing wrong into the file will cause mysql to throw an error.
>
>Are you sure that server reserves the memory for BDB? According to
>
> http://dev.mysql.com/doc/refman/5.0/en/bdb-start.html
>
>it shouldn't. It could show the values of different b
| pc-linux-gnu |
| wait_timeout| 28800 |
+-+---+
thx for the help in advance
-----
_/_/_/ Mathias E. Koch
_/_/_/ Florastrasse 46
_/_/_/ D-47799 Krefeld
T 02151 61
Hello dear all-mighty list :)
I do run mysql in 4.0.24 and have the following very slow query.
select tbl3.colname from tbl
.. (some left joins)
where
left(colname,1)="{letter}"
the tbl.col has no index nore will it ever get one because auf
the tbl structre. (this would make no sense becaus only
isam tables.. and wonder if this is even possible
best regards
mathias
_/_/_/ Mathias E. Koch
_/_/_/ Florastrasse 46
_/_/_/ 47799 Krefeld
Development+ Communications+ Strategies
Tel.: +49 (0)2151 15 05 28 / Mob.: +49 (0)171 64 50 137
<mailto:[EMAIL PROTECTED]>
keys is. The only requirement is that the column be
low-cardinality.
It basically works like this:
true 01101
false 10010
One bitmap is stored for each possible value of the column. In this
case the false bitmap shows that the first and fourt
ing a BITMAP index,
like Oracle. They're perfect for indexing boolean true/false columns or
any column that has a small number of possible values.
--
Daniel Koch <[EMAIL PROTECTED]>
-
Before posting, please check
EMAIL PROTECTED] (Alexander Koch)
>Organization: cid.net, Germany
>MySQL support: none
>Synopsis: mysqld dying every some minutes
>Severity: serious
>Priority: high
>Category: mysql
>Class:
>Release: mysql-3.23.52 (Source distribution)
>Ser
Don Vu wrote:
Hi guys,
I have a script in my home directory that i want others to be able to run. I 'chmod 777'ed the file and the folder it lives in and people still can't run it when they are at the mysql prompt and type "source /path/to/script/scriptname.sql". I can execute that script, even
On Mon, 2002-10-07 at 10:30, Jeremy Tinley wrote:
> Howdy,
>
> There has been some interest lately in HA of MySQL services both in my
> company and on the list. A few of us here sat down on Friday (at 5PM no
> less) and started hashing out the details of providing such a service.
> Following sev
4') then
> update the record. If the record doesn't exist then insert it.
See if REPLACE does what you want:
http://www.mysql.com/doc/R/E/REPLACE.html
--Dan Koch
-
Before posting, please check:
http://www.my
Arul wrote:
>Hi
>
>Any idea when MySQL 4.0 stable release will be made..
>As of now only Alpha is released..
>
>Also any sites which run on 4.0 Alpha
>
>
>
4.0.1 has been very stable for us:
[root@db1 root]# mysqladmin version
mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for pc-linux-gnu on i6
Hey there -
I think maybe you need to attach the port number as well.
In my applications I use the URL:
jdbc:mysql://:3306/
Insert the correct hostname, databasename and your userId/password.
Hope it works.
Regards
Thomas
-Original Message-
From: flag [mailto:flag]On Behalf Of Kenn
esults applied to non unique
combinations in the select and group by statement. I suppose that¹s the case
for your 'robotId, startTime' pair.
If I got this wrong forgive me it was first thing in the morning.
Hannes
On 6/26/01 4:05 AM, "Thomas Michael Koch" <[EMAIL PROTECTED]&
esults applied to non unique
combinations in the select and group by statement. I suppose that¹s the case
for your 'robotId, startTime' pair.
If I got this wrong forgive me it was first thing in the morning.
Hannes
On 6/26/01 4:05 AM, "Thomas Michael Koch" <[EMAIL PROTECTED]&
ows produced from the SQL is in the
neighbourhood of 5000 rows. That shouldn't be a problem.
I have also tried the following statement with the same result (problem):
SELECT robotId, startTime
FROM RobotRun
WHERE startTime >= '2001-06-26 00:00:00'
AND endTime IS NOT NULL
GRO
18 matches
Mail list logo
