Hello.
Have you been at:
http://dev.mysql.com/doc/mysql/en/full-table.html
"V. Agarwal" <[EMAIL PROTECTED]> wrote:
> Hi,
> I am using Mysql built-in defaults for starting the
> server. It chokes when the table size grows to 4GB.
> ===
> -rw-rw1 vagarwal dev
April 2005 14:46
> To: mysql@lists.mysql.com
> Subject: Mysql 4.1.1 on Linux table size limit of 4GB and grant priv
for
> Load
>
> Hi,
> I am using Mysql built-in defaults for starting the
> server. It chokes when the table size grows to 4GB in
> data directory.
> What
Hi,
I am using Mysql built-in defaults for starting the
server. It chokes when the table size grows to 4GB in
data directory.
What parameter needs to be tweaked for allowing larger
size tables ?
===
-rw-rw1 vagarwal dev 4294967284 Apr 29
22:33 crec.MYD
-rw-rw1 vagarwa
Hi,
I am using Mysql built-in defaults for starting the
server. It chokes when the table size grows to 4GB.
===
-rw-rw1 vagarwal dev 4294967284 Apr 29
22:33 crec.MYD
-rw-rw1 vagarwal dev 950261760 Apr 29
23:22 crec.MYI
I created a user and granted a
e.myodbc
Sent: Friday, May 21, 2004 4:59 AM
Subject: Mysql 4.1.1, InnoDB - Slow TRUNCATE operations with Multiple
Tablespaces
> --=_NextPart_000_0050_01C43F2A.002F6960
> Content-Type: text/plain;
> charset="us-ascii"
> Content-Transfer-Encoding: 7bit
>
> Hi eve
I've have been looking for libmysqld.dll so I can test the MySQL embedded
server on my Win2k machine. Where can I download it? I've searched
www.mysql.com to no avail. TIA
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
e else experienced such slow TRUNCATE operations?
Here's a summary of my environment:
Platform: Mysql 4.1.1-aplha, InnoDB
Noteable parameters: innodb_file_per_table, 160MB innodb buffer pool
Hardware: Win XP, 3Ghz P4 (HT), 1GB RAM, multiple 7200RPM drives
Database location: On its own da
At 15:18 +0700 4/15/04, Hendro S. wrote:
Hi all,
I have win2k server machine, if this machine online, i could login
to MySQL 4.1.1 on RH 9 is about 1 second, but if this machine
offline connection establish in about 10 seconds, then i try connect
to mysql 4.0.17 in SuSe machine its done in
Hi all,
I have win2k server machine, if this machine online, i could login to MySQL
4.1.1 on RH 9 is about 1 second, but if this machine offline connection
establish in about 10 seconds, then i try connect to mysql 4.0.17 in SuSe
machine its done in about 1 second. I connect to mysql server
I downloaded the Linux RPM binaries for MySQL 4.1.1 and all except
MySQL-shared-4.1.1-0.i386.rpm and MySQL-shared-compat-4.1.1-0.i386.rpm
installed correctly. The -shared RPM failed on missing dependencies, it
was looking for openssl 0.9.6 and libcrypto 0.9.6 shared libraries and
couldn't
-+---+
2 rows in set (0.00 sec)
Now PID=1 is wrong. It appears to always mess up the
last element. What's up? I ran this on MySQL
4.1.1-alpha under both Linux (RedHat) and Windows with
the same results.
I start up the server as follows:
bin\mysqld-max --standalone --console --ansi --default
Hi,
I have installed the package bk-3.0.4-x86-win32.EXE
from Bitkeeper.com, to get the Mysql-4.1.1 source code
for Windows 2000 box.
It's installed successfully and frame the shortcuts in
my Start menu --> program --> Bitkeeper with
sub menus for
bash shell1
bash shell2
Lior,
this is probably the subquery bug that was fixed in the 4.1 source tree
about 2 months ago. The seg fault happens because MySQL-4.1.1 releases table
'intention' locks too early, and InnoDB closes the consistent 'read view' of
the transaction.
Best regards,
Hei
"Nisim, Lior" <[EMAIL PROTECTED]> wrote:
> My server crashes on sub qurey , can any one help ?
[skip]
I wasn't able to repeat crash with my test table and test data. Could you create a
repeatable test case?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This emai
handle_one_connection + 563
0x40044c3f _end + 933891415
0x401b5b2a _end + 935402562
Thanks
Lior
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 02, 2004 10:08 PM
To: Nisim, Lior
Cc: [EMAIL PROTECTED]
Subject: Re: Mysql 4.1.1 crashes
Did you run a stack
Did you run a stack trace?
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 3/2/04, 9:02:15 AM, "Nisim," Lior
| licence | email support | extended email support
]
>Synopsis:
>Severity: <[ non-critical | serious | critical ] (one line)>
>Priority: <[ low | medium | high ] (one line)>
>Category: mysql
>Class: <[ sw-bug | doc-bug | change-request | support ] (one line)>
>R
If it's really utf8 problem lets check this out. Please submit the report
as Sergei had asked.
Regards,
Igor
-Original Message-
From: Donny Simonton [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 19, 2004 1:02 PM
To: 'Brian Wintz'; [EMAIL PROTECTED]
Subject:
-Original Message-
> From: Brian Wintz [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 18, 2004 9:39 PM
> To: [EMAIL PROTECTED]
> Subject: MySQL 4.1.1 Performance
>
> I have begun working with MySQL 4.1.1 using the utf8 encoding to capture
> unicode data. I conve
Hi!
On Feb 18, Brian Wintz wrote:
> I have begun working with MySQL 4.1.1 using the utf8 encoding to capture
> unicode data. I converted an existing MySQL 4.0 (latin1) database by doing
> a dump and load (with the new databases character set to utf8). I'm
> noticing that the p
I have begun working with MySQL 4.1.1 using the utf8 encoding to capture
unicode data. I converted an existing MySQL 4.0 (latin1) database by doing
a dump and load (with the new databases character set to utf8). I'm
noticing that the performance on the new 4.1 database is about 5 times
s
appreciate that!
Regards and thanks to all,
Marty Ray
On Feb 12, 2004, at 4:43 PM, j.e.b. wrote:
Marty Ray
This should help you out - http://www.entropy.ch/software/macosx/mysql/
I just downloaded and installed mysql 4.1.1 on a Macintosh G5, but I
cannot get it to start up. I first tried manu
K. Here are the step-by-step instructions that might help.
1 - Download and unpack the tar.gz file from mysql.com/downloads
2 - Open the Users panel and add a new user called 'mysql' with whatever
password you choose.
3 - Open Terminal.app and log on as root
4 - [/] root# cd /usr/local/mysql (or y
I really appreciate all the help! I tried running
./scripts/mysql_install_db and this is what I got:
G5-Computer:/usr/local/mysql martyray$ ./scripts/mysql_install_db
mkdir: ./data/mysql: Permission denied
chmod: ./data/mysql: Permission denied
mkdir: ./data/test: Permission denied
chmod: ./data/
You have to re-run the ./scripts/mysql_install_db
I had this exact error and it comes from deleting (or not installing) the
'mysql' database, which is a required component for MySQL to run. It also
installs a db called 'test' which is not required.
J.R. Bullington
Innovatim Technical Support
[EMA
n wrote:
Marty Ray wrote:
I just downloaded and installed mysql 4.1.1 on a Macintosh G5, but I
cannot get it to start up. I first tried manual startup using the
unix commands as detailed in the manual. I kept getting the message
mysql shutting down before I could hit ctl-Z. Then when I tri
Marty Ray
This should help you out - http://www.entropy.ch/software/macosx/mysql/
> I just downloaded and installed mysql 4.1.1 on a Macintosh G5, but I
> cannot get it to start up. I first tried manual startup using the unix
> commands as detailed in the manual. I kept getting the mess
e_mysqld. You may not be seeing the error messages that would tell
you why it's not starting. Try starting mysql directly.
cd /usr/local/mysql
sudo ./bin/mysqld
You'll probably see an error message that is a bit more helpful.
On Feb 12, 2004, at 4:09 PM, Marty Ray wrote:
I just downlo
Marty Ray wrote:
I just downloaded and installed mysql 4.1.1 on a Macintosh G5, but I
cannot get it to start up. I first tried manual startup using the unix
commands as detailed in the manual. I kept getting the message mysql
shutting down before I could hit ctl-Z. Then when I tried to connect
a bit more helpful.
On Feb 12, 2004, at 4:09 PM, Marty Ray wrote:
I just downloaded and installed mysql 4.1.1 on a Macintosh G5, but I
cannot get it to start up. I first tried manual startup using the unix
commands as detailed in the manual. I kept getting the message mysql
shutting down before I cou
I just downloaded and installed mysql 4.1.1 on a Macintosh G5, but I
cannot get it to start up. I first tried manual startup using the unix
commands as detailed in the manual. I kept getting the message mysql
shutting down before I could hit ctl-Z. Then when I tried to connect,
it stated
Table created with out any error in MySQL 4.0.17-max-debug win
mysql> create table foo (id int not null default -1);
Query OK, 0 rows affected (0.22 sec)
mysql> explain foo;
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+---+-+--
Tedman Leung <[EMAIL PROTECTED]> wrote:
> I've been unable to find any information on this issue so I'm not quite
> sure if it's a bug or a new restriction. In either case I think it's a bug
> due to it's inconsistency with itself.
>
>create table foo (id int not null default -1)
> does
I've been unable to find any information on this issue so I'm not quite
sure if it's a bug or a new restriction. In either case I think it's a bug
due to it's inconsistency with itself.
create table foo (id int not null default -1)
does not work
create table foo (id int not nul
.
Regards,
Chris
On Fri, 2004-01-16 at 23:21, Ugo Bellavance wrote:
> > -Message d'origine-
> > De : I.P. [mailto:[EMAIL PROTECTED]
> > Envoyé : Friday, January 16, 2004 6:41 AM
> > A : [EMAIL PROTECTED]
> > Objet : Mysql 4.1.1 and PHP
> >
>
> -Message d'origine-
> De : I.P. [mailto:[EMAIL PROTECTED]
> Envoyé : Friday, January 16, 2004 6:41 AM
> A : [EMAIL PROTECTED]
> Objet : Mysql 4.1.1 and PHP
>
>
>
> Hi.
>
> I would like test mysql 4.1.1 with php but, i cann't connect
Hi.
I would like test mysql 4.1.1 with php but, i cann't connect to it. I have
error when use password :(
>From mysql CC beta 0.9.4 i could connect to my 4.1.1 server to.
I can connect to mysql 4.1.1 - only if i have no password set.
What's going on ?
Regards.
Irens.
--
Hi!
I compiled mysql 4.1.1 today and used the following config:
#v+
--with-character-set=latin1 \
--with-collation=latin1_german1_ci \
--with-extra-charsets=all
#v-
./configure and make worked fine, but make test failed:
#v+
cd mysql-test ; ./mysql-test-run
Installing Test Databases
lto:[EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 5:48 PM
To: Steven Roussey; [EMAIL PROTECTED]
Cc: 'Matt Lynch'
Subject: Re: Spatial Extension in MySQL 4.1.1-alpha
At 16:03 -0800 12/16/03, Steven Roussey wrote:
>You did an insert this way:
>
> mysql> insert into geom va
At 16:03 -0800 12/16/03, Steven Roussey wrote:
You did an insert this way:
mysql> insert into geom values(GeomFromText('POINT(1,1)'));
and expected results this way:
mysql> select AsText(g) from geom;
+---+
| AsText(g) |
+---+
| Point(1 1)|
+---+
1 row in
You did an insert this way:
mysql> insert into geom values(GeomFromText('POINT(1,1)'));
and expected results this way:
mysql> select AsText(g) from geom;
+---+
| AsText(g) |
+---+
| Point(1 1)|
+---+
1 row in set (0.00 sec)
The formatting of the POINT coo
Hi,
I am trying out the new GIS capabilities in MySQL 4.1.1-alpha (windows)
and I am trying to follow some of the examples from chapter 10 in the
manual.
Here is a snap shot of my run
mysql> create table geom(g geome
I noticed that too. Does anyone know the reason?
May the force be with you all!
nelson
>>> hotmail <[EMAIL PROTECTED]> 12/14/03 01:53pm >>>
Clear DayEvening,
No setup file is included in the ZIP mysql-4.1.1-alpha-win.zip
Do you know why ??
Cheers
Mark
>No setup file is included in the ZIP mysql-4.1.1-alpha-win.zip
>Do you know why ??
It is alpha software, expect an installer with the final version. In the meantime just
extract the zip file into a directory and it should run.
--
MySQL General Mailing List
For list archives
Clear DayEvening,
No setup file is included in the ZIP mysql-4.1.1-alpha-win.zip
Do you know why ??
Cheers
Mark
Christophe DIARRA <[EMAIL PROTECTED]> wrote:
>
> First, sorry, if my problem is know or documented. I have made a rapid
> search on the MySQL site, but without success.
>
> Here is my problem : the following 'create table' command refuses to
> execute on 4.1.1, if -1 is not put between a quottat
Hi!
> > > > create table t(a enum ('','ÐÐÐ','ÐÑÐ'));
> > > > show create table t;
> > > > CREATE TABLE `t` (
> > > > `a` enum('','???','???') default NULL
> > > > ) TYPE=MyISAM DEFAULT CHARSET=cp1251
>
> firstly, upgrade you mysql to current stable version (4.0.16).
I need 4.1, not 4.0
On Wed, 10 Dec 2003 15:25:57 +0200
"Juri Shimon" <[EMAIL PROTECTED]> wrote:
> Hi!
>
> >
> > > create table t(a enum ('','__','__'));
> > > show create table t;
> > > CREATE TABLE `t` (
> > > `a` enum('','???','???') default NULL
> > > ) TYPE=MyISAM DEFAULT CHARSET=cp1251
fi
Hi!
>
> > create table t(a enum ('','ÃÃÃ','ÃÃÃ'));
> > show create table t;
> > CREATE TABLE `t` (
> > `a` enum('','???','???') default NULL
> > ) TYPE=MyISAM DEFAULT CHARSET=cp1251
>
> But a bug in what?
> CREATE TABLE `t` (
> `a` enum('','ÃÃÃ','ÃÃÃ') default NULL
> ) TYPE=MyISAM
Hi,
> create table t(a enum ('','ÃÃÃ','ÃÃÃ'));
> show create table t;
>
> CREATE TABLE `t` (
> `a` enum('','???','???') default NULL
> ) TYPE=MyISAM DEFAULT CHARSET=cp1251
>
> and this is a bug!
But a bug in what?
I've created the table with Database Workbench, and when doing
a SHOW CR
Hi!
create table t(a enum ('','ÃÃÃ','ÃÃÃ'));
show create table t;
CREATE TABLE `t` (
`a` enum('','???','???') default NULL
) TYPE=MyISAM DEFAULT CHARSET=cp1251
and this is a bug!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://
Hi!
How I can set server variable "character_set_system" to cp1251 ?
I can use xxx'char' construction - but I need a downward compatibility.
I can select USER() and parse result on clientside - but I wan't rewrite
existing client apps.
> mysql -u root -e "select substring_index(USER(),
Hi!
> Latin1 is the default as i know.
> Let's check:
> 2.3.3 Typical configure Options
> 4.7 MySQL Localisation and International Usage
I know this. BUT, when I set def char set = cp1251 and do
CREATE DATABASE lalala
I get new database created in latin1
Is this a bug?
--
MySQL General Mail
Hi.
First, sorry, if my problem is know or documented. I have made a rapid
search on the MySQL site, but without success.
Here is my problem : the following 'create table' command refuses to
execute on 4.1.1, if -1 is not put between a quottation mark:
create table testTable (name varchar(10),
Hi!
In my.cnf:
[mysqld]
...
default-character-set=cp1251
default_collation=cp1251_general_ci
...
Then, after
>show variables like '%character%'
I have:
character_set_servercp1251
character_set_clientcp1251
character_set_connectioncp1251
character_set_resultscp1251
character_s
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Fri, 5 Dec 2003, Boehn, Gunnar von wrote:
> > Yes, we plan to offer Linux/PPC binaries in the near future - we're
> > currently working on purchasing a system for that.
>
> If you have some harddisk space left, then you can install Linux on o
At 19:04 4/12/2003 -0600, Matt W wrote:
Hi,
Named Pipe crashes on MySQL (4.1.1 alpha) WinXPI have been unable to get
named pipes to work on mysqld-nt 4.1.1
Alpha(including today's official release). As soon as I attempt a
connect the server crashes. I can't create a debug trace because n
Hallo Lenz,
> From: Lenz Grimmer [mailto:[EMAIL PROTECTED]
> > Any chance to offer binaries for PowerPC Linux as well ? (Preferable
> > tgz)
>
> Yes, we plan to offer Linux/PPC binaries in the near future - we're
> currently working on purchasing a system for that.
If you have some harddisk sp
For those who are interested like me:
MySQL 4.1.1 is released.
Thanks,
__
NZEYIMANA Emery Fabrice
NEFA Computing Services, Inc.
P.O. Box 5078 Kigali
Office Phone: +250-51 11 06
Office Fax: +250-50 15 19
Mobile: +250-08517768
Email: [EMAIL PROTECTED]
http
e -
Subject: Named Pipe crashes on MySQL (4.1.1 alpha) WinXP
Named Pipe crashes on MySQL (4.1.1 alpha) WinXPI have been unable to get
named pipes to work on mysqld-nt 4.1.1
Alpha(including today's official release). As soon as I attempt a
connect the server crashes. I can't create a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Thu, 4 Dec 2003, Boehn, Gunnar von wrote:
> Any chance to offer binaries for PowerPC Linux as well ? (Preferable
> tgz)
Yes, we plan to offer Linux/PPC binaries in the near future - we're
currently working on purchasing a system for that. I h
Hi Lenz,
Lenz Grimmer wrote:
> MySQL 4.1.1, a new version of the popular Open Source/Free Software
> database management system, has been released. It is now available in
> source and binary form for a number of platforms from our
> download pages
Any chance to offer binaries
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL 4.1.1, a new version of the popular Open Source/Free Software
database management system, has been released. It is now available in
source and binary form for a number of platforms from our download pages
at http://www.mysql.com/downloads
Are binaries of MySQL 4.1.1 available or we need to
compile it from the source.
Karam
__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
>> Are binaries of MySQL 4.1.1 available or we need to
>> compile it from the source.
> No, binaries are not available yet.
They will be available very soon, most probably this week (yes, I know
today's Thursday :-).
Regards,
--
Stefan Hinz <[EMAIL PROTECTED]
Karam Chand <[EMAIL PROTECTED]> wrote:
> Are binaries of MySQL 4.1.1 available or we need to
> compile it from the source.
No, binaries are not available yet.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ens
David Ritter <[EMAIL PROTECTED]> wrote:
>
> I think I have found a bug in the MySQL 4.1.1 C Binding API with inserting
> NULL values using the bind API. Can someone please send me an address that
> I can send a test case to the MySQL development staff so they can t
Hello,
I think I have found a bug in the MySQL 4.1.1 C Binding API with inserting
NULL values using the bind API. Can someone please send me an address that
I can send a test case to the MySQL development staff so they can take a
look at it?
Alternatively can someone tell me if this is the
"Rick Robinson" <[EMAIL PROTECTED]> wrote:
>
> When will 4.1.1 be officially available in a packaged download?
>
>
It should be released in September or in early October.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http:/
When will 4.1.1 be officially available in a packaged download?
Just curious.
Thx,
Rick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
70 matches
Mail list logo
