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/
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
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
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,
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,
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
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.
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
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]
, 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
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:
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:
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
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
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
|
+---+--+---+--+-+--+---+---+
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
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
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
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
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,
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
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,
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
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
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
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
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
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
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
$ 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
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
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,
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 (
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
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
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
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
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
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
39 matches
Mail list logo