Roman,
- Original Message -
From: Roman Neuhauser [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 11:46 PM
Subject: Re: innodb: storage requirements
# [EMAIL PROTECTED] / 2003-09-24 17:41:29 +0300:
the row count in SHOW
Does anybody have any idea why this program won't compile, it seems to
be straightforward, but it I can't get it to compile on Redhat-7.3.
It starts screaming about mysql.h immediately, I use this link to
compile with, on my machine at the house, it compiles just fine and runs
just fine, but I
Hi Daniel,
Yes, query_cache_type is 1 by default if you don't set it. :-) It's not
used by default, however, because query_cache_size is 0. You need to set
query_cache_size to 16M, 32M, etc.
Hope that helps.
Matt
- Original Message -
From: Daniel Kasak
Sent: Thursday, September 25,
Hi,
Imagine I had a table with 50,000,000 rows, would it improve search speeds
if I split it up into smaller tables of 10,000,000 rows each? This means
if I had to search for a record, I'd have to query the 5 tables one after
the other.
I'd greatly appreciate any help.
Gerald.
--
MySQL
hello !
I'm using my french host's phpMyAdmin and I'd like to create manually a new table
using different character set and collation
than default one. This is the code I've used :
CREATE TABLE `ru` (
`pkey` INT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`titre` TEXT NOT NULL
) CHARACTER SET
On Thu, 25 Sep 2003 10:11:27 +0200 (CEST)
Artem Batoussov [EMAIL PROTECTED] wrote:
The first part has been generated by phpMyAdmin and I've just added CHARACTER SET
koi8r COLLATION koi8r_general_ci
like it's done in the example from this doc :
Due to complex query needs and the lack of subqueries in the current
production version of MySQL i have to use temporary tables, but there is
almost no information about the behavior of them in the manual.pdf
documentation file of mySQL database. Does any one know where to find more
On Thu, 25 Sep 2003 02:26:28 -0600
[EMAIL PROTECTED] wrote:
1) What happens if two (or more) users create a temporary table with the
same name at the same time?
2) If i don't drop the tables, when are the tables droped by the server?
3) what are the memory and or performance issues of
Imagine I had a table with 50,000,000 rows, would it improve search
speeds
if I split it up into smaller tables of 10,000,000 rows each? This means
if I had to search for a record, I'd have to query the 5 tables one after
the other.
Which is likely to be slower. If you have good indexes for
Thanks!
Antony Dovgal [EMAIL PROTECTED]
25/09/2003 02:33 a.m.
To
[EMAIL PROTECTED]
cc
Subject
Re: Temporary tables
On Thu, 25 Sep 2003 02:26:28 -0600
[EMAIL PROTECTED] wrote:
1) What happens if two (or more) users create a temporary table with the
same name at the same time?
2)
Thank you very much Paul and Keith for your response , I guess I will have
to use LIKE clause in SQL statement for searching the records then.
Imran
- Original Message -
From: Keith C. Ivey [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Imran Aziz [EMAIL PROTECTED]
Sent: Tuesday, September
i'm trying to compile mysql-4.0.15a on my server and i'm getting the
folowing error:
gcc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\
-DDATADIR=\/data/mysql\ -DSHAREDIR=\/usr/local/mysql/share/mysql\
-DUNDEF_THREADS_HACK -DDONT_USE_RAID -DMYSQL_CLIENT -I. -I. -I..
-I./../include -I../include -I./..
Hi All,
I have recently discovered that when you place a primary key constraint on a column of
type CHAR(2) the constraint causes the following to happen when I add a new row to the
table:
if a key (AA) is already in the table then I can not add Aa, aA or aa
this seams a bit wrong as 'A' !=
Morning all,
I've been using the same format of text files to import monthly text
files using LOAD DATA LOCAL INFILE into a table.
It's been working fine until today when it decided to import the rows
from the text file in a semi-random order instead of working through the
file from start to
Jacques Buitendag [EMAIL PROTECTED] wrote:
I have recently discovered that when you place a primary key constraint on a column
of type CHAR(2) the constraint causes the following to happen when I add a new row
to the table:
if a key (AA) is already in the table then I can not add Aa, aA
At 02:55 AM 9/25/03 -0400, you wrote:
Does anybody have any idea why this program won't compile,
it compiles fine on my slak box with includes from 4.0.15 so the program is
probably ok.
...
It starts screaming about mysql.h immediately,...
gcc -c -I/usr/include/mysql mysql1.c
make sure the
Louie Miranda [EMAIL PROTECTED] wrote:
When i exported the data, i found an option on the lower part of the sql
code.
) TYPE=MyISAM AUTO_INCREMENT=0 ;
I tried to make a table again, and when i entered it resets to whatever
options i last type it on the AUTO_INCREMENT=0 value.
You can use
On Thu, 25 Sep 2003 [EMAIL PROTECTED] wrote:
[...]
Which is likely to be slower.
Wow!
[...] Just give it lots of Ram so that it can cache its indexes in
mamory, and it will perform very well.
Thanks for taking time to answer this.
Cheers,
Gerald
--
MySQL General Mailing List
For list
- Original Message -
From: Anne Piotet
To: [EMAIL PROTECTED]
Sent: Thursday, September 25, 2003 1:07 PM
Subject: Secting according to values of previous records!
Hi!
I'm relatively new to MySQL and encounter the following problem:
- I have a table (~300'000 records) containing
Hi!
I'm relatively new to MySQL and encounter the following problem:
- I have a table (~300'000 records) containing process data (which I get
under a given form from plants); a flag (1¦0) signals the start of a new
series of trials , moreover another field indicates the waiting time between
trial
i'm trying to compile mysql-4.0.15a on my server and i'm getting the
folowing error:
gcc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\
-DDATADIR=\/data/mysql\ -DSHAREDIR=\/usr/local/mysql/share/mysql\
-DUNDEF_THREADS_HACK -DDONT_USE_RAID -DMYSQL_CLIENT -I. -I. -I..
-I./../include -I../include -I./..
i'm trying to compile mysql-4.0.15a on my server and i'm getting the
folowing error:
gcc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\
-DDATADIR=\/data/mysql\ -DSHAREDIR=\/usr/local/mysql/share/mysql\
-DUNDEF_THREADS_HACK -DDONT_USE_RAID -DMYSQL_CLIENT -I. -I. -I..
-I./../include -I../include -I./..
How did you determine this?
I hope not by the order returned when you select them.
There is no order to the set returned unless you use an ORDER BY clause.
Adrian Sill wrote:
Morning all,
I've been using the same format of text files to import monthly text
files using LOAD DATA LOCAL INFILE into
No, raw viewing via phpmyadmin.
We have some strange rules on our dates which mean that when it comes to
processing the data its easier if it's in order before it goes in.
for example, we have a schedule running 24 hours a day, but the dates
associated with the entries run from 6am to 6am,
On Thu, 25 Sep 2003 15:28:15 +0200
Richard Pijnenburg [EMAIL PROTECTED] wrote:
i'm trying to compile mysql-4.0.15a on my server and i'm getting the
folowing error:
Richard, please, resend your letter one more time, we have real enjoy reading it again
and again...
=)
---
WBR,
Antony Dovgal
Sorry, but because I haven't got it I thought it didn't get here.
Sorry!
M.v.g.
Richard Pijnenburg
-Original Message-
From: Antony Dovgal [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 25, 2003 3:42 PM
To: [EMAIL PROTECTED]
Subject: Re: mysql compile error.
On Thu, 25 Sep 2003
Hi,
I have three tables. One of the tables has a column that
is a foreign key that references columns from the other
two tables. This table is shown below.
CREATE TABLE `pheno` (
`id` smallint(5) unsigned NOT NULL auto_increment,
`relevant` enum('y','n') default NULL,
`phenotype`
I am the admin of a Mysql 4.0.14-standard databas running on Solaris 9.
A developer and I created a shell script that does a mysqldump of the
database and then runs an optimize on the largest table we have. The
command line is as follows:
$EXECPATH/mysql --host=172.65.12.10 --user=user
On Thu, 25 Sep 2003 09:23:13 -0500
Ben Ricker [EMAIL PROTECTED] wrote:
Here is the output we got this morning:
test.MESSAGES optimizeerror 13 when fixing table
test.MESSAGES optimizestatus Operation failed
# perror 13
Error code 13: Permission denied
check if it's
I'm using InnoDB tables and created a new one with an autoincrement
field to use for a primary key. These tables are being loaded from
text files that I create out of another database system (Lotus
Notes).
My question is what must I do in the text file structure to account
for the autoincrement
Yes, i did that.
It's given me something like
si 200/300
so 300/500
It's a lot, doing my system going down. But i think that the problem is that i'm
reserving too much memory for mysql...
Or could exists another reason?
Thx
Alexis
Quoting Per Andreas Buer [EMAIL PROTECTED]:
[EMAIL
Thank you for your support.
In fact the problem was in MySQL Front.
I tried using SQLyog and it passed very well.
The problem is that SQLyog will not facilitate me in buying since I have no
credit card!!! I am in Africa and the best payment method I have access to
is by Western Union
Hi groups,
I need some experienced users to guide me on this issue.
I am developping an Application that will be accessing a MySQL database through MyODBC.
The application is developped using Visual Basic.
Since my application will be used simultaneously by more than 200 users, I want to
know
My experience is this. I use DAO through MyODBC, and I also use the
libmysql.dll with a custom recordset. Connection times through both options
are extremely fast. Fast enough in my situation that it can basically can be
ignored. There are times when I open several connections to the server at
The general rule of thumb is that connection creation/destruction is the most costly
part of approach #2. However, it is unlikely that each connection needs a dedicated
connection, and therefore memory resources on the server for the entirity of the
client's lifespan...
if your clients are
I found the answer in the archives:
http://marc.theaimsgroup.com/?l=mysqlm=104770109826977w=2
/* client1.c - connect to and disconnect from MySQL server */
#include my_global.h
#include my_sys.h /* - Added this and it all works fine now */
#include mysql.h
thanks Paul :)
KL
Kelley
Michael sleibi [EMAIL PROTECTED] wrote:
Could you please tell me what is the command to install the mysql 4.1
alpha with the default character sets arabic (cp1256) on windows .
MySQL doesn't support cp1256 character set. You can use unicode for arabic language in
v4.1.
--
For
What is connection pooling?
How big should my memory be if 200 connections may be required?
Is there any limit of how many connections I can use in MySQL?
I know one can set the max connections in MySQL. Does MySQL impose the limit
I can tell it? I mean, may I set that number to let's say 1?
I never use DAO.
Is there any benefit over ADO?
Thanks
Emery
- Original Message -
From: Roger Davis [EMAIL PROTECTED]
To: Director General: NEFACOMP [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, September 25, 2003 18:14
Subject: RE: Ideas on creating
Oscar (TOMCAT) [EMAIL PROTECTED] wrote:
I'm using MySQLcc version 0.9.2-beta... I want to recover more than 1000
rows in a select statement... What is the command to alter this setting
???
Open the Register Server window, go to the MySQL Options, there you can find
Automatically limit
On Thu, Sep 25, 2003 at 03:55:26PM +0100, [EMAIL PROTECTED] wrote:
Yes, i did that.
It's given me something like
si 200/300
so 300/500
It's a lot, doing my system going down. But i think that the problem is that i'm
reserving too much memory for mysql...
That's probably true and very
On Thu, Sep 25, 2003 at 06:47:10PM +0200, Director General: NEFACOMP wrote:
What is connection pooling?
http://search.yahoo.com/search?ei=UTF-8fr=sfpp=what+is+connection+pooling
How big should my memory be if 200 connections may be required?
What memory?
That depends on your platform.
DAO is, I guess you would say, the predessor to ADO. I am currently in the
process of getting rid of all the DAO code in the application and moving to
a custom recordset using the libmysql.dll. Some of this is done in VB and
it is still extremely fast for a VB based recordset. Although there
Just wanted to know if anyone knows the status of the MySQL powered Mailserver found
at http://www.mysql.com/portal/software/item-239.html
Thanks,
__
NZEYIMANA Emery Fabrice
NEFA Computing Services, Inc.
P.O. Box 5078 Kigali
Office Phone: +250-51 11 06
Office
Please tell me it ain't so! My test user is using MyOBDC to connect
to
our 4.1.0 alpha server. She will be creating some Crystal Reports
from
the data. Her test DSN fails on an incompatible protocol error with a
message that she should upgrade to the newest client. Do I have to
download bitkeeper,
Thank you for your time.
I don't want to be too much demanding.
I currently have a problem with MyODBC 3.51.
When my client machine is set to use French numbers (with a COMMA instead of
a PERIOD or DOT for floats), MyODBC does not let the decimal part to pass.
Venu told me he will try to look
I use MyODBC 3.51.06 to connect my VB applications to MySQL and it works.
Thanks
Emery
- Original Message -
From: Randy Chrismon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, September 25, 2003 19:20
Subject: Connect to 4.1 using MyOBDC
Please tell me it ain't so! My test
As I understand, no new work is done with DAO and I think Microsoft
dropped support for DAO.(I may be wrong). I've been using ADO for a
while now and have had no problems with it. I used to use DAO when I
started doing VB but I tend to like ADO much better.
Also, as far as I know
Just my $0.02
Is everyone on the list receiving the message below?
It is coming to me every time I send a message to the mysql list
Thanks
Emery
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, September 25, 2003 20:04
Subject: No valid command found
Your message
Try here
http://www.lencom.com/desc/indexN16185.html
-Original Message-
From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 25, 2003 1:18 PM
To: [EMAIL PROTECTED]
Subject: MySQL powered MailServer
Just wanted to know if anyone knows the status of the
Or not, try here instead http://gd.tuwien.ac.at/graphics/sf/h/hmailserver/
-Original Message-
From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 25, 2003 1:18 PM
To: [EMAIL PROTECTED]
Subject: MySQL powered MailServer
Just wanted to know if anyone knows
Although I would love to share the code for this recordset, unfortunately,
it is not completely ready for dissemination at this time. At some time in
the future, I will release it under a GPL license but there is still quite a
bit of work.
I use recordset in the vaguest of terms as it somewhat
me too !!!
- Original Message -
From: Director General: NEFACOMP [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, September 25, 2003 1:52 PM
Subject: Fw: No valid command found
Is everyone on the list receiving the message below?
It is coming to me every time I send a
Seems to be a problem with the fact that the server is on a Linux
box.
I was having this problem connecting the mysql command environment to
the linux server until I added -protocol=TCP to the login statement.
Or maybe it's just that we use a TCP/IP network (doesn't everybody?).
Anyway, my test
It seems the developpers are no longer doing any work on this server. Their
website is empty: http://www.halvar.com/
Thanks
Emery
- Original Message -
From: Luc Foisy [EMAIL PROTECTED]
To: Director General: NEFACOMP [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, September 25, 2003
I can connect to my v4.1 MySQL server from Crystal Reports v8.5 using MyODBC
v3.51. (Via selecting my DSN from the list of ODBC DSNs that Crystal shows
me).
-Holly
-Original Message-
From: Randy Chrismon [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 25, 2003 10:21 AM
To: [EMAIL
Hi,
I asked sometimes ago - I'ld be happy, if some of you knows an answer:
does anybody uses OpenOffice.org with mysql and can start there the gui for
foreignkeys?
Kind regards
Dieter
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi,
I have question on replication setting in my.cnf
what is the difference between relay-log and relay-log-index? If I do not
set them, what will happen?
thanks
Hsiu-Hui
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hello,
I'm doing this some in my application, and was wondering if anyone had
any ideas about the efficiency of cross-database queries:
Select * from db1.poems left join db2.users on poems.mid = users.mid
My runtime variables do show 319 'change db' queries - but I don't know
if that
These options are used to specify the location of the respective files.
If you do not set them they go to your datadir e.g. /var/lib/mysql
http://www.mysql.com/doc/en/Replication_Options.html
relay-log=filename
To specify the location and name that should be used for relay logs. You
can use
Folks,
When I try to start MySQL the mysqld just crashes. I looked at
/usr/lib/mysql/{hostname}.err file and I see the following:
030925 10:01:47 mysqld started
030925 10:01:47 /usr/libexec/mysqld: Can't find file: './mysql/host.frm'
(errno: 13)
030925 10:01:47 mysqld ended
I can not make
On Thu, Sep 25, 2003 at 11:46:49AM -0700, Kevin wrote:
Hello,
I'm doing this some in my application, and was wondering if anyone had
any ideas about the efficiency of cross-database queries:
Select * from db1.poems left join db2.users on poems.mid = users.mid
They're no slower than
Hello,
I am trying to select records from two tables, all the fields in both tables
are varchar's but some of the fields I would like returned as DATETIME
types. I have no problem using the CAST(field as DATETIME) function on one
table, but as soon as I try to union two selects the CAST no
---Original Message-
--From: Joseph Donato [mailto:[EMAIL PROTECTED]
--Sent: Thursday, September 25, 2003 12:12 PM
--To: [EMAIL PROTECTED]
--Subject: mysqld error
--
--Folks,
--
--When I try to start MySQL the mysqld just crashes. I looked at
--/usr/lib/mysql/{hostname}.err file and I
Evenin',
Sorry to send noob questions, I know how annoying they can be, but we need help too ;)
Anyways, Im using a self teach book to teach myself PHP, MySQL and Apache. The book
is getting into MySQL and basic commands. Anyways, they gave an example, and I typed
it in as shown in the
I don't know about the hMailServer, but you may look at dbMail too
(dbmail.org). You can use MySQL or PostgresSQL as the backend. Although
I think it's only for Unix/Linux systems. I've been meaning to try
setting it up on OSX, but haven' gotten around to it yet.
On Thursday, September 25,
Hello all,
We want to use MySQL (InnoDB) for a corporate/non-stop environment, but we
really want/need multiple tablespace support + subqueries.
When will both be available for a production environment? Only in 4.1.x? Any
date?
Thank you!
Eduardo
--
MySQL General Mailing List
For list
I know I have been.
Adam Clauss
[EMAIL PROTECTED]
-Original Message-
From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 25, 2003 12:52 PM
To: [EMAIL PROTECTED]
Subject: Fw: No valid command found
Is everyone on the list receiving the message
Ive been fighting some strange demons and I think they
may be related.
I am trying to benchmark our application by load
testing with various numbers of users and threads. App
is java/jsp and architecture is Tomcat and Mysql.
Platform is Mac jaguar.
First off I had the Too Many Open files error
Charlie Brewer wrote:
http://hostultra.org/brewer/mysql.jpg
'Error 1046: No Database Selected' means just that :-) So you have
to select one -- see http://www.mysql.com/doc/en/USE.html
HTH!
--
Hassan Schroeder - [EMAIL PROTECTED]
Webtuitive Design === (+1)
Error 13 means that the file exista, but mysql has no permissions for
the file.
Make sure mysql is the owner of the data directory and all its
subdirectories and files.
Joseph Donato wrote:
Folks,
When I try to start MySQL the mysqld just crashes. I looked at
/usr/lib/mysql/{hostname}.err
Hello,
When I start mysql, the processlist shows 10 processes:
Ps aux | grep mysql | wc -l
10
But 'mytop' (handy command line utility to see processes) shows only the
number of threads I'm using.
Anyone know why its using 10 processes if it only has 1 thread? I'm not
familiar with how 'ps'
I've installed now mysql-4.0.14 without any problems. So I think it's
something about the .15 version. Does anyone know a thing about it?
With kind regards,
Richard Pijnenburg
-Original Message-
From: Richard Pijnenburg [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 25, 2003
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Thu, 25 Sep 2003, Richard Pijnenburg wrote:
i'm trying to compile mysql-4.0.15a on my server and i'm getting the
folowing error:
gcc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\
-DDATADIR=\/data/mysql\
Hello all,
Has anybody had experience accessing MySQL tables via MyISAM library?
I'm working on an application that has to have both SQL-like and ISAM-like
(file-level) access to the table data. I thought that using MyISAM
directly would be a good idea. If anybody has any better suggestions, I am
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Thu, 25 Sep 2003, Kevin wrote:
When I start mysql, the processlist shows 10 processes:
Ps aux | grep mysql | wc -l
10
On Linux (I assume this is what we're talking about here), threads are
shown as separate processes, too. On other OS'es
Never heard of that one, you might try http://www.dbmail.org
Curtis
On Thu, 25 Sep 2003, Director General: NEFACOMP wrote:
It seems the developpers are no longer doing any work on this server. Their
website is empty: http://www.halvar.com/
Thanks
Emery
- Original Message -
On Thu, Sep 25, 2003 at 01:18:12PM -0700, Kevin wrote:
Hello,
When I start mysql, the processlist shows 10 processes:
Ps aux | grep mysql | wc -l
10
But 'mytop' (handy command line utility to see processes) shows only the
number of threads I'm using.
Anyone know why its using 10
On Thu, Sep 25, 2003 at 04:35:29PM -0300, Eduardo D Piovesam wrote:
Hello all,
We want to use MySQL (InnoDB) for a corporate/non-stop environment, but we
really want/need multiple tablespace support + subqueries.
When will both be available for a production environment? Only in 4.1.x?
Ah apparently this silly book skipped that step. So when I do databases I
get mysql and nuke. And figuring out how to make a new one wasnt very
hard heh. Thanks, plenty more noob questions to come im sure :)
- Original Message -
From: Parker Morse [EMAIL PROTECTED]
To: Charlie Brewer
Hello All,
I am trying to compile udf_example.cc or myfunc.cc (copy of udf_example)
with gcc on Solaris 2.8 but facing following errors
[EMAIL PROTECTED]:/usr/local/mysql-4.0.14/sqlgcc -shared
-I/usr/local/mysql-4.0.14/include -o myfunc.so myfunc.cc
In file included from myfunc.cc:122:
try adding a '\' before the comma like a \n in c++
-Original Message-
From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 25, 2003 10:41 AM
To: Roger Davis; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Ideas on creating connections
Thank you for
First, my apologies. I originally posted this to the
mailing.databases.mysql newsgroup, not realizing that
the newsgroup is just mirror of the mailing list.
I have since figured out the answer to my second
question (I think) - see below. My answer is: The
Primary Key specification creates an
At 12:33 25/9/2003 +0900, Ganbold wrote:
Hi,
I installed mysql-4.0.15 in Windows 2000 Advanced server. Mysql-max-nt is
working fine, except some problems.
Sometimes when I try to use access web pages through php pages, mysql says
Connection to server lost or
Can't connect to mysql server or
Ed,
InnoDB does not support the 'short' syntax:
CREATE TABLE phone (id char(5) not null
REFERENCES person(id),
num char(10) not null, PRIMARY KEY (id, num));
It simply ignores that REFERENCES definition. It is in the TODO list to add
support for that syntax, too. Until then you have to use
Fareeda,
- Original Message -
From: fareeda [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, September 25, 2003 5:32 PM
Subject: Question on rollback segment equivalent
What is the equivalent of rollback segments (from Oracle) on MySQL?
And if something is being
Rob, Spyros,
you can simply copy .frm, .MYI, .MYD, ibdata files, and ib_logfiles between
Windows and Linux. The binary formats on disk are the same.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot
Another way I was thinking about by now is to periodically calculate the
database's size and, if over quota, revoke the user's INSERT, UPDATE rights
and so on.
It's not real-time, too, but maybe a little more friendly since I don't know
how MySQL behaves when running against fs quota writing to a
On Wednesday, September 24, 2003, at 03:25 PM, Oscar (TOMCAT) wrote:
I'm using MySQLcc version 0.9.2-beta... I want to recover more than
1000 rows in a select statement... What is the command to alter this
setting ???
You can always explicitly add the LIMIT clause to change this for your
I have CocoaMySQL running on my G4 Powerbook Mac OS 10.2.6, and I'm using it
with a table imported from a 29MB .csv file. This database is a list of
names and info and I am able to search quickly to look up names and emails
and also able to import .csv files to this table with no trouble.
The
Thanks Miguel.
I increased net_read_timeout and net_write_timout up to 300 sec, but
problem still exists.
My queries are executing only in few seconds, but sometimes mysql shows
Can't connect to server, or Connection lost etc.
I used mysql-4.0.14 server and client, but problem was same and I
Uscript
Some months ago I developed a lightweight middle layer between MySql and the
web. The purpose was experimentation with web programming without the
complexity of a standard middleware layer. I will describe the system to you,
and make the source available if anyone wants to experiment
I'm trying to execute a code with multiple SQL statement over VB 6.0. The
code includes the creation of temporary tables, multiple inserts and one
final select...
It looks like i can only excecut one single SQL statement... does any one
know how to fix that?
I can run the code with out
93 matches
Mail list logo