Title: RE: duplicate records check
Hi Neil,
try something like this
SELECT
FROM
GROUP BY
HAVING COUNT(*) > 1
Mit freundlichen Grüssen
Frank Kalis
Asset Management
ProACTIV___
CiV Versicherungen * PB Versicherungen * PB Pensionsfonds AG
Neustraße
Could any one advise what SQL statement I would need to use, to check a
table for any duplicate records e.g that contain the same data within a
field. Note that I haven't got the field as a unqiue field.
Thanks
Neil
_
Stay in touch
Hi Mixo,
How about adding a second innodb file and set the first one to a fixed size ?
"...If the disk becomes full you may want to add another data file to another
disk, for example. Then you have to look the size of `ibdata1', round the
size downward to the closest multiple of 1024 * 1024 byt
The size is already set to 2000M, and I may be wrong, but the autoextend
feature is not support
in mysql version earlier that 4.
Nils Valentin wrote:
Hi Mixo,
Do you have the autoextend feature enabled for the innodb table ?
It can be set f.e in my.cnf.
Best regards
Nils Valentin
Tokyo/Japan
2
Paul,
I have used the ODBC interface as a rough test to experiment with application
compatibility with MySQL. I would not consider using ODBC at all to load in a
production environment.
I want to develop a loading method that is as fast as possible. If I were to use LOAD
FILE, my application
At 21:36 -0700 7/8/03, cmars wrote:
Hi,
I want to insert massive amounts of data in near real-time into a
MySQL database. The data is in a structured binary format, and I
have code that parses the data into logical data structures.
Right now I can load into a MySQL database via ODBC, but I need
Hi,
I want to insert massive amounts of data in near real-time into a MySQL database. The
data is in a structured binary format, and I have code that parses the data into
logical data structures.
Right now I can load into a MySQL database via ODBC, but I need to improve throughput.
How can I
At 11:23 +0700 7/9/03, Dominicus Donny wrote:
Try analyze your table(s).
What information will this yield to make indexing faster?
"Me fail English? That's unpossible"
###___Archon___###
- Original Message -
From: "electroteque" <[EMAIL PROTECTED]>
To: "Paul DuBois" <[EMAIL PROTECTED]>; "F
Try analyze your table(s).
"Me fail English? That's unpossible"
###___Archon___###
- Original Message -
From: "electroteque" <[EMAIL PROTECTED]>
To: "Paul DuBois" <[EMAIL PROTECTED]>; "Florian Weimer" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, July 09, 2003 10:23 AM
Subject
Hi, all
Who can recommend me a good tools for testing performance under heavy use of
mysql. With large corcurrent queries.
-Ares
--
Nuclear Science & Technology Virtual Research Center
http://nst.pku.edu.cn
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubs
Hi Paul,
2003年 7月 9日 水曜日 11:17、Paul DuBois さんは書きました:
> At 12:31 +0900 7/8/03, Nils Valentin wrote:
> >Hi Koh,
> >
> >Shouldn't the value in the first sample be used like this ?
> >
> >1) SELECT * FROM table1 WHERE field1 = '0x6100620063006400';
> >
> >Correct me if I am wrong.
>
> You're wron
Hi Paul,
A good lesson to learn ;-).
What you are saying actually means that Kevin didnt need to install it again.
I must have missed this part in the manual.
Thank you for pointing this out.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 9日 水曜日 11:14、Paul DuBois さんは書きました:
> At 10:35 +0900 7/
when reimporting or reinserting or whatever from a huge db i usually drop
all the indexes reimport then create them again much quicker
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 1:09 PM
To: Florian Weimer; [EMAIL PROTECTED]
Subject: Re: Fa
At 4:20 -0500 7/7/03, Anthony Scism wrote:
I am relatively new at this, but is there any way to perform the
following:
| obs_date | date | YES | | NULL |
|
| obs_time | time | YES | | NULL |
|
| object | varchar(40) | YES | | NULL
At 9:39 +0200 7/7/03, Florian Weimer wrote:
I've got a table with 100 million rows and need some indexes on it
(one row is 126 bytes).
I'm currently using MyISAM and the indexing proceeds at an
astonishingly low rate: about 200 MB per hour. This is rate is far
too low; if we had to recover the dat
Thanks for the Info Paul
I guess since I'm a newbie and the server's not especially loaded or
anything, I'll just leave it be.. (for the time being)
Thank
Cheers,
Mun Heng, Ow
H/M Engineering
Western Digital M'sia
DID : 03-7870 5168
-Original Message-
From: Paul DuBois [mailto:[EMAIL
At 9:46 +0800 7/7/03, Ow Mun Heng wrote:
Hi,
This may be a stupid question but can I still just ask it?
Why do you want to disable the use of InnoDB tables? If you don't
use it, couldn't the files still be there? It's not like it's a security
risk (or is it?) or that it takes up lots of
At 17:42 -0500 7/6/03, Greg Donald wrote:
> my coulmn (id) is an auto_increment coulmn and lets say that i have 100
entries, so the problem is that when i delete all entries on my table, the
column (id) starts from 101 ,shouldn't is starts from 1 again!
please i need help with this
Use truncate
At 12:58 -0500 7/8/03, azamka wrote:
Hi everyone,
I am trying to create tables with type innodb. I created a database and all
the tables of type ISAM. Now I am at the point of making relations and
establish refrential integrity. For that ofcourse I have to change the tables
in the Innodb type. I d
At 13:11 -0700 7/8/03, Daevid Vincent wrote:
Hmmm. Well you might be able to work some magic if you know the length of
the field it's supposed to be, then you could subtract the length of the
Field and then pad with spaces.
If this is to be displayed in a web page, and I assume you're trying to lin
At 19:58 +0200 7/8/03, Boris Villazon wrote:
Hi
I need to know if is there anyway to clone a existing database
(structure and data)?
If yes, how can I do this? I looking for a SQL command.
There is no single SQL statement to do this. You can use mysqldump
to generate a file containing multiple
I have a table like this (table_gender):
gender_id gender_description
---
0 female
1 male
I also have a table like this (table_post):
post_id post_
Paul,
Your probably right about him running on windows, but I have also seen this
in other situations running linux. In fact, and yes I am almost ashamed to
say, I even set one up this way in my earlier days. It was on a local
network with no internet, and the "users" were on a custom app
At 9:35 -0400 7/8/03, DePhillips, Michael P wrote:
Hey Folks
I'm having a tough time finding any information in the available
documentation about this feature. Does anyone out there have a bit of
insight as to what exactly it does.
Docs says MySQL will store a checksum for each row if this is
Peter
hh is supposed to be a C++ header file
"In some cases hh is a precompiled header"
I would check out your make script or Ant build.xml to see how it's used
Is there an accompanying .h file e.g. sqlplus.h file?
Martin
- Original Message -
From: "Peter Moscatt" <[EMAIL PROTECTED]>
To:
At 12:31 +0900 7/8/03, Nils Valentin wrote:
Hi Koh,
Shouldn't the value in the first sample be used like this ?
1) SELECT * FROM table1 WHERE field1 = '0x6100620063006400';
Correct me if I am wrong.
You're wrong. :-)
0x6100620063006400 is a hex literal, which will be treated as
a string
I'm kinda new to administering MySQL. I have a remote db that I want to
backup to my local MySQL server (windows). I can do a dump of the db
from phpMyAdmin on the remote server. I try running it on my local
server through the MySQL Control Center, and it says "Read Only". I
don't have to enter pas
At 10:35 +0900 7/7/03, Nils Valentin wrote:
2003îN 7åé 7ì åéójì 10:28ÅANils Valentin ÇÇÒÇÕèëÇ´ÇÐǵÇ:
Hi Kevin,
try this:
1) stop the mysql server
2) mysqld_safe --skip-grant-tables
3) mysql -u root
4) mysql> SHOW GRANTS FOR root;
5) GRANT ALL ON *.* TO 'root'@'%';
GRANT ALL ON *.* TO
I have just installed MySQL++ 1.7.9 using the RPMs
from Rpmfind.com.
It installed all Ok. The reason why I installed the
RPM over the source was that I can't get the source to
compile.
When I go and search the drive after the installation
I don't see the 'sqlplus.hh'
I am using Mandrake 9.1.
W
At 8:55 -0700 7/8/03, Michael Iatauro wrote:
I took once moe a sharp look now that you did a reply with another
sample. Actually I was wrong the SQL statement was NOT correct -
you forgot the semicolon in the first exapmple ;-)
To my knowledge, the semicolon is unnecessary when using mysql --ex
At 14:35 -0700 7/8/03, Steve Quezadas wrote:
> have you done any "optimize" to your tables ?
it should help improving the query performance.
it's normal to have memory lower on each day, because your index
files are growing, and takes memory.
if you're not using innodb or bdb, you can try to
At 21:17 -0400 7/8/03, Roger Davis wrote:
localhost does not mean 127.0.0.1 Localhost is the socket to connect to and
has is separate from IP addresses. The % is for IP address access. That is
why there are 2 ways. I would hardly call that redundant.
Roger
That's true on Unix, but if Jim (the o
From: http://www.mysql.com/doc/en/Can_not_connect_to_server.html
"A MySQL client on Unix can connect to the mysqld server in two different
ways: Unix sockets, which connect through a file in the file system (default
`/tmp/mysqld.sock') or TCP/IP, which connects through a port number. Unix
sockets
Roger Davis wrote:
> localhost does not mean 127.0.0.1 Localhost is the socket to connect to and
> has is separate from IP addresses.
Does this mean from the machine's console, or something else?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:h
localhost does not mean 127.0.0.1 Localhost is the socket to connect to and
has is separate from IP addresses. The % is for IP address access. That is
why there are 2 ways. I would hardly call that redundant.
Roger
> -Original Message-
> From: Joel Rees [mailto:[EMAIL PROTECTED]
> Sen
Hi Kalle,
Try
mysqldump databasename -uusername -ppassword > /to/a/directory/dump.sql
NO SPACE between the -p and the password
-Hassan
-Original Message-
From: Kalle Saarinen [mailto:[EMAIL PROTECTED]
Sent: Monday, July 07, 2003 10:06 PM
To: MySQL
Subject: mysqldump
Hello
I'm tryin
did you try the --skip-networking option?
This option still allows local connections, so, not sure if it serves your purpose
though...
HTH,
SB
-Original Message-
From: Rudy Metzger [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003 10:08 AM
To: [EMAIL PROTECTED]
Subject: backup / s
> Not sure where these came from, but in my users I've got a [EMAIL PROTECTED] and a
> [EMAIL PROTECTED] Is this redundant, or is there a reason for this?
Well, some people might say it's redundant, but it _is_ by design --
http://www.mysql.com/doc/en/Privileges.html
> ...
--
Joel Rees, p
Joe Celko's SQL for Smarties: Advanced SQL Programming
By Joe Celko
-Original Message-
From: David Thompson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 4:21 AM
To: 'MySQL Mailing List'
Subject: Good Database Philosophy Book?
Looking for a book to help me develop a philosophy
At 18:36 08-07-2003 -0400, Larry R. Sieting wrote:
Hi,
When I delete both my.cnf from the root (C:\) directory and my.ini from
windows (C:\WINDOWS), Mysql will restart as sson as I log in to
WinMysqlAdmin. I dont want to use that program...
Anyway... any suggestions?
Go to start menu -> open a
Looking for a book to help me develop a philosophy for building
databases (particularly on MySQL). And then taking them from concept to
construction.
Something like Start by asking which queries you will be performing,
then define all data needed for each of those queries, then progress to
nor
Hi Mixo,
Do you have the autoextend feature enabled for the innodb table ?
It can be set f.e in my.cnf.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 8日 火曜日 22:45、mixo さんは書きました:
> How can I avoid this:
>
> DBD::mysql::st execute failed: The table 'Transactions' is full at
> /usr/lib/perl
2003年 7月 9日 水曜日 00:55、Michael Iatauro さんは書きました:
> > I took once moe a sharp look now that you did a reply with another
> > sample. Actually I was wrong the SQL statement was NOT correct - you
> > forgot the semicolon in the first exapmple ;-)
>
> To my knowledge, the semicolon is unnecessary when u
Not sure where these came from, but in my users I've got a [EMAIL PROTECTED] and a
[EMAIL PROTECTED] Is this redundant, or is there a reason for this? The original
MySQL
install was done by an application we're running, but we've since added
additional databases.
thanks,
Jim
--
MySQL General
This question came up at work today, would like to get some fellow developer's
opinions:
Scenario 1: 2 tables to track checks
in terms of HD space a separate table would have been smaller since the checks table
grows at 1000+ per week, but there would only be a handful of returned checks. In
t
Hi Rudy,
How about changing the port number in my.cnf and restarting the server ?
All clients will look on the wrong port number and not be able to connect.
That should do it while you take your backup.
When finished change the port number back to 3306.
Best regards
Nils Valentin
Tokyo/Japan
Hello,
I have been reading this list for about a month or so, and have picked up
some good information.
I have this little nagging problem with the install on my machine.
I am running an XP box with Apache 1.3.27, PHP 4.3.2 and MySql
4.0.13. This is a dev machine I use all the time.
Now, whe
> I don't know anything about MySQLDriverCS but if you continue to have
> problems, you might try my provider at www.bytefx.com
Reggie,
You've ended a week's worth of frustration for me! Thanks a million! You've
got a great product, even if it's not a release version yet!
FYI, I only had to chan
> have you done any "optimize" to your tables ?
> it should help improving the query performance.
>
> it's normal to have memory lower on each day, because your index files are growing,
> and takes memory.
> if you're not using innodb or bdb, you can try to run "flush threads" and "flush
> table
Hi,
Your solution converts the binary field to a string and then compares two
strings. You should get rid of any conversion problems by comparing the
values as binary data:
SELECT * FROM table1 WHERE field1 = BINARY 0x6100620063006400;
--
Mikko Noromaa ([EMAIL PROTECTED])
- SQL in Excel, ch
I am working on mysqld-max. I have created the my.cnf file yet. The manual
does not have clear instructions on that. Can you help me in making mysqld-max
to work?? I mean can u explain me the procedure if possible.
Appreciate it
thank U
Kamran
>= Original Message From "Subhakar Burri" <
> I need to know if is there anyway to clone a existing database (structure and
> data)?
I use mysqlhotcopy myself.
http://www.mysql.com/doc/en/mysqlhotcopy.html
--
Greg Donald
http://destiney.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
On Tue, Jul 08, 2003 at 12:49:54PM -0700, Christian Nelson wrote:
>
> Greetings...
>
> We're eagerly awaiting 4.0.14 since it fixes the SET FOREIGN_KEY_CHECKS
> bug.
>
> http://www.mysql.com/doc/en/InnoDB_news-4.0.14.html says it should be
> released in June... it's now July 8th.
>
> When can w
Christian,
- Original Message -
From: "Christian Nelson" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, July 08, 2003 10:51 PM
Subject: 4.0.14 Date?
>
> Greetings...
>
> We're eagerly awaiting 4.0.14 since it fixes the SET FOREIGN_KEY_CHECKS
> bug.
>
> http://www.
There'z no InnoDB mode for a database, it's only for tables and you can create InnoDB
tables in any database as long as it supports InnoDB features. Do you have mysqld-max
running?
HTH,
SB
-Original Message-
From: azamka [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003 11:38 AM
To
I have a shopping cart which creates temporary tables in the format of
zorder_;
These tables are used to hold a customers order while they shop and
after checking out, it is dropped. The values of the shopping cart are
put together in an HTML table and stored as their history.
What I want to
Avoid NAS... that's like dealing with mysql via NFS ...
Internal raid depending on controller type and disk configuration could be
faster than an external SAN... But chances are external SAN has alot more
scalability as far as adding more controller, cabinets and disks...
If it was my choice and
You're using Windows, so I can't make any promises because this is what
I'd do under *nix, but when I first set up mySQL if I type:
# mysql -h localhost -p
The password will be denied, because no password is needed. So I'd
type:
# mysql -h localhost
And get in. This is under the /root/, and I
Can not make mysql connection -
error log:
030708 08:53:48 mysqld started
030708 8:53:49 InnoDB: Operating system error number 13 in a file
operation.
InnoDB: See http://www.innodb.com/ibman.html for installation help.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: t
Hmmm. Well you might be able to work some magic if you know the length of
the field it's supposed to be, then you could subtract the length of the
Field and then pad with spaces.
If this is to be displayed in a web page, and I assume you're trying to line
things up pretty, just put them in table
Greetings...
We're eagerly awaiting 4.0.14 since it fixes the SET FOREIGN_KEY_CHECKS
bug.
http://www.mysql.com/doc/en/InnoDB_news-4.0.14.html says it should be
released in June... it's now July 8th.
When can we expect 4.0.14 to be released?
Thanks in advance...
Christian
-
If there's a FAQ I'm missing, please point me to it.
v 4.0.13-NT
I'm a C++ programmer trying to learn Java and JDBC (Java Database
Connectivity). Obviously I need a database to bounce off in order to do
that. Enter MySQL.
I am going in through the command line shell. I am unable to do much
Yeah I though about that too. But i am not able to find the command for
creating a database in an innodb mode.?? DOu have an idea about it Grant??.
thank u
kamran
>= Original Message From "Quinlan, Grant" <[EMAIL PROTECTED]> =
>I am a newbie myself, so please someone correct me if I a
couldn't you dump the database and then use the backup to reload the
database?
-dan
On Tue, 2003-07-08 at 13:58, Boris Villazon wrote:
> Hi
>
> I need to know if is there anyway to clone a existing database (structure and data)?
>
> If yes, how can I do this? I looking for a SQL command.
>
>
I am a newbie myself, so please someone correct me if I am wrong, but here
is how I understand it:
A MySQL installation can support several databases. The system tables are
always in a system database that uses tables of type ISAM. You create
another database of type InnoDB, in which you keep your
> Hi,
>
> can someone explain me the avantage of using date and time, and also can
> i set time + XX minutes??
>
> Thanx
> Anthony
Short answer is: You can use the date and time functions and formats.
There is one or just use '+' or '-' See chapter 6 in the ref. manual.
If you need both date and
Hi,
can someone explain me the avantage of using date and time, and also can i set time +
XX minutes??
Thanx
Anthony
Hi everyone,
I am trying to create tables with type innodb. I created a database and all
the tables of type ISAM. Now I am at the point of making relations and
establish refrential integrity. For that ofcourse I have to change the tables
in the Innodb type. I did that with the commad "alter tab
Hi
I need to know if is there anyway to clone a existing database (structure and data)?
If yes, how can I do this? I looking for a SQL command.
Thanks in advance and best regards
Boris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://li
Subhakar,
it is a bug which was fixed in 3.23.57:
http://www.mysql.com/doc/en/News-3.23.57.html
"
D.4.2 Changes in release 3.23.57 (06 Jun 2003)
...
SHOW VARIABLES LIKE 'innodb_data_file_path' displayed only the name of the
first datafile (bug #468).
...
"
Regards,
Heikki
...
I wonder if you could make a backup of your original users table, then make one
of JUST your super user... Then when you go to do your back up you would copy
your table with JUST your super user in there and go to work... After you are
done with the backup copy your old table back and restart mysql
Trevor Sather wrote:
> Hello
>
> The following query used to work when I was using an Access database,
> but now that I've moved to MySQL I get a syntax error when I try and
> run it:
>
> SELECT *, (SELECT COUNT (*)
> FROM Links
> WHERE Links.CAT_ID = Categories.CAT_ID AND LINK_APPROVED = 'Yes'
Dear all,
Is there a way to start mysqld in a way, that say only a superuser can
connect. I would need this e.g. for restoring a backup, because I do not
want users to connect to the server while I restore the binary log.
I already check the options for mysqld but could not find anything
(e
Hi, sorry to keep this thread going ...
I'm sending you the output of my results ... I don't see the autoextend string in my
output. I'm using 3.23.56
I have the following entry in my .cnf file:
innodb_data_file_path=innodb_data01:5M;innodb_data02:5M:autoextend:max:10M
And the output of my vari
Does the mysql user have write permissions on the files?
HA. Mooduto wrote:
dear all,
what is the problem sql error : 1036 ...table is read only.
please help me..
thank's...
--
This mail sent through PSP: http://www.polinpdg.ac.id/
--
MySQ
Hi,
I am a newbie
I want to create a temporary table and I get the following error
message :
mysql> CREATE TEMPORARY TABLE tempemp AS SELECT * FROM emp;
ERROR 1044: Access denied for user: '@localhost' to database 'test1'
Any help would be appreciated
Didier
I work for a small (but very fast-growing) company, and we're about to
start deploying our new website. Because it has a "live inventory"
setup, and because our internal tools are so integrated with the
ecommerce side of things, I figure that replication is the best tool for
us - we'd have a fast
dear all,
what is the problem sql error : 1036 ...table is read only.
please help me..
thank's...
--
This mail sent through PSP: http://www.polinpdg.ac.id/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsu
I took once moe a sharp look now that you did a reply with another sample.
Actually I was wrong the SQL statement was NOT correct - you forgot the
semicolon in the first exapmple ;-)
To my knowledge, the semicolon is unnecessary when using mysql --execute.
~Michael Iatauro
--
MySQL General Ma
All;
Does anyone know of a more secure way than storing the username and password
to the database connection within the odbc.ini ? We are using PHP on one
server connecting to a MySQL 4.0 database ?
Thanks
Well, I would avoid NAS as it introduces unwanted overhead when
accessing the data. As for SAN versus the internal RAID5, I am not sure,
I would say benchmark the two and see which comes out better, or wait to
see if there is anyone out there that has dealt with both.
Regards,
Mike Hillyer
www.vbm
Hello
The following query used to work when I was using an Access database, but
now that I've moved to MySQL I get a syntax error when I try and run it:
SELECT *, (SELECT COUNT (*)
FROM Links
WHERE Links.CAT_ID = Categories.CAT_ID AND LINK_APPROVED = 'Yes') AS
LINK_COUNT FROM Categories
ORDER B
I've done a lot of stuff to try to get mySQL to work. I'm running Mac
OS 10.2.6 and Apache webserver.
First, I installed mySQL. No problems there. However, not knowing how
everything worked, I used PHPmyAdmin to delete the root user. Yes, I
know, stupid. Then, realizing my error with the h
Hello All,
I am trying to decide which storage I should use for the "Data Directory".
My application has lots of 'SELECT's (80%) and fewer
UPDATEs/INSERTs(20 %).
I have the following choices of Data storage
1) Xiotech SAN (66 Mhz FCAL)
2) NAS
3) Internal SCSI 3 RAID 5
Will I achieve any better
Hello. Thought I¹d pass this along to whoever cares.
Issue:
error running the mysql-test-run as logged
> Installing Test Databases
> Removing Stale Files
> Installing Master Databases
> mysqld is missing - looked in ../bin
> Error: Could not install master test DBs
Any suggestions?
Details:
I
"Kevin H. Phillips" <[EMAIL PROTECTED]> wrote:
> Hi, Nils
> I was able to stop the mysqld daemon using the kill command. However,
> when I tried to start it using mysqld_safe --skip-grant-tables, a line
> would appear saying:
> [EMAIL PROTECTED] root]# mysqld_safe --skip-grant-tables
> Starting
"awarsd" <[EMAIL PROTECTED]> wrote:
>
> I tried to look everywhere @ mysql.com but i couldn't my question is
> how many records can a table handle so it stays fairly fast?
> What is the maximum records it can handle??
Up to 4 billion rows.
--
For technical support contracts, goto https://order
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 08, 2003 7:58 PM
Subject: Re: Replication stops for no reason...
> "Jeff McKeon" <[EMAIL PROTECTED]> wrote:
> > I've seen one other reference to this exact situation but it didn't have
How can I avoid this:
DBD::mysql::st execute failed: The table 'Transactions' is full at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm
The table type is InnoDB.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql
Hey Folks
I'm having a tough time finding any information in the available
documentation about this feature. Does anyone out there have a bit of
insight as to what exactly it does.
Docs says MySQL will store a checksum for each row if this is 'on' - that's
about all I can find.
Some
"Jeff McKeon" <[EMAIL PROTECTED]> wrote:
> I've seen one other reference to this exact situation but it didn't have
> a resolution. What I've done is created a script that runs every 10
> minutes via cron and checks a value from both databases and if it's not
> equal then it issues a "slave stop"
I've seen one other reference to this exact situation but it didn't have
a resolution. What I've done is created a script that runs every 10
minutes via cron and checks a value from both databases and if it's not
equal then it issues a "slave stop" and "slave start" command on the
slave machine.
Hi Loren,
Thanks for quick response. The previous application
is written by me in ANSI C using mysql API. I'd love to write it in Java if
it was first time:)
Do you have any suggestion related to MySQL C API?
Ganbold
At 02:28 AM 7/8/2003 -0700, you wrote:
I'm not sure if there are formal resour
I'm not sure if there are formal resources on this topic, but here are some basic
guidelines I have followed in the past:
1) You can imagine that each running thread will have its own MySQL connection.
2) The connection can get created and held for the lifetime of a thread, or, if you
plan to have
Hi,
We use MySQL 4.0.13, Redhat 7.3(kernel 2.4.18.3). Apache 1.3.27
Mysql is alive and there are process but I don't see in ps (process
table) and very slow web receive.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.co
Note that trailing spaces are not removed when you insert data into a TEXT
(or BLOB for that matter) column. This may be of use to you, but TEXT does
have limitations.
Andy
> -Original Message-
> From: Egor Egorov [mailto:[EMAIL PROTECTED]
> Sent: 08 July 2003 09:31
> To: [EMAIL PROTECTE
"Pedro X Gomes-Fabre" <[EMAIL PROTECTED]> wrote:
>
> Can I link two fields in two tables, in the way that if I add a new value
> into a table in the other table the value is added automatically,
No.
> or Do I need to add the values one time for every table?
Yes.
--
For technical support con
Mark Depenbrock <[EMAIL PROTECTED]> wrote:
> I have installed a Mac OS X 'PKG' binary package on my OS version
> 10.2.6 Mac.
>
> I have been instructed that after the installation I can start up MySQL
> by running the following command lines:
>
> [Computer:/usr/local/mysql] mark% sudo ./bin/mys
Hi Jeff,
We had similar problems caused by replication crossing a
firewall with a 5 minute timeout on its access control list.
If the replication stream went idle for 5 minutes, the firewall
would drop the connection and MySQL wouldn't notice.
Our workaround was to run a daemon on the master to
Mixo,
you have to add another InnoDB data file. Also adjust other InnoDB
parameters in my.cnf to get a good performance.
http://www.innodb.com/ibman.html#InnoDB_start
"
An advanced my.cnf example. Suppose you have a Linux computer with 2 GB RAM
and three 60 GB hard disks (at directory paths `/',
1 - 100 of 105 matches
Mail list logo
