Re: mysql x64en server 64 bits

2008-07-03 Thread Juan Eduardo Moreno
Hi, Try to download using the mirror called : United States of America [X10 WTI / Seattle, WA] HTTPhttp://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-essential-5.0.51b-winx64.msi/from/http://mirror.x10.com/mirror/mysql/

Re: mySQL support required

2008-06-09 Thread 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

Re: purge binary logs on master

2008-05-17 Thread 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

Re: master - slave replication - slave not updating

2008-05-16 Thread 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,

Re: master - slave replication - slave not updating

2008-05-16 Thread 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,

Re: changing 'max_allowed_packet'

2008-05-16 Thread 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

Re: innodb disabled

2008-05-06 Thread 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.

Re: innodb disabled

2008-05-06 Thread Juan Eduardo Moreno
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

Re: MySQL (mysql-5.0.54)

2008-05-06 Thread 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]

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

2008-04-28 Thread Juan Eduardo Moreno
, 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

Re: Performance problem MySQL 4.0.20

2007-07-03 Thread 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:

Re: only select privilege

2007-06-08 Thread 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:

Re: Alternative command of SET GLOBAL SQL_SLAVE_SKIP_COUNTER

2007-06-08 Thread 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

Re: error after system setup/replication

2007-06-05 Thread 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

Re: Problem with compex query

2007-05-22 Thread 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

Re: Problem with compex query

2007-05-22 Thread Juan Eduardo Moreno
| +---+--+---+--+-+--+---+---+ 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

Re: Problem with compex query

2007-05-22 Thread Juan Eduardo Moreno
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

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

2007-05-09 Thread 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

Re: expire_logs_days

2007-05-02 Thread 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

Re: MySQL 64 bits

2007-04-10 Thread 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,

Re: Database creation question

2007-03-21 Thread Juan Eduardo Moreno
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

Re: Database creation question

2007-03-20 Thread 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,

Re: load sharing

2007-02-26 Thread Juan Eduardo Moreno
Complementing Chris : http://www.onlamp.com/lpt/a/6549Asume 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

Re: Qustion

2007-02-25 Thread 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

Re: backup stratergy

2007-02-23 Thread 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

Re: Abnormal mySQL service behavior / 5.0.26

2007-02-16 Thread 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

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

2007-02-15 Thread 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

Re: 2 ways replication

2007-02-13 Thread 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

Re: MySQL log_slow_queries Error

2007-02-11 Thread 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

Re: Error starting service

2007-01-31 Thread 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

Re: Strange InnoDB Deadlock Behavior

2007-01-18 Thread Juan Eduardo Moreno
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

Re: Dual Hardisk

2007-01-12 Thread 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,

Re: InnoDB vs MyISAM

2007-01-04 Thread 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 (

Fwd: innodb_log_files_in_group

2006-12-27 Thread 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

Re: socket error

2006-12-21 Thread 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

Re: ERROR 1114

2006-12-20 Thread 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

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

2006-12-18 Thread Juan Eduardo Moreno
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

innodb_buffer_pool_size. How to setup with more than 5G ?

2006-12-12 Thread 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

Milliseconds of now()

2006-12-04 Thread 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