I am running Mysql 4.0 with InnoDB on a linux 2.4.0
machine
I am doing a "mass import" of a file with some 40
inserts
and I get a strange "unknown error 1114"
Interestingly enough , this is not exactly
reproducible, i.e.
the error occurs in slightly different import
positions.
I have b
On Thu, Jan 17, 2002 at 08:27:40PM -0500, Jon Shoberg wrote:
>
> Well,
>
> Another app was launched on my mySQL server. Only this one is poorly
> coded and heavily used.
That sucks. :-(
> Is there a way to change the priority of my connection? My entire
> app consists of select statements. O
Hi,
This is my first post to this list so please be patient on this
one. I was told that this might be the place to get an answer to this
question, although not entirely a MySQL Question. So, any suggestions or
help would appreciated.
We have a RaQ4i 400MHz server with 512MB o
Hi,
I've notice sometimes DISTINCT clause take a really high amount of time to
remove duplicates whereas it should be really quick (I assume it should be
;))
My first query is :
mysql> SELECT COUNT(*) as count, numreponse FROM searchhardwarefr3 GROUP BY
mot,date,numreponse HAVING count>1 LIMIT
Hello,
Using a fulltext search on a products database I'm running into some
rather strange results.
I'm trying to get a list of matches sorted by relevance.
Here is the query:
select products_name,MATCH
(products_name,products_name,products_description,item) AGAINST
('necker knife') as score f
Well,
Another app was launched on my mySQL server. Only this one is poorly coded
and heavily used. Is there a way to change the priority of my connection?
My entire app consists of select statements. Once I changed everything to
"SELECT HIGH_PRIORITY ...", that helped a ton. Can I bum
There is a link at http://www.entropy.ch/software/macosx/mysql/ for a
startup items package. This will cause MySQL to start when you restart the
Mac OS X system.
On 1/17/2002 8:30 AM, "Erik Price" <[EMAIL PROTECTED]> wrote:
> There is a utility called "daemonic" which is designed to deal with t
People,
KISS principle!
Please research "Table Options" in 6.5.3 CREATE TABLE Syntax because this can be done
when you set up/re-create
or ALTER the table, without fuss...
Regards,
=dn
- Original Message -
From: "Peter Dunham" <[EMAIL PROTECTED]>
To: "Mike Grabski" <[EMAIL PROTECTED
> Steve Rapaport
> still at large
are the (MySQL) police chasing you,
or is this the consequence of an enjoyable festive season?
=dn
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://l
On Thu, Jan 17, 2002 at 05:06:07PM -0600, Dan Nelson wrote:
> In the last episode (Jan 17), Jeremy Zawodny said:
> > On Thu, Jan 17, 2002 at 04:37:40PM +0200, Heikki Tuuri wrote:
> > > The maximum process space of Linux x86 is 2 GB, and better play
> > > safe.
> > >
> > > Jeremy, I think some Int
Hi!
Thanks a lot for you bug report.
This has already been fixed and it will be available as soon as 0.8.1
(note the versioning scheme change) is released.
Regards,
Jorge
--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /
Interesting, some of the databases were owned by root.
I chainged ownership back to mysql and now they all work. Even the one i had
trouble with after recovering from mysqlhotcopy.
Thanks much,
~Travis
>Error 13 is permission denied.
>
>chown -R mysql:mysql /var/lib/mysql ( or whatever )
>
>
In the last episode (Jan 17), Jeremy Zawodny said:
> On Thu, Jan 17, 2002 at 04:37:40PM +0200, Heikki Tuuri wrote:
> > The maximum process space of Linux x86 is 2 GB, and better play
> > safe.
> >
> > Jeremy, I think some Intel x86 processors support segmented memory
> > above > 4 GB. Is that sup
Hi. I recently installed MyCC 0.0.8 on Windows XP, and when attempting
to connect to a MySQL 3.22.30-MIPS server, MyCC crashes after automatically
issuing the following command: SHOW STATUS LIKE 'Uptime'. I've tested this
using the generic mysql client, and indeed the server reports that this
On Thu, Jan 17, 2002 at 04:37:40PM +0200, Heikki Tuuri wrote:
> The maximum process space of Linux x86 is 2 GB, and better play
> safe.
>
> Jeremy, I think some Intel x86 processors support segmented memory
> above > 4 GB. Is that supported in Linux?
Not sure. Most of what I've heard has alway
It's messy but you can also insert x rows, then delete x rows and the next
row inserted will have id x+1 assuming that you started with 0 rows.
--
Peter Dunham
Ellipse Media
t. +44 (0)20 8656 0950
---
-Original Message-
From: Mike Grabski [mailto:
Ken,
the 'connection lost' error suggests some bug in the client or
communication. Since you are running 4.0.1-alpha, it could be something with
the query cache. I think Sanja has already fixed some bugs there since 4.0.1
was released. The query cache is suspect since the error did not crash the
Would choosing a varchar field with 80 duplicate values, be a good candidate
for indexing. Please take a look at my table structure. I am thinking of
using the column odorant for indexing even though there will always be 80
duplicate values, per odorant, and there will be 350 unique odorants. E
I found the answers to my previous question about MySQL in the manual. Doh!
However, when I tried to compile MySQL, I ran into the following error:
/bin/sh ../libtool --mode=compile cc
-DDEFAULT_CHARSET_HOME="\"/export/home/bteale/mysql-3.23.47\""
-DDATADIR="\"/export/home/bteale/mysql-3.23.47/v
Hi Heikki,
Thought you might want to hear this one, I was trying to mysqldump
our support database (all tables innodb) WHen I got the following
error:
bash-2.04$ mysqldump --opt -uken -p supportdb terms >supportdb.dump
Enter password:
mysqldump: Error 2013: Lost connection to MySQL server durin
You can set your max_connections variable thusly:
mysqld -O max_connections=1000
(That's an upper-case letter "O" and the above needs to be appended to the
other options that start mysqld
-Original Message-
From: Mitch Fournier [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 17, 2002
I believe auto_increment uses the last highest value inserted into the
record. So if your first insert is 1000, it will count up from 1000 there on
after. Correct me if wrong.
Mike
-Original Message-
From: Jure Grom [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 17, 2002 3:56 PM
To:
> Is there any way to start Ids in table from some number for exampl 1
> with function auto_increment and not from 1?
http://www.bitbybit.dk/mysqlfaq/faq.html#ch6_4_0
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
-
> Remember a while back when I posted about restoring a mysqlhotcopy copied
> database that I got an error that it can't find the .frm file? Well, the
> error reports have been coming in that apparently most if not all
> my tables
> (restored or new) have the same error.
> Here is a sample from o
http://www.mysql.com/information/crash-me.php
> Is there some material available which comapres mySql with Oracle and PostgreSql.
--
Steve Rapaport
still at large
-
Before posting, please check:
http://www.mysql.com/man
Error 13 is permission denied.
chown -R mysql:mysql /var/lib/mysql ( or whatever )
Travis Farmer wrote:
>Remember a while back when I posted about restoring a mysqlhotcopy copied
>database that I got an error that it can't find the .frm file? Well, the
>error reports have been coming in that
Mitch,
You need to set the max_connections variable to something in you my.cnf
file. This number is really determined by your OS/Memory etc. but I
think the MySQL manual says somewhere about 500 to 700 being possible
with Solaris. Currently we use a figure of 220, but I got to that number
by
Hi
Has your host installed and configured MySQL, Apache, and PHP?
If that's the case you're looking at a few of hours of work (depending on
site size)
Let me know if that's been done and give me some basic idea of your site
size and I can get back with a price.
Fred Steinkopf
On Thu, 17 Jan 2002,
Remember a while back when I posted about restoring a mysqlhotcopy copied
database that I got an error that it can't find the .frm file? Well, the
error reports have been coming in that apparently most if not all my tables
(restored or new) have the same error.
Here is a sample from one of the pag
Hi,
i've been googlizing for a while now and can't find a straight answer to
this question:
- what is the optimal setting for "max_connections" in mysql?
- how do i start the server w a higher number?
stats on my db setup:
- database machine has 384MB of ram
- clients are web browsers hittin
Is there any way to start Ids in table from some number for exampl 1
with function auto_increment and not from 1?
tnx
jure
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lis
Hello
I am working in a project on Tcl/tk and Mysql, I use Win98, Just change my
computer to a Sony Vaio PIII It comes whit Win me. We can not make it work,
has any body do it? it so could you send me the .dll files or I just go
back to win98.
Alberto Romero
[EMAIL PROTECTED]
Mazatlan Mexico
>looks more like an MP3 player than a db admin tool.
Which is not necessary a bad thing :) I guess the main reason why linux is
not growing its user base on desktops is the awful design of the UI of all
basic apps. In addition to the lack of compatibility to M$ tools..
>Incidentally, their dat
Rich,
it was a bug. If inserts to several tables containing an auto-inc column are
wrapped inside one LOCK TABLES, InnoDB will assert in lock0lock.c, line
2843.
Workaround: remove the LOCK TABLES if you can, or LOCK just one table at a
time.
I have fixed the bug to 3.23.48. You will get a patch
Hi. I have been attached to this mailing list for some months now.
And i just love it when i open my post box to find 110 new emails! ;)
ANyway, i have installed a bullitin board (vbullitin) with a table for
SQL. I know the mailing list is a convenient way to keep track of
things, but a boa
On Thu, 17 Jan 2002, Ryan Fox wrote:
> The current action is that this value is truncated to fit the column. The
> other option would be to automagically expand the column's length so the
> value would fit. Despite what the original poster may think, they _really_
> don't want that to happen.
R
A couple of questions about compiling on Solaris.
1) Are the Sun Workshop 6 compilers supported for MySQL and MySQL++?
1a) Can you use the -native flag without problems?
2) Is the binary distribution compiled with Sun or GNU compilers?
Background Info:
We are currently trying to ingest 1.5
On Thursday 17 Jan 2002 7:16 pm, Alok K. Dhir wrote:
> P.S. For those who haven't used Mascon, I highly recommend it. It's a
> terrific tool for managing MySQL databases
the only thing I would say against it, is that it's a client not a server,
and a larger organisation that needs to chang
On Thu, 17 Jan 2002, Henning Sprang wrote:
> ok, so it isn't depending on "fixed length" as you first said, and the
> reason for it is just the simple design of sql, right?
Right. (Sorry for the previous inacuracy, I was using 'fixed' in a wide
sense viz. including 'bounded'.)
Cheers,
--
,
I am trying to compare two tables and get a list of all the data that does not match.
How can I compare all the fields from two tables with one SQL statement? I've been
using the Find Unmatched Query Wizard, but it will only let me compare one field at a
time. I want to list all the ID numbers
> > > Doesn't matter: "If you assign a value to a CHAR or VARCHAR
> column that
> > > exceeds the column's maximum length, the value is truncated to fit."
> >
> > ok, so it isn't depending on "fixed length" as you first said, and the
> > reason for it is just the simple design of sql, right?
>
>
Hello,
We have a site that uses PHP and MySQL on Linux, and we
need to get it moved from our own server to a professionally
hosted server. Unfortunately no one in our organization has
enough Linux and MySQL knowledge to make this happen,
so we're looking to hire an experienced developer for this
Nope. Looks like you're stuck with their "creamy" look. In fact, it
doesn't really use XP widgets - it uses it's own widget set/skin which
looks more like an MP3 player than a db admin tool.
Incidentally, their database admin tool, called Navicat, looks awfully
familiar... It's basically just
> > Doesn't matter: "If you assign a value to a CHAR or VARCHAR column that
> > exceeds the column's maximum length, the value is truncated to fit."
>
> ok, so it isn't depending on "fixed length" as you first said, and the
> reason for it is just the simple design of sql, right?
As I see it, the
Problem Solved.
Indeed version 4 does work :-)
Here are some times I got for all of you mysql fans (I knew that mysql
couldn't let me down :-))
MSSQL: 28,6 secs
MySQL 3: 40,1 secs
MySQL 4: 36,3 secs
MySQL 4 (caching enabled): 21,9 secs
MySQL 4 (caching enabled - second pass): 0 secs
So indeed c
chown -R mysql:mysql /var/lib/mysql
( or whatever the data directory is ).
Henning Sprang wrote:
> Hy all,
> I just try to set up Replication with two mysql databases,
> i did everything like described in the Replication-Howto.
>
> Now i get the following errors when starting the slave:
>
> 020
M. A. Alves wrote:
> On Thu, 17 Jan 2002, Henning Sprang wrote:
>
>>>So your field is of fixed length type (you hadn't told us that yet).
>>>
>>Aehm, no, it isn't! It's VARCHAR.
>>
>
> Doesn't matter: "If you assign a value to a CHAR or VARCHAR column that
> exceeds the column's maximum length,
Hy, sorry for the trouble!
i tried to do a
chown mysql:daemon -R *
in the data dir, and after that it worked.
I didn't try that before because somehow i couldn't see a connection
between differing ownerships and disfunctional tables when looking at this.
sorry,
henning
Henning Sprang wrote:
thanks, sinisa.
in case anyone else wants it, here is the shell fragment i wrote to test for
this condition. there is no timeout.
#!/bin/sh
echo -n "waiting for MySQL: "
until [ -n "`mysqladmin ping 2>/dev/null`" ]
do
echo -n "."
On Thursday 17 Jan 2002 4:52 pm, fla wire wrote:
> Hello,
> I have a freebsd machine running mysql and php. Yes I am one of those
> newbies.
> I have read the FU*K manual. I have a sams learn in 21 day book. also a php
> essentials and build your own database drive book. I have a brazilian rain
>
The first thing that comes to mind is that you're running the databases on
different hardware and operating systems. I know the Linux kernel had some
SMP performance issues not too long ago, prompting IBM to rewrite portions
of the kernel and improving performance by (I think) 16-20%. Also, you're
> The bug manifests itself in the following situation. A temporary
> table has been created on the master server. A query is executed
> using an alias for that temporary table. The connection is dropped
> without explicitly dropping that temporary table. In the binary log,
> mysql records a dr
Hi,
It's already done since MySQL 4.0.1.
Take a look here :
http://www.mysql.com/doc/Q/u/Query_Cache.html
Regards,
Jocelyn
- Original Message -
From: "Ioakim Spyros" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 17, 2002 6:52 PM
Subject: FW: Optimization
Hello all
On Thursday 17 Jan 2002 1:13 am, Mr Aaron Brandis wrote:
> Hi everyone
>
> This is the first time I have posted to this list and I was wondering if
> someone could answer my question. I know you can run commands from a
> shell prompt (such as unix...) like:
>
> shell> mysql -e 'SELECT * FROM tabl
Hy all,
I just try to set up Replication with two mysql databases,
i did everything like described in the Replication-Howto.
Now i get the following errors when starting the slave:
020117 18:37:55 mysqld started
Can't initialize InnoDB as 'innodb_data_file_path' is not set
/usr/sbin/mysqld-max:
> We have a php page that we put in people that belong to a football pool.
> However it is not adding the data to the table. We do not get any error
> messages either even tho the php page is setup to display the errors.
> I find no errors in the http-errrors.log. the httpd-access.log shows the
>
Hello all,
I'm having real trouble trying to optimize MySQL cause I can't believe that MSSQL is
faster.
My configurations are as follows:
MSSQL 2000 on W2K server. PIII 733 - 512 MB memory.
MySQL-3.23.47-1 on Redhat 7.2. Dual PIII 1000 - 1.128 GB memory
I have a PHP script that runs on a Redh
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: REPLICATION BUG
>Description:
The bug manifests itself in the following situation. A temporary
table has been created on the master server. A query is executed
using an alias for that temporary table. The connection is dropped
withou
John,
I had already updated the online manual at http://www.innodb.com. It warns
now about the 2 GB limit on memory usage in Linux x86.
InnoDB does not use the record_buffer of MySQL at all. But sort_buffer is
used.
I think the danger lies in server overload: many ORDER BY queries may get
stuck
I've been trying to install mysql-3.23.43 on a SunOS 5.7 machine. I grabbed
mysql-3.23.43-sun-solaris2.7-sparc.tar.gz from the ftp site. I've unzipped
and untarred the file, but I don't see a configure file or a Makefile for
that matter. What gives? When I issue the "tar xvf" I get the followi
Hello,
I have a freebsd machine running mysql and php. Yes I am one of those
newbies.
I have read the FU*K manual. I have a sams learn in 21 day book. also a php
essentials and build your own database drive book. I have a brazilian rain
forest of manuals,printouts etc.
We have a php page that we
There is a utility called "daemonic" which is designed to deal with this
as well, but works for more than just MySQL -- it's intended to be used
for all server daemons.
http://daemonic.sourceforge.net/
It is Mac OS X-specific at this time, but according to the web site is
designed for future
And can you turn those off and get normal widgets that respect user system settings?
XP style for me is a reason to not even look!
At 11:07 2002-01-17, you wrote:
>Just downloaded and at least it looks pretty creamy with the latest XP style
>widgets...
G: database,sql,query,table
--
Hi
I have been experiencing the following error when using MyODBC in Windows
2000 within Microsoft Access 2000 with MDAC Component 2.7:
ODBC--call failed
[TCX][MyODBC]Access denied for user:
'[EMAIL PROTECTED]' (Using password: YES) (#1045)
The thing I can't understand is the problem does not a
Gerald
Thanks a lot for that...
The first option is what worked, I didn't think to CHMOD the directory to
give execute permissions!
Just for the record and for any other newbies out there, the database table
worked when I CHMOD'd the directory all the .frm, .MYI, .MYD files are held
in to 700.
I am using mySQL with tomcat and JSP without any problem.
Hearing about your symptoms, I would guess that your connections need to be
refreshed from time to time (after a certain time an unactive connection
will be dropped which explain why you have to restart tomcat)
You should use a connection
added to http://jfontain.free.fr/mysql/ :
- Howto:
- Monitoring replicated servers
- Sending SNMP traps
- Sending SMS messages
Please let me know what you think and/or you have other ideas for howtos.
Cheers,
--
Jean-Luc Fontaine
---
It is the code that closes the connections (pconnect)
So it would be good to have a look at client first...
MySQL should have no problme with upto 1000 connetions...more if you are not
on Linx..
I hope this helps you or some one else...
Simon
-Original Message-
From: Core Dumped
Hy,
has anyone ever experienced the problem that when specifying a
program-prefix with configure, the specified prefix will be prefixed two
times, say i do
./configure --prefix=/usr/local/mysql/ --program-prefix=ga
then I get binaries like
gagamysql gagamysqladmin gagamysqlshow
and so on..
On Thu, 17 Jan 2002, Henning Sprang wrote:
> > So your field is of fixed length type (you hadn't told us that yet).
> Aehm, no, it isn't! It's VARCHAR.
Doesn't matter: "If you assign a value to a CHAR or VARCHAR column that
exceeds the column's maximum length, the value is truncated to fit."
(MyS
Ok, i think i've found the cause of my problem and maybe your too !
In fact my MySQL doesn't close opens conections and he doesn't let me open
an another one...and so throw me an exception. If i'm waiting few minutes
before opening new connections, it's working, so just check your
'connection t
The user under which mysql is running ( 'mysql' ? Better check. ) does
not have read permissions on
the .frm files OR does not have execute (x) permissions on their parent
( or any ancestor ) directory.
chown -R mysql:mysql /var/lib/mysql
should do the trick. Replace /var/lib/mysql with the ac
Heikki & Jeremy,
Thanks again for your help. I'll try it out and see how things go. I
will just note that in most of the MySQL documentation talks about how
one can set key_buffer or innodb_buffer_pool up to 75% of your maximum
memory, which in the case of our db machines is 4GB. I have been
I got the same problem, and i have the impression that this is a MySQL bug...
Sorry i can't help you at this moment... i have to help myself first ! :))
Good luck
-
Before posting, please check:
http://www.mysql.com/manual.ph
M. A. Alves wrote:
> On Thu, 17 Jan 2002, Henning Sprang wrote:
> So your field is of fixed length type (you hadn't told us that yet).
Aehm, no, it isn't! It's VARCHAR.
Sorry I overread that part, a colleague sitting next to me told me that
this behaviour is _normal_ and documented, and so I
> I suggest setting record_buffer to 1 MB. Disk reads in blocks of 1 MB are
> probably as fast as in blocks of 10 MB.
I agree
A typical modern disk has an average access time of 5.5 msec and a transfer
rate of 40 Mbyte/sec.
This means that the two are the same for a disk transfer of about 200k
Hi
I have MySQL running on a RAQ4i. It has been running perfectly well for
almost a year and has four separate databases on it.
Last week, whilst checking over the sites that make calls on these databases
I noticed that only one had problems.
Through searching the FAQs and online documentation
Hi
I have this query on ma table:
explain select count(przetargi_zaw.id_kat),przetargi_typy.nazwa as typy from
przetargi_typy left join przetargi_zaw on przetargi_zaw.id_kat =
przetargi_typy.id group by typy;
i see:
+---+---+---++---+--
-
John,
I suggest setting record_buffer to 1 MB. Disk reads in blocks of 1 MB are
probably as fast as in blocks of 10 MB.
Also set sort_buffer to 1 MB, and only increase it if there are performance
problems.
The maximum process space of Linux x86 is 2 GB, and better play safe.
Jeremy, I think so
On Thu, 17 Jan 2002, Henning Sprang wrote:
> >>... I just realized that Mysql simply "cuts" Data i want to insert
> >>into a field when it is too long, without giving any warning or error
> >>message. . .
> > If the field has fixed length that is standard behaviour (together with
> > right-paddin
It's probably a tinyint field which won't go higher than 127.
Fred.
On Thu, Jan 17, 2002 at 02:40:54PM +0100, Thibaut Allender wrote:
>
> an index cannot be null
>
> you should do this :
>
> insert into equipment (id,description) values ('','test data');
>
> regards
>
> At 14:27 17/01/2002
Hi,
Michael Tam wrote:
>
> Hi All,
>
> I just installed resin-cmp-1.0.5 with Apache1.3.22 and mysql3.23.47. I
> used m.mmysql.2.0.8 JDBC driver with the following config segment in my
> resin.conf:
>
>
>
> jdbc/test
> javax.sql.XADataSource
>
[snip]
Do you use MySQL or My
an index cannot be null
you should do this :
insert into equipment (id,description) values ('','test data');
regards
At 14:27 17/01/2002, you wrote:
>database,sql,query,table
>
>If you just reply to this message, and include the entire text of it in the
>reply, your reply will go through. How
Michael Widenius writes:
>
> Hi!
>
>
> MySQL will first read systemdir\my.ini and then C:\my.cnf
>
> Sorry, Sinisa, you can't get things right every time ;)
> (No one can...)
>
> I have updated the manual regarding this.
>
> Regards,
> Monty
Yes, you are right.
I looked a bit better.
On
database,sql,query,table
If you just reply to this message, and include the entire text of it in the
reply, your reply will go through. However, you should
first review the text of the message to make sure it has something to do
with MySQL. Just typing the word MySQL once will be sufficient, for
Hi!
> "Heikki" == Heikki Tuuri <[EMAIL PROTECTED]> writes:
Heikki> Ross,
Heikki> "Ross Davis" wrote in message ...
>> On the front screen of the mysql site the mysql-Max 3.23.47 is listed as
>> stable.
>>
>> However on the download page it is said to be considered a beta yet?
Heikki> the
M. A. Alves wrote:
> On Thu, 17 Jan 2002, Henning Sprang wrote:
>
>>... I just realized that Mysql simply "cuts" Data i want to insert
>>into a field when it is too long, without giving any warning or error
>>message. . .
>>
>
> If the field has fixed length that is standard behaviour (togethe
On Thu, 17 Jan 2002, Henning Sprang wrote:
> ... I just realized that Mysql simply "cuts" Data i want to insert
> into a field when it is too long, without giving any warning or error
> message. . .
If the field has fixed length that is standard behaviour (together with
right-padding too short v
Hi!
> "Jeremy" == Jeremy Zawodny <[EMAIL PROTECTED]> writes:
Jeremy> On Thu, Jan 17, 2002 at 03:17:10AM +0200, Michael Widenius wrote:
>>
>> Hi!
>>
Sinisa> my.cnf will be read first and if it is found my.ini will not be read
Sinisa> at all.
>>
Sinisa> Take a look at mysys/default.c for
Hy,
I have an interesting question, I just realized that Mysql simply "cuts"
Data i want to insert into a field when it is too long, without giving
any warning or error message.
Ok, i know now that this happens and that i have to take care myself
that this doesn't happen.
But i am very curiou
Hi,
Is there some material available which comapres mySql with Oracle and PostgreSql. What
I
am looking for is a comparison of features, for example what all is supported by
Oracle/PostgreSql which is not there in mySql. It will be great if there is some
information on alternative approaches tha
Hi!
On Jan 17, Alexei V. Alexandrov wrote:
> Hello everyone,
>
> I`m running mysql version 4.0.0-alpha under FreeBSD 4.3-STABLE on a
> dual pentium 4 x 1Ghz with a total memory of 1.5Gb and a scsi hard
> drive with a volume about 50Gb. The problem is in the InnoDB startup
> option innodb
Hello everyone,
I`m running mysql version 4.0.0-alpha under FreeBSD 4.3-STABLE on a
dual pentium 4 x 1Ghz with a total memory of 1.5Gb and a scsi hard
drive with a volume about 50Gb. The problem is in the InnoDB startup
option innodb_buffer_pool_size. I`m trying to set it to about 500MB.
Now there seems to be some kind of evaluation version available:
http://www.mysqlstudio.com/shareware.php3
Just downloaded and at least it looks pretty creamy with the latest XP style
widgets... I guess this is the more commercial direction MySQL might take.
Like what Covalent is doing with apa
Now there seems to be some kind of evaluation version available:
http://www.mysqlstudio.com/shareware.php3
Just downloaded and at least it looks pretty creamy with the latest XP style
widgets... I guess this is the more commercial direction MySQL might take.
Like what Covalent is doing with apa
On Thu, Jan 17, 2002 at 03:17:10AM +0200, Michael Widenius wrote:
>
> Hi!
>
> Sinisa> my.cnf will be read first and if it is found my.ini will not be read
> Sinisa> at all.
>
> Sinisa> Take a look at mysys/default.c for futher details ...
>
> To refresh my memory, I did.
>
> MySQL will first
On Wed, Jan 16, 2002 at 09:46:48PM -0500, John Kemp wrote:
> From the innodb.com site (bugs & fixes):
>
> This has me worried, but I haven't seen this behaviour on our site. We have
>
> innodb_buffer_pool = 1100Mb
> key_buffer = 400 Mb
> record_buffer = 10Mb
> sort_buffer = 20Mb
> max_connectio
On Tue, Jan 15, 2002 at 08:42:44PM +0200, Emmanuel van der Meulen wrote:
> Hello all,
>
> Is there a roadmap for MySQL releases
Sort of.
The way it generally works is that the MySQL developers work off the
TODO list that you'll find in the MySQL Manual.
> and in particular when it the eta for
Check out :
http://www.weberdev.com/index.php3?GoTo=phenominet/prices.htm
This is your one stop shop for hosting. WeberDev.com is hosted there
and I can tell you that their service is amazing. They are fast,
reliable
and more than anything, very professional (specially in PHP / MySQL).
Sincere
Oracle didn't publish its database Architecture
diagram. But the oracle press books contain the
diagram.
The diagram in general describes the inner thing of
oracle database, i.e how,where,when the data is stored
and what are the process involved to do it.
Like Database buffers,redo log buffers,sha
1 - 100 of 104 matches
Mail list logo
