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 ca

Re: INSERT DELAYED and logging

杨涛涛 *Stop top posting.* * * *thanks.* * * On Thu, Dec 23, 2010 at 12:16 AM, 杨涛涛 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 Blog:http://yueliangdao0608.cublog.cn > My

Re: Password Reset

SQL injection? Check Apache or whatever log files. On Thu, Dec 16, 2010 at 4:17 PM, Gary 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 could find nothing out

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 wrote: > Hi, > > I will answer my own question. > > I have to add a line in (/etc

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 maliciou

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 ve

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: http://cve.mitre.or

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 I

Re: MySQL 5.0.3 --no-auto-rehash

= 2M [mysqlhotcopy] 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.

Re: MySQL 5.0.3 --no-auto-rehash

.cnf came from 5.0.2 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. >

MySQL 5.0.3 --no-auto-rehash

ell what is it? Thnx. Alejandro -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

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

Temporary tables rights

mb time). Someone have an idea 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]

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

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

4:04:56 [ERROR] Aborting 041203 14:04:56 [Note] /usr/sbin/mysqld: Shutdown complete 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

ven, we tried to set the field 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!

DD PRIMARY KEY(hdr_code); aaca> SELECT d.* FROM details d INNER JOIN tmp aaca> ON d.hdr_code=tmp.hdr_code WHERE ...; aaca> DROP TABLE TMP; aaca> -- aaca> Alejandro D. Burne aaca> Departamento de Sistemas aaca> Asociación Médica Rosario aaca> España 401 - S2000SBI aa

RE: Index problem

-huge.cnf What 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 an

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: 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 connect

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 datab

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

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 functiona

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 b

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:http://lists.mysql.com

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 i

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 hel

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 PROT

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 PROT

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)   select field1 from table where field2=1; select

Temporary tables rights

full 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 sid

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í

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í

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 usi

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. Wh

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 (ascendig

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: 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 ta

Bug Report, timestamp columns

f almost 1 second between the first select and the update, because the column `b' takes the current time!. Only happens with timestamp columns not with datetime ones. I hope it will help you to make MySQL better. For further information, please don't hesitate to contact me at: [EMAI

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 PRO

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: http://www.mysql.com/manual.ph

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: http://www.mysql.c

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

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 4

Can I use the concept of Effective Date with MySQL?

) to be used in a WHERE 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 addr

Date format problem

e, %Y-%m-%d)" It doesn't work fine Thanks a lot for your time Lic. Alejandro Ralla Districomp S.A Magallanes 1688 Montevideo 11200 Uruguay (5982)400-1115 int 119 [EMAIL PROTECTED] www.districomp.com

MySQL dead during an Access/Odbc query

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

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

Mysqld eats up RAM and CPU

Hi There.. I'm running mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686) on a RedHat 6.1 Os. The server is installed and the configuration is almost by default. The problem is that most of the time the mysqld threads eat up my RAM and CPU! The server gets very slow at times and it (obvi

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 ca