Re: Really slow batch insert??

Ah, forgot to mention that table is INNODB. On Mon, Dec 30, 2013 at 1:59 PM, Cabbar Duzayak wrote: > Hi, > > > We have a basic table, which is something like : > > > (id varchar50, productId varchar50, category varchar50) > > > In this table, ID is the primary key

Really slow batch insert??

Hi, We have a basic table, which is something like : (id varchar50, productId varchar50, category varchar50) In this table, ID is the primary key and we have a unique index on (category, productId). And, there is a case where we want to do bulk inserts (3000 inserts) using: INSERT INTO (id,

Re: Query Plan Analyzer

Is this a joke? On Thu, Nov 22, 2012 at 10:20 AM, Zhigang Zhang wrote: > By experience! > > -Original Message- > From: Cabbar Duzayak [mailto:cab...@gmail.com] > Sent: Thursday, November 22, 2012 3:13 PM > To: mysql@lists.mysql.com > Subject: Query Plan Analyzer >

Query Plan Analyzer

Hi All, Is there a way of looking at how mysql builds the query plan and executes it for a given query? EXPLAIN is definitely a useful tool, but it is not exact (shows approximations as far as I can see), furthermore I want something like how the predicates were applied (before or after JOINS), wh

Re: Subquery taking too much time on 5.5.18?

=on | ++ 1 row in set (0.00 sec) On Sat, Jul 7, 2012 at 8:01 PM, Peter Brawley wrote: > On 2012-07-07 9:52 AM, Cabbar Duzayak wrote: >> >> Hmm, >> >> Looking at the link http://www.artfulsoftware.com/infotree/queries.php >> and explanations here, EXISTS() should ha

Re: Subquery taking too much time on 5.5.18?

Hmm, Looking at the link http://www.artfulsoftware.com/infotree/queries.php and explanations here, EXISTS() should have performed better, but does not seem to??? I stopped it after about 5 minutes. I tried both: SELECT * FROM A WHERE EXISTS (SELECT * FROM B WHERE A.id=B.A_ID and B.name like 'X

Re: Subquery taking too much time on 5.5.18?

forcing MySQL to run > from the inside out. I don't have a running instance nearby to test on, but I > hope it helps. > > > > > > > -Original Message- > From: Reindl Harald [mailto:h.rei...@thelounge.net] > Sent: Friday, July 06, 2012 11:58 AM &g

Subquery taking too much time on 5.5.18?

Hi Everyone, I have been trying to understand why subqueries are taking tooo much time on my installation of MySQL 5.5.18 on Ubuntu 11.10 release. In a nutshell, I have 2 tables: A and B. And, I do something like this: SELECT * FROM A WHERE A.id IN (SELECT A_ID FROM B WHERE B.name like 'X%'); T

Re: Indexed Query examining too many rows!

s. On Mon, Feb 13, 2012 at 12:57 AM, Peter Brawley wrote: > On 2/12/2012 4:40 PM, Reindl Harald wrote: >> >> Am 12.02.2012 23:25, schrieb Cabbar Duzayak: >>> >>> Hi All, >>> >>> I have a table with a btree index on its searchKey column, and when I

Pointers about replication

Hi All, Would it be possible to provide some advanced pointers (articles/books/tutorials/sites) for learning more about replication? I am particularly interested in master-to-master replication (not even sure if this is possible with mysql) and/or real-world usage scenarios/examples as to how mu

Pushing mysql to the limits

Hi, We have huge amount of data, and we are planning to use logical partitioning to divide it over multiple machines/mysql instances. We are planning to use Intel based machines and will prefer ISAM since there is not much updates but mostly selects. The main table that constitutes this much of d

MySQL memory allocation

Hi, Could you please tell how I can tell how much memory does mysql server allocate on a linux box? I tried doing: top -b -n 1 | grep mysql But, it printed out bunch of processes for mysql. Are these all using shared memory so each line gives you the total amount for mysql? How can one interpre

Too many open processes??

I am using mysql_pconnect from PHP to connect to our mysql server. However, whenever there is a temprorary surge in the number of users, i.e. concurrent users jump from 30 to 200 for like 5 minutes, Apache creates 200 processes and after the surge is over, they die gracefully, and # of processes g

Queue implementation on MySQL

Hi, Can you please recommend an open-source, light-weight and more importantly RELIABLE point-to-point queue implementation, built on mysql? Something similar to Oracle's Advanced Queue? I don't need publish/subscribe or a priority-based point-to-point queue, just a simple one which provides a rel

Active user sessions

Hi, Is there a way of listing all the active db sessions and their IP addresses and/or db user names? Something like v$session in oracle? Thanks... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQLDump - Command line password

Hi, I have setup cronjobs to take daily backups of my db using mysqldump. But the problem is, mysqldump requires the password to be passed via command line, which means anyone on the same machine can take a peek at my password using "top", "ps -ef", etc. Is there a way of avoiding this, i.e. maki

Storing huge amount of binary data

Hi Everyone, I will be starting a project for which I will need to store about 1 million image files all of which are about 50-100K in size. I will be using Linux for this project. The database won't be very busy, there will be batch image uploads 1-2 times a day, and around 100-200 concurrent use