MySQL Replication Broken

Hi all, We have a pool of 8 MySQL servers where the first one is the master and the others 7 are slave. Yesterday we have a hard time where the server begin with too many lag ( 1 hour ) and then slaves start to fail with messages like this one thd=0x38f18130 Attempting backtrace. You

Re: INSERT DELAYED and logging

杨涛涛 *Stop top posting.* * * *thanks.* * * On Thu, Dec 23, 2010 at 12:16 AM, 杨涛涛 david.y...@actionsky.com wrote: Hi. I think if there are not some concurrency visitors, you should not use it. Otherwise, just put it. David Yeung, In China, Beijing. My First

Re: Autostart not working for me in 5.5.8 version

You are right. In previous version init script have a default value, now is empty. mysql 5.1..53 - basedir=/usr/local/mysql mysql-5.5.8 - basedir=. Cheers. On Thu, Dec 16, 2010 at 12:42 AM, Yangontha Maung yangontha5...@yahoo.comwrote: Hi, I will answer my own question. I have to

Re: Password Reset

SQL injection? Check Apache or whatever log files. On Thu, Dec 16, 2010 at 4:17 PM, Gary gp...@paulgdesigns.com wrote: I recieved a call from a client saying the web site did not work, turns out the database password was reset, and not by me. In looking in the DB after the PW was reset, I

BLOCK SELECT INTO OUTFILE ?

Hi, I am going to implement a mysql hosting, and I would to make a question, if a mysql-user with only a SELECT privilege make this query: SELECT * FROM table1 INTO OUTFILE '/mysqldb/data/test.sql'; the result is a file in this path with the content of the table. I could think that a malicious

security question CAN-2005-0709 CAN-2005-0710 CAN-2005-0711

Hi, I have installed binary mysql version 3.23.58 downloaded from www.mysql.org. In changelog from the documentation say that the release is from september 2003 and the security bug is in March 2005. What can I do ? How mysql provide updates? Thanks!! = Security info:

Re: security question CAN-2005-0709 CAN-2005-0710 CAN-2005-0711

I agree with you, I will upgrade . Thanks for the advice. On 8/16/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Alejandro [EMAIL PROTECTED] wrote on 08/16/2005 03:01:59 PM: Hi, I have installed binary mysql version 3.23.58 downloaded from www.mysql.org. In changelog

mysql decrypt

Hi, I´m developing a database with the aes_encrypt and aes_decrypt functions, with integrity constraints and varbinary types. My problem is that when I insert a row into a table, I encrypt with aes_encrypt, but when I desencrypt with aes_decrypt, it returns null with some values. The only way

MySQL 5.0.3 --no-auto-rehash

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

Re: MySQL 5.0.3 --no-auto-rehash

and this option it's not supported on 5.0.3? Alejandro. On Mon, 28 Mar 2005 14:21:28 -0600, Paul DuBois [EMAIL PROTECTED] wrote: At 16:30 -0300 3/28/05, Alejandro D. Burne wrote: Hi, I'm testing 5.0.3. I make a rpm update from 5.0.2. After it mysqld through mysqlamanager doesn't start. I'll

Re: MySQL 5.0.3 --no-auto-rehash

] interactive-timeout [EMAIL PROTECTED] etc]# On Mon, 28 Mar 2005 15:05:04 -0600, Paul DuBois [EMAIL PROTECTED] wrote: At 17:50 -0300 3/28/05, Alejandro D. Burne wrote: OK, I confuse a little, this is the message: [EMAIL PROTECTED] init.d]# /etc/rc.d/init.d/mysql start Starting MySQL/usr/sbin

RE: Multi-Table Query Problem...

Why don't you use Fulltext indexes, they are very fast and you use several columns. http://dev.mysql.com/doc/mysql/en/fulltext-search.html Best regards Alejandro -Mensaje original- De: nick [mailto:[EMAIL PROTECTED] Enviado el: Lunes, 14 de Marzo de 2005 05:59 p.m. Para: Mysql List

Version 5.0.3

Any idea 5.0.3 release date? There are many bugs fixed right now for 5.0.2! Alejandro -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Error on View

Hi, I installed the mysql 5.0.2 alpha for linux and i got an error after created a view and try to select * from the view. ERROR 2013: Lost connection to MySQL server during query Does anyone knows what is happening? Best Regards Alejandro

RE: Increasing the InnoDB log file size

Hello, I had the same issue myself, i read the manual and there says that you have to stop mysql, then change the parameter in my.cnf, then i moved to another directory the log file just to be cautious, and then restarted mysql. Everything went right. Best regards Alejandro -Mensaje

Re: Bug? Can't create/write to file '/root/tmp/ibu6vdue' (Errcode: 13)

Heikki I do it, in my.cnf on [mysqld] section I add: tmpdir=/tmp then I try: /usr/bin/mysqld_safe --tmpdir=/tmp --datadir=/var/lib/mysql --user=mysql with the same result If I change TMPDIR enviroment variable to /tmp works fine. I forgot to say I install mysql from rpm. Alejandro On Fri, 3

Temporary tables rights

how to deal with this? Alejandro -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Bug? Can't create/write to file '/root/tmp/ibu6vdue' (Errcode: 13)

041203 14:04:56 mysqld ended The only way to do work innodb is chmod 777 /root and /root/tmp, =( Alejandro -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RV: Innodb log file

Can't init databases 041028 0:10:49 Aborting thanks in advance Alejandro

Innodb log file

Can't init databases 041028 0:10:49 Aborting thanks in advance Alejandro

RE: Linking Mysql tables across databases

Hey Rob, If all the databases are on the same server you can point to every table just with DB_name.Tablename if you have the permissions. Best Regards Alejandro -Mensaje original- De: Rob Keeling [mailto:[EMAIL PROTECTED] Enviado el: Lunes, 06 de Septiembre de 2004 01:22 p.m. Para

Weird behavior on varchar fields

into the primary key to try to correct this, but is the same. We double check on the application and we have a lot of validation code to avoid this problem. Does anyone have any clue about it? Best Regards Alejandro

RE: help tuning a DB installation

Hi Jim, First of all, you should assingn a greater value for the key_buffer_size variable than 16k. This should help to reduce the readings on your hd. You should consider to set up the query cache. Best regards Alejandro -Mensaje original- De: Jim [mailto:[EMAIL PROTECTED] Enviado

Re[3]: Mysql growing pains, 4 days to create index on one table!

TABLE TMP; aaca -- aaca Alejandro D. Burne aaca Departamento de Sistemas aaca Asociación Médica Rosario aaca España 401 - S2000SBI aaca Rosario - Santa Fe - Argentina aaca +54-0341-4252313 Interno 145 I'm sorry this was an answer to Patrick Drouin -- Alejandro D. Burne Departamento de Sistemas

Index problem

Hi, i'm trying to create an index on a table with 199 million records. The problem is that is taking too long (8 hours and is not yet finnished). does anyone have any idea? the server is 2Xeon 2.8 gigs with 6 Gb of ram. Best regards Alejandro

RE: Index problem

operating system are you using? Redhat Linux 7.3 David Oropeza Querejeta, Alejandro wrote: Hi, i'm trying to create an index on a table with 199 million records. The problem is that is taking too long (8 hours and is not yet finnished). does anyone have any idea? the server is 2Xeon 2.8 gigs

Re: Memory to Memory INSERTS

. Does anyone know if the direct table/index insert idea is valid? At 09:43 AM 6/29/04, you wrote: Could Alejandro re-use the sections of the MySQL source code that handle replication and bin-logging to make his data capture application appear as a Master server and have his MySQL database act

Re: Memory to Memory INSERTS

Eric, I'm looking for a way to eliminate the construction, transmission, and parsing of the long multi-row INSERT queries that we are issuing from our client app. Since we are inserting 200k rows a shot, we're looking for every boost that we can find. * Connecting: (3) [want to use a

Memory to Memory INSERTS

Hi! I'm looking for a better way to insert large numbers of rows from a client application that is sampling physical data in real-time. In our case, we are using a C double hipvalues[100] cyclical array to buffer our sampled values. We're currently creating large query strings similar to:

INDEX DESC

Does anyone know when INDEX DESC will be implemented? I'm storing time values and want to access the data from the most recent time value without sorting the result set. Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: INDEX DESC

I don't see any relationship between your two sentences? Thanks for the responses. I guess I was not clear enough in my last post. You can define an index to sort values in a particular order... ASC is the default. DESC is an option, but it is not implemented yet. I want to know when it will

Re: INDEX DESC

That could be. If so, it's a MySQL 3.23 limitation that was fixed in MySQL 4.0. So, what we are agreeing on is that MySQL 4.x does in fact support both DESC and ASC indexes? If this is the case and we're doing something wrong here, cool! I definitely think the docs should reflect this

Data spikes and buffering inserts...

Hi! My MyISAM database works perfectly for 98% of the cases that we encounter. However, there are a few cases during our experiment that we know will cause spikes in dataflow. We know both the why and when, so we are trying to plan appropriately for it. Is there a way that I can mix in memory

thread_stack and out of memory issues...

Hi! My Config: Running Redhat 9.0 Linux 2.4.20-8bigmem SMP 8GB mem 250GB raid array My server: MySQL 4.1.2-alpha-standard We are running into strange memory related errors with our system. 1) Warning: Asked for 262144 thread stack, but got 126876 On start up, we get the above warning. How can I

RV: Select data from two different databases

Hi, two questions: Is it possible to select data from different Databases on the same server? Is it possible to select data from different Databases on Different servers across the network? I searched for information on how to do it, but i haven't found any. thanks in advance Alejandro

Select data from two different databases

Hi, two questions: Is it possible to select data from different Databases on the same server? Is it possible to select data from different Databases on Different servers across the network? I searched for information on how to do it, but i haven't found any. Best Regards Alejandro

Reinstall Windows.

I need to re-install windows, so I need to re-install mysql. How can I backup my databases so when I reinstall mysql put them to work again?, Thx in advance, Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Reinstall Windows.

I need to re-install windows, so I need to re-install mysql. How can I backup my databases so when I reinstall mysql put them to work again?, Thx in advance, Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Number of records returned

I'm testing store procedures, and I want to know the number of records returned from a query. There is a function or variable to get it through odbc? I'll be trying with mysql_num_results() but makes me en error(seems to be made for c api) selectfield1 from table where field2=1; select

Temporary tables rights

privileges. There is a problem with this because 'TMP%' as table_name doesn't work in tables_priv, you must insert many rows as many different temporary tables names you think use. The question is: There is a way to improve tmp rights management? I think this is a weak side of mysql. Thnks!

OT: MySQL NAT

Someone can make nat with mysql? I can do it with apache without problems, but mysql client freeze trying to connect. Thanx, Alejandro. _ IncrediMail - El E-mail ha evolucionado finalmente - Haga clic aquí

Execute shell script

There is a command or function to call a shell script through mysql? _ IncrediMail - El E-mail ha evolucionado finalmente - Haga clic aquí

deleting mysql users

Hi !! Whenever i create a database user using GRANT command, mysql add a register inside the user table in mysql database. I've noticed that if i use REVOKE to revoke all privileges from that user, mysql does not delete the register from user table, but denies every permission for that user.

Re: deleting mysql users

Thanks !! Do you happen to know why mysql decided not to erase those users?? On Fri, 10 Oct 2003 17:07:12 +0300 Victoria Reznichenko [EMAIL PROTECTED] wrote: Alejandro Javier Pomeraniec [EMAIL PROTECTED] wrote: Whenever i create a database user using GRANT command, mysql add

insert ... select .. order by, problem

Hallo everyone ! I already sent this, but I think some people think is not clear enough ;-) Im using Mysql 4.0.12 on RedHat 7.3 x86 I know it's not the last binary but I cannot upgrade now. (And i saw nothing about this in the changelog for 4.013 and 4.0.14) I found the following : I have two

Re: insert ... select .. order by, problem

Hi Stephan, Let's see the case : I use ORDER BY, because I want that order in PTemp table, so I do not have to order them later (because they are retrieved several times later). 1. Inserting with mysql c.l.i. : I get the records well sorted : first by a, secondly by b and finally by c

Re: copying a

Hey Enserink, your mail have virus!, please before sending mail please check your machine!!!. - Original Message - From: W. Enserink [EMAIL PROTECTED] Sent: Friday, August 01, 2003 8:43 AM Subject: copying a Hi all, Im in need of some tps. I want to copy a row in a table to a

Bug Report

__ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Bug Report, timestamp columns

Alejandro Paz Schmidt Republica Argentina __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Problems inserting a date...

I had a problem inserting a date...which format do I need to use?...I'm using -mm-dd, but when I throw a query, the records display -00-00. Thx in advance - Before posting, please check:

User Accounts...

How can I create different user accounts for a table?. (I've just installed the MySQL, and the root just don't have a password yet..how can assign one? Thxs in advance, Alex - Before posting, please check:

Always need to change to root user when I start the server

The problem is this. Always when I start the server, when I try to show the table mysql, I get an error message that saids Access Denied to user but when I put the same command with the --user=root it works. the question is: How can I start the server whit root priviledges? thxs. Alex.

Problems Configuring MySQL...

Hi all and thx in advance for trying to fix my problem. I'm instaling for the first time MySQL and when I try to test the program, I receive an error like Cannot connect to localhost (100060)...How can I configure the MySQL. Thx again Alex

Bug?

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Alejandro D. Burne Sistemas AMR Asociación Médica de Rosario España 401 - Rosario (2000) Teléfono +54 (0341) 4252313 Int.145 Santa Fe - Argentina ICQ #4304494

Help needed with C program + Mysql

I have defined a Mysql table with some integer variable, I can put NULL values in these elementes, but when I user mysql_fetch_row, if there's some integer field with NULL value, the program fails with core dump. Where's the problem? Thanks in advance.

Re: error log

please, if somebody knows about this problem, help me regards alemo - Original Message - Hello, I've updated my mySQL from version 3.21 to 3.23, and (after this change) all of my perl programs which use mysql, prints to STDERR, a debug (?) message like this: SV = RV(0x84ec388) at

error log

Hello, I've updated my mySQL from version 3.21 to 3.23, and (after this change) all of my perl programs which use mysql, prints to STDERR, a debug (?) message like this: SV = RV(0x84ec388) at 0xb2f0 REFCNT = 1 FLAGS = (ROK,READONLY) RV = 0x8552d3c Then, I updated the mySQL version to

Can I use the concept of Effective Date with MySQL?

statment ? I've been searching for this for hours and could not fnd a solution with MySql. Thanks! Alejandro [EMAIL PROTECTED] _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com

MySQL dead during an Access/Odbc query

wrong? Thanx, and sorry for my poor english. _- - - - - - - - - Alejandro Alfonso Fernández - - - - - - - - - /\___/\ Grupo Universitario de Informática - Diplomatura en Estadística /__\ _\/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - /_/\_\ - Lo

Re: MySQL and PHP Question

Adrian D'Costa wrote: Hi, I have two tables city and country +---+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-++ | id|

normal cpu usage

Hi guys..would you be so kind to tell me what's the normal % of cpu usage per mysqld thread? i get some 10.5 or 12 % peaks, which frighten me a lil' bit. Thanks! AML

copying table

I have a calendar db, and in there a base table (with holidays and such). I need to create a table, exactly the same as the base (data included). Is there an easy way of doing this?.. Alejandro Lujan Toro CAI: Centro de Aplicación de la Informática

Multiple installations of MySQL

Hello, We are programming the Control Panel of an Internet Data Center. They are going to install MySQL for each user in ther domain and they will assign a port to each installation of MySQL. If it possible to access the specific intallation of each user in a different port with PHP. How