RE: mysqldumpslow output interpretation

Hi List, Any update on this Thanks Anil Hi List, Below is the output of mysqldumpslow. In the output query execution time is showing -ve value how to interpret the below output i.e how to interpret -ve value for query execution time please advice Count: 1 Time=4294967223.00s

RE: backup/restore

Hi, with which options of mysqldump you have taken backup. if you use --add-drop-table option then it will add drop table statement in dump file. otherwise it wont add that statement and you will get that type of errors. if you didn't use that option then drop the schema and then try to restore

RE: User can't login to his DB.

Hi, after granting privileges did you executed flush privileges command. if not execute below command and then check mysql flush privileges; thanks Anil -Original Message- From: sam [mailto:[EMAIL PROTECTED] Sent: Monday, January 03, 2005 9:09 AM To: mysql@lists.mysql.com Subject:

RE: backup/restore

and child tables Please advise me, how to get rid of the above error messages. Thanks, Narasimha -Original Message- From: Anil Doppalapudi [mailto:[EMAIL PROTECTED] Sent: Monday, January 03, 2005 7:03 PM To: Lakshmi NarasimhaRao (WT01 - TELECOM SOLUTIONS); [EMAIL PROTECTED] Cc: mysql

RE: Regarding User creation and loading data

use root user of mysql. u wont get any privilege restrictions with root user. other wise the user you are using should have file privilege to load data from file or to write to a file Thanks Anil -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday,

RE: Restore help! been going 2 weeks

22, 2004 7:12 PM To: Anil Doppalapudi Cc: mysql@lists.mysql.com Subject: Re: Restore help! been going 2 weeks Those are pretty much standard settings I had ours set almost exactly like that, and performance was worse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

RE: mysqldump and innodb - set foreign_key_checks=0

just write the below lines of code to a file in the location where your mysqldump file exists SET FOREIGN_KEY_CHECKS = 0; SOURCE dumpfile name; SET FOREIGN_KEY_CHECKS = 1; then execute the following command mysql filename Thanks Anil DBA -Original Message- From: Heikki Tuuri

RE: myql command-line no warning

after executing command. use the below command to know the warnings it is throwing mysql show warnings; Thanks Anil -Original Message- From: Qunfeng [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 22, 2004 10:45 AM To: Paul DuBois; mysql@lists.mysql.com Subject: Re: myql

RE: Need more info about currently running queries

may be due to corrupted indexes it is taking long time. just re-org the table.if your table is InnoDB type then use below command to re-org it. mysql alter table table name type=InnoDB; based on size of the table it may execute for long time . for us it has solved performance issue. Thanks

Monitoring replication in mysql

Hi, we have no of mysql replication setups in our setup. how to monitor those replication setups.my aim is if any slave goes down my script should immediately send an alert mail to me. if anybody having already developed scripts please let me know otherwise just give me an idea what to monitor

RE: Restore help! been going 2 weeks

: Monday, December 20, 2004 5:56 PM To: matt_lists Cc: Anil Doppalapudi; [EMAIL PROTECTED] Subject: Re: Restore help! been going 2 weeks matt_lists wrote: Can you post your my.ini or my.cnf sense your restore actually worked Mine is not swapping, in fact, mysql is only using 610,824 K of ram

RE: Restore help! been going 2 weeks

: matt_lists [mailto:[EMAIL PROTECTED] Sent: Friday, December 17, 2004 12:11 AM To: Anil Doppalapudi Cc: [EMAIL PROTECTED] Subject: Re: Restore help! been going 2 weeks Anil Doppalapudi wrote: it is not normal. i have restored 90 GB database in 2 days on dell server with 2 GB RAM. Are you able

RE: mysql_install_db problem!!

check the privileges on directories. that error you generally get when user dont have sufficient privileges on directories. please go through the installation steps given in mysql documentation Anil -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: Thursday,

RE: Restore help! been going 2 weeks

of this limitation I tested with InnoDB and found it horribly slow for what we do Anil Doppalapudi wrote: check your .myd file size. if table type is myisam and it it is more than 4 GB then convert it to InnoDB. --Anil -- MySQL General Mailing List For list archives: http

creating mysqldump log file

Hi, Is there any way to create a log file for mysqldump just like oracle export log file i.e what tables exported no of rows exported like that Thanks in advance Anil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

RE: Are these variables healthy?

hi you can find mysql recommendations of my.cnf parameters based on on RAM size in /usr/local/mysql/support-files with file name my-huge.cnf go through those files and set parameters accordingly for most of databases it will work fine. Anil -Original Message- From: Fagyal Csongor

RE: Deleting redundant rows

create a unique key on city,cc columns with ignore option of alter table it will keep the first row and deletes redundant rows. check the below link for alter table syntax http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html Anil -Original Message- From: Walter Pucko [mailto:[EMAIL

RE: Restore help! been going 2 weeks

check your .myd file size. if table type is myisam and it it is more than 4 GB then convert it to InnoDB. --Anil -Original Message- From: matt_lists [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 14, 2004 8:36 PM Cc: [EMAIL PROTECTED] Subject: Re: Restore help! been going 2 weeks

How to rebuild indexes in InnoDB

Hi, any one give me an idea how to rebuild indexes in InnDB database. database users are complaining that response time is slow. right now what I am doing is dropping indexes on table and recreating them. After that Database is working fine for some days and again it is giving problem. dropping

RE: Increasing the InnoDB log file size

Hi, First shutdown the mysql cleanly. #mysqladmin shutdown then drop log files in data directory. restart mysql. it will create new log files. Thanks Anil NOC -Original Message- From: Ronan Lucio [mailto:[EMAIL PROTECTED] Sent: Friday, December 10, 2004 11:08 PM To: [EMAIL

RE: Increasing the InnoDB log file size

if mysql shutdowns cleanly. then there is no chance of loosing data. for safe side take compleate database backup. -Original Message- From: Ronan Lucio [mailto:[EMAIL PROTECTED] Sent: Friday, December 10, 2004 11:39 PM To: Anil Doppalapudi; [EMAIL PROTECTED] Subject: Re: Increasing

RE: max allowed packet error

follow these steps 1) first shutdown the database mysqladmin shutdown 2) Start the mysqldeamon bin/safe_mysqld --max_allowd_packet=16M --user=mysql 3) to check what max allowd_packet it is using mysqladmin variables in the out-put check the value of variable max_allowed_packet

my.cnf parameter settings for 4 GB RAM

please provide me listof my.cnf parameter values for 4 GB RAM . from support files i can list out only upto 2 GB RAM my database is mysql 4.0.20 binary installation on linux and along with database apache, tomcat and one more application is running on the server. Thanks in advance Anil --

Incremental backups in Mysql

Is it possible to take incremental backups in mysql.if yes please provide me links or info on it Thanks Anil DBA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mysqldump very slow

mysqldump running very slow. what might be the reason Server details === Dell RAM : 4 GB Innodb_buffer_pool_size : 1000MB i am using --quick option in mysqldump Thanks Anil DBA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

RE: Mysqldump very slow

. Good answers depend on good questions. But a hint: You can't expect mysqldump to run in fractions of seconds. Depending on database size, it is quite normal for it to take some minutes. Stefan Am Thursday 28 October 2004 13:48 schrieb Anil Doppalapudi: mysqldump running very slow. what might

How to flush process which are in sleep state

Hi, when i issue show processlist command it gives very long list of process most of them are sleep state . is there a way to clear those processs with out killing them Thanks in advace ANil DBA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Table creation Time stamp

Hi, where can we find the time stamp of table creation i.e when that table was created Thanks Anil DBA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MySql Configuraton on Redhat

use the command below mysqladmin -u root -p options supply the passwd when prompted Anil DBA -Original Message- From: Kamal Ahmed [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 13, 2004 8:35 PM To: Kamal Ahmed; [EMAIL PROTECTED] Subject: MySql Configuraton on Redhat Hi, This is

RE: Create Table Error 1071

There might be limitation on length of index in mysql try this CREATE TABLE `adminpages` ( `adminpageid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT , `file_name` VARCHAR( 250 ) NOT NULL , `page_title` VARCHAR( 250 ) NOT NULL , PRIMARY KEY ( `adminpageid` ) , INDEX ( `file_name` , `page_title` )

RE: Read-Only DB User

First connect to mysql as root user and issue the following command grant select on databasename.* to username@ipaddress identified by 'passwd'; flush privileges; it will grant only select privilege to the newly created user on database and he can only connect from the ipaddress specified in

Restoring few tables from all-databases dump file

Hi, Regularly we maintain backup of all databases using mysqldump utility. Most of the times i am getting requests from our QA department to restore a particular table or particular database to check purging scripts and other scripts. Is there any way to restore a particular table or databases

Reg : eliminating duplicate entries

Try this Take dump of table using mysqldump utility eg : mysqldump db name tablename --quick --allow-keywords --no-create-info dumpfilename Then truncate table data eg: mysqltruncate table tablename; create primary or unique keys what ever you want on table Then restore the data from dump

RE: How to extract Particular Tables from a Dump file taken with mysqldump

The actual problem is we maintain regular all-databases mysqldump.it is a automated script and after taking complete backup we purged data later we identified that some required data is missed in a particular table. so we require restore of only that particular table. we tried extracting only