MySQL 5.1 Cluster Certification Study Guide
Hi, A little over a year since the project to write this book began, the MySQL 5.1 Cluster Certification Study Guide is now at long last available. Covering the Certified MySQL 5.1 Cluster Database Administrator exam, this study guide is the one authority to look to when you're preparing for the test. The book teaches you all the concepts, principles, and techniques that you'll need to know for the exam, with many practice questions and real-world examples to help you prepare for test day. The book is also an excellent reference guide for your real-world MySQL Cluster administration needs. Whatever your reason for becoming MySQL certified, this book gives you the information you need to help you better understand MySQL Cluster technologies and prepare for and pass the exams. The authors span from Australia over Europe to the East and West coast of the US. We had reviewers from four different continents. Seeing a project like this actually working and producing a great result is really fascinating. Carsten Pedersen helped to get the table of contents in place, wrote the introduction, and made sure certification program and study guide were kept in sync, while Stefan Hinz was the project lead, but, naturally, the lion's share was done by the authors: * Jon Stephens is not only the master of MySQL Cluster Documentation, he has actually moved himself halfway across the world be be closer to the Cluster developers while he works. His author's credits include Beginning MySQL Database Design and Optimization from Apress. * Mike Kruckenberg should be a familiar name to anyone reading Planet MySQL. Mike is co-author of Pro MySQL from Apress, and member of the MySQL Certification Technical Advisory Board. * Roland Bouman, blogger extraordinaire, winner of one of the 2006 MySQL Community awards, and hired in 2006 to (among many other things) develop the Cluster certification exams. If anyone knows what's on the exams, he is the one. * Stewart Smith not only hacks away at Cluster during his working hours, he's also very involved in the Australian Open Source community, and is often heard speaking on MySQL Cluster. * Solomon Chang, a founding member of LAMPSIG of Los Angeles and a professional DBA, has contributed material for exercises and reviewed much of the book. This is the first book we published all on our own. It's printed and shipped via lulu.com, a print-on-demand shop. You can order your copy here: http://www.lulu.com/content/1297960. It will also be available from retailers (Amazon as well as brick and mortar bookstores) soon. -- Regards, Stefan Hinz [EMAIL PROTECTED], MySQL AB Documentation Manager Berlin, Germany (UTC +1:00/winter, +2:00/summer) Skype:stefanhinz Cell:+491777841069 Desk:+493082702940 Fax:+493082702941 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Replication
Hi All, Is the circular replication is suitable for production. In my view it becomes complex. Thanks Krishna Chandra Prajapati
Re: how to drop index if exists
Fantastic, thanks very much! Adam Rob Wultsch wrote: On Nov 29, 2007 4:34 AM, Adam Lipscombe [EMAIL PROTECTED] wrote: Folks How can one conditionally drop an index in MySQL? Googling shows that the drop index does not support an if exists qualifier - apparently a bug has been raised but as far as I know its not fixed yet. Does anyone know of a work-around? TIA - Adam Sent my first response late at night and not the community... And the response also sucked. DROP INDEX is mapped to ALTER TABLE tbl_name DROP INDEX. ALTER IGNORE TABLE tbl_name DROP INDEX ought to be functionally equivalent to IF EXISTS. What is your goal? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
possible combine update statement
hi list, i have a loop to update my table: update tbl_idea set col1 = 'text1', col2 = NOW() where ideaID = 1; update tbl_idea set col1 = 'text2', col2 = NOW() where ideaID = 5; ... update tbl_idea set col1 = 'textzzz', col2 = NOW() where ideaID = XXX; my question is can i combine above statements into one statement so i can only do update only once? thanks, T. Hiep -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Partitioning in mysql
Hi All, Please tell me the concept of partitioning in mysql. How it help to access the data faster. How i can implement partitioning on mysql tables. Suggest me some link for partitioining. Thanks -- Krishna Chandra Prajapati
Re: how to drop index if exists
Sorry I got carried away in my former response. When I tried this, ALTER IGNORE TABLE tbl_name DROP INDEX seems to fail if the index does not exist. The DROP INDEX statement is part of a larger script, what I want is for the script to conue to execute if this index does not exist. e.g. ALTER IGNORE TABLE table_name DROP INDEX index_name; ALTER IGNORE TABLE table_name ADD INDEX UNIQUE index_name(column_1,column_2); Thanks - Ada Rob Wultsch wrote: On Nov 29, 2007 4:34 AM, Adam Lipscombe [EMAIL PROTECTED] wrote: Folks How can one conditionally drop an index in MySQL? Googling shows that the drop index does not support an if exists qualifier - apparently a bug has been raised but as far as I know its not fixed yet. Does anyone know of a work-around? TIA - Adam Sent my first response late at night and not the community... And the response also sucked. DROP INDEX is mapped to ALTER TABLE tbl_name DROP INDEX. ALTER IGNORE TABLE tbl_name DROP INDEX ought to be functionally equivalent to IF EXISTS. What is your goal? -- Adam Lipscombe T: 01872 575083 M: 07957 548686 E: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
REPLICATION
Hi, I am working on production and thinking of implementing chain replication A-B-C. A is replicated to B. B is being replicated to C. I want to know that there is any script or any cron by which i can replicate (manually or automatically) D server to C. (D is another replication server). I was thinking that manually i can get the mysql-bin log sql and execute it on server C. In this way D will replicate to C. The above task is possible or not. I haven't tested till now. Any other idea any body have. -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: [EMAIL PROTECTED]
Re: possible combine update statement
On Dec 5, 2007 8:48 AM, Hiep Nguyen [EMAIL PROTECTED] wrote: hi list, i have a loop to update my table: update tbl_idea set col1 = 'text1', col2 = NOW() where ideaID = 1; update tbl_idea set col1 = 'text2', col2 = NOW() where ideaID = 5; ... update tbl_idea set col1 = 'textzzz', col2 = NOW() where ideaID = XXX; my question is can i combine above statements into one statement so i can only do update only once? Use a CASE statement: update tbl_idea set col1 = CASE WHEN ideaID = 1 THEN 'text1', WHEN END WHERE ideaID IN (1, ) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqlmanager startup scripts for Debian
Where possible I use distro builds of applications (let them worry about security updates and testing, means I don't need build tools on a production server), but all the distros I've checked use their own startup scripts which do not allow me to use mysqlmanager (or even mysqld_multi) to run multiple server instances. Does anyone have any startup scripts suited to (say) a Debian or Ubuntu binary installation? My test server is Ubuntu 7.04 but I'll consider any offers! mysqlmanager is present, it's just that the startup scripts don't use it. The Debian startup sripts are very from the MySQL supplied ones and I don't know if that's just because they're old (if it isn't broken, don't fix it) or there's some more significant reason behind it. -- Mark Rogers // More Solutions Ltd (Peterborough Office) // 0845 45 89 555 Registered in England (0456 0902) at 13 Clarke Rd, Milton Keynes, MK1 1LG -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how to drop index if exists
On Dec 5, 2007 7:03 AM, Adam Lipscombe [EMAIL PROTECTED] wrote: Sorry I got carried away in my former response. When I tried this, ALTER IGNORE TABLE tbl_name DROP INDEX seems to fail if the index does not exist. Right. ALTER IGNORE means that rows that violate unique indexes won't be copied to the new table during the ALTER. It has nothing to do with what you're looking for. There is no statement that does what you're looking for, as far as I know. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
help with select
hi list, i have two tables: idea(iid int not null primary_key auto_increment, completed_by int, submitted_by int); employee(eid int not null primary_key auto_increment, first varchar(20), last varchar(30)); table idea data: 1 | 4 | 10 2 | 3 | 7 table employee data: 3 | john | Doe 4 | betty | smith 7 | bob | Gomez 10 | sun | mcnab i'm trying to select from idea table such that when iid = 1, i should get betty smith for completed_by column and sun mcnab for submitted_by column. 1st trial: select iid,completed_by,submitted_by from idea where iid=1 i got: 1 | 4 | 10 2nd trial: select idd,concat(first, ,last),submitted_by from idea,employee where iid=1 and completed_by=eid; i got: 1 | betty smith | 10 now, instead of 10 for the submitted_by column, how do i get sun mcnab? thanks, T. Hiep -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: help with select
You might try this: SELECT I.iid, CONCAT(ECOMP.last, ', ', ECOMP.first) AS 'Completed By', CONCAT(ESUB.last, ', ', ESUB.first) AS 'Submitted By', FROM idea I JOIN employee ECOMP ON I.completed_by = ECOMP.eid JOIN employee ESUB ON I.submitted_by = ESUB.eid andy Hiep Nguyen wrote: hi list, i have two tables: idea(iid int not null primary_key auto_increment, completed_by int, submitted_by int); employee(eid int not null primary_key auto_increment, first varchar(20), last varchar(30)); table idea data: 1 | 4 | 10 2 | 3 | 7 table employee data: 3 | john | Doe 4 | betty | smith 7 | bob | Gomez 10 | sun | mcnab i'm trying to select from idea table such that when iid = 1, i should get betty smith for completed_by column and sun mcnab for submitted_by column. 1st trial: select iid,completed_by,submitted_by from idea where iid=1 i got: 1 | 4 | 10 2nd trial: select idd,concat(first, ,last),submitted_by from idea,employee where iid=1 and completed_by=eid; i got: 1 | betty smith | 10 now, instead of 10 for the submitted_by column, how do i get sun mcnab? thanks, T. Hiep -- Andy Wallace - CISData - IDX Slave AIM: acmwallace [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Stable MySQL Version
On Wed, 2007-12-05 at 07:13 -0800, Amit Nair wrote: Could some one please let me know a stable version of MySQL for my computer? Version 5.0.45. http://dev.mysql.com/downloads/mysql/5.0.html#win32 -- Tiago Cruz http://everlinux.com Linux User #282636 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: REPLICATION
-Original Message- From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 05, 2007 8:09 AM To: MySql Subject: REPLICATION Hi, I am working on production and thinking of implementing chain replication A-B-C. A is replicated to B. B is being replicated to C. I want to know that there is any script or any cron by which i can replicate (manually or automatically) D server to C. (D is another replication server). I was thinking that manually i can get the mysql-bin log sql and execute it on server C. In this way D will replicate to C. The above task is possible or not. I haven't tested till now. Any other idea any body have. So you want to do this? A-B-C-D -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: help with select
mysql select idea.iid, concat(employee.first, ,employee.last),(SELECT concat( employee.first, ,employee.last) FROM EMPLOYEE where employee.eid=idea.submitted_by) from ide a,employee where idea.iid=1 and idea.completed_by=employee.eid; M-- - Original Message - From: Hiep Nguyen [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, December 05, 2007 2:02 PM Subject: help with select hi list, i have two tables: idea(iid int not null primary_key auto_increment, completed_by int, submitted_by int); employee(eid int not null primary_key auto_increment, first varchar(20), last varchar(30)); table idea data: 1 | 4 | 10 2 | 3 | 7 table employee data: 3 | john | Doe 4 | betty | smith 7 | bob | Gomez 10 | sun | mcnab i'm trying to select from idea table such that when iid = 1, i should get betty smith for completed_by column and sun mcnab for submitted_by column. 1st trial: select iid,completed_by,submitted_by from idea where iid=1 i got: 1 | 4 | 10 2nd trial: select idd,concat(first, ,last),submitted_by from idea,employee where iid=1 and completed_by=eid; i got: 1 | betty smith | 10 now, instead of 10 for the submitted_by column, how do i get sun mcnab? thanks, T. Hiep -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Logout after table update
Hi everyone , I'm new to the mysql administration world (couple months). Couple days ago a client came up with the following situation he got logged out after editing a table (tt_content table part of typo3) He thinks he was kicked out because he tried to update a record and it became too big for the table. Is this a possible explanation ? Any of you ever saw someone getting logged out after doing an update ? I looked on the net for a while before asking here but i didn't see much case similar to this. Any thoughts or insight would be interesting to hear. Thanks Éric Fournier Technicien en informatique Direction générale des technologies de l'information(DGTI) Direction des services logiciels et technologiques(DSLT) 1500E, Rue Cyrille-Duquet, RC Québec (Québec) G1N 4T6 Téléphone: (418) 644-1500 poste 2085 Télécopieur: (418) 646-0988
MySQL server connection question.
I hope a simple question, Can a MySQL Client (5.0.14) connect to a MySQL Server (5.1.22) (or more specifically I have a static build of PHP using the libmsqlclient.la from MySQL version 5.0.14 as a client attempting to connect to a MySQL server running version 5.1.22rc.)? My thanks in advance Jeff Johnson
Re: SQL analysis tool - open source?
Have you considered: http://forge.mysql.com/wiki/MySQL_Proxy On Dec 5, 2007 5:14 PM, Russell E Glaue [EMAIL PROTECTED] wrote: Does anyone know of an open source SQL analysis tool? I have query logging turned on in MySQL. And I would like to analyze all the logged SQL select queries to find out how the database is being used, and then optimize MySQL databases or the SQL views/statements accordingly. Perhaps it would generate a report of most used columns for searching and retrieving, across all logged SQL queries. We have a software package used to generate reports from data in MySQL, and the users are allowed to make ad hoc querying. So we do not (necessarily) have control over the SQL queries that are executed. And once in a great while, some unknowing user will execute a query (unoptimized of course) that takes longer than satisfactory to execute. So I want to analyze all the queries users have issued, and try and optimize the database tables accordingly, or adjust the views in the reporting software. Any tools (open source only) out there to help? -RG -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SQL analysis tool - open source?
Does anyone know of an open source SQL analysis tool? I have query logging turned on in MySQL. And I would like to analyze all the logged SQL select queries to find out how the database is being used, and then optimize MySQL databases or the SQL views/statements accordingly. Perhaps it would generate a report of most used columns for searching and retrieving, across all logged SQL queries. We have a software package used to generate reports from data in MySQL, and the users are allowed to make ad hoc querying. So we do not (necessarily) have control over the SQL queries that are executed. And once in a great while, some unknowing user will execute a query (unoptimized of course) that takes longer than satisfactory to execute. So I want to analyze all the queries users have issued, and try and optimize the database tables accordingly, or adjust the views in the reporting software. Any tools (open source only) out there to help? -RG -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Stable MySQL Version
Hello Team Could some one please let me know a stable version of MySQL for my computer? Configuration is as below: OS- Windows XP Professional Service Pack 2 Processor AMD Athlon 64 Processor 2800+ 1.8Ghz RAM 1 GB Actually I have downloaded one which was meant for AMD processor, but it was not even getting installed. Thanks Amit - Never miss a thing. Make Yahoo your homepage.
ERROR 126 (HY000): Incorrect key file for table
Hi All, I am getting below error when i am updating a table ERROR 126 (HY000): Incorrect key file for table '/tmp/#sql_5dc3_0.MYI'; try to repair it Its a myisam engine, mysql update user_hist t,testprod.user_tory y set - t.billing_plan=y.billing_plan, t.referrer_info=y.referrer_info, t.storefr - t.crm_billing_plan=y.crm_billing_plan, t.wmark_billing_plan=y.wmark_billin - t.gallery_billing_plan=y.gallery_billing_plan, t.tickets_billing_plan=y.ti - t.ihost_billing_plan=y.ihost_billing_plan, t.reports_billing_plan=y.repor - t.revise_billing_plan=y.revise_billing_plan, t.syn_billing_plan=y.syn_bill an, - t.checkout_billing_plan=y.checkout_billing_plan, t.counters_billing_plan=y - t.analyzer_billing_plan=y.analyzer_billing_plan, t.research_billing_plan= - t.hot_billing_plan=y.hot_billing_plan, t.suppliers_billing_plan=y.supplier - t.autos_billing_plan=y.autos_billing_plan, t.contract_billing_plan=y.contr - where t.user_id=y.user_id - and t.billing_run=y.billing_run; commit; how do i fix it, out /tmp file system has 16GB of space. regards anandkl
Re: Circular replication
Hello, EDS and MySQL are having a webinar on the subject of circular replication today. Check out: http://www.mysql.com/news-and-events/web-seminars/index.html If you can't make it today, it will be archived in the On-Demand section. -- Jimmy Alex Arul Lurthu wrote: Chain replication is fine as long as reading stale data from the last slave in your chain is ok. the staleness depends on the write throughput and capacity of the intermediate slaves. But Chain replication with circular replication is a definite no no in prod since if any intermediate fails, you will not be able to restore it easily and the data goes out of sync. On Dec 5, 2007 12:31 AM, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: Hi All, Is circular replication or chain replication is suitable for production environment. Whether any testing has been done. If yes then, Please let me know. There is any other issue related to circular replication. Thanks -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Determining Table Storage Engine Type on Crashed Table
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sun, Dec 02, 2007 at 09:55:23AM +0530, Alex Arul Lurthu wrote: How about looking at the .frm file of the table. A couple of quickie tests shows something promising: strings table.frm | egrep 'MyISAM|InnoDB|engineA|engineB|etc' Unknonwn whether other engines obey the same rules and methods. - -- Regards... Todd Chris: grep 500 sendmail.mc undefine(`FAIL_MAIL_OVER_500_MILES')dnl Chris: just in case ... Linux kernel 2.6.22-14-generic 3 users, load average: 0.00, 0.00, 0.00 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHVw0rY2VBGxIDMLwRAgXTAJwJnbs7jSnXmEezsOhpfHZeITcTegCfYfhh LIv3YNplxWpzYjvluTeTKyk= =XdMs -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL server connection question.
Today, I installed 5.1.22RC and 6.0.3-alpha on my PC I used 5.0.45's client successfully to connect to both. I don't about 5.0.14 Give it a try !!! -Original Message- From: Jeffrey M. Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 05, 2007 4:36 PM To: mysql@lists.mysql.com Subject: MySQL server connection question. I hope a simple question, Can a MySQL Client (5.0.14) connect to a MySQL Server (5.1.22) (or more specifically I have a static build of PHP using the libmsqlclient.la from MySQL version 5.0.14 as a client attempting to connect to a MySQL server !!! running version 5.1.22rc.)? My thanks in advance Jeff Johnson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Circular replication
Chain replication is fine as long as reading stale data from the last slave in your chain is ok. the staleness depends on the write throughput and capacity of the intermediate slaves. But Chain replication with circular replication is a definite no no in prod since if any intermediate fails, you will not be able to restore it easily and the data goes out of sync. On Dec 5, 2007 12:31 AM, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: Hi All, Is circular replication or chain replication is suitable for production environment. Whether any testing has been done. If yes then, Please let me know. There is any other issue related to circular replication. Thanks -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: [EMAIL PROTECTED] -- Thanks Alex http://alexlurthu.wordpress.com
Re: Partitioning in mysql
Am Mittwoch, den 05.12.2007, 17:59 +0530 schrieb Krishna Prajapati: Suggest me some link for partitioining. http://dev.mysql.com/tech-resources/articles/mysql_5.1_partitions.html http://dev.mysql.com/doc/refman/5.1/en/partitioning.html Norbert -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysqldump (in crontab) failing with 'errno 32' even though it worked last week
Maybe too much data is being pumped in through the pipe This sounds spot on. I redid the command to take the pipe out of the equation and it seems to be working now. Thanks for the feedback. Rolando Edwards-3 wrote: 'errno 32 on write' That's a broken pipe error (Run 'perror 32' in Linux) Maybe too much data is being pumped in through the pipe. Instead of this : /usr/bin/mysqldump --all-databases -u root | /usr/bin/gzip -c /backups/mysql_backup.gz Try it this way : /usr/bin/mysqldump --all-databases -u root AllData.txt /usr/bin/gzip -c /backups/mysql_backup.gz AllData.txt -Original Message- From: FMGreen [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 04, 2007 11:52 AM To: mysql@lists.mysql.com Subject: mysqldump (in crontab) failing with 'errno 32' even though it worked last week I use the mysqldump command (as below) in crontab to do a dump of my database each night. Up until last week this was working fine. Last week (when I was out of the office) there was a problem with the db and a colleague of mine had to do a manual dump. When he tried to run mysqldump (using the same command as I do) he got 'errno 32 on write'. I just tried to run the command myself and also got 'errno 32 on write'. My cronjob has also started failing even though crontab has not been changed. I am very confused given that this exact command was working up until last week. Can anyone shed light on what is going on? This is the command I use, run as super user: /usr/bin/mysqldump --all-databases -u root | /usr/bin/gzip -c /backups/mysql_backup.gz -- View this message in context: http://www.nabble.com/mysqldump-%28in-crontab%29-failing-with-%27errno-32%27-even-though-it-worked-last-week-tf4944271.html#a14154528 Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- View this message in context: http://www.nabble.com/mysqldump-%28in-crontab%29-failing-with-%27errno-32%27-even-though-it-worked-last-week-tf4944271.html#a14171020 Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Performance with MySQL 5.0.18
Hello, We're working with a MySQL 5.0.18 on a Linux System (Kernel 2.6.5-7.97-smp). The Server got 2G of RAM and enough HDD-Space. We use several Tables on 2 Databases. Most of them were MyISAM-Tables and we encountered some problems: By 96% of the time we got reaction times in the range of 150 ms but some exceptions we got reaction times more than 400ms. By benchmarking the system we decided to change the important tables to InnoDB. Now 99% got reaction times of 4 ms but the rest got reaction times more than 600 ms. we got mainly 3 tables in one system: 1 Input (one Reading Process) (5-10 % of Exceptions) Still MyISAM 2 Output (1 writers 1 updaters and 1-2 reading Processes) (90-95% of Exceptions) --- Those were changed to InnoDB The my.cnf was changed to the following Values: -START- connect_timeout=259200 #wait_timeout=10 key_buffer = 32M max_allowed_packet = 2M table_cache = 128 sort_buffer_size = 1M net_buffer_length = 16k read_buffer_size = 512K read_rnd_buffer_size = 1M myisam_sort_buffer_size = 16M # Uncomment the following if you are using InnoDB tables innodb_data_home_dir = /somewhere/mysql/innodbs/ innodb_data_file_path = ibdata1:50M:autoextend innodb_log_group_home_dir = /somewhere/mysql/logs/ innodb_log_arch_dir = /somewhere/mysql/logs/ # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high #innodb_buffer_pool_size = 128M # ORIGINAL VALUE ! innodb_buffer_pool_size = 256M #innodb_additional_mem_pool_size = 48M # ORIGINAL VALUE ! innodb_additional_mem_pool_size = 64M # Set .._log_file_size to 25 % of buffer pool size #innodb_log_file_size = 30M # ORIGINAL VALUE ! innodb_log_file_size = 128M #innodb_log_buffer_size = 30M # ORIGINAL VALUE ! innodb_log_buffer_size = 60M #innodb_flush_log_at_trx_commit = 1 # ORIGINAL VALUE ! innodb_flush_log_at_trx_commit = 0 innodb_lock_wait_timeout = 50 # NEW innodb_flush_method=O_DSYNC --- END By running the benchmarks we only had exceptions of 4 ms, but in productive settings we have those exceptions of 600ms ! Shall I increase the InnoDB-Values to reduce the exceptions ? Thanks in Advance Frank
Re: possible combine update statement
Hiep Nguyen wrote: i have a loop to update my table: update tbl_idea set col1 = 'text1', col2 = NOW() where ideaID = 1; update tbl_idea set col1 = 'text2', col2 = NOW() where ideaID = 5; ... update tbl_idea set col1 = 'textzzz', col2 = NOW() where ideaID = XXX; Depending on what you mean by 'text1', would UPDATE tbl_idea SET col1=CONCAT('text',ideaID), cols=NOW(); .. be close? Don't test it unless you're sure, it'll change all the records in the table! -- Mark Rogers // More Solutions Ltd (Peterborough Office) // 0845 45 89 555 Registered in England (0456 0902) at 13 Clarke Rd, Milton Keynes, MK1 1LG -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
HOW DO YOU LOCATE AND REMOVE ROGUE QUERIES FROM EXECUTING?
I started using MySQL 5 a couple of months ago and I was able to handle most of the issues OK. However there is this particular problem that is causing untold misery for my self and particularly my users. At unexpected times, a roque query is executed or triggered all on its accord and starts deleting a certain group of records. I remember manually entering executing a query like DELETE * from LEDGER_ACCOUNTS where LED_Type = BFW; from the MySQL GUI browser program some time ago. I have never used that query again and yet this query had been executed intermittently a number of times already. I have tried restarting the MySQL server a number of times but still no success. The question is, how do I locate this rogue query and remove it so it doesn't executed at all? Aibo Bebes papua New Guinea Be a better pen pal. Text or chat with friends inside Yahoo! Mail. See how. http://overview.mail.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: REPLICATION
Yes, Is it possible or not -Krishna Chandra Prajapati On Dec 5, 2007 8:56 PM, Jeff Mckeon [EMAIL PROTECTED] wrote: -Original Message- From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 05, 2007 8:09 AM To: MySql Subject: REPLICATION Hi, I am working on production and thinking of implementing chain replication A-B-C. A is replicated to B. B is being replicated to C. I want to know that there is any script or any cron by which i can replicate (manually or automatically) D server to C. (D is another replication server). I was thinking that manually i can get the mysql-bin log sql and execute it on server C. In this way D will replicate to C. The above task is possible or not. I haven't tested till now. Any other idea any body have. So you want to do this? A-B-C-D
Re: REPLICATION
Does any body has tried this On Dec 6, 2007 10:08 AM, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: Yes, Is it possible or not -Krishna Chandra Prajapati On Dec 5, 2007 8:56 PM, Jeff Mckeon [EMAIL PROTECTED] wrote: -Original Message- From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 05, 2007 8:09 AM To: MySql Subject: REPLICATION Hi, I am working on production and thinking of implementing chain replication A-B-C. A is replicated to B. B is being replicated to C. I want to know that there is any script or any cron by which i can replicate (manually or automatically) D server to C. (D is another replication server). I was thinking that manually i can get the mysql-bin log sql and execute it on server C. In this way D will replicate to C. The above task is possible or not. I haven't tested till now. Any other idea any body have. So you want to do this? A-B-C-D -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: [EMAIL PROTECTED]
RE: REPLICATION
Bubble bubble bubble -Original Message- From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 05, 2007 9:48 PM To: Jeff Mckeon Cc: MySql Subject: Re: REPLICATION Does any body has tried this On Dec 6, 2007 10:08 AM, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: Yes, Is it possible or not -Krishna Chandra Prajapati On Dec 5, 2007 8:56 PM, Jeff Mckeon [EMAIL PROTECTED] wrote: -Original Message- From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 05, 2007 8:09 AM To: MySql Subject: REPLICATION Hi, I am working on production and thinking of implementing chain replication A-B-C. A is replicated to B. B is being replicated to C. I want to know that there is any script or any cron by which i can replicate (manually or automatically) D server to C. (D is another replication server). I was thinking that manually i can get the mysql-bin log sql and execute it on server C. In this way D will replicate to C. The above task is possible or not. I haven't tested till now. Any other idea any body have. So you want to do this? A-B-C-D -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: [EMAIL PROTECTED] Internal Virus Database is out-of-date. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.16.6 - Release Date: 11/24/2007 12:00 AM Internal Virus Database is out-of-date. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.16.6 - Release Date: 11/24/2007 12:00 AM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]