Hi,
after some "research" we found out something, that was
reported sometimes to this list (and never has been
answered). The errors while compiling mysql_lex.cc, that
were reported, looked like this:
make[3]: Entering directory `/services/source/database/mysql/mysql-3.23.52/sql'
g++ -DMYSQL_SER
Dear MySQL!
I can't compile the source codes I've made top MySQL4.0.2 alpha release because the my
MS Visual C++ 6.0 compiler tells me it can't find the my_alloc.h header file. I've set
the mysql include path for the compiler, so it seems this file is missing from your
install kit. Please writ
I have a lot of tables, and not all of them are filled
equally.
Inserts to tables that have a lot of entries(see the
count below), take a long time (about .06 secs on the
average in mysql, over 0.09-0.1 in DBI), for example
mysql> INSERT INTO T1 VALUES
('3CCF571C1A88118801040302','072','
Hi Andreas,
> I'm just getting started with mysql so please bear with me. =8-}
> I do a 3 table query like:
> SELECT a.x, b.y, c.z
> FROM a, b, c
> WHERE a.b_fk = b.id AND a.c_fk = c.id;
> That works so far.
> In c can be rows which aren't active anymore.
> There is a good_from and a good_until
Hi.
I have problem.
I would like to upgrad from 3.23.51 on my win98 to 3.23.52 but with innodb
tables 3.23.52 hang on starting. and my win98 goes slowly and slowly.
ctrl-alt-del helps :)
In log i see:
010820 20:20:13 C:\MYSQL\BIN\MYSQLD.EXE: Got signal 2. Aborting!
010820 20:20:13 Aborting
The key words are "over which I have no control". See if you can figure it.
- Original Message -
From: "Andrew Conkling" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 22, 2002 12:36 PM
Subject: Error
Hey, I'm trying to create a db on a server (over which I have no
Greetings!
MySql documents specifies user defined function made in
.dll/.so to be invoked in MySQL. Is there a way in which a function made in
java be invoked in MySQL.
Regards
-
Before posting, p
Attila,
Thursday, August 22, 2002, 11:54:24 AM, you wrote:
AM> I can't compile the source codes I've made top MySQL4.0.2 alpha release because
the my MS Visual C++ 6.0 compiler tells me it can't find the my_alloc.h header file.
I've set the mysql include
AM> path for the compiler, so it seems t
Andrew,
Thursday, August 22, 2002, 7:36:35 AM, you wrote:
AC> Hey, I-m trying to create a db on a server (over which I have no
AC> control) and I keep getting this error:
AC> =
AC> mysqladmin: CREATE DATABASE failed; error: 'Access denied for user:
AC> '@localhost' to database 'musica''
AC> =
AC>
Norris,
Wednesday, August 21, 2002, 6:44:51 PM, you wrote:
N> I have just got into a situation in which I need to explore replication and
N> I know nothing about it. Can any one direct me to specific documentation on
N> this and maybe a simple tutorial for the "greener" of us?
Check the appropri
David,
Thursday, August 22, 2002, 9:48:14 AM, you wrote:
DB> Victoria
DB> Monday, August 19, 2002 11:58 AM, you wrote :
VR>> Hi, David!
VR>> You can find new 3.23.52 binary packages at www.mysql.com
VR>> Could you install new packages and check if loading problem occurs
VR>> again?
DB> One of ou
Alex,
Thursday, August 22, 2002, 4:54:01 AM, you wrote:
AJ> We want to set quota per user. Is that possible on MySQL ? If so
AJ> how can that be done?
Depends on what you want to limit per user. Some info you can find
here:
http://www.mysql.com/doc/en/User_resources.html
--
For technic
> -Ursprüngliche Nachricht-
> Von: Ferdinand, Dieter
> Gesendet am: Donnerstag, 22. August 2002 10:56
> An: '[EMAIL PROTECTED]'
> Betreff: problem with null values by insert into .. select ..from ..
> join
>
> hello,
> i have one problem with insert into ... select ... from ..
Description:
A time ago I reported next bug:
"The ALTER TABLE command behaves very strange when stopping and
restarting the MySQL server afterwards. I noticed this after having
rebooted my PC (which means that the MySql server is stopped and
rest
Alex,
Mysql does not do quota for users (atleast as far as I know). But I
read once in sysadmin mag that an programmer at an isp wrote a mysql
quota daemon. The article is not on the web but here is the issue:
http://www.sysadminmag.com/articles/2002/0202/
There is a link on the left ha
> David,
> Thursday, August 22, 2002, 9:48:14 AM, you wrote:
> DB> Victoria
> DB> Monday, August 19, 2002 11:58 AM, you wrote :
>
> VR>> Hi, David!
> VR>> You can find new 3.23.52 binary packages at www.mysql.com
> VR>> Could you install new packages and check if loading problem occurs
> VR>> aga
Ok, so, I created that index. Now, it does not use filesort. Still 3
seconds, but better than a minute.
Now, however, the previously fast query is using filesort. WTF?
I will be needing both of these queries in Phorum 5 so I need to have them
both running as fast as possible. I will add a fo
InnoDB are "supposed" to be faster at Inserts and updates than MyISAM.
However, my dealings with InnoDB have made me think that unless you _need_
transactions, foreign keys, etc, MyISAM is still the way to go for speed on
large tables.
If you can go MyISAM (you may need that stuff), fixed width t
On Tue, 20 Aug 2002, Steinar Kolnes wrote:
> I am going to make a 6.5 mill. phone directory database, and after some
> previous advice I am able to make a search in a fraction of a second.
>
> However there should only be a single search line, not different fields for
> First, Last - name, stree
Hi,
my name is Francesca and I've a problem with the space character using mysql.
I try to explain the problem in a way similar to mysqldebug.txt.
m: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Problem updating a CHAR(1) columns whith a space character.
Description:
I have a tab
20 matches
Mail list logo
