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
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
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
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
> 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
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
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
> -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 ..
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
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
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
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>
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
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
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
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
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
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','
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
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
20 matches
Mail list logo
