RE: different type column and keys for EXPLAIN

new index would work. -Original Message- From: Sergey Petrunya [mailto:pser...@askmonty.org] Sent: Monday, December 14, 2009 5:58 PM To: Manish Ranjan Cc: mysql@lists.mysql.com Subject: Re: different type column and keys for EXPLAIN Manish, On Mon, Dec 14, 2009 at 05:33:43PM +0530, Man

RE: different type column and keys for EXPLAIN

Already did "Analyze table" and table is up to date. It seems like optimizer glitch only but I am not sure. Will try adding index hints. From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De Meersman Sent: Monday, December 14, 2009 9:14 PM To: Manish Ranjan

RE: different type column and keys for EXPLAIN

Thanks Johan. More to add here, execution time for query with 'clarke' is much higher than query with 'clark'. This is why it looks a bit strange behavior. From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De Meersman Sent: Monday, December 14, 200

different type column and keys for EXPLAIN

| NULL | 2190 | Using intersect(fldLASTNAME,fldFIRSTNAME); Using where; Using index | ++-+---+-+-- +--+-+--+--+ -+ 1 row in set (0.02 sec) What could be the problem here. Please help. Thanks, Manish

RE: MySQL Performance with large data

[mailto:vegiv...@gmail.com] On Behalf Of Johan De Meersman Sent: Tuesday, November 24, 2009 9:56 PM To: Manish Ranjan (Stigasoft) Cc: mysql@lists.mysql.com Subject: Re: MySQL Performance with large data The amount and type of data is less the issue than the amount and type of queries is :-) The machine

MySQL Performance with large data

Hi, I am using MySQL 5.0.45 in production environment. One of my tables (using MyISAM Engine) is expected to have around 4 billion records and each record will have 1867 bytes of data. All fields in this table are of character data type. I have 8 GB RAM on the server, RAID 5 with 750 GB storage

Re: Sun bought by Oracle

lists.mysql.com/mysql?unsub=kaushalshri...@gmail.com > > > > > > DOJ ? does it mean Department of Justice ? > > > > Kaushal > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=manish.in@gmail.com > > -- Manish Gupta Follow me on twitter: twitter.com/nimbus3000

Client Programs

How do i run a mysql client program on a computer connected to the computer which has the mysql server installed and configured. the host computer does not have the mysql installed in any form. Regards -- Manish Gupta Follow me on twitter: twitter.com/nimbus3000

Re: Installation Problems

Goto a new DOS Window and type 'mysql -uroot' >You should be mysql now. > > If you got to this point successfully, have fun from here !!! > > Rolando A. Edwards > MySQL DBA (CMDBA) > > 155 Avenue of the Americas, Fifth Floor > New York, NY 10013 > 212-6

Installation Problems

I had MySQL 4.0. Today i downloaded the recent version, mysql5.12.32-Win32 installer. I deleted the older verison of mysql that i had. I didnt have any data there and thus no upgrade was needed as such. I used typical install option and after the install i used the standard configuration for the se

New to MySQL

Hi all, I am Manish from India and i am new to mysql. These are the steps that i had taken: 1. Installed MySQL 4.0.20d-Winit came with a cd in a book i bought. 2. Executed the winmysqladmin file from mysql/bin. gave it a username and password. 3. went to command prompt and the troubles

Re: Changing port no of the server using command line method

t processing but since I can't call myself a champ in this field, so thought of the other way. Thanks for the help though. -- Manish Sinha Personal Blog: http://www.manishsinha.info Tech Blog: http://manishtech.wordpress.com OpenPGP Key: 99E6658F -- MySQL General Mailing List For list arc

Re: Changing port no of the server using command line method

of. I can understand the security issues but I am actually trying to make an app which can administrate MySQL and would later add a GUI over it. -- Manish Sinha Personal Blog: http://www.manishsinha.info Tech Blog: http://manishtech.wordpress.com OpenPGP Key: 99E6658F -- MySQL General Mailing Lis

Changing port no of the server using command line method

might harm others server's settings. -- Manish Sinha Personal Blog: http://www.manishsinha.info Tech Blog: http://manishtech.wordpress.com OpenPGP Key: 99E6658F -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/m

Re: What files to install for Windows

Octavian Rasnita wrote: Is it legal to build the MySQL installer with a program I make? Thanks. Octavian Legal Issues? I think in such a case you have provide the source code too as per GPL. Wait for experts in this field -- Manish Sinha Personal Blog: http://www.manishsinha.info Tech Blog

Re: What files to install for Windows

know. -- Manish Sinha Personal Blog: http://www.manishsinha.info Tech Blog: http://manishtech.wordpress.com OpenPGP Key: 99E6658F -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Selecting a group of distinct items?

of course, although DISTINCT(name) works On Fri, 2005-10-07 at 12:29 +1300, Jasper Bryant-Greene wrote: > Manish Marathe wrote: > > SELECT DISTINCT(name), date, value FROM table_name ORDER BY date DESC; > > DISTINCT is not a function. The above (if it even works) is exactly

Re: Selecting a group of distinct items?

SELECT DISTINCT(name), date, value FROM table_name ORDER BY date DESC; On Thu, 2005-10-06 at 17:33 -0400, Donnie Lynch wrote: > Hi, > > I'm pretty much an SQL newbie, so apologies in advance if this is > basic stuff. That'll teach me for skipping the databases class in > college... > > I just c

Error Running MySQL tests

Hello all, I checked out the MySQL code and was running tests using mysql-test- run.sh. I keep getting this error: ERROR: /tmp/mysql/mysql-test/var/run/master.pid was not created in 400 seconds; Aborting Any insights, suggestions ? Thank You -Manish -- MySQL General Mailing List For

Re: Running MySQL tests

Hello, Any inputs or information on running MySQL tests under Valgrind, http://valgrind.org . Thanks -Manish On Tue, 2005-10-04 at 14:25 -0700, Manish Marathe wrote: > Hello All, > > I was building mysql after checking out from the bk repository. In that > process, while executing

Running MySQL tests

the next test case starts, Valgrind gets confused. I have learnt that MySQL is already tested under Valgrind. Does anyone has any idea about this ? Any help would be highly appreciated. Thanks -Manish -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

mysql prob.

bugs -uroot > /home/manish/bug_bkp.sql i got the error usr/local/mysql/bin/mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect.. ..well i m able to start mysql server but can't able to take ba

error in mysql

Hi, I have installed linux 9 with mysql-standard-4.0.15-pc-linux-i686.. mysql responding very slow when i request to find out any database its took long time to respons... plz help me Manish Popli - Fiorano

How to set character set UTF-8 for mysqldump

arsets\Index' file How can I do this? TIA, - Manish -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

JDBC driver support

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

Re: Help me optimize this query

(0.00 sec) Any inputs??? TIA, - Manish - Original Message - Sent: Saturday, December 04, 2004 10:26 AM Subject: Re: Help me optimize this query > If you change the update to a select you can use explain to see it's > execution path just like you would with a normal sel

Update optimization...

imize this query? What are the parameters for this optimization? Can someone give me links where I can read up about such optimizations for update query. TIA, - Manish -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Help me optimize this query

imize this query? What are the parmeters for this optimization? Can someone give me links where I can read up about such optimizations for update query. TIA, - Manish -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Delete duplicate records

ot; Can I have sth that will dynamically delete those records when count > 1. My version does not allow subqueries, and I am not too familiar with advanced MySQL stuff. TIA, - Manish -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Delete duplicate records

up by record_no having count > 1; Now I want to delete all these duplicate records in such a way that only one of them for each record_no stays in the database (the one with highest ID may stay). How can I do this?? TIA, - Manish -- MySQL General Mailing List For list archives: http://lists.m

Backup problem

st as possible. How can I do this? TIA, - Manish -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Select non-matching rows

Thanks!!! It works, the only change I needed was - WHERE tbl2..another_id IS NULL rgds, - Manish - Original Message - From: "Johan Hook" <[EMAIL PROTECTED]> To: "Manish" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, August 20, 2004 12:

Select non-matching rows

ill be highly appreciated. TIA, - Manish -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Tunning Process

. Now the condition arise on what percentage I have to take backup of my database. with mediumtext or without mediumtext. Thax In Advance Manish Mehta - Before posting, please check: http://www.mysql.com/manual.php (the

Encrpt/Decrypt

Hi I can Encrypt password in mysql using password() command. what is the way to decrypt the password. Manish - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Export

Hi, I am working on Mysql . I wants to take backup (export) of my database from dos prompt . Is their any way. Please Tell. Thx in advance Manish Mehta - Before posting, please check: http://www.mysql.com/manual.php

Begin work

Hi Any body tells me what the use of "Begin work" in SQL . Manish Mehta - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

max function

ary status and max -> salary status date according to the employee id. My requriment is show only single for particular employee. how can it is possible. pl. help, Manish - Before posting, please check: http://www.mys

between

Hi In mysql I found a problem with between query. For example select * from bugdetail where dbugcreate_date between from_days(to_days('2002-03-01')) and from_days(to_days('2002-03-04')) this query shows only those records up to '2002-03-03' instead of

encrypt password

Select query. please tells me the process . Thx in advance Manish Mehta - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request t

Export database

Hi i have 3.23.32 version of mysql. i wants to export the database from \mysql\bin\ please tell. thanks in advance Manish Mehta CORE Solucomm Limited 423 B, Hamilton Court, DLF City, Phase IV, Gurgaon, India - 122 001. Tel: +91-124-6392896 / 897 / 035 Fax:+91-124-6392036 E-mail: [EMAIL

Test Case (Urgent)

Hi, I am new to test case design in Database. I wants to know Basically how to calculate the Maximum Database. When we have to take backup.? What are steps to be flow please tell me. Thanks in advance. Manish Mehta E-mail: [EMAIL PROTECTED

Database in MySQL

Hi, As we know that MySql support maximum of 4 GB data per table. Now the question arise that what is the maximum limit of Database in MySQL. Manish Mehta E-mail: [EMAIL PROTECTED] - Before posting, please check: http

Database Size Limit

Hi, As we know that MySql support maximum of 4 GB data per table. Now the question arise that what is the maximum limit of Database in MySQL. Manish Mehta E-mail: [EMAIL PROTECTED] - Before posting, please check: http

auto_increment

Hi Is it possible auto_increment start 100 instead of 1 . for example create table a ( a int(10) primary key auto_increment 100); Manish Mehta E-mail: [EMAIL PROTECTED] - Before posting, please check: http

Error List

d Enjoy . Manish Mehta E-mail: [EMAIL PROTECTED] - 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 <[EMAI

SQL Problem

2 2001-11-20 2 Thanks Manish Mehta E-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Error List

hello I wants to Know of web site where's i found the list of errors mysql have. thanks Manish Mehta E-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual)

problem in SQL

Master table. As comparing with RoleActionReation table (field -> nAction_ID , nRole_ID ) I need those Action Name which are not mapped with the Role Name . This Query shows me those field also which are already mapped. Thanks Manish Mehta E-mail: [EMAIL PROTEC

Procedure and Funcion

Hello, I am facing a big problem related to some queries. Is i use store procedure or function in My SQL. If yes , Please tells me the syntax. Thanks Manish Mehta E-mail: [EMAIL PROTECTED] - Before posting, please

Problem related to not equal to function

lready present in other table. Manish Mehta E-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread,

Urgent : - Select Query

70 123 43 36750 123 43 999 45 890 435 346 56 345 14 456 15 999 45 678 234 Please Help me. Manish Mehta E-mail:

Windows Threads Support

Hello, Windows support 2000 threads by default (with the help of thread library). Then what a mean of max_connection = 100 because MySQL One each connection on differente thread. Is i able to increase the max_connection limit. Manish Mehta E-mail: [EMAIL PROTECTED

mysqladmin Vs WinMySQLAdmin

Hello What a difference between mysqladmin Vs WinMySQLAdmin Because i thing both were works as same. but those thing i set through --set-variable command not reflect on WinMySQLAdmin. Why? Manish Mehta E-mail: [EMAIL PROTECTED

Encryption

hello, Is MySQL Support Encryption ? Manish Mehta E-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

Max Database

Hello Everyone, We are using MySQL as backend. What is Maximum size of MySQL Database? Manish Mehta E-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Is MySQL Support Procedure?

Does MySQL Support Procedure.If yes, Whats a real syntax? Manish Mehta - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Support related to tables

r any Load Tester in MySQL? Manish Mehta - 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 P

Support

Hello, Does MySQL Support Distributed Database .If not, then what's the way out ? Manish Mehta - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: SQL Parser

ing engine out of mysql. Is it possible to do that? Thanks! Manish - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread,

conversion of sql data to mysql

hi I am willing to convert the data from sql to mysql but i don't what quary should i pass to do the same, can you help me out. thanking you in anticipation manish __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $