Re: mysql x64en server 64 bits

[Juan Eduardo Moreno]

Hi,

Try to download using the mirror called :


United States of America [X10 WTI / Seattle, WA]
HTTP
FTP


Install the software.

Regards,
Juan

On Thu, Jul 3, 2008 at 5:10 PM, Jaime Fuentes <[EMAIL PROTECTED]> wrote:

> Hi every body:
> I've a Server with Intel quad Core processor + Wndows 2003 server R2 64
> bits, I'm trying to install a myql 5.1 x64 but it shows me that
> "this installation package is npot supported by this processor type.
> Contact your vendor."
>
> What could be happening ?
>
> please help me Urgent.
>
> Jaime Fuentes R.
> Peru
>
>
>
> Arpotu escribió:
>
>> All,
>>
>> I have a customer who has been on MySQL for about 8 years, but they are
>> moving their business elsewhere.  They are moving their database into an
>> Oracle shop, and want me to export their MySQL data into a format that's
>> easily imported into Oracle.  Does anyone have experience doing this, or
>> are there migration tools?
>>
>> A flatfile export has been suggested, but I'm not sure if they'll need to
>> maintain data types in the export.
>>
>> Ideas?
>>
>> Thanks,
>> Arpotu.
>>
>>
>>
>>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>

Re: mySQL support required

[Juan Eduardo Moreno]

Hi Kishore,

Please see the following approach :

http://dschneller.blogspot.com/2007/09/error-1033-hy000-on-innodb.html

Regards,
Juan



On Mon, Jun 9, 2008 at 8:26 AM, <[EMAIL PROTECTED]> wrote:

>
>
>
> Hi ,
>
>
>
> We are in Urgent need of support to recover from a database problem
>
>
>
> Details of our license product are as below
>
>
>
> License serial numbers is : 565076
>
> Received on 19/Apr/006
>
>
>
> The Problem detail is said below,
>
>
>
> We are not able to access the innodb data from the mysql Database .
>
> Any select statement results in an error
>
> ERROR 1033 (HY000): Incorrect information in file:
>
>
>
> We have taken the instance of the Database and tested on a different
> system, the data seems to be fine .
>
> The Queries seems to work fine .
>
>
>
> We would like to know ,if any changes are required in the Database to
> recover from this situation , Since we assume there is no problem with
> the data
>
>
>
> Regards
>
> Kishore
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Please do not print this email unless it is absolutely necessary.
>
> The information contained in this electronic message and any attachments to
> this message are intended for the exclusive use of the addressee(s) and may
> contain proprietary, confidential or privileged information. If you are not
> the intended recipient, you should not disseminate, distribute or copy this
> e-mail. Please notify the sender immediately and destroy all copies of this
> message and any attachments.
>
> WARNING: Computer viruses can be transmitted via email. The recipient
> should check this email and any attachments for the presence of viruses. The
> company accepts no liability for any damage caused by any virus transmitted
> by this email.
>
> www.wipro.com
>

Re: purge binary logs on master

[Juan Eduardo Moreno]

Ananda,

Use, PURGE MASTER LOGS TO 'name of the last binary that you want leave in
your disk';

Regards

On Sat, May 17, 2008 at 8:56 AM, Ananda Kumar <[EMAIL PROTECTED]> wrote:

> Hi All,
> I using this command to purge binary logs on master, but i dont see the
> binary logs getting deleted. These binary logs are listed in index file.
> I am using mysql version 5.0.41 community version. Can you please let me
> know if any thing else need to be done for this to work.
>
> log-bin is enables.
>
> PURGE LOGS BEFORE '2008-05-07 00:00:00';
>
> regards
> anandkl
>

Re: changing 'max_allowed_packet'

[Juan Eduardo Moreno]

Hi,

In your my.cnf put this :

[mysqldump]
quick
max_allowed_packet = 32M

Regards,
Juan

On Fri, May 16, 2008 at 6:55 PM, Sigfrid <[EMAIL PROTECTED]> wrote:

>
> Hello, I have a simple question: how can I change the value of
> max_allowed_packet ? (I use server version: 5.0.51a MySQL Community Server
> on MacOS 10.5)
>
>
> In my application I upload file but sometime I get this error
>
> Mysql::Error: #08S01Got a packet bigger than 'max_allowed_packet' bytes:
>
>
> Thanjs and have a good 1!
>
> -
> Alla prossima ...
> --
> View this message in context:
> http://www.nabble.com/changing-%27max_allowed_packet%27-tp17284967p17284967.html
> Sent from the MySQL - General mailing list archive at Nabble.com.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>

Re: master - slave replication - slave not updating

[Juan Eduardo Moreno]

Hi Tom,

Your master binary log start with mysql-bin.03, then, your insert ( or
update)  in the master could be in mysql-bin.02 or 1.

Please, reload your binary logs again from the beginning ( put
mysql-bin.02 or 1, ). Your insert or update could be in one of this
files.

Regards,
Juan

On Fri, May 16, 2008 at 10:09 AM, Tom Brown <[EMAIL PROTECTED]> wrote:

>
>
>> Yes thanks - i have done that and restarted the slave and _some_ tables
>> now appear to update but others dont
>>
>> eg
>>
>> master:
>> mysql> select count(*) from tbl_checkcommand;
>> +--+
>> | count(*) |
>> +--+
>> |   30 |
>> +--+
>> 1 row in set (0.00 sec)
>>
>> slave:
>> mysql> select count(*) from tbl_checkcommand;
>> +--+
>> | count(*) |
>> +--+
>> |0 |
>> +--+
>> 1 row in set (0.00 sec)
>>
>> all seems ok in the log
>>
>> 080516 12:21:55 [Note] Slave SQL thread initialized, starting replication
>> in log 'mysql-bin.03' at position 2941, relay log
>> './devsw19nagios02-relay-bin.01' position: 2909
>> /usr/libexec/mysqld: ready for connections.
>> Version: '4.1.20'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source
>> distribution
>> 080516 12:21:55 [Note] Slave I/O thread: connected to master '
>> [EMAIL PROTECTED]:3306',  replication started in log 'mysql-bin.03'
>> at position 4608829
>>
>> any ideas as to why they are not all updating ?
>>
>>
>>
> i should probabbly also mention that the slave appears to think its happy,
> i believe,
>
> mysql> show slave status\G
> *** 1. row ***
>Slave_IO_State: Waiting for master to send event
>   Master_Host: 192.168.12.225
>   Master_User: repl
>   Master_Port: 3306
> Connect_Retry: 60
>   Master_Log_File: mysql-bin.03
>   Read_Master_Log_Pos: 6412734
>Relay_Log_File: devsw19nagios02-relay-bin.02
> Relay_Log_Pos: 1803952
> Relay_Master_Log_File: mysql-bin.03
>  Slave_IO_Running: Yes
> Slave_SQL_Running: Yes
>   Replicate_Do_DB:
>   Replicate_Ignore_DB:
>Replicate_Do_Table:
>Replicate_Ignore_Table:
>   Replicate_Wild_Do_Table:
> Replicate_Wild_Ignore_Table:
>Last_Errno: 0
>Last_Error:
>  Skip_Counter: 0
>   Exec_Master_Log_Pos: 6412734
>   Relay_Log_Space: 1803952
>   Until_Condition: None
>Until_Log_File:
> Until_Log_Pos: 0
>Master_SSL_Allowed: No
>Master_SSL_CA_File:
>Master_SSL_CA_Path:
>   Master_SSL_Cert:
> Master_SSL_Cipher:
>Master_SSL_Key:
> Seconds_Behind_Master: 0
>
> 1 row in set (0.00 sec)
>
>
>

Re: master - slave replication - slave not updating

[Juan Eduardo Moreno]

Hi Tom,

The error 1062 you could skipped in the slave modifying your my.cnf ( slave
side)   using :

slave-skip-errors=1062

This error on duplicated records, normally is problem in binarylogs transfer
data. But, anyway, please confer that the data exist in the slave.

Regards,
Juan



On Fri, May 16, 2008 at 8:40 AM, Tom Brown <[EMAIL PROTECTED]> wrote:

> Hi
>
> I am running 4.1.20 as this is the stock version in RHEL4 u5 and i have
> setup a master/slave combination. Updates at first appeared to work as
> creating and inserting into the master created the db's on the slave etc. I
> have noticed however that data in the master is not making its way to the
> slave.
>
> I am now seeing issues like this
>
> mysql> show slave status\G
> *** 1. row ***
>Slave_IO_State: Waiting for master to send event
>   Master_Host: 192.168.12.225
>   Master_User: repl
>   Master_Port: 3306
> Connect_Retry: 60
>   Master_Log_File: mysql-bin.03
>   Read_Master_Log_Pos: 2008085
>Relay_Log_File: devsw19nagios02-relay-bin.01
> Relay_Log_Pos: 2909
> Relay_Master_Log_File: mysql-bin.03
>  Slave_IO_Running: Yes
> Slave_SQL_Running: No
>   Replicate_Do_DB:
>   Replicate_Ignore_DB:
>Replicate_Do_Table:
>Replicate_Ignore_Table:
>   Replicate_Wild_Do_Table:
> Replicate_Wild_Ignore_Table:
>Last_Errno: 1062
>Last_Error: Error 'Duplicate entry '754' for key 1' on
> query. Default database: 'nagiosql'. Query: 'INSERT INTO tbl_logbook SET
> user='Admin',time=NOW(), entry='Passwort successfully modified''
>  Skip_Counter: 0
>   Exec_Master_Log_Pos: 2941
>   Relay_Log_Space: 2008053
>   Until_Condition: None
>Until_Log_File:
> Until_Log_Pos: 0
>Master_SSL_Allowed: No
>Master_SSL_CA_File:
>Master_SSL_CA_Path:
>   Master_SSL_Cert:
> Master_SSL_Cipher:
>Master_SSL_Key:
> Seconds_Behind_Master: NULL
> 1 row in set (0.00 sec)
>
> and in the mysql log
>
> 080516  9:23:01 [Note] Slave SQL thread initialized, starting replication
> in log 'mysql-bin.03' at position 79, relay log
> './devpctnagios02-relay-bin.01' position: 4
> 080516  9:23:01 [Note] Slave I/O thread: connected to master '
> [EMAIL PROTECTED]:3306',  replication started in log 'mysql-bin.03'
> at position 79
> 080516 10:06:58 [ERROR] Slave: Error 'Duplicate entry '754' for key 1' on
> query. Default database: 'nagiosql'. Query: 'INSERT INTO tbl_logbook SET
> user='Admin',time=NOW(), entry='Passwort successfully modified'',
> Error_code: 1062
> 080516 10:06:58 [ERROR] Error running query, slave SQL thread aborted. Fix
> the problem, and restart the slave SQL thread with "SLAVE START". We stopped
> at log 'mysql-bin.03' position 2941
>
> Any clues as to how i can fix this?
>
> thanks
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>

Re: MySQL (mysql-5.0.54)

[Juan Eduardo Moreno]

Hi,

Please, you must set up the log-bin for enable replication :

Example ( in your my.cnf )

--log-bin=mysqld-bin

The mysql signal 4 error appear when you install erroneus your environment.
I recommed reinstall your MySQL in your OS.

Regards,
Juan

On 5/6/08, Kaushal Shriyan <[EMAIL PROTECTED]> wrote:
>
> Hi
>
> I am not able to restart MySQL Database Server (mysql-5.0.54) on Gentoo, I
> see the below information in the mysqld.err file
>
>
> ##
>
> 06  6:30:13 [Warning] No argument was provided to --log-bin, and
> --log-bin-index was not used; so replication may break when this MySQL
> server acts as a master and has his hostname changed!! Please use
> '--log-bin=mysqld-bin' to avoid this problem.
> 080506  6:30:13 - mysqld got signal 4;
> This could be because you hit a bug. It is also possible that this binary
> or one of the libraries it was linked against is corrupt, improperly
> built,
> or misconfigured. This error can also be caused by malfunctioning
> hardware.
> We will try our best to scrape up some info that will hopefully help
> diagnose
> the problem, but since we have already crashed, something is definitely
> wrong
> and this may fail.
>
> key_buffer_size=0
> read_buffer_size=262144
> max_used_connections=0
> max_connections=100
> threads_connected=0
> It is possible that mysqld could use up to
> key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections =
> 76800 K
> bytes of memory
> Hope that's ok; if not, decrease some variables in the equation.
>
> thd=(nil)
> Attempting backtrace. You can use the following information to find out
> where mysqld died. If you see no messages after this, something went
> terribly wrong...
> frame pointer is NULL, did you compile with
> -fomit-frame-pointer? Aborting backtrace!
> The manual page at http://dev.mysql.com/doc/mysql/en/crashing.htmlcontains
> information that should help you find out what is causing the crash.
>
>
>
> ##
>
> Any ideas
>
> Thanks and Regards
>
> Kaushal
>

Re: innodb disabled

[Juan Eduardo Moreno]

Hi,

Can you send the error log file of mysql server in your machine?.

Regards,
Juan


On 5/6/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> Hi Juan,
>
> I have verified directory permissions, its shown below.
>
> linux76:~# ls -l /data/mysql/
> total 535088
> drwx-- 2 mysql mysql 20480 2008-05-04 23:44 dip
> -rw-rw 1 mysql mysql  10485760 2007-12-23 01:21 ibdata1
> -rw-rw 1 mysql mysql 268435456 2008-01-13 01:17 ib_logfile0
> -rw-rw 1 mysql mysql 268435456 2008-01-13 01:17 ib_logfile1
> drwx-- 2 mysql root   4096 2008-03-28 02:58 mysql
>
> In error log file there is error.
> debian-sys-maint error
>
> The above error come while starting mysql for the first time. Then i have
> given the permissions for debian sys-maint from  /etc/mysql/debian.cnf.
> After that restart mysql don't gives any error. still innodb is disabled.
>
> Thanks,
> Prajapati
>
> On Tue, May 6, 2008 at 7:03 AM, Juan Eduardo Moreno <
> [EMAIL PROTECTED]> wrote:
>
> > Hi,
> >
> > The InnoDB engine was disable because some ib_log files or Ibdata
> > files,  InnoDB can´t read. In some cases, could be a directory permissions
> > or some error in creation of ib_logfiles when database is started. If you
> > want , try to see in the error log file generated in order to see more
> > details. If you don´t understand nothing in the error log file, please send
> > this errors to the list.
> >
> > Regards,
> > Juan
> >
> >
> >
> > On Tue, May 6, 2008 at 5:27 AM, Krishna Chandra Prajapati <
> > [EMAIL PROTECTED]> wrote:
> >
> > > Hi all,
> > >
> > > I have change the data directory from /var/lib/mysql to /data/mysql
> > > directory and adding innodb_file_per_table. By doing this innodb
> > > storage
> > > engine get dissabled. my.cnf doesn't contains "#skip-innodb". Is it's
> > > adding
> > > will enable or not
> > >
> > > HOW CAN I ENABLE INNODB
> > >
> > > mysql> show engines;
> > >
> > > ++--++
> > > | Engine | Support  |
> > > Comment|
> > >
> > > ++--++
> > > | MyISAM | DEFAULT  | Default engine as of MySQL 3.23 with great
> > > performance |
> > > | MEMORY | YES  | Hash based, stored in memory, useful for
> > > temporary
> > > tables  |
> > > | InnoDB | DISABLED | Supports transactions, row-level locking,
> > > and
> > > foreign keys |
> > > | BerkeleyDB | NO   | Supports transactions and page-level
> > > locking   |
> > > | BLACKHOLE  | NO   | /dev/null storage engine (anything you write
> > > to it
> > > disappears) |
> > > | EXAMPLE| NO   | Example storage
> > > engine |
> > > | ARCHIVE| YES  | Archive storage
> > > engine |
> > > | CSV| YES  | CSV storage
> > > engine |
> > > | ndbcluster | DISABLED | Clustered, fault-tolerant, memory-based
> > > tables |
> > > | FEDERATED  | YES  | Federated MySQL storage
> > > engine |
> > > | MRG_MYISAM | YES  | Collection of identical MyISAM
> > > tables  |
> > > | ISAM   | NO   | Obsolete storage
> > > engine|
> > >
> > > ++--++
> > > 12 rows in set (0.00 sec)
> > >
> > >
> > > # /etc/mysql/my.cnf: The global mysql configuration file.
> > > # $Header: /var/cvsroot/gentoo-x86/dev-db/mysql/files/my.cnf-4.1-r1,v
> > > 1.3
> > > 2006/02/01 20:25:56 vivo Exp $
> > > #
> > > # $Revision:$
> > > # $Id:$
> > >
> > > # The following options will be passed to all MySQL clients
> > > [client]
> > > #password   =
> > > port= 3306
> > > socket  =
> > > /var/run/mysqld/mysqld.sock
> > >
> > > [mysql]
> >

Re: innodb disabled

[Juan Eduardo Moreno]

Hi,

The InnoDB engine was disable because some ib_log files or Ibdata files,
InnoDB can´t read. In some cases, could be a directory permissions or some
error in creation of ib_logfiles when database is started. If you want , try
to see in the error log file generated in order to see more details. If you
don´t understand nothing in the error log file, please send this errors to
the list.

Regards,
Juan


On Tue, May 6, 2008 at 5:27 AM, Krishna Chandra Prajapati <
[EMAIL PROTECTED]> wrote:

> Hi all,
>
> I have change the data directory from /var/lib/mysql to /data/mysql
> directory and adding innodb_file_per_table. By doing this innodb storage
> engine get dissabled. my.cnf doesn't contains "#skip-innodb". Is it's
> adding
> will enable or not
>
> HOW CAN I ENABLE INNODB
>
> mysql> show engines;
>
> ++--++
> | Engine | Support  |
> Comment|
>
> ++--++
> | MyISAM | DEFAULT  | Default engine as of MySQL 3.23 with great
> performance |
> | MEMORY | YES  | Hash based, stored in memory, useful for
> temporary
> tables  |
> | InnoDB | DISABLED | Supports transactions, row-level locking, and
> foreign keys |
> | BerkeleyDB | NO   | Supports transactions and page-level
> locking   |
> | BLACKHOLE  | NO   | /dev/null storage engine (anything you write to
> it
> disappears) |
> | EXAMPLE| NO   | Example storage
> engine |
> | ARCHIVE| YES  | Archive storage
> engine |
> | CSV| YES  | CSV storage
> engine |
> | ndbcluster | DISABLED | Clustered, fault-tolerant, memory-based
> tables |
> | FEDERATED  | YES  | Federated MySQL storage
> engine |
> | MRG_MYISAM | YES  | Collection of identical MyISAM
> tables  |
> | ISAM   | NO   | Obsolete storage
> engine|
>
> ++--++
> 12 rows in set (0.00 sec)
>
>
> # /etc/mysql/my.cnf: The global mysql configuration file.
> # $Header: /var/cvsroot/gentoo-x86/dev-db/mysql/files/my.cnf-4.1-r1,v 1.3
> 2006/02/01 20:25:56 vivo Exp $
> #
> # $Revision:$
> # $Id:$
>
> # The following options will be passed to all MySQL clients
> [client]
> #password   =
> port= 3306
> socket  =
> /var/run/mysqld/mysqld.sock
>
> [mysql]
> character-sets-dir=utf8
> default-character-set=utf8
>
> [mysqladmin]
> character-sets-dir=utf8
> default-character-set=utf8
>
> [mysqlcheck]
> character-sets-dir=utf8
> default-character-set=utf8
>
> [mysqldump]
> character-sets-dir=utf8
> default-character-set=utf8
>
> [mysqlimport]
> character-sets-dir=utf8
> default-character-set=utf8
>
> [mysqlshow]
> character-sets-dir=utf8
> default-character-set=utf8
>
> [myisamchk]
> character-sets-dir=utf8
> default-character-set=utf8
>
> [myisampack]
> character-sets-dir=utf8
>
>
> # use [safe_mysqld] with mysql-3
> [mysqld_safe]
> err-log = /var/log/mysql/mysql.err
>
> # add a section [mysqld-4.1] or [mysqld-5.0] for specific configurations.
> [mysqld]
> old_passwords = false # inserted by debconf
> character-set-server= utf8
> default-character-set   = utf8
> user= mysql
> port= 3306
> socket  = /var/run/mysqld/mysqld.sock
> pid-file= /var/run/mysqld/mysqld.pid
> log-error   = /var/log/mysql/mysqld.err
> basedir = /usr
> #datadir= /var/lib/mysql
> skip-locking
> #set default_storage_engine=InnoDB
> key_buffer  = 384M
> max_allowed_packet  = 16M
> table_cache = 1024
>
> sort_buffer_size= 9M
>
> net_buffer_length   = 8K
> read_buffer_size= 2M
> read_rnd_buffer_size= 32M
> myisam_sort_buffer_size = 64M
>
> query_cache_type= 1
> query_cache_size= 100M
>
> language= /usr/share/mysql/english
>
> set-variable = max_connections=1024
>
> # Begin replication section
> log-bin=/var/db/db05-master-bin.log
> server-id=5
>
> # End replication section
>
> #security:
> #using "localhost" in connects use sockets by default
> #skip-networking
> #bind-address   = 127.0.0.1
>
> # Point the following paths to different dedicated disks
> tmpdir  = /tmp

Re: Error reading packet from server: Out of memory (Needed 6560 bytes) ( server_errno=5)

[Juan Eduardo Moreno]

Hi,
This error occur when slave servers could incorrectly interpret an
out-of-memory error from the master and reconnect using the wrong binary log
position.

This was fix in 5.0.48 version. Please, try to update your version ( from
5.0.45)  of mysql and try again.

regards,
Juan


On 4/28/08, Dominik Klein <[EMAIL PROTECTED]> wrote:
>
> Hi.
>
> Juan Eduardo Moreno wrote:
>
> > Sorry, what is your setting for max_allowed_packet variable?
> >
>
> mysql> show variables like "%allowed%";
> ++--+
> | Variable_name  | Value|
> ++--+
> | max_allowed_packet | 16776192 |
> ++--+
> 1 row in set (0.00 sec)
>
> Here's an excerpt from the logs. It does not look like that value is
> involved in this:
>
> 080428 13:07:04 [ERROR] Error reading packet from server: Out of memory
> (Needed 2704 bytes) ( server_errno=5)
> 080428 13:07:04 [Note] Slave I/O thread: Failed reading log event,
> reconnecting to retry, log 'SRV02bin.000131' position 447892967
> 080428 13:07:04 [Note] Slave: connected to master '
> [EMAIL PROTECTED]:3306',replication resumed in log 'SRV02-bin.000131'
> at position 447892967
> 080428 13:22:14 [ERROR] Error reading packet from server: Out of memory
> (Needed 2704 bytes) ( server_errno=5)
> 080428 13:22:14 [Note] Slave I/O thread: Failed reading log event,
> reconnecting to retry, log 'SRV02-bin.000131' position 471157588
> 080428 13:22:14 [Note] Slave: connected to master '
> [EMAIL PROTECTED]:3306',replication resumed in log 'SRV02-bin.000131'
> at position 471157588
> 080428 14:38:06 [ERROR] Error reading packet from server: Out of memory
> (Needed 3464 bytes) ( server_errno=5)
> 080428 14:38:06 [Note] Slave I/O thread: Failed reading log event,
> reconnecting to retry, log 'SRV02-bin.000131' position 583864714
> 080428 14:38:06 [Note] Slave: connected to master '
> [EMAIL PROTECTED]:3306',replication resumed in log 'SRV02-bin.000131'
> at position 583864714
> 080428 15:13:24 [ERROR] Error reading packet from server: Out of memory
> (Needed 3128 bytes) ( server_errno=5)
> 080428 15:13:24 [Note] Slave I/O thread: Failed reading log event,
> reconnecting to retry, log 'SRV02-bin.000131' position 635409380
> 080428 15:13:24 [Note] Slave: connected to master '
> [EMAIL PROTECTED]:3306',replication resumed in log 'SRV02-bin.000131'
> at position 635409380
> 080428 15:32:14 [ERROR] Error reading packet from server: Out of memory
> (Needed 2688 bytes) ( server_errno=5)
> 080428 15:32:14 [Note] Slave I/O thread: Failed reading log event,
> reconnecting to retry, log 'SRV02-bin.000131' position 665146758
> 080428 15:32:14 [Note] Slave: connected to master '
> [EMAIL PROTECTED]:3306',replication resumed in log 'SRV02-bin.000131'
> at position 665146758
>
> Regards
> Dominik
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>

Re: Performance problem MySQL 4.0.20

[Juan Eduardo Moreno]

Please, mount your disks using "forcedirectio".

Regards,
Juan

On 7/3/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:


Hello,

I've a performance problem with our database:

Some select statements take about 20 seconds.
The same statements on an equal testmachine take less than 1 second.

Server: CPU: 2 x 440 MHz sparcv9
RAM: 2GB
(top: Memory: 2048M real, 931M free, 732M swap in use, 2839M swap
free)

OS: SunOS 5.9

Database:   Version: MySQL 4.0.20 (build from source)
Traffic: averaged 4985 Bytes/sec sent
 averaged 41 questions/sec
 averaged 0,3 connections/sec

Some options in my.cnf:
[mysqld]
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 96
sort_buffer_size = 512K
net_buffer_length = 8K
myisam_sort_buffer_size = 8M
query_cache_size = 16M
max_connections = 125


Is there just to much traffic on the machine or could help tuning some
parameters?
Thanks.

Best regards,
Spiker
--
Ist Ihr Browser Vista-kompatibel? Jetzt die neuesten
Browser-Versionen downloaden: http://www.gmx.net/de/go/browser

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]

Re: Alternative command of SET GLOBAL SQL_SLAVE_SKIP_COUNTER

[Juan Eduardo Moreno]

Hi,

We have some options in order to skip type of errors in the replication
process.

Please, identify your number error in slave machine and put into my.cnf
"slave_skip_errors= 1087" for example, where 1087 is a recurrent error for
your replication architecture.

Regards,
Juan



On 6/8/07, Ashok Chauhan < [EMAIL PROTECTED]> wrote:


Hi List,

I want to know the alternative command of
"SET GLOBAL SQL_SLAVE_SKIP_COUNTER" OR
How i skip the counter of Relay Log Position.

Thanks
Ashok

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]

Re: only select privilege

[Juan Eduardo Moreno]

Hi,

Try to do that :

GRANT SELECT ON abc.* to 'qa'@'%' identified by 'qa';
flush privileges;

Explain : The user qa have access of all tables of user abc. In this
command, only SELECT is possible is you connect using user qa.


Regards,
Juan


On 6/8/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:


How do i give only select privilege to a specific database.

I did this

GRANT SELECT ON abc.* to 'ab'@'%' identified by 'ab';


FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> select select_priv from user where user='qa';
+-+
| select_priv |
+-+
| N   |
+-+
But is shows as "N". Can you please help me.



regards

anandkl

Re: error after system setup/replication

[Juan Eduardo Moreno]

Keith,

When you copied the database, you need recreate de logfiles and the
sequences. Then, startup the database.
1) clean your actually log files ( backup to another side)
2) When the database startup automatically recreate the log files and
sequence.

Send feedback about it.

Regards,
Juan

On 6/5/07, Keith Murphy <[EMAIL PROTECTED]> wrote:


This:

070605 15:07:27 InnoDB: Error: page 170144 log sequence number 71
2823728422
InnoDB: is in the future! Current system log sequence number 71 452597657.
InnoDB: Your database may be corrupt.
070605 15:07:28 InnoDB: Error: page 61253 log sequence number 71 910331446

InnoDB: is in the future! Current system log sequence number 71 452599188.
InnoDB: Your database may be corrupt.
070605 15:07:29 InnoDB: Error: page 56830 log sequence number 71
3280625836
InnoDB: is in the future! Current system log sequence number 71 452601958.

InnoDB: Your database may be corrupt.


shows up in the error log on a new server we are setting up.

This system had the data copied to it from another db server.

On the old server we locked the tables (flush tables with read lock), did
a "show slave status" to get the bin log position and copied the relevant
directories (50gigs) to the new server.

Then we started up the new server.

Everything appears to be going fine. Replication status showed that it was
roughly 5000 seconds behind, but it synced up so that it is now 0 seconds
behind.

However, the same error message is still being written to the error log. I
am not familiar with it at all. There is some mention of it in google but
the answers really don't make any sense to me.

Any ideas?

Thanks,

Keith
--
Database Administrator
iContact
2635 Meridian Parkway, 2nd Floor
Durham, North Carolina 27713
(o) 910-433-0786
(c) 850-637-3877

Re: Problem with compex query

[Juan Eduardo Moreno]

Patricio,

2) What you meant with " indexes for the query"?


A: Create some indexes for a query in order to improve the performance.


Regards,
Juan Eduardo

On 5/22/07, Patricio A. Bruna <[EMAIL PROTECTED]> wrote:


Juan Eduardo,

1) The versions are the same.
2) What you meant with " indexes for the query"?
3) Im goint to try that.
4) Good Idea.

Thanks.

- Mensaje Original -
De: "Juan Eduardo Moreno" <[EMAIL PROTECTED]>
Para: "Patricio A. Bruna" <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Enviados: martes 22 de mayo de 2007 13H31 (GMT-0400) America/Santiago
Asunto: Re: Problem with compex query

Hi Patricio,

Your explain is scary.No use of index...Please, ask to programers in
order to create some index in the schema.

Development Server has the same version of MySQL production environment?.
4.0.18 ?

Resume:

1) Please check the version of mysql ( prod and development)
2) Please use indexes for the query.
3) For the session in Websphere please ask to programers in order to set
the enviroment only for the query. Use explicit code for that.
SET SESSION SQL_BIG_SELECTS=1;
SET SESSION SQL_MAX_JOIN_SIZE=DEFAULT;
4) In order to improve the insert, try to  commit every ( for example)
1 records. Ask to programers for provide some cursor or something like
that.


Regards,
Juan

On 5/22/07, Patricio A. Bruna <[EMAIL PROTECTED] > wrote:
>
> Juan Eduardo,
>
> Great to hear about you :)
> One thing you must know is that i can run this query from a mysql
> client, without the insert part.
> The problem only happens when is run from the J2EE (Websphere - drp)
> application.
>
> I run the query as you asked, here are some results:
>
> 
++-+-+---+-+-+--+---+
>
> | drp_id_sku | drp_id_deposito | drp_volumen | 1 | drp_dia | drp_mes |
> drp_anno | drp_fecha_dia_cargado |
>
> 
++-+-+---+-+-+--+---+
> |161 |  35 | 1.6 | 1 |  12 |   5
> | 2007 | 2007-05-12 00:00:00   |
> |161 |  20 | 1.5 | 1 |   2 |   5
> | 2007 | 2007-05-02 00:00:00   |
> |161 |  22 | 0.2 | 1 |  11 |   5
> | 2007 | 2007-05-11 00:00:00   |
> |161 |  13 | 0.2 | 1 |   7 |   5
> | 2007 | 2007-05-07 00:00:00   |
> |161 |  16 | 2.2 | 1 |   9 |   5
> | 2007 | 2007-05-09 00:00:00   |
> |161 |  35 | 4.0 | 1 |   3 |   5
> | 2007 | 2007-05-03 00:00:00   |
> |161 |  16 |24.0 | 1 |   4 |   5
> | 2007 | 2007-05-04 00:00:00   |
> |161 |   2 | 0.2 | 1 |   9 |   5
> | 2007 | 2007-05-09 00:00:00   |
> |163 |  35 |16.6 | 1 |  11 |   5
> | 2007 | 2007-05-11 00:00:00   |
> |163 |  36 | 2.2 | 1 |   4 |   5
> | 2007 | 2007-05-04 00:00:00   |
> |163 |  16 |-2.4 | 1 |   8 |   5
> | 2007 | 2007-05-08 00:00:00   |
> |163 |  35 | 8.8 | 1 |   2 |   5
> | 2007 | 2007-05-02 00:00:00   |
> |163 |  32 |13.0 | 1 |   8 |   5
> | 2007 | 2007-05-08 00:00:00   |
> |163 |  34 | 7.6 | 1 |   7 |   5
> | 2007 | 2007-05-07 00:00:00   |
>
> And the EXPLAIN:
>
>
> 
+---+--+---+--+-+--+---+---+
> | table | type | possible_keys | key  | key_len | ref  | rows  |
> Extra |
>
> 
+---+--+---+--+-+--+---+---+
> | d | ALL  | NULL  | NULL |NULL | NULL |37 | Using
> temporary   |
> | md| ALL  | NULL  | NULL |NULL | NULL |32 | Using
> where   |
> | vv| ALL  | NULL  | NULL |NULL | NULL | 12694 | Using
> where   |
> | s | ALL  | NULL  | NULL |NULL | NULL |   104
> |   |
> | ms    | ALL  | NULL  | NULL |NULL | NULL |   184 | Using
> where; Distinct |
>
> 
+---+--+---+--+-+--+---+---+
> 5 rows in set (0.00 sec)
>
>
> Any ideas?
>
> - "Juan Eduardo Moreno" < [EMAIL PROTECTED]> escribió:
> > Hi Patricio,
> >
> > Some options are to  prevent programmers/users  make a "bad" queries
> > into
> > the database' SQL_BIG_SELECTS = 0 

Re: Problem with compex query

[Juan Eduardo Moreno]

Hi Patricio,

Your explain is scary.No use of index...Please, ask to programers in
order to create some index in the schema.

Development Server has the same version of MySQL production environment?.
4.0.18?

Resume:

1) Please check the version of mysql ( prod and development)
2) Please use indexes for the query.
3) For the session in Websphere please ask to programers in order to set the
enviroment only for the query. Use explicit code for that.
SET SESSION SQL_BIG_SELECTS=1;
SET SESSION SQL_MAX_JOIN_SIZE=DEFAULT;
4) In order to improve the insert, try to  commit every ( for example) 1
records. Ask to programers for provide some cursor or something like that.


Regards,
Juan

On 5/22/07, Patricio A. Bruna <[EMAIL PROTECTED] > wrote:


Juan Eduardo,

Great to hear about you :)
One thing you must know is that i can run this query from a mysql client,
without the insert part.
The problem only happens when is run from the J2EE (Websphere - drp)
application.

I run the query as you asked, here are some results:

++-+-+---+-+-+--+---+

| drp_id_sku | drp_id_deposito | drp_volumen | 1 | drp_dia | drp_mes |
drp_anno | drp_fecha_dia_cargado |

++-+-+---+-+-+--+---+
|161 |  35 | 1.6 | 1 |  12 |   5 |
2007 | 2007-05-12 00:00:00   |
|161 |  20 | 1.5 | 1 |   2 |   5 |
2007 | 2007-05-02 00:00:00   |
|161 |  22 | 0.2 | 1 |  11 |   5 |
2007 | 2007-05-11 00:00:00   |
|161 |  13 | 0.2 | 1 |   7 |   5 |
2007 | 2007-05-07 00:00:00   |
|161 |  16 | 2.2 | 1 |   9 |   5 |
2007 | 2007-05-09 00:00:00   |
|161 |  35 | 4.0 | 1 |   3 |   5 |
2007 | 2007-05-03 00:00:00   |
|161 |  16 |24.0 | 1 |   4 |   5 |
2007 | 2007-05-04 00:00:00   |
|161 |   2 | 0.2 | 1 |   9 |   5 |
2007 | 2007-05-09 00:00:00   |
|163 |  35 |16.6 | 1 |  11 |   5 |
2007 | 2007-05-11 00:00:00   |
|163 |  36 | 2.2 | 1 |   4 |   5 |
2007 | 2007-05-04 00:00:00   |
|163 |  16 |-2.4 | 1 |   8 |   5 |
2007 | 2007-05-08 00:00:00   |
|163 |  35 | 8.8 | 1 |   2 |   5 |
2007 | 2007-05-02 00:00:00   |
|163 |  32 |13.0 | 1 |   8 |   5 |
2007 | 2007-05-08 00:00:00   |
|163 |  34 | 7.6 | 1 |   7 |   5 |
2007 | 2007-05-07 00:00:00   |

And the EXPLAIN:


+---+--+---+--+-+--+---+---+
| table | type | possible_keys | key  | key_len | ref  | rows  |
Extra |

+---+--+---+--+-+--+---+---+
| d | ALL  | NULL  | NULL |NULL | NULL |37 | Using
temporary   |
| md| ALL  | NULL  | NULL |NULL | NULL |32 | Using
where   |
| vv| ALL  | NULL  | NULL |NULL | NULL | 12694 | Using
where   |
| s | ALL  | NULL  | NULL |NULL | NULL |   104
|   |
| ms| ALL  | NULL  | NULL |NULL | NULL |   184 | Using
where; Distinct |

+---+--+---+--+-+--+---+---+
5 rows in set (0.00 sec)


Any ideas?

- "Juan Eduardo Moreno" < [EMAIL PROTECTED]> escribió:
> Hi Patricio,
>
> Some options are to  prevent programmers/users  make a "bad" queries
> into
> the database' SQL_BIG_SELECTS = 0 | 1
>
> The documentation say :
> "If set to 0, MySQL will abort if a SELECT is attempted that probably
> will
> take a very long time. This is useful when an inadvisable WHERE
> statement
> has been issued. A big query is defined as a SELECT that probably will
> have
> to examine more than max_join_size rows. The default value for a new
> connection is 1 (which will allow all SELECT statements)."
>
> For testing try this :
>
> 1)
>
> SET SESSION SQL_BIG_SELECTS=1;
> SET SESSION SQL_MAX_JOIN_SIZE=DEFAULT;
> Run the query;
>
> 2) Send your results and explain of query ( explain select )
>
> Regards,
> Juan
>
>
> On 5/22/07, Patricio A. Bruna <[EMAIL PROTECTED] > wrote:
> >
> > Friends,
> > im having troubles with the following query:
> >
> > ---
> > INSERT drp_volumen_venta_diaria_deposito (drp_id_sku,
> drp_id_deposito,
> > drp_volumen, drp_es_cct, drp_dia, drp_mes, drp_anno,
> drp_fecha_dia_carg

Re: Problem with compex query

[Juan Eduardo Moreno]

Hi Patricio,

Some options are to  prevent programmers/users  make a "bad" queries into
the database' SQL_BIG_SELECTS = 0 | 1

The documentation say :
"If set to 0, MySQL will abort if a SELECT is attempted that probably will
take a very long time. This is useful when an inadvisable WHERE statement
has been issued. A big query is defined as a SELECT that probably will have
to examine more than max_join_size rows. The default value for a new
connection is 1 (which will allow all SELECT statements)."

For testing try this :

1)

SET SESSION SQL_BIG_SELECTS=1;
SET SESSION SQL_MAX_JOIN_SIZE=DEFAULT;
Run the query;

2) Send your results and explain of query ( explain select )

Regards,
Juan


On 5/22/07, Patricio A. Bruna <[EMAIL PROTECTED]> wrote:


Friends,
im having troubles with the following query:

---
INSERT drp_volumen_venta_diaria_deposito (drp_id_sku, drp_id_deposito,
drp_volumen, drp_es_cct, drp_dia, drp_mes, drp_anno, drp_fecha_dia_cargado )
SELECT DISTINCT s.drp_id_sku, d.drp_id_deposito, vv.drp_volumen, 1,
vv.drp_dia, vv.drp_mes, vv.drp_anno,vv.drp_fecha_dia_cargado
FROM drp_volumen_venta_diaria_tmp vv, drp_sku s, drp_deposito d,
drp_mapeo_sku ms, drp_mapeo_deposito md
WHERE vv.drp_codigo_sku = ms.drp_cod_sku_odyssey AND ms.drp_cod_sku_sap =
s.drp_codigo_sku
AND REPLACE(UCASE(TRIM(vv.drp_codigo_deposito)),' ','')=
REPLACE(UCASE(TRIM(md.drp_alias_deposito_odyssey)),' ','') AND
REPLACE(UCASE(TRIM(md.drp_alias_deposito_sap)),' ','') =
REPLACE(UCASE(TRIM(d.drp_alias_deposito)),' ','')
AND
CONCAT(vv.drp_anno,if(LENGTH(vv.drp_mes)=1,CONCAT('0',vv.drp_mes),
vv.drp_mes)
, if(LENGTH(vv.drp_dia)=1,CONCAT('0',vv.drp_dia),vv.drp_dia) ) >= '
20070501 '
AND
CONCAT(vv.drp_anno,if(LENGTH(vv.drp_mes)=1,CONCAT('0',vv.drp_mes),
vv.drp_mes)
, if(LENGTH(vv.drp_dia)=1,CONCAT('0',vv.drp_dia),vv.drp_dia) ) <= '
20070515 ';

-

I run this query in 2 servers, devel and production, which have the same
data.
I run the query in devel without problems, but in production is not
working and give me this error:

" The SELECT would examine more rows than MAX_JOIN_SIZE. Check your WHERE
and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is ok
"

The value of MAX_JOIN_SIZE is set at: 4294967295 and SET_SQL_BIG_SELECTS
is 1.
MySQL version is 4.0.18 over Red Hat 3.


any idea why this isnt working?

thanks

Re: help on loading the world.sql(script and data) onto world database

[Juan Eduardo Moreno]

Kebede,

Send some example of WORLD contains.

Regards
Juan

On 5/9/07, kebede teferi <[EMAIL PROTECTED]> wrote:


hi, it's my first time trying my hand in inputting data in batches to
mysql database and it drives me crazy, please help.

  *I've created the WORLD database.
  *I've downloaded WORLD.SQL and unzipped the file.
  *When I open it in notepad I see the instructions to create the three
tables and the instructions for data insertions.

  As per the load instruction on MySQL page I did the following within
mysql:

  *mysql> use world;
  *mysql> source world.sql;
  I get an error message 'Can't open the file' error: 2.

  I tried the following at windows command prompt:

  *C:\Document and Settings>mysql world < world.sql
  I get the message 'I can't get file specified.

  I don't have any problem connecting to mysql from windows prompt, and
world.sql is a sub folder under Documents and Settings.

  I know I'm green related to mysql, and I need your help.  Thanks


-
It's here! Your new message!
Get new email alerts with the free Yahoo! Toolbar.

Re: expire_logs_days

[Juan Eduardo Moreno]

Hi,

I'm experience using expire_log_days and don't work. I set this parameters
in the CNF and when the time of ( for example 5 days) is in, don't delete
anything.

On my expirience, this parameters don't work ( 5.0.27).

Regards
Juan

On 5/2/07, Ofer Inbar <[EMAIL PROTECTED]> wrote:


Baron Schwartz <[EMAIL PROTECTED]> wrote:
> Actually, the manual does mention the variable, but it doesn't work
> for us.  We run a nightly cron job that just runs [purge master logs]

When you say "it doesn't work for us" do you mean that you tried it?
In what way did it not work?

Tim Lucia <[EMAIL PROTECTED]> wrote:
> We do the same thing, based on the "rumors" I read at the time I set it
up.
> (Where "rumors" means that googling for expire_logs_days reveals many
with
> problems and not much good news.)

Has anyone here had direct experience with expire_logs_days either
working or not working?  What happened?

(note: I'm running 5.0.24)

  --  Cos (Ofer Inbar)  --  [EMAIL PROTECTED]
   "OSI is a beautiful dream, and TCP/IP is living it!"
 -- Einar Stefferud <[EMAIL PROTECTED]>, IETF mailing list, 12 May 1992

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL 64 bits

[Juan Eduardo Moreno]

Oie,

Sim, é seguro usar MySQL 64Bits.

Is safe to use MySQL 64Bits, much better Innodb.

Only try to understand that + 10% of Memory is use for 64 bit.

For example : total memory 4G ( OS 10% + IO 10% + database 70% + 10% for use
64Bit). You must reserve this 10% in the ecuation.

Any help, please, send a email or call me : 21 86391874

Regards,
Juan


On 4/10/07, Dyego Souza Dantas Leal <[EMAIL PROTECTED]> wrote:


I want to use Debian 4.0 x64 with MySQL 64 bits... (5.0 version) and
InnoDB tables

is it safe ?


is it stable ?

is it ready for enterprise production ?


TNKS !

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]

Re: Database creation question

[Juan Eduardo Moreno]

In your conf file, please add :

Previously create a temp directory


[mysqld]
tmpdir=/usr/local/mysql/temp


Regards,
Juan

On 3/20/07, Lopez, Denise <[EMAIL PROTECTED]> wrote:


That still didn't work.  I think I just need to restart the mysql
service.

Denise Lopez
UCLA Center for Digital Humanities
Network Services
Systems Engineer
337 Charles E. Young Drive East
PPB 1020
Los Angeles, CA 90095
310/206-8216

____

From: Juan Eduardo Moreno [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 20, 2007 4:03 PM
To: Lopez, Denise
Cc: mysql@lists.mysql.com
Subject: Re: Database creation question



Denise,

Hola!.

1) Connect to the system like root user

2) $ chown -R mysql:mysql /usr/local/mysql/

3) In oder to create user use :


mysql> GRANT ALL PRIVILEGES ON DATABASENAME.* TO USERNAME@"%"
   IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;

Regards,
Juan Eduardo

On 3/20/07, Lopez, Denise < [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> > wrote:

Hello everyone,

I had a really weird thing happen and I was wondering if anyone has seen

anything like this. From a shell command line I connected to a running
instance of mysql with the mysql -u root -p command. I successfully get
to a mysql prompt. I needed to create a new database and user for the
database.
mysql > create database 'database name';
mysql > grant all privileges on 'database_name'.* to [EMAIL PROTECTED]
identified by 'password';

These 2 commands finished successfully and when I run the show databases

command, my new database shows up.  I can exit back to shell prompt and
reconnect to mysql with the command above and it still displays the new
database.

Up to here is what I expected, here's the weird part.  With the username

and password from above I tried to create a table in my database and
received this error:

Can't create/write to file
'/usr/local/mysql/var/timetrackerdb/mytemp.MYI'
I google'd this and the only suggestion was the disk that mysql was
trying to write to was out of space.  So I checked the space on
/usr/local/mysql/var and there is plenty of room on the drive.

Come to find out that the database directory didn't get created in the
data directory where all the database directories are located.

Any ideas why the mysql process didn't create the database directory?  I
already checked permissions on the /usr/local/mysql root mysql 755 and
/usr/local/mysql/var mysql mysql 700.

Thanks in advance.

Denise Lopez
UCLA Center for Digital Humanities
Network Services
Systems Engineer
337 Charles E. Young Drive East
PPB 1020
Los Angeles, CA 90095
310/206-8216

Re: Database creation question

[Juan Eduardo Moreno]

Denise,

Hola!.

1) Connect to the system like root user

2) $ chown -R mysql:mysql /usr/local/mysql/

3) In oder to create user use :


mysql> GRANT ALL PRIVILEGES ON DATABASENAME.* TO USERNAME@"%"
  IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;

Regards,
Juan Eduardo

On 3/20/07, Lopez, Denise <[EMAIL PROTECTED]> wrote:


Hello everyone,

I had a really weird thing happen and I was wondering if anyone has seen
anything like this. From a shell command line I connected to a running
instance of mysql with the mysql -u root -p command. I successfully get
to a mysql prompt. I needed to create a new database and user for the
database.
mysql > create database 'database name';
mysql > grant all privileges on 'database_name'.* to [EMAIL PROTECTED]
identified by 'password';

These 2 commands finished successfully and when I run the show databases
command, my new database shows up.  I can exit back to shell prompt and
reconnect to mysql with the command above and it still displays the new
database.

Up to here is what I expected, here's the weird part.  With the username
and password from above I tried to create a table in my database and
received this error:

Can't create/write to file
'/usr/local/mysql/var/timetrackerdb/mytemp.MYI'
I google'd this and the only suggestion was the disk that mysql was
trying to write to was out of space.  So I checked the space on
/usr/local/mysql/var and there is plenty of room on the drive.

Come to find out that the database directory didn't get created in the
data directory where all the database directories are located.

Any ideas why the mysql process didn't create the database directory?  I
already checked permissions on the /usr/local/mysql root mysql 755 and
/usr/local/mysql/var mysql mysql 700.

Thanks in advance.

Denise Lopez
UCLA Center for Digital Humanities
Network Services
Systems Engineer
337 Charles E. Young Drive East
PPB 1020
Los Angeles, CA 90095
310/206-8216

Re: load sharing

[Juan Eduardo Moreno]

Complementing Chris :

Asume that your Application Server is
Tomcat.

BALANCING SERVERS:

You can implement some servers or appliance only for balancing your primary
connections. This servers or appliance you must implement using Hearbeat (
only). For example one of the balancing servers fail.

APPLICATION SEVER

Your x ( quantity) of applications servers receive the connections from
Balancing Servers and distribute across the diferent nodes of MySQL using
LVS. You must implement Hearbeat for each application server too ( just in
case of failure of some app. server).


DATABASE SERVERS

MySQL and multimaster replication, please see below
http://www.onlamp.com/lpt/a/6549


Technology : for OS try to use Linux, for Hearbeat try to use UltraMonkey (
www.ultramonkey.org) for Balancing try to use LVS ( Linux).


I hope this help.

Regards.
Juan Eduardo


On 2/26/07, Chris McKeever <[EMAIL PROTECTED]> wrote:


On 2/26/07, Chris W < [EMAIL PROTECTED]> wrote:

>
> Can someone here give some insight and suggest other options I could
> look into?

you could replicate all the data between web/application servers, and
use the local store as a read-only  database, and push all your
updates to a central update 'master' server.  You could also play with
multiple-master replication.


>
> --
> Chris W
> KE5GIX
>
> "Protect your digital freedom and privacy, eliminate DRM,
> learn more at http://www.defectivebydesign.org/what_is_drm";
>
> Gift Giving Made Easy
> Get the gifts you want &
> give the gifts they want
> One stop wish list for any gift,
> from anywhere, for any occasion!
> http://thewishzone.com
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]

Re: Qustion

[Juan Eduardo Moreno]

What a fu...?

On 2/24/07, nessah arezki <[EMAIL PROTECTED]> wrote:


Bonjour ;

  Je suis un étudiant en fin de cycle. Dans le
cadre de mon projet de fin d'étude, je devais transférer une base de données
sous Access à MySQL. J'ai effectué le transfère par Excel Mais j'ai trouvé
un problème ; les tables de MySQL ont une taille Limitée à 2048 KO et celles
que je désire transférer dépassent cette dernière. Veuillez m'informer s'il
y a possibilité de modifier cette taille et dans le cadre de possible, me
proposer une méthode de transfère.


   Merci.


-
Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions
! Profitez des connaissances, des opinions et des expériences des
internautes sur Yahoo! Questions/Réponses.

Re: backup stratergy

[Juan Eduardo Moreno]

Ananda,

For Innodb the best is Innodb Hot Backup ( www.innodb.com (US$) )

For MyISAM you can use a simple backup ( copy/paste) of your files. Also,
you can do snapshots using mysqldump.

Also, you can use Zmanda ( www.zmanda.com).

Regards,
Juan Eduardo


On 2/23/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:


Hi All,
Can you please direct me to any good documentation for a good backup and
recovery stratergy for MyISAM and INNODB in mysql.

regards
anandkl

Re: Abnormal mySQL service behavior / 5.0.26

[Juan Eduardo Moreno]

On 2/16/07, Mark Papadakis <[EMAIL PROTECTED]> wrote:


Good day,




R: are you using MyISAM or InnoDB tables?

For the past 2 weeks, we have been dealing with some rather strange

problems.
While nothing changed in terms of the mySQL server or clients
configuration ( including the options provided to the server during
startup, by either my.cnf or as arguments to the executable ), we are
getting the following kind of errors.



o Server shutdown in progress



R: Could be any fatal error in mysql that produce this "server shutdown in
progress"

o Out of memory (Needed 5256540 bytes)



R: What is your sort_buffer_size setting?

o Sort Aborted


R: filesort.cc ..The error 'Sort aborted' comes if the sort function fails
for some reason. You can try identified what query is a cause of error.

o o Can't create a new thread (errno 11); if you are not out of

available memory, you can consult the manual for a possible
OS-dependent bug
o Unknown Error ( this occurs more often than the rest )




R: What say the  error file in specific?

There is plenty of memory on the system, as much as there was before

the problems surfaced.

We moved a database from that system, to another system ( that
database was the one hit more often ) in hope to perhaps solve the
problem. Indeed, the errors are coming up less frequently now, but
they still do.




R: It`s a correct version of MySQL for your OS?

Is there any chance this is due to tables corruption or corruption of

any other kind on the server side? I didn't see any bug fixes in 0.27+
revisions that seem to be related to this problem, so I assume its not
a bug that existed in <= 0.26.




R: Can you try to upgrade your mysql to 5.0.27?.

Any ideas ?



R: Can you delete your installation of mysql and reinstall it ( install
5.0.27)?

Thank you very much in advance.


PS: Please reply to this email address as well, if possible.






--

MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]

Re: How can I detect if MySql is already installed?

[Juan Eduardo Moreno]

Linux :

$ rpm -qa |grep -i mysql

Regards,
Juan

On 2/14/07, Zsolt Csillag <[EMAIL PROTECTED]> wrote:


Hello,

I would like to create a setup program for my demo version that uses MySql
database.

I need to detect if the target computer has already got the MySql
installed
because I don't want to ruin an existing database.

Is there any method to detect it?

Thank you in advance

--
Zsolt Csillag

Re: 2 ways replication

[Juan Eduardo Moreno]

Dear all,


We can view interesting tipic into :  http://www.onlamp.com/lpt/a/6549


Regards,
Juan Eduardo


On 2/12/07, Atle Veka <[EMAIL PROTECTED]> wrote:


2 way replication, also referred to as dual master replication, has been
available for quite some time. However implementation can be tricky. Look
for the "Dual master" section in chapter 7 of the High Performance MySQL
book:
http://dev.mysql.com/books/hpmysql-excerpts/ch07.html

If you need more than 2 masters, then all bets are off..


Atle


On Mon, 12 Feb 2007, Rilawich Ango wrote:

> Hi all,
>
>   I know it is an old question and I have read from the mysql website
> about the topic.  Until now, mysql still doesn't support 2 ways
> replication, quoted from mysql website.  As I have multiple location
> and each location will have a DB.  Most of all need to read and write
> to the database.
>
>   In my case, 2 ways replication is the most direct way to do it.  Any
> other solution is suitable for me to implement if 2 ways replication
> is not a good way?  Anyone has successfully implement 2 ways
> replication?  Any suggestion?
>
> 1PC-read/update-DB(a)  <--- 2 ways replication --> DB(b)-read/update-PC2
>
> ango
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL log_slow_queries Error

[Juan Eduardo Moreno]

Hi,

You can only set this parameters in order to monitoring slow queries:

long_query_time = 120 ( example of 2 minutes)
#log-long-format
#log-slow-queries=/var/log/slow-queries.log

You can enable and disable using  " # "


You set :

log=ON
log_slow_queries = ON
log_slow_queries=/var/log/slow-queries.log
long_query_time=10

MUST BE :

long_query_time = 120
log-long-format
log-slow-queries=/var/log/slow-queries.log


I think that 2 minutes ( for this type of log) is good number...2 minutes.
The queries for more than 2 minutes of elapsed time mysql write to this log
( slow log ).


Regards,
Juan

On 2/11/07, Pratchaya Chatuphian <[EMAIL PROTECTED]> wrote:


Hi , Everyone :: I need your help.

I have problem about mysql.
it about log_slow_queries

this is my.cnf file


[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
old_passwords=1
#skip-networking
skip-innodb
skip-bdb
skip-name-resolve
skip-locking
skip-character-set-client-handshake
skip-thread-priority
skip-name-resolve
log=ON
log_slow_queries = ON
log_slow_queries=/var/log/slow-queries.log
long_query_time=10
log-bin


And I have already create "slow-queries.log" in the "/var/log"
But I can't success use log_slow_queries
Caz, i see my log file ( /var/log/mysqld.log )


070212 00:00:05  mysqld started
^G/usr/libexec/mysqld: File '/var/log/slow-queries.log' not found
(Errcode: 13)
070212  0:00:05 [ERROR] Could not use /var/log/slow-queries.log for
logging (error 13). Turning logging off for the whole duration of the
MySQL server process. To turn it on again: fix the cause, shutdown the
MySQL server and restart it.
/usr/libexec/mysqld: ready for connections.
Version: '4.1.20-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306
Source distribution



PS.  " ls -l " in /var/log/

-rw-r--r--  1 mysql   mysql 0 Feb 11 21:32 slow-queries.log

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error starting service

[Juan Eduardo Moreno]

$ chown -R mysql:mysql yourdirectoryofmysql

On 1/31/07, WebIT <[EMAIL PROTECTED]> wrote:


Sorry, probably a really simple thing, but when I try and start mysqld it
fails.

[EMAIL PROTECTED] yum.repos.d]# /sbin/service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL:[FAILED]

I've checked the mysqld.log file and it has the following:

070131 09:34:17  mysqld started
070131  9:34:18  InnoDB: Started; log sequence number 0 43634
070131  9:34:18 [ERROR] /usr/libexec/mysqld: Can't create/write to file
'/var/run/mysqld/mysqld.pid' (Errcode: 13)
070131  9:34:18 [ERROR] Can't start server: can't create PID file:
Permission denied
070131 09:34:18  mysqld ended

I can't see what permissions it needs that are different.  Can anyone
assist?

Thanks
Nunners


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]

Re: Strange InnoDB Deadlock Behavior

[Juan Eduardo Moreno]

Jason,

I assume that your principal databases are INNODB databases.



Regards


On 1/17/07, Jason J. W. Williams <[EMAIL PROTECTED]> wrote:


Hi Juan,

Just wanted to touchbase and see if you had any suggestions based on
the my.cnf and machine config. Thank you in advance.

Best Regards,
Jason

On 1/15/07, Juan Eduardo Moreno <[EMAIL PROTECTED]> wrote:
> Jason,
>
> Send me a my.cnf in order to view your configuration ( using innodb
storage
> engine). Send me a configuration of your machine ( CPU and Memory).
>
> Regards
>

[client]
#password   = [your_password]
port= 3306
socket  = /tmp/mysql.sock

# *** Application-specific options follow here ***

#
# The MySQL server
#
[mysqld]

# generic configuration options
port= 3306
socket  = /tmp/mysql.sock
datadir = /node1_css_mysql
basedir = /opt/mysql-5.0.27
# back_log is the number of connections the operating system can keep in
# the listen queue, before the MySQL connection manager thread has
# processed them. If you have a very high connection rate and experience
# "connection refused" errors, you might need to increase this value.
# Check your OS documentation for the maximum value of this parameter.
# Attempting to set back_log higher than your operating system limit
# will have no effect.
back_log = 50

# Don't listen on a TCP/IP port at all. This can be a security
# enhancement, if all processes that need to connect to mysqld run
# on the same host.  All interaction with mysqld must be made via Unix
# sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
#skip-networking

# The maximum amount of concurrent sessions the MySQL server will
# allow. One of these connections will be reserved for a user with
# SUPER privileges to allow the administrator to login even if the
# connection limit has been reached.

# Modified by Juan
max_connections = 256
skip_name_resolve

# Maximum amount of errors allowed per host. If this limit is reached,
# the host will be blocked from connecting to the MySQL server until
# "FLUSH HOSTS" has been run or the server was restarted. Invalid
# passwords and other errors during the connect phase result in
# increasing this value. See the "Aborted_connects" status variable for
# global counter.
max_connect_errors = 10

# The number of open tables for all threads. Increasing this value
# increases the number of file descriptors that mysqld requires.
# Therefore you have to make sure to set the amount of open files
# allowed to at least 4096 in the variable "open-files-limit" in
# section [mysqld_safe]

# Modified by Juan
table_cache = 256

# Enable external file level locking. Enabled file locking will have a
# negative impact on performance, so only use it in case you have
# multiple database instances running on the same files (note some
# restrictions still apply!) or if you use other software relying on
# locking MyISAM tables on file level.
#external-locking

# The maximum size of a query packet the server can handle as well as
# maximum query size server can process (Important when working with
# large BLOBs).  enlarged dynamically, for each connection.

# Modified by Juan
max_allowed_packet = 32M

# The size of the cache to hold the SQL statements for the binary log
# during a transaction. If you often use big, multi-statement
# transactions you can increase this value to get more performance. All
# statements from transactions are buffered in the binary log cache and
# are being written to the binary log at once after the COMMIT.  If the
# transaction is larger than this value, temporary file on disk is used
# instead.  This buffer is allocated per connection on first update
# statement in transaction

# Modified by Juan
#binlog_cache_size = 1M
max_binlog_size= 1

# Maximum allowed size for a single HEAP (in memory) table. This option
# is a protection against the accidential creation of a very large HEAP
# table which could otherwise use up all memory resources.
max_heap_table_size = 64M

# Sort buffer is used to perform sorts for some ORDER BY and GROUP BY
# queries. If sorted data does not fit into the sort buffer, a disk
# based merge sort is used instead - See the "Sort_merge_passes"
# status variable. Allocated per thread if sort is needed.

# Modified by Juan
sort_buffer_size = 1M

# This buffer is used for the optimization of full JOINs (JOINs without
# indexes). Such JOINs are very bad for performance in most cases
# anyway, but setting this variable to a large value reduces the
# performance impact. See the "Select_full_join" status variable for a
# count of full JOINs. Allocated per thread if full join is found
join_buffer_size = 2M

# How many threads we should keep in a cache for reuse. When a client
# disconnects, the client

Re: Dual Hardisk

[Juan Eduardo Moreno]

Hi,

Your storage engine is Innodb?. If your answer is yes, please see below :

innodb_data_file_path=/u01/ibdata1:50M;/u01/ibdata2:50M*;/u03/ibdata3:100M *
You can create a new ibdata ( tablespace) in a new device :

1) Stop mysql
2) Change conf ( add new one tablespace)
3) start mysql

Regards,
Juan


On 1/11/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:


Hi,
I have a database named X on a hardisk, and  the hardisk can not store new
record because it has no space anymore. Can I just add a new hardisk and
ask
MySQL to store new record for database X to the new hardisk? Please share
me
the knowledge to do it, many thanks for your helps.

Regards


Willy


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]

Re: InnoDB vs MyISAM

[Juan Eduardo Moreno]

Octavian,


1) You can use MyISAM for example when you use static information in a
webpage. For example, only for store information of customers, something
like that..

2) Innodb is a engine that support ACID, you can use for  transactions.  For
example, load information of sales from PDA ( field) of a lot of sales man (
1000).

please see below

http://en.wikipedia.org/wiki/ACID


Bye,
Juan

On 1/4/07, Octavian Rasnita <[EMAIL PROTECTED]> wrote:


>
>> And is InnoDB recommended now?
> It depends.. :)

Depends on... what?

I mean, if I don't need transactions, is there another reason for using
InnoDB?
If it is necessary I can build the client program without foreign keys
support also.

Thanks.

Octavian


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]

Fwd: innodb_log_files_in_group

[Juan Eduardo Moreno]

FYI

-- Forwarded message --
From: Juan Eduardo Moreno <[EMAIL PROTECTED]>
Date: Dec 27, 2006 9:30 PM
Subject: Fwd: innodb_log_files_in_group
To: [EMAIL PROTECTED]

Dave,


The default (and recommended) is 2. The log files, save the trasactions into
file in circular order. This files are like a redolog files in oracle. This
log file are useful when you recover your database after some crash for
example or when you use a replication mysql.


innodb_buffer_pool_size you don`t have any restrictions ( normally 80% of
phisical mem).

Now, for the innodb_log_file_size ( 25% of buffer_pool_size) , the combined
size of the InnoDB log files must not exceed 4 GB. If you
have 2 log files, you can make each at most 2000 MB in size.

When you startup your MySQL using innodb, in your my.cnf you can set the
variable innodb_log_files_in_group. For example, if your set
innodb_log_files_in_group=2
( ib_log_file001, ib_log_file002 are created) the total size must not exceed
4G.

Regards,
Juan


On 12/27/06, David Sparks < [EMAIL PROTECTED]> wrote:


Is there any benefit/reason to set innodb_log_files_in_group to
something other than 2?

Thanks,

ds

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: socket error

[Juan Eduardo Moreno]

Waleed,


First, please try to upgrade your mysql.

Try to review in your my.cnf if your configuration socket appear two twice (
in two lines ).

Verify in your environment if your mysql is running using "ps -aux | grep -i
mysql".

$ service mysql stop
$ ps -aux | grep -i mysql
$ (if still running mysql) kill -9 
$ service mysql start

On 12/20/06, eng.waleed <[EMAIL PROTECTED]> wrote:


hi
I have this error on mysql engine Could not connect: Can't connect to
local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)
is there any suggestion my version is 3.23.58
BR

Re: ERROR 1114

[Juan Eduardo Moreno]

Raj,

Normally, if you have problem with your configurations, I suggest recreate
your databases :

1) backup all your database using mysqldump

*$ mysqldump --opt --user=root --password= --databases db1 db2 db3
db4  > /your/directory/of backups/backup.databases.dmp*
**
**
2) delete your databases

3) modify your configurations using 3 or 4
ibdata1:1900;ibdata2:1900;ibdata3:1900 ( my.cnf).

$service mysql stop
$service mysql start

4) load your initial backup into mysql
Option 1:
mysql > set foreign_key_checks=0
mysql > set autocommit=0
mysql > source backup.mysql.dmp ( your possition must be of the file of
backup)

option 2 :


*$ mysql --user=root --password= < backup.mysql.dmp*


Comments : You can use innodb_file_per_table , but if you say that your
files can grow only 2G could be dangerous.

On 12/20/06, Raj Shekhar <[EMAIL PROTECTED] > wrote:


[EMAIL PROTECTED] wrote:

> In my configuration file there was a line that said:
> innodb_data_file_path = ibdata1:10M:autoextend:max:1900M
>
> This refers to the data file that contains all of my databases.  The
> number
> 1900M is close to the 2G filesize limit on my linux server.  With all of

> the chatter about other causes of Error 1114, I'd missed that this file
> had grown to it's limit.


A small suggestion that you may find useful.  You could have used
'optimize
table' to free up some space.  To make it easier to run optimize table,
you
can put in the 'innodb_file_per_table' into your my.cnf. This will create
each table in its own file/tablespace, thus making it easier for optimize
to run faster.  However, this option only affects new tables.  Old tables
would still live in the shared ibdata file.

--
raj shekhar
facts: http://rajshekhar.net | opinions: http://rajshekhar.net/blog
I dare do all that may become a man; Who dares do more is none.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]

Re: innodb_buffer_pool_size. How to setup with more than 5G ?

[Juan Eduardo Moreno]

Remigiusz,

If you work with 32bit OS you need apply hugemem package for work with big
memory settings.


I work with 64bit OS and you don`t need apply any package. In order to add
more memory for the Innodb using innodb_buffer_pool_size you don`t have any
restrictions. You can set 10G, 20G depend of your phisical memory.

Now, for the innodb_log_file_size, the combined size of the InnoDB log files
must not exceed 4 GB. If you
have 2 log files, you can make each at most 2000 MB in size.

When you startup your MySQL using innodb, in your my.cnf you can set the
variable innodb_log_files_in_group. For example, if your set
innodb_log_files_in_group=2
( ib_log_file001, ib_log_file002 are created) the total size must not exceed
4G.

Regards,
Juan


On 12/18/06, Remigiusz Soko?owski <[EMAIL PROTECTED]> wrote:


Uz.ytkownik Juan Eduardo Moreno napisa?:
> Hi everyone!!
>
>
> Normally we can set the .._buffer_pool_size up to 50 - 80 % of RAM
> innodb_buffer_pool_size = 50% of phisical memory.
>
> And
>
> # Set .._log_file_size to 25 % of buffer pool size
> innodb_log_file_size = 25% of buffer pool size
>
> Now, we installed a machine using Linux Redhat ES with 16G of RAM.
> When try
> to configure, for example 50% of ram ( 8G) in the
> innodb_buffer_pool_size,
> the Innodb and MySQL startup but not create the innodb log file size.
>
> It`s necessary use any special configuration in order to use 50-80% of
> 16G
> RAM in the Inno_buffer_pool_size?. Hugemem for OS or something for
> innodb/mysql?.
>
> Today we only config 5G in the innodb_buffer_pool_size.
did You change settings for log file size, when You added memory?



--
---
Remigiusz Sokolowski <[EMAIL PROTECTED]>
WP/PTI/DIP/ZAB (+04858) 52 15 770
MySQL  v.  4.x
Oracle v. 10.x
---

innodb_buffer_pool_size. How to setup with more than 5G ?

[Juan Eduardo Moreno]

Hi everyone!!


Normally we can set the  .._buffer_pool_size up to 50 - 80 %  of RAM
innodb_buffer_pool_size = 50% of phisical memory.

And

# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 25% of buffer pool size

Now, we installed a machine using  Linux Redhat ES with 16G of RAM. When try
to configure, for example 50% of ram ( 8G) in the innodb_buffer_pool_size,
the Innodb and MySQL startup but not create the innodb log file size.

It`s necessary use any special configuration in order to use 50-80% of 16G
RAM in the Inno_buffer_pool_size?. Hugemem for OS or something for
innodb/mysql?.


Today we only config 5G in the innodb_buffer_pool_size.


Thank you,
Juan

Milliseconds of now()

[Juan Eduardo Moreno]

Hello!,


How can obtain the miliseconds of function of NOW()??


In the example  we can obtain only  0 ( zero)The result is zero.



*SELECT MICROSECOND(now());*


Thank you,
Juan