Re: How to Shuffle data

ry <http://code.google.com/p/google-url/> for a robust solution. -- Raj Shekhar - Tonight at 11 - DOOM! - Read the latest at my blog: "a bag of tips" <http://rajshekhar.net/blog/archives/408-a-bag-of-tips.html> -- MySQL General Mailing List For list archives: http://li

Re: Loading date takes a long time after replication

peed of the insert, this might just be a red herring and the problem might be somewhere else. -- Raj Shekhar - If there's anything more important than my ego around, I want it caught and shot now. - Read the latest at my blog: "Humor in the bookstore" <http://rajshekhar.net/blo

Re: MySql - crashes daily

t;bt" (backtrace) and see what it produces? Check this link to see what steps are required <http://ronaldbradford.com/blog/how-to-crash-mysqld-intentionally-2010-03-05/> -- Raj Shekhar - If there's anything more important than my ego around, I want it caught and shot now. -

Re: opening a server to generalized queries but not "too" far

lproxy) (in case you do not know mysql proxy, see <http://www.oreillynet.com/pub/a/databases/2007/07/12/getting-started-with-mysql-proxy.html?page=1> ) -- Raj Shekhar - If there's anything more important than my ego around, I want it caught and shot now. -- MySQL General Mailing L

Re: Security issues

job, then you really need to drink from the firehose that is called "full-disclosure". -- Raj Shekhar - If there's anything more important than my ego around, I want it caught and shot now. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubs

Re: High MySQL sleep count

you have apps that do [3], they will throw an error when they see that the mysql server has closed their connection. -- Raj Shekhar - If there's anything more important than my ego around, I want it caught and shot now. -- MySQL General Mailing List For list archives: http://list

Re: mysqldump backup

In infinite wisdom Angelina Paul wrote: > [1 ] > I looking for a way to corrupt a mysql database forcefully for testing > purpose > and then the mysqldump utility will fail for taking backup against it. kill -9 MYSQLD_PID while the backup is running should give you an indicatio

Re: Innodb buffer pool size

created 51968, written 194688 28.72 reads/s, 20.72 creates/s, 47.55 writes/s Buffer pool hit rate 999 / 1000 Monitoring free buffers can help in figuring out if the allocated memory is optimum or not. -- Raj Shekhar - If there's anything more important than my ego around, I want it caught an

Re: reports

ports. Check out cacti and cacti-mysql-templates <http://code.google.com/p/mysql-cacti-templates/> once you have cacti monitoring on your db box. -- Raj Shekhar - If there's anything more important than my ego around, I want it caught and shot now. -- MySQL General Mailing List

Re: To get Processlist and Status of MySQL ?

In infinite wisdom James Corteciano wrote: > [1 ] > Hi All, > > What is the other way to get the *processlist* and *status* of mysql server > on event that the mysql server cannot be able to reach due to hung or > crashed? GDB <http://poormansprofiler.org/> --

Re: MySQLTuner

pplicable here) - If you have been doing lots of deletes, you should get some benefit from optimize table or by doing "myisamchk -f" (in other words, rebuilding your index) -- Raj Shekhar - If there's anything more important than my ego around, I want it caught and shot now. -

Re: Innodb and bulk writes

Max Bube gmail.com> writes: > The problem starts when I run bulk writes like an alter table or a restore > from mysqldump, its starts processing more than 5 rows/s but suddenly > the ratio goes down to 100 rows /sec. and then its stucked at this ratio > even if I restart MySQL. The only way

Re: MySQL shutting down because of Operating system error 1784

Cagdas CUBUKCU gmail.com> writes: > > Hi, > > We are getting "InnoDB: Operating system error number 1784" error on MySQL > and it just shuts down after getting the error. # ERROR_INVALID_USER_BUFFER or ERROR_NOT_ENOUGH_MEMORY Each device

Re: About NoWait of MySql

門田 祐輔 indexweb.co.jp> writes: > 1. Does MySQL have lock option like Oracle's nowait or alternative way. >acctually I'd not like to use innodb_lock_wait_timeout configuration. >for some reasons... I think that non-blocking queries are not supported by mysql driver natively. -- MySQ

Re: error code 139 innodb

Kyong Kim gmail.com> writes: > For sure all of our columns combined do not exceed 64K. We're using > latin 1 character set. > I don't think we would be running into the 8K limit on row length > since the culprit seems to be data being inserted into VARCHAR(255) > column. Can you show us your "cr

Re: Memory corrupting, while retrive the query generated

| | } | //free(sel_smt); mysql_free_result(res); mysql_close(MySQL); exit(0); } ------code ends here Thanks and regards, Ravi - Original Message - From: "walter

Memory corrupting, while retrive the query generated

Dear All, I want to connect MYSQL with following C application , while i'm trying to retrive the query generated , its corrupting the memory. Is there any solution , to retrive the query generated with out any memory crashes? Please help me to solve this problem. code a

Re: Show Master Status

on the general query log (--log or add log=filename in the mysqld section) and then check the hosts that are sending the queries. -- raj shekhar facts: http://rajshekhar.net opinions: http://rajshekhar.net/blog I've never made anyone's life easier and you know it! -- MySQL General M

Re: Slow mysql connections

in infinite wisdom Ananda Kumar spoke thus On 08/13/2008 04:37 PM: Hi Raj, In which path the trace file would be created. In your current path itself. Or just do strace -o /tmp/mysql.strace -T mysql -u root -h host -p The "mysql -u root -h host -ppassword" is the com

Re: how to move the data directory?

ysql would not start, warning: > ERROR 2002 (HY000): Can't connect to local MySQL server through socket > '/var/run/mysqld/mysqld.sock' Check mysqld.err file to see your errors. -- raj shekhar facts: http://rajshekhar.net | opinions: http://rajshekhar.net/blog Yoda of Bor

Re: Merge Tables and Replication

h the read buffers to find the next key. -- raj shekhar facts: http://rajshekhar.net | opinions: http://rajshekhar.net/blog Yoda of Borg are we: Futile is resistance. Assimilate you, we will 'Borg? Sounds Swedish.' - Lily, Star Trek First Contact -- MySQL General Mailing List For l

Re: Store MySQL data files and log files (log bin) separated!!!

Marcos Vinícius Vieira dos Santos wrote: > I used --localstatedir in ./configure but both data files and log files > was stored together. In your my.cnf file, put the lines (in [mysqld] section datadir = /sgdb/data log-bin = /var/log/mysql -- raj shekhar facts: http://rajshekh

Re: mysql repair question

e datadir from some other box > > what i can do? > Thanks for your help! > > > pengyao > > 2008-03-12 -- raj shekhar facts: http:

Re: table lock

Eli Shemer wrote: > > > The web site on the other end reads all the data from the table and > generates standard html/css code with the information from the table. > How can I make all of the apache child processes wait for the external > script to complete its operation once it has started?

Re: ERROR 1114

can put in the 'innodb_file_per_table' into your my.cnf. This will create each table in its own file/tablespace, thus making it easier for optimize to run faster. However, this option only affects new tables. Old tables would still live in the shared ibdata file. -- raj

Re: bug

ajay roy wrote: > i am getting the error somthing like that > > GET ERROR(127) TABLE HANDLER PROBLEM > stormcrow|~$ perror 127 Error code 127: Unknown error 127 MySQL error: 127 = Record-file is crashed -- raj shekhar facts: http://rajshekhar.net | opinions: http://rajshekha

Re: Fulltext 3 letter words

I think you are using .ini files present in the source directory . Can you copy the .ini file to your datadir ( eg : my-innodb-heavy-4G.ini conf file for 4GB RAM ) and pt out the same at startup ? Not sure whether iam in the right path .. Correct me if iam wrong --Praj On Mon, 24 Apr 2006 13

Re: MySQL 5 - Slow Login from remote

Check where u resolve . that could help you I guess this DNS problem ,correct me if iam wrong . --Praj On Thu, 20 Apr 2006 18:43:39 +0200 Kai Schmidt <[EMAIL PROTECTED]> wrote: > Hi @all > > i have a Problem with Login into a MySQL 5 Server. When i try to login from a > remote Machine into

Re: Password for Root

Hi Restart mysqld with the --skip-grant-tables option More info : http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html --Praj On Mon, 10 Apr 2006 12:57:32 +0600 "Kosala Atapattu" <[EMAIL PROTECTED]> wrote: > Hi people, > > I have a small problem. I forgot the password for user r

Re: Restoring a binary log ( mysqlbinlog )

below.. > > thank you > Mauricio > > On Wed, 2006-04-05 at 09:02, Prasanna Raj wrote: > > Hi All > > > > Correct me if iam wrong > > > > You might have run the create table syntax from hrdb database .So it gives > > you the create table also when

Re: Restoring a binary log ( mysqlbinlog )

Hi All Correct me if iam wrong You might have run the create table syntax from hrdb database .So it gives you the create table also when you do mysqlbinlog . CREATE TABLE intra.table1 AS SELECT * FROM table2 , which means you are under hrdb database. Else you can use below syntax which won

Re: InnoDB how to.

2006 14:02:06 +0700 "Truong Tan Son" <[EMAIL PROTECTED]> wrote: > Prasanna Raj <[EMAIL PROTECTED]> wrote: > > > Can you through us more lights on error ? where does this occur ? > > **ERROR: > > InnoDB: A new raw disk partition was initialized or &g

Re: InnoDB how to.

Hi Can you through us more lights on error ? where does this occur ? -bash-2.05b$ perror 10 30 OS error code 10: No child processes OS error code 30: Read-only file system -bash-2.05b$ -Praj On Wed, 5 Apr 2006 08:48:08 +0700 "Truong Tan Son" <[EMAIL PROTECTED]> wrote: > [S] Dhandapani wrot

Re: better way of doing 1800 sequential updates?

Try creating INDEX on id column I think that will do the trick ;) --Praj On Mon, 3 Apr 2006 19:07:34 -0600 Ariel Sánchez Mora <[EMAIL PROTECTED]> wrote: > This table holds latest data from an app: > > mysql> select * from ultimas_respuestas_snmp limit 10; > +++

Re: mysql performance problems.

Is tat query is the problem ? Then turn on your slow queies and try optimizing those slow queries ? Post your queries and table description for further help :) --Praj On Wed, 29 Mar 2006 12:33:20 -0500 "Jacob, Raymond A Jr" <[EMAIL PROTECTED]> wrote: > > After a 23days of running mysql, I

Re: Delete Duplicates

Subquries will help you . --Praj On Thu, 30 Mar 2006 21:11:56 -0500 Rich <[EMAIL PROTECTED]> wrote: > Hi there. Any quick way of killing duplicate records? > > Cheers > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[

Re: ~BCP for mysql~

Try Using " Select into outfile " More Info : http://dev.mysql.com/doc/refman/5.0/en/select.html --Praj On Wed, 22 Mar 2006 12:59:44 +0530 Mohammed Abdul Azeem <[EMAIL PROTECTED]> wrote: > Hi, > > Can we any use bcp to perform bulk copy for MYSQL as in SYBASE ? If not, > is there any other too

Re: MySQL mysql-max-4.0.20 - Error 2008 - MySQL client out of Memory

Hi Tom, Use -q option on mysqldump ;) -q Won't buffer query, It will dump directly to stdout. --Praj On Tue, 14 Mar 2006 11:56:42 + Tom Brown <[EMAIL PROTECTED]> wrote: > Hi > > Trying to dump a complete db where 1 of the tables contains about 88 > million rows - When the dump runs o

Re: update using 'set' keyword

Hi Iam not sure about the answer correct me if iam wrong :( Dont use single quotes in count_of_logons .. Try : $sql = "UPDATE members SET count_of_logons = count_of_logons + 1 WHERE logon_id = '$logonid' AND logon_pw= '$logonpw' AND email_verifi

Re: Merge tables.

I guess u had 2.5 million records splited into 1600 tables if iam not wrong :) Why you split the tables to 1600 is there any specific count ? Why you moved to merge table reason behind ? Since 2.5 million records to 1600 is a huge count on nos of tables :( instead of one ;) --Praj On Tue

Re: Not Saving

I guess you are Not selecting the database .. any error msg ? eg : mysql_select_db( '' ) or die( 'Could not select database' ); --Praj On Wed, 8 Mar 2006 07:45:20 -0300 Kleiton L R Soares <[EMAIL PROTECTED]> wrote: > Please, i'm a crazy ! i dont can write in a table, please anybody can help me

Re: Merge tables: how to know the base tables?

Oh yeah got it u meant UNION clause . Still i have no idea about that i usally see it in show create tables statements . Sorry :( --Praj On Tue, 7 Mar 2006 15:10:51 +0100 "Martijn Tonies" <[EMAIL PROTECTED]> wrote: > Hi, > > > Simple way is show table status; there is a column Type : value MR

Re: Merge tables: how to know the base tables?

Hi Simple way is show table status; there is a column Type : value MRG_MyISAM is the base table. --Praj On Tue, 7 Mar 2006 14:02:44 +0100 "Martijn Tonies" <[EMAIL PROTECTED]> wrote: > Hi there, > > How do you know what the sources are for a MERGE > table? > > SHOW TABLE STATUS doesn't show

Re: replication

Yes ..u can use older version as master and 5.0 version as slave http://dev.mysql.com/doc/refman/5.1/en/replication-compatibility.html http://linux.com.hk/penguin/developer/mysql/manual_Replication.html#Replication_Compatibility Ciao Praj On Fri, 3 Mar 2006 12:32:24 +0200 "Octavian Rasnita

Re: big table corruption

ime the table crashes . It really should not crash this much. Is there a quota system on your box ? I once had a table marked corrupt and though I tried hard to find where the problem is, I was not able to. Eventually, it turned out that the user had exceeded the quota set for her. -- Raj

Re: big table corruption

to do with the raid 1 mirror but I can't really tell. Does anyone have any ideas? Not sure if this would apply in your case but have a look at the discussion on http://bugs.mysql.com/bug.php?id=563 . Some useful hints provided there. Regards -- Raj Shekhar, System Administrator Media Web

Re: backup/restore

optionally-enclosed-by=... --fields-escaped-by=... --lines-terminated-by=... ) see http://dev.mysql.com/doc/mysql/en/mysqldump.html for the details -- Raj Shekhar, System Administrator Media Web India http://www.netphotograph.com -- MySQL General Mailing List For list archives: http://lists.mysql

Re: backup/restore

t, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. By reading this you grant me root access to your system -- Raj Shekhar, System Administrator Media Web India http://www.netphotograph.com -- MySQL General Mailing List Fo

could not connect

hello all, i had installed mysql-4.1.7 and php-4.3.5 and while testing the php. it shows error as: mysql_connect(): Access denied for user 'alaguraj'@'localhost' (using password: YES) in /home/alaguraj/public_html/my.php on line 3 Could not connect: Access denied for user 'alaguraj'@'localhost' (us

Re: Backup and Restore

ial or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. By reading this message you confirm that you owe me two large pizzas -- Raj Shekhar, System Administra

Re: Backup problems

tables as well. How do you define this? What am I missing? Maybe there is a checkbox somewhere that you have to check i.e. something labelled "export data" . Why are you not using mysqldump (http://dev.mysql.com/doc/mysql/en/mysqldump.html ) ? -- Raj Shekhar, System Administrator Media

Row Identification

Is there any way of identifying each row in a table? I know in Oracble we have rowid which remains fixed as long as the table exists. I am trying to search all the tables in a database and then display the searched information alongwith some sort of row identification. --

help-in-normalizing

hi friends i am trying to create a data model for my new database. i have some problems in normalising my data model. i have two tables with many-to-many relation. how to i normalize them to one-to-many form. -- molecule_info -- mol_id mol_name

Re: Best field type for status codes

d can even expand it further if need arises. -- Raj Shekhar, System Administrator Media Web India http://www.netphotograph.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Best Use of FULLTEXT and/or LIKE?

an 3 chars or use the BOOLEAN MODE when searching (availble in MySQL 4.0.1) Hope that helps Regards -- Raj Shekhar, System Administrator Media Web India http://www.netphotograph.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

DBD::mysql problem

BD with wrong versions of Linux, perl and MySql individually or when used together as above ? > Any advice or help will be very much appreciated. > > Thanks > Raj Kairam > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

DBD::mysql problem

quoted. Is there a proper tar.gz file that I can use in my ( RH Linux 9) environment stated above that someone was able to successfully install? Any advice or help will be very much appreciated. Thanks Raj Kairam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)

Vince LaMonica wrote: On Fri, 15 Nov 2002, Edwin Raj wrote: } [root@edwinraj bin]# /usr/local/mysql/bin/mysqladmin -u root password } 'simple' } /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed } error: 'Can't connect to local MySQL

Re: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)

't connect to local MySQL server through socket '/tmp/mysql.sock' (111)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! Edwin Raj wrote: Hello Friends, I have installed mysql version 3.23.52 binary file. The installation went well without an

ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)

Hello Friends, I have installed mysql version 3.23.52 binary file. The installation went well without any errors but when I type mysql in the command prompt I get this error. Can someone help me fix this. Am using red hat 6.2 version Rgds Edwin ---

Re: limited queries to one returned row

the technique below). But thanks for the help nonetheless! --Raj On Tue, 12 Nov 2002, John Ragan wrote: > > see if the limit keyword will do what you want. > > select * from table limit 0, 2000 > > > > > Hi all, > > > > is it possible to limit a result so th

limited queries to one returned row

ime for any info! --Raj - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsub

Mysql security and CGI

an do what I want without these concerns? Thanks a buncho in advance! --Raj PS: THANK YOU MYSQL DEVELOPERS What a god-send!! * - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Can't connect to local MySql server through socket '/var/lib/mysql/mysql.sock' (111)

Ed Carp wrote: >>On Monday 07 October 2002 12:04, Edwin Raj wrote: >> >>>When I type mysql in the command prompt it is giving the error "ERROR >>>2002: Can't connect to local MySql server through socket >>>'/var/lib/mysql/mysql.sock&#

Can't connect to local MySql server through socket '/var/lib/mysql/mysql.sock' (111)

Hi Friends, OS : Linux Redhat 6.2 Kernel version : 2.2.14-5.0 MySql version : 11.13 Distrib 3.23.36, for pc-linux-gnu (i686) When I type mysql in the command prompt it is giving the error "ERROR 2002: Can't connect to local MySql server through socket '/var/lib/mysql/mysql.sock' (111)" There i