Re: Stored procedures

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

Re: mysqldump with single-transaction with high-concurrency DB

. If that's not what happened in your case, I apologize for the long-winded email. You'll have to provide more details about what error messages were reported, and your system configuration, for people to help more. HTH, Devananda Mark Steele wrote: Dan: The options I specified are correct

Re: mysqldump with single-transaction with high-concurrency DB

happened? Regards, Devananda Mark Steele wrote: Dan: The options I specified are correct (according to the documentation) to get a consistent non-blocking snapshot. (--single-transaction disables --lock-tables, --opt is the default behavior for mysqldump). My question was more in the nature

Re: How can I get my disk space back?

, Devananda David Israelsson wrote: I have a really simple (two tables, one relation) but big (~70 GB) innodb database containing rather dynamic data. After deleting lots of records from the tables, the innodb data files still take the same amount of disk space as before. What is the correct way

Re: NOT IN vs IS NULL

inadvertently caused. Best regards, Devananda Actually, what was missing all along was pab.login_id=1 in the ON clause, not the WHERE clause!!! I guess I've not used that sort of condition in a JOIN before... If I rewrite your query like this, which is much simpler, it does

Re: NOT IN vs IS NULL

[EMAIL PROTECTED] wrote: Devananda, I have to support Peter on this one. What he submitted to you is a perfectly appropriate solution. It seems as though you rejected his assistance before even trying to see if it would work. On the contrary, I have tried his suggestions and they do

NOT IN vs IS NULL

| ++-++---+---+---+-+-+-+---+ 4 rows in set (0.01 sec) Thanks in advance, -- Devananda vdv http://devananda

Re: Select records added in last hour

(), interval 1 hour) | +--+ | 2006-01-19 13:47:53 | +--+ 1 row in set (0.00 sec) Cheers :) -- Devananda vdv http://devananda-vdv.blogspot.com/ http://mycat.sourceforge.net/ -- MySQL General Mailing List For list

Re: Circular Replication

integrity would be lost. In short, any time you are running circular replication, you have to ensure that updates are processed in the same order on all servers, or know that the order is irrelevant to your data integrity. Regards, Devananda vdv -- MySQL General Mailing List For list archives

Re: Options --lock-tables, --lock-all-tables do not work in mysql-4.1.8

, this option will Lock all tables across all databases. However, there is a note that may be of interest to you, since you are using 4.1.8 --first-slave, -x Deprecated, renamed to --lock-all-tables in MySQL 4.1.8. Regards, Devananda vdv -- MySQL General Mailing List For list archives: http

Re: Non-linear degradation in bulk loads?

are already importing your data in chunks, try making each chunk a separate transaction, or waiting until disk activity slows to load the next chunk. Also, there have been major improvements to InnoDB in the later 4.1 releases, so if possible, I would suggest upgrading. Hope that helps! Devananda

Re: crashes in InnoDB with MySQL 4.1.14 (semaphore wait timeout)

innodb_additional_mem_pool_size = 128M innodb_buffer_pool_size = 1G innodb_flush_log_at_trx_commit = 0 innodb_lock_wait_timeout = 30 Is anything wrong with this? The server had been running fine for months with these settings Regards, Heikki Thanks for all your time! Devananda vdv -- MySQL

Re: crashes in InnoDB with MySQL 4.1.14 (semaphore wait timeout)

Heikki Tuuri wrote: Deva, please post the complete output except the transaction data. Regards, Heikki Please let me know if there is any additional data I can provide to help resolve this. = 051005 7:18:17 INNODB MONITOR OUTPUT

Re: crashes in InnoDB with MySQL 4.1.14 (semaphore wait timeout)

thread id 3, query id 5280 192.168.1.38 webserver update INSERT INTO emails_history_30_17(email_id, mailing_id, action_type, xtime) VALUES ( - Original Message - From: Devananda [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Thursday, October 06, 2005 10:14 AM Subject: Re

crashes in InnoDB with MySQL 4.1.14

EXTENDED, that came back saying everything was fine. While I was writing this email, the server has crashed two more times in this same way. Any help would be appreciated! Thanks in advance, Devananda vdv -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: crashes in InnoDB with MySQL 4.1.14 (semaphore wait timeout)

Devananda wrote: One of our servers which is configured primarily for InnoDB has crashed in the same fashion three times in the past 48 hours. I've been going over the error log, and I would like to know if anyone else has seen similar errors, or can give me some pointers to work out

Re: MyISAM to InnoDB

Table_locks_waited 306450 Hope that helps! Devananda vdv -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MyISAM to InnoDB

or deny new connections. You need to adjust something in the formula - reduce max_connections if that is possible, or reduce the key_buffer_size if you do not need to be working with MyISAM tables on this server, or allocate less memory to innodb_buffer_pool_size. Best Regards, Devananda

Re: MyISAM to InnoDB

allowing you to allocate plenty of RAM to the innodb_buffer_pool). Of course, you can do both (just to play it safe, right?). ;) Best Regards, Devananda vdv -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: MyISAM to InnoDB

with a lot more clarity than I would have, so I'll just agree with what he wrote and stop here :) Regards, Devananda vdv -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MyISAM to InnoDB

/replication-features.html (towards the bottom it talks about replication of transactions and MyISAM engine) Best Regards, Devananda vdv -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MyISAM to InnoDB

Jeff wrote: -Original Message- From: Devananda [mailto:[EMAIL PROTECTED] Sent: Thursday, September 22, 2005 16:14 To: Jeff Cc: mysql@lists.mysql.com Subject: Re: MyISAM to InnoDB Jeff wrote: True, is there a way to tell a slave to not replicate certain queries like alter table

Re: Bad MySQL performance with LEFT JOINS in combination with BIGINT(16) Keys

on. Regards, Devananda vdv -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SET query with inproper AND doesn't generate error?

be issued to help folks recognize when this is happening and encourage the clear use of parentheses. Just my $0.02 Devananda vdv -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Circular Replication

servers have BOTH log-bin and log-slave-updates. With just 2 servers (A-B-A), you need log-bin, but do not need log-slave-updates. Regards, Devananda vdv -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Circular Replication

logging enabled, and needs to have the other server as it's master. Regards, Devananda vdv -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Circular Replication

Jeff wrote: -Original Message- From: Jeff McKeon Sent: Friday, September 16, 2005 13:19 To: Devananda Cc: mysql@lists.mysql.com Subject: RE: Circular Replication -Original Message- From: Devananda [mailto:[EMAIL PROTECTED] Sent: Friday, September 16, 2005 11:55 To: Jeff Cc

Re: Optimizing query WHERE date0

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

Re: a difficult join query question

| Dell Desktop| atpc01 | | 1003 | Acer Laptop | atpc02 | | 1004 | Apple iBook | NULL | +---+-++ 4 rows in set (0.00 sec) Regards, Devananda vdv -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Problem with autoincrement management

old DBMS into MySQL, and continue to use it as such, without problem. Have you tried this in a test environment yet? Perhaps I have completely misunderstood what you are trying to do. If that's the case, I apologize for the long winded and useless answer! Best Regards, Devananda vdv

Re: Flushing logs on replication setup

a binary log so you can replicate those updates back to the master. Best regards, Devananda vdv Thanks, Devananda! I really should have looked at the manual once again. I'm not sure what you meant by the last sentence - all the updates are done on the master, and they are naturally replicated

Re: Flushing logs on replication setup

to the master. Best regards, Devananda vdv -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: NULL and database size

. Best regards, Devananda vdv -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Index - max key length is 1024 bytes

/char.html http://dev.mysql.com/doc/mysql/en/charset-unicode.html HTH, Devananda vdv -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: OR in Query String

Justin Palmer wrote: Hi List, I have the following query where I am trying to locate a single students record. I only know that the students record has an id of 3690 and an employer_id of 3 possibles. So I thought that OR would work great. The problem is that it returns all students with

Re: Newbie question: number of connections

Brian Dunning wrote: In one case I do need to jump back and forth between databases that are on different physical servers. What's the most efficient way to handle this? On Aug 2, 2005, at 11:14 AM, Devananda wrote: Brian Dunning wrote: My RaQ4 is throwing the Too many connections error

Re: Sleeping Processes Timeout?

set the wait_timeout value in your my.cnf to something shorter, but this would affect all your applications and does not address the source of your problem. Regards, Devananda vdv -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: why so many table scans?

, stopping if a range is encountered. Thanks again, Devananda vdv -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: very slow inserts on InnoDB

about the servers themselves (CPU, RAM, etc)? Seeing the configuration parameters would help us to understand where your problem may be coming from. Regards, Devananda vdv Catalin Trifu wrote: Hi, I have the following table : CREATE TABLE `raw_outgoing_sms` ( `id` bigint

Re: query on a very big table

statement. Taking 10 hours to alter a very large table is not unheard of, though it really depends on your table structure. Regards, Devananda vdv Christos Andronis wrote: Hi all, we are trying to run the following query on a table that contains over 600 million rows: 'ALTER TABLE

Re: why so many table scans?

, etc. Regards, Devananda vdv Chris Kantarjiev wrote: I'm looking at the stats on one of our servers and trying to understand why Handler_read_rnd_next is so high. It's 256.5M right now, which is about 10x the total number of reported queries. The machine is being used, almost entirely

Re: Questions about backups, InnoDB tables, etc.

, this could cause serious problems to your application if it relies on making any writes to the database while you are dumping it. Thus, I would suggest using InnoDB as much as possible. -Devananda vdv -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: database problems.

! Devananda vdv Chris Knipe wrote: Hi all, The moral of the story, is don't run out of disk space, but it's a bit to late for that now. A quick scenario One master server, two backups replicating from the master. Our data and bin logs are on two different partitions, and the partition holding

Re: Storing huge amount of binary data

, then you would benefit from distributing the read load to multiple slave servers.) Regards, Devananda vdv -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: database structure question...

of room. (See http://answers.google.com/answers/threadview?id=122241 for an explanation.) ~ Devananda bruce wrote: hi... i'm considering an app where i'm going to parse a lot of colleges (~1000) faculty information. would it be better to have all the faculty information in one large table

Re: innodb crashes during heavy usage with exceeded memory error

with the option innodb_autoextend_increment, in megabytes. The default value is 8. Regards, Devananda Kasthuri Ilankamban wrote: Thank a lot for your quick reply. SInce we are not using myisam tables ( except for the system tables), I deallocated memory from myisam and allocated to innodb. When

Re: Tuning MySQL

If you can, I recommend installing mytop (http://jeremy.zawodny.com/mysql/mytop/) - it has helped me immensely to identify which particular queries are putting the heaviest load on the server. I have a lot of two column tables consisting of integer primary key and varchar in the second

Re: How to SELECT something (CONCAT) and search the field

While the query WHERE expr LIKE '%$user%' works without fail, it can not use an index, and thus on large tables will be exceedingly slow. mysql explain select last, first from users where concat(last,first) like '%user%'\G *** 1. row ***

InnoDB crash and runaway rollback - help pls

991879310 768.08 inserts/s, 5.00 updates/s, 0.00 deletes/s, 21583.28 reads/s END OF INNODB MONITOR OUTPUT -- Devananda van der Veen Systems Developer http://hydragroup.com -- MySQL General Mailing List For list archives: http

graphical innodb status monitoring

Hi all, Does anyone know of a graphical monitor for innodb status? Something like RRD, or that integrates with RRD? I'm looking to set up status monitoring for a group of 20 servers, and this would be a very big help in diagnosing problems. Thanks for your time, Devananda van der Veen Neopets

question about innodb_thread_concurrency

are currently running with innodb_thread_concurrency=16. Each DB has 200-400 active php clients, and there appears to be quite a large backup within innodb, based on this. Any suggestions? Or experience with setting this option to 500? Thanks :) Devananda Neopets, Inc -- MySQL General Mailing List

gcc version question

into similar problems? Thanks for you time, Devananda -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]