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

mand which you want to strace. -- 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 Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

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

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]