Explain syntax

Hi list: I have the following partial result from an explain select: | table| type | possible_keys | key

Speeding query

Hi list: I have the following partial result from an explain select: | table| type | possible_keys | key

Explain select

Hi list: I have the following partial result from an explain select: | table| type | possible_keys | key

EXPLAIN COMMAND

Hi list: I have the following partial result from an explain select: | table| type | possible_keys | key

Re: Master-Slave Replication

Here is a good URL, maybe it can help you to deploy your Master-Slave solution. URL: http://mysql.us.themoes.org/doc/en/Replication_HOWTO.html Greetings Mikel From: Sanya Shaik [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Master-Slave Replication Date: Thu, 21 Aug 2003 12:50:31 -0700

Re: Doing differential backups

Thanxs for the URLS, I'll check them out. Greetings Mikel _ Charla con tus amigos en línea mediante MSN Messenger: http://messenger.microsoft.com/es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Differential backup

Hi list, Does any know how to do differential backups or does exist a tool that do this kind of backups. I have mysql 4.0.12 and use innodb tables, mysql is running on redhat 7.3 Greetings and thnx in advanced _ MSN. Más Útil

DIFFERENTIAL BACKUPS

Hi list, Does anyone know how to do a differntial backup for mysql databases. Is it possible?. I use mysql 4.0.12 on a redhat 7.3 box. Greetings and thnx in advanced _ MSN Fotos: la forma más fácil de compartir e imprimir fotos.

Doing Differential backup

Hi list, Does any know how to do differential backups or does exist a tool that do this kind of backups. I have mysql 4.0.12 and use innodb tables, mysql is running on redhat 7.3 Greetings and thnx in advanced _ MSN. Más Útil Cada

Re: Max size

No, it doesn't realize that the file size is about 330GB. To best performance is better split the ibdata in several files? or should I have only one? Thanx From: Jeremy Zawodny [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Miguel Perez [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject

Max size

Hi list: I would like to know some of the best practices to manage innodb tables. I have an ibdata file that its size is 4.5GB, and it will increase every day the max size of the hard disk is about 330GB, the question is should I split this ibdata file in several files in a way that I can

Suggestion

Hi list: I would like to know some of the best practices to manage innodb tables. I have an ibdata file that its size is 4.5GB, and it will increase every day the max size of the hard disk is about 330GB, the question is should I split this ibdata file in several files in a way that I can

Best practices

Hi list: I would like to know some of the best practices to manage innodb tables. I have an ibdata file that its size is 4.5GB, and it will increase every day the max size of the hard disk is about 330GB, the question is should I split this ibdata file in several files in a way that I can

mysql crashes

Hi Guys: Does anyone know how come I'm getting a lot of mysql processes when I start mysql server for the first time. When I type top it showed the following: 5:33pm up 15 min, 4 users, load average: 0.16, 0.19, 0.10 80 processes: 79 sleeping, 1 running, 0 zombie, 0 stopped CPU0 states:

doesn't start mysql

Hi every one: I have the followin error just after mysql starts: /usr/bin/safe_mysqld: line 280: 17018 Killed $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 030725 16:50:07

Log

Hi: I have a question: does anyone know if exists a log in mysql to store only incorrect queries or queries that causes a code error in mysql. Greetings and thnx in advanced. _ MSN. Más Útil Cada Día http://www.msn.es/intmap/ --

DATE COMPARISON

Hi: I was wondering if there is a date function to get the older date between two dates?. Or smething that indicates me that one date is older than the other one. I know that I have the function YEAR,MONTH,DAY and I can use them, but I don't know if exists a function that can do the same.

RE: Pulling large Microsoft SQL files into MySQL

Hi: Or you can use a DTS to transfer the info to MySQL Greetings From: Ralph Guzman [EMAIL PROTECTED] To: 'Rudolf Bekker' [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: Pulling large Microsoft SQL files into MySQL Date: Tue, 15 Jul 2003 10:32:03 -0700 LOAD DATA INFILE data.txt INTO TABLE

TRANSACTION... COMMITTED IN MEMORY

Hi everyone: I have the next question I have php script that does a lot of inserts to my tables, the first time I executed the script worked fine and I could see the results and when I did a select the command showed me the right info, but now when I try running again the script all seems is

RESETTING AUTO_INCREMENT

Hi everyone: Does anyone know how to reset the auto_increment value of certain table. Any ideas or sugestions Greetings in advance _ Únete al mayor servicio mundial de correo electrónico: http://www.hotmail.com -- MySQL General

ERROR 2013:Lost connection to MySQL server

Hi folks: I have the following problem, when I try to connect to my DB servicios I get connected succesfully, but when I try to access certain tables I get the error ERROR 2013: Lost connection to MySQL server during query but only with those certain tables, to be more specific there's only 2

Re: ERROR 2013:Lost connection to MySQL server

Engen [EMAIL PROTECTED] To: Miguel Perez [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: ERROR 2013:Lost connection to MySQL server Date: Tue, 1 Jul 2003 21:23:41 +0200 Hi, On Tue, Jul 01, 2003 at 02:13:23PM -0500, Miguel Perez wrote: I have the following problem, when I try to connect to my DB

Re: ERROR 2013:Lost connection to MySQL server

- Original Message - From: Miguel Perez [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 02, 2003 12:11 AM Subject: Re: ERROR 2013:Lost connection to MySQL server The OS I'm using is Red Hat 7.3, and the mysql version is 4.0 The wierd thing is that I could access

Re: ERROR 2013:Lost connection to MySQL server

Heikki: The only thing that I did with those tables is that I renamed both of them. And I didn't drop anything. Do you think that the renamed thing did affect my tables?.. Greetings From: Heikki Tuuri [EMAIL PROTECTED] To: Miguel Perez [EMAIL PROTECTED],[EMAIL PROTECTED] Subject: Re: ERROR

memory usage

Hi, I have a question about the memory that mysql uses, Here is the info that top command displays: 7:39pm up 55 days, 2:51, 1 user, load average: 0.18, 0.08, 0.02 54 processes: 53 sleeping, 1 running, 0 zombie, 0 stopped CPU0 states: 0.1% user, 10.1% system, 0.0% nice, 89.3% idle CPU1

odd Date

Hi: I have the following problem: When I insert a date in my table, and after do the insert I select the column date to see if the date is right but it displays the date like follows: 2019-06-20 When the original insert is: 2003-06-19 I looked into the manual to figure out how mysql works

RE: odd Date

='', colorProducto='', esGarantiaReparacion='1' Best Regards From: Jay Blanchard [EMAIL PROTECTED] To: Miguel Perez [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: odd Date Date: Fri, 20 Jun 2003 09:21:06 -0500 [snip] When I insert a date in my table, and after do the insert I select the column date to see

RE: odd Date

] To: Miguel Perez [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: odd Date Date: Fri, 20 Jun 2003 09:35:43 -0500 [snip] insert into OrdenServicio set folioOrdenServicio='', idCanal='1', idTienda='107', idPedido='306', idProducto='503578', fallaCliente='no prende', idEntregaControl='1', numSerie

Re: odd Date

Hi: The weird thing is that not always do the same, I mean I always introduce that insert query, but not always inserts a wrong date, sometimes the date is correct. Mikel From: Roger Baklund [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: Miguel Perez [EMAIL PROTECTED] Subject: Re: odd Date Date

GRANTs Options

Hi everyone: I wonder if the command GRANT could be alered. I mean if I have the following privileges over certain database: +--+ | Grants for [EMAIL PROTECTED]

Re: GRANTs Options

Thnx for the hint Paul, I will do that. Regards.. From: Paul DuBois [EMAIL PROTECTED] To: Miguel Perez [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: GRANTs Options Date: Thu, 19 Jun 2003 18:57:15 -0500 At 18:47 -0500 6/19/03, Miguel Perez wrote: Hi everyone: I wonder if the command GRANT

Re: Can't delete on cascade

technical support from https://order.mysql.com/ - Original Message - From: Miguel Perez [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Sunday, June 15, 2003 12:27 AM Subject: Can't delete on cascade Hi every one does anyone know if there are bugs on the statement ON DELETE

Can't delete on cascade

Hi every one does anyone know if there are bugs on the statement ON DELETE CASCADE, cause I have 2 tables as follows: Reparacion |CREATE TABLE `Reparacion` ( `folio` bigint(19) NOT NULL default '0', `idTipo` int(4) NOT NULL default '0', `idAlmacen` int(4) NOT NULL default '0',

INNODB Transactions

Hi : I would like to know what happen if I start a transaction using BEGIN command I do some insert or update statements, and just before executing a ROLLBACK or COMMIT command I get disconnected and I can't execute those commands. For how long does the table remain locked, or in other words