Re: I need 50.000 inserts / second

On Fri, May 31, 2002 at 01:56:12PM -0500, Dan Nelson wrote: > In the last episode (May 31), Mark said: > > Cesar, you really should consider using placeholders and bind_param > > (if available). Without using placeholders, the insert statement will > > contain the literal values to be inserted and

Re: Query Problem

[EMAIL PROTECTED] ("Daren Cotter") wrote: >I am having major troubles creating this query...ok here's some >background info: > >I have three tables: members, which contains info about the member, such >as city, state, zip, marital status, etc; interests, which stores just >an interest_id and name

Setting Auto Increment

Hi All Is it that i can make a column auto increment only if its data type is integer. Can i not set auto increment value for a numeric datatype -Arul sql,query - Before posting, please check: http://www.mysql.com/manua

Re: Mysql newbie show table question

Hrm. Closest I can think of is EXPLAIN SELECT * FROM demo WHERE name LIKE 'user_access'; I think this is what you mean. Adam Hooper [EMAIL PROTECTED] On Fri, 31 May 2002 08:44:49 -0700 marc malacarme <[EMAIL PROTECTED]> wrote: > I can¹t seem to make any of the describe or show queries work wh

Query Help (more)

As a follow up to my previous question, two possible solutions came to mind: 1) Query members table for all members matching criteria stored in that table (country, marital status, income, etc). Then, take all those member_ids, and query member_interests table for members who match there. i.e., S

Query Problem

I am having major troubles creating this query...ok here's some background info: I have three tables: members, which contains info about the member, such as city, state, zip, marital status, etc; interests, which stores just an interest_id and name; and member_interests, which stores just member_

Re: Column names that contain %

In the last episode (May 31), David Adam said: > I have a table that includes numerous column names of the form > '%_Dry_Weight' -- that is, they start with a > percent sign. I am unable to query these columns, as mysql returns a > "you have an error in your SQL syntax' > message. When I try to

Re: Finding holes in autoinc sequences

Genius. I knew there must be a way of tricking Mysql into applying a having statement and hence doing the whole query in a non join based statement. I have found the variable features of mysql most useful for a query of the type, select the top x rows per group. i.e. a limit per group. This is per

mysqldump -A >dump.txt

Hi, How do I deal with the import of this file? Every example I see involves a dump of a single database, or else uses a command line like my subject, but with no corresponding mysqlimport. If I use mysql http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the l

Column names that contain %

I have a table that includes numerous column names of the form '%_Dry_Weight' -- that is, they start with a percent sign. I am unable to query these columns, as mysql returns a "you have an error in your SQL syntax' message. When I try to escape the % character with a backslash, the error persis

ncurses argument.

hi, I am installing mysql3.23.49. For that, I just installed ncurse In the ./configure --help, I found this switch --with-named-curses-libs=ARG what should I put inc the ARG when I do ./configure? Thanks, Wei - Before post

(newbieish)How do you query by indax?

Hi, I'm trying to make a query to my database based upon an index. Eg. we have last name,first name, eyecolour,age we search for all the records with the last name starting with 'smi' and I'm browsing forward through the records using mysql_use_result I get halfway through the last name 'smith' an

Re: InnoDB Delete On Cascade

Hi! Please check that you are using >= 3.23.50. I tested this on Win NT-4.0 with 3.23.52, and it worked: mysql> CREATE TABLE parent(id INT NOT NULL, -> PRIMARY KEY (id)) TYPE=INNODB; Query OK, 0 rows affected (0.14 sec) mysql> CREATE TABLE child(id INT, parent_id INT,

Re: Constraints - Error or Bug????

Frank, please check with SHOW TABLE STATUS that the tables really are InnoDB type. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Original Message

Re: HELP: MySQL Dynamic Structure

> MySQL alone cannot represent a complex data-structure. > not true at all, it's just not object oriented but don't you know that there is still no good (consistent and "complete") theoretical model for OO-DBMS. Relational Model _has_ good underlying theory and I think this is the main

Re: my.cnf necessity

In the last episode (May 31), [EMAIL PROTECTED] said: > > I currently am a MySQL dba and am having issues from a security/linux > administrator that doesn't want me to have access to the /etc/my.cnf. > What can't I do with local database .cnf files that I can only do with > my.cnf? There are no

my.cnf necessity

I currently am a MySQL dba and am having issues from a security/linux administrator that doesn't want me to have access to the /etc/my.cnf. What can't I do with local database .cnf files that I can only do with my.cnf? Any ideas? I have looked at the documentation and it doesn't really say wha

Re: Constraints - Error or Bug???? - Part II

MySQL wrote: >Hi all, > >It seems that some is misunderstanding my problem, so i try to re-write my problem >again. > > >I just wonder. I have tried this example from www.mysql.org Doc. > >CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB; >CREATE TABLE child(id INT, parent_id

Re: incorrect column specifier

On 31 May 2002, at 11:56, T. Dahms wrote: > This line -> > building_idx decimal(8,0) unsigned zerofill DEFAULT '' not > null auto_increment <-is in a supplied perl script and causes the > error message. An AUTO_INCREMENT column has to be an integer (see http://www.mysql.com/doc/C/R/CREA

Re: Where can I get help?

Hi. On Fri, May 31, 2002 at 11:39:12AM -0500, [EMAIL PROTECTED] wrote: > Does anyone know where I can get help writing an MySQL update statement that > contains a join in the where clause? Multi-table updates are not supported (yet) by MySQL. You have to construct the updates on the application

Re: innodb rollbacks

Jeremy, - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, May 30, 2002 8:43 PM Subject: Re: innodb rollbacks > On Thu, May 30, 2002 at 12:16:28PM +0300, Heikki Tuuri wrote: > > > > However, if t

Re: MS Access Queries

Hi. On Fri, May 31, 2002 at 01:26:34PM -0400, [EMAIL PROTECTED] wrote: > Hey guys, > i'm still doing this web ODBC thing, and i was wondering since, all the > wqueries i'm going to use are in a database, is there a way (using > php/mysql/odbc) to access and call on those queries without typing t

Re: incorrect column specifier

Hi. I am not sure, but I guess that AUTO_INCREMENT is not allowed for DECIMAL. Bye, Benjamin. On Fri, May 31, 2002 at 11:56:36AM -0500, [EMAIL PROTECTED] wrote: > I'm getting an error ->incorrect column specifier > using MySQL 3.23.37 on SuSe 7.2 > This line -> > building_idx decimal(

Re: Trying to find source Tarball for 4.0.2

Hi. As 4.0.2 is not released yet, there is not tarball of it. Bitkeeper is the only method to retrieve a version of the current 4.0.2 tree. You do not have to have much experience with Bitkeeper to get a working tree. A step by step explaination can be found in the manual: http://www.mysql.com/

Constraints - Error or Bug???? - Part II

Hi all, It seems that some is misunderstanding my problem, so i try to re-write my problem again. I just wonder. I have tried this example from www.mysql.org Doc. CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB; CREATE TABLE child(id INT, parent_id INT, INDEX par_ind (pare

Re: I need 50.000 inserts / second

Hi Jeremy, I've done some tests grouping the INSERTs in groups of 1000 and 1, and it got very faster, in my Pentium III 700 from job I could get less than 3s. But I'm still doing concatenation to get the INSERT clause in the form "values (x,x), (x,x) ...". Is there a way to make a template q

RE: SSH & Replication

Melvyn Sopacua wrote: - >Does MySQL have any facility for using SSH to tunnel ports for use in >replication? Has anyone implemented anything like this? >We can't just assume if we create an SSH tunnel manually that the >connection will stay up. There was an excellent piece in

Re: I need 50.000 inserts / second

In the last episode (May 31), Mark said: > Cesar, you really should consider using placeholders and bind_param > (if available). Without using placeholders, the insert statement will > contain the literal values to be inserted and has to be re-prepared > and re-executed for each row. With placehol

Re: I need 50.000 inserts / second

- Original Message - From: "Benjamin Pflugmann" <[EMAIL PROTECTED]> To: "Mark" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, May 31, 2002 8:42 PM Subject: Re: I need 50.000 inserts / second > The general idea is correct, but note that MySQL does not support > this (yet)... Re

Re: I need 50.000 inserts / second

Hi. On Fri, May 31, 2002 at 03:24:52PM +0200, [EMAIL PROTECTED] wrote: > Cesar, you really should consider using placeholders and bind_param (if > available). Without using placeholders, the insert statement will contain > the literal values to be inserted and has to be re-prepared and re-execute

Re: Trying to find source Tarball for 4.0.2

On Fri, May 31, 2002 at 06:06:02PM +0300, Nikolaos Georgiafentis wrote: > SO if anybody could point me a place where i can download the whole > 4.0.2 code in .tgz format it will be a HUGE help for me. Follow the instructions here: http://www.mysql.com/doc/I/n/Installing_source_tree.html Jere

Re: Re[2]: [BUG] Excess Privileges required for SELECT INTO OUTFILE

Hello. On Fri, May 31, 2002 at 02:08:57AM +0100, [EMAIL PROTECTED] wrote: [...] > BP> So you may consider upgrading and check if you find the problems > BP> still reproducable. [...] > I generally only update on a needs basis, most notably for security, > as I like to keep things stable and conse

Re: HELP: MySQL Dynamic Structure

Most of what you desire has already been done in products called FileMaker (Apple Computer) and Access (Microsoft). It's been a while since I used Access, but FileMaker will automatically change all references to a field/column if you change the field name. It will warn you of broken references if

Re: Constraints - Error or Bug????

Dear friend, Take a look,carefully, about how are create tables; All fields are INTeger type.Do a "select * from child;" to see what values are stored in tablesfor your curiosity. Good luck, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail ad

Where can I get help?

Does anyone know where I can get help writing an MySQL update statement that contains a join in the where clause? Thank you. All the best, Joe Joseph W. Cherner, President SmokeFree Educational Services, Inc. http://www.smokefree.org "Never doubt that a small group of thoughtful citizens can

MS Access Queries

Hey guys, i'm still doing this web ODBC thing, and i was wondering since, all the wqueries i'm going to use are in a database, is there a way (using php/mysql/odbc) to access and call on those queries without typing them over in my php script? So basically i just want to connect to queries.mdb ac

RE: Finding holes in autoinc sequences

Richard, Say, that's really good! I'm still not used to taking advantage of those variables. Clever. Also, I think you can remove all but the rows showing gaps by adding a group by and having clause... select id,@b:=IF(id=@a+1,id,concat(@a+1,"..",id-1)) range,@a:=id, @flag:=IF(@b=id,id,"MISSING

incorrect column specifier

I'm getting an error ->incorrect column specifier using MySQL 3.23.37 on SuSe 7.2 This line -> building_idx decimal(8,0) unsigned zerofill DEFAULT '' not null auto_increment <-is in a supplied perl script and causes the error message. I acknowledge this is just one line from a fairly long

Installation process

Hello! I am a newbie, to group and MySQL. I just downloaded MySQL for win 2000. The zip file, when opened and clicked on install, it created c:\mysql directory and did the install. Now what next? DOnt I have to start the server? How do I create instances? How do I get into the dbadmin to m

Constraints - Error or Bug????

Hi all, I just wonder. I have tried this example from www.mysql.org Doc. CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB; CREATE TABLE child(id INT, parent_id INT, INDEX par_ind (parent_id), FOREIGN KEY (parent_id) REFERENCES parent(id) ON DELETE SE

Re: I need 50.000 inserts / second

If HEAP table won't do because of memory constraints, why not use straight flat files like typical Unix or Web logs? Start a new file at set intervals, whether it be time intervals or "record" intervals. Then you can use the LOAD DATA command to load the files. Your situation seems similar to that

Re: SSH & Replication

Hi Mark, At 11:14 5/31/2002 -0400, [EMAIL PROTECTED] wrote: >Does MySQL have any facility for using SSH to tunnel ports for use in >replication? Has anyone implemented anything like this? >We can't just assume if we create an SSH tunnel manually that the >connection will stay up. There was an e

Re: Multiple Queries

You can create another frame that's "invisible" by having a zero height or width. This can be your page that does all the queries and refreshes. You can then use the javascript command document.write() to update the other frames without having to hit the server again. Or, retrieve the data in the

RE: HELP: MySQL Dynamic Structure (long)

[snip a lot...] MySQL alone cannot represent a complex data-structure. [/snip] Incorrect, and if it IS the case (from your POV) then no RDBMS can represent a complex data structure. [snip] Re-modeling of MySQL data is required in Perl, PHP, Java, etc. In each language - I have had to re-model th

smaller mysql docs?

is there a place to get the manual that is split a bit more then the current manual_split. these are the 2 pages i end up reading the most even though its usually for just the grant, create, insert syntax (human in need of memory upgrade) 416k Sep 26 2001 manual_MySQL_Database_Administration

Compiling On Tru64

I'm compiling on Tru64 ver 5.1 using GNU 3.1 and make 3.79. I am receiving the following error: Any help will be appreciated. Dean inition In file included from ../include/my_sys.h:35, from mysys_priv.h:19, from my_pthread.c:20: ../include/my_pthread.h:307:

Error in mysqldump -X

Here is what happens: C:\mysql\bin>mysqldump -X database01 1 first C:\mysql\bin> Notice this line: first It consists of two opening tags with no closing tags (the second should instead be ) :) Gavin

Mysql newbie show table question

I can¹t seem to make any of the describe or show queries work when I apply a search statement: Query=show table status from demo; Works fine. Now I¹m trying to get info from only one table: Query=show table status from demo where name like "user_access"; Does no work. Thank You

Mysql newbie show table question

I can¹t seem to make any of the describe or show queries work when I apply a search statement: Query=show table status from demo; Works fine. Now I¹m trying to get info from only one table: Query=show table status from demo where name like "user_access"; Does no work. Thank You

Re: Alternative to decode() in Oracle

Thanx Lewis..It worked - Original Message - From: "Neville Lewis" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Friday, May 31, 2002 12:34 PM Subject: RE: Alternative to decode() in Oracle > Have a look below: > -- > > If expr1 is TRUE (expr1 <> 0 and expr1

Re: HELP: MySQL Dynamic Structure

On Fri, May 31, 2002 at 10:01:34AM -0500, Ryan Hatch wrote: > - > THE PROBLEM: > - > MySQL alone cannot represent a complex data-structure. > > Re-modeling of MySQL data is required in

SSH & Replication

Does MySQL have any facility for using SSH to tunnel ports for use in replication? Has anyone implemented anything like this? We can't just assume if we create an SSH tunnel manually that the connection will stay up. Thanks, Mark R. Andrachek, Jr. Analyst I Federal Reserve Bank of Richmond [EM

RE: Trying to find source Tarball for 4.0.2

I've been trying to find it too. Haven't had any luck yet... --Walt Weaver Bozeman, Montana -Original Message- From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 9:06 AM To: [EMAIL PROTECTED] Subject: Trying to find source Tarball for 4.0.2 Dear List,

Re: SSL

On Fri, 2002-05-31 at 17:52, Marcel wrote: > Hi all, > > > How is the best tool for acess Mysql By SSL protocol ? What do you need to do? MySQL C API has all neccessary stuff to use SSL and mysql command line tool can use it from 4.0.x versions. Tònu ---

RE: Using Joins

* Arul > Is it possible that i can use 3 tables in a Join Query.. > Assuming that i have 3 tables Sure! > artist table contains artistid , artistname > cd table contains cdid,artistid , Filmname > artistaddress table contains artistid , City , phone no [...] > If i execute this query i get only

Trying to find source Tarball for 4.0.2

Dear List, since i am working on a project that uses extensively "full text search" i have to find a source distribution of 4.0.2 source code which has some very important features and bug fixes respect to 4.0.1 and try to compile it with different charset e.t.c. Unfortunately i don't have any

HELP: MySQL Dynamic Structure

Hello all... please read I've struggled with this for YEARS - THE PROBLEM: - MySQL alone cannot represent a complex data-structure. Re-modeling of MySQL data is required in Perl, PH

RE: newbie question

[snip] > The readme file says "... Analysis of data is conducted at Coast > Guard Headquarters using a 4GL Relational Database Management System." > [/snip] > > "Which" 4GL Relational Database Management System? It may use a proprietary > file type for which you may have to have that database's en

RE: newbie question

Which 4GL Relational Database Management System are they talking about? --Walt Weaver Bozeman, Montana -Original Message- From: Phil Reardon [mailto:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 7:57 AM To: [EMAIL PROTECTED] Subject: newbie question I have data on CD ROM for the Mari

SSL

Hi all, How is the best tool for acess Mysql By SSL protocol ? --- Marcel P. Tardelli DBA - DBLive Corp. [EMAIL PROTECTED] - Before posting, please check: http://www.mysq

Using Row Id

Hi All How do i use RowId 's in MYSQL.. Can anyone throw some light on it Regards, -Arul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

RE: newbie question

[snip] The readme file says "... Analysis of data is conducted at Coast Guard Headquarters using a 4GL Relational Database Management System." [/snip] "Which" 4GL Relational Database Management System? It may use a proprietary file type for which you may have to have that database's engine to exp

newbie question

I have data on CD ROM for the Marine Casualty and Pollution Database, comprised of fourty data tables, a data dictionary and a readme file. I would like to access the data using mysql, which I have on my Mandrake 8.1 linux box. The readme file says "... Analysis of data is conducted at Coast

Re: I need 50.000 inserts / second

On Fri, 2002-05-31 at 20:54, Cesar Mello - Axi wrote: > Hello, > > >You could maybe buffer the data in Your application > >and then run inserts later... like this. > > This is not a solution for me as the data acquisition can take hours without > any break. Whatever you do, with any SQL you get

Re: Can't start server : Bind on unix socket ?

Chris, Friday, May 31, 2002, 4:51:37 AM, you wrote: CG> Somewhat new to the list (and very new to mySQL), so thanks for you help CG> in advance. I installed RedHat 7.1 (Seawolf) on a PC, and it came with CG> mysql 3.23.36. I logged in as a regular admin user and typed mysql to CG> get started..

Re: index not hit ?

kmlau, Friday, May 31, 2002, 1:18:26 PM, you wrote: k> show index from gwarp; k> mysql> k> +---+++--+-+---+ k> -+--++-+ k> -> | Table | Non_unique | Key_name | Seq_in_index | Column_name | k> Co

Re: displaying errors in

Charles, Friday, May 31, 2002, 10:55:20 AM, you wrote: CS> I've seen this question asked before, but I'm hoping maybe this is now CS> possible. CS> When one does a "LOAD DATA INFILE..." or similar and get a result CS> like this: CS> Query OK, 428 rows affected (4.30 sec) CS> Records: 428 Delet

Using Joins

Hi All Is it possible that i can use 3 tables in a Join Query.. Assuming that i have 3 tables artist table contains artistid , artistname cd table contains cdid,artistid , Filmname artistaddress table contains artistid , City , phone no here artist acts as a Master table and cd and artistaddres

Re: replication problem

More than likely you have missed the step that the slave database has to be the exact one that the master has before the start of the binlog. Shutdown both servers, grab a copy of the master's data directory and tar that up, move that to the slave, delete the slave's current data directory, now u

Re: I need 50.000 inserts / second

Cesar, you really should consider using placeholders and bind_param (if available). Without using placeholders, the insert statement will contain the literal values to be inserted and has to be re-prepared and re-executed for each row. With placeholders, the insert statement only needs to be prepa

INSTALLATION HELP, PLEASE!!

im missing the mysql and mysqladmin binaries after my admin guy installed the most recent stable mysql rpm on a (linux) machine. are these included in the "client" rpm that he may have missed or is there something "new" that i missed? Luke ---

Re: I need 50.000 inserts / second

Hello, >You could maybe buffer the data in Your application >and then run inserts later... like this. This is not a solution for me as the data acquisition can take hours without any break. >I might be missunderstanding You since I don't get this together... > You wrote: > The following C++

how to deinstall old mysql version?

Hi there, I am just trying to configure my root server. The provider has preinstalled mysql on suse72. So I did try to get rid of this installation with yast, but this did not work out. After compiling php,apache and mysql, PHP is still trying to connect to the old server. The new server is runni

Crash in mysql_read_default_options

>Description: Perl script segfaults when it tries to connect database if DSN string contains mysql_read_default_file=/path/to/my.cnf and /path/to/my.cnf contains section [client] with 'socket' parameter. GDB stacktrace: #0 0x401c2810 in strcend () from /home/perl-5.6.1/cpan/build/DBD-mysql-2.

replication problem

hello, i have major problem with setting up replication. both ends are running mysql 3.23.49 i have set up proper entries in my.cnf on both sides and have replicated the dbs. now, on master: show master status reads: ++--+--+--+ | File

Cardinality and index using

Hi, all I am using mysql - 3.23.46, Intel, Solaris 8 Some questions: 1) Why cardinality value don't automaticly change when query change set of unique values in index ( insert or update ) ? Example: mysql> create table a ( a int not null, index ( a ) ); Query OK, 0 rows affected (0.02 sec)

Trying to find source Tarball for 4.0.2

Dear List, since i am working on a project that uses extensively "full text search" i have to find a source distribution of 4.0.2 source code which has some very important features and bug fixes respect to 4.0.1 and try to compile it with different charset e.t.c. Unfortunately i don't have any

Re: Multiple Queries

You're running 3 entirely independent scripts, so they can't share a connection. You may save an infinitessimal amount of time by using mysql_pconnect() instead of mysql_connect(), which will give each process/thread a permanent database connection, so it doesn't have to connect every time. Ad

Re: Newbie question : Can't connect to database through a web interface

Try replacing that with this bit of code: $db = mysql_pconnect("localhost", "testdb", "test123") or exit(mysql_error()); It should give you a more descriptive error message. Note I didn't put the "@", which is used to suppress error messages in PHP. Adam Hooper [EMAIL PROTECTED] On 31 May 102

Re: I need 50.000 inserts / second

Depending on your available RAM & length of your sampling runs, you could write records to heap (in-memory) tables - http://www.mysql.com/doc/H/E/HEAP.html - and then dump those to disk after the sample was done. You might even be able to use heap tables as a buffer with one process a

DB pagination: COUNT, LIMIT...

(been trying to answer this question for a long time; a recent post on the topic has convinced me to admit defeat and ask the list...) I have a large database and would like to output 'results' page by page. 'Results' refers to fairly general database computations, including groups, joins, logica

index not hit ?

show index from gwarp; mysql> +---+++--+-+---+ -+--++-+ -> | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | -> +---+

Fw: Home Grown E-Learning Solution on Mysql/Php

Hello, I am quite new to the world of databases, but need to know if I can implement an e-learning solution using Mysql database and PHP. What then happens to the LMS Accorn standard if I need to track my students' progress. Please advise. Olusola

Multiple Queries

Sorry If this is the wrong list for this topic, I hope someone can shed some light onto my problem. I am building a php/ Mysql web site for a client which is a picture gallery. The web site has 3 frames (required by the designer so that the whole thing doesnt refresh all the time). Frame 1- Navig

Re[2]: Mirroring / synchronizing two MySQL servers on different mach ines.

First way is unacceptable, for sure. Second, hmz. Still not what i need. The deeper problem is: I want to put and to get data to that S2 from outside LAN (using Windows application). Besides, both servers must be active all the time. Ok, thanks for help. It seems i have to code some tool to do th

InnoDB Delete On Cascade

Hello People, I was just designing my database and I was planning to finally use the new feature provided by InnoDB : ON DELETE CASCADE So I tried the example : CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB; CREATE TABLE child(id INT, parent_id INT,

RE: Mirroring / synchronizing two MySQL servers on different machines.

There are two ways to do this. One open a hole in the firewall. Two put a second Ethernet card in each system and use this for BIN updates. Simon -Original Message- From: Agris [mailto:[EMAIL PROTECTED]] Sent: 31 May 2002 09:17 To: [EMAIL PROTECTED] Subject: Mirroring / synchronizing two

large data design for mysql

Hi, Within MySql if you have a large amount of data of the same format and also know that there are distinct groups within this data which you need to run many comprehensive searches against; is it better to have a well indexed large table or many small tables / databases for each distinct group

Mirroring / synchronizing two MySQL servers on different machines.

Hello! Can anyone help me in this situation - S1: One MySQL on FreeBSD with direct connection to internet; S2: One MySQL on FreeBSD without direct connection (just intranet); I can't connect to S2 from non-intranet but I can connect to S1. What I need is to synchronize S1 and S2 realtime or, at l

displaying errors in "load data from..."

Hi, I've seen this question asked before, but I'm hoping maybe this is now possible. When one does a "LOAD DATA INFILE..." or similar and get a result like this: Query OK, 428 rows affected (4.30 sec) Records: 428 Deleted: 0 Skipped: 0 Warnings: 431 ...is there any possible way to see the e

Help with InnoDB configuration

Hi. I need help with InnoDB configuration. - The machine is a 2 Pentium III 1000GHz, Memory 1G, 30GB SCSSI. - The operating system is FreeBSD 4.5. - The mysql server is 3.23.49 (using FreeBSD port). I read carefully section InnoDB in MySQL manual and set the innodb parameters as: # Uncommen