Re: Certified MySQL Associate (CMA) certification value
Thanks for the input, everyone. I've gone back and am now leaning towards a VCC (Vancouver Community College) certificate: Database Developer Certificate (DDC) http://www.vcc.ca/cs/_printable-datesort.cfm? area=CSCOMPUTERprog=DATABASE#CSCOMPUTERDATABASE What I like about this is the cumulative effect of formalised learning with, I hope, job placement help from VCC. It's, I think, an outrageous price, but is fast and gives me something tangible. I don't mind paying the cash, but if it's not worth much more than: Associate (CMA) Certification http://www.mysql.com/certification/ it wouldn't make sense in a cost/benefit analysis. Just curious what others think of this program. -Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Certified MySQL Associate (CMA) certification value
Well, it sounds like something you can learn a lot from. But nobody's ever heard of it. And if you're looking to learn about MySQL in particular, I suspect you won't get much out of this; it will mostly be general knowledge. So if you're looking for a job as a MySQL DBA, I suspect this won't do a whole lot for you. On Mon, Feb 25, 2008 at 3:34 AM, Thufir [EMAIL PROTECTED] wrote: Thanks for the input, everyone. I've gone back and am now leaning towards a VCC (Vancouver Community College) certificate: Database Developer Certificate (DDC) http://www.vcc.ca/cs/_printable-datesort.cfm? area=CSCOMPUTERprog=DATABASE#CSCOMPUTERDATABASE What I like about this is the cumulative effect of formalised learning with, I hope, job placement help from VCC. It's, I think, an outrageous price, but is fast and gives me something tangible. I don't mind paying the cash, but if it's not worth much more than: Associate (CMA) Certification http://www.mysql.com/certification/ it wouldn't make sense in a cost/benefit analysis. Just curious what others think of this program. -Thufir -- 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]
Re: Re-creating tables
At 05:16 PM 2/24/2008, Waynn Lue wrote: That's actually why I'm dropping/recreating, because I thought the changes I have to make require multiple statements. Let me know if that's a wrong assumption, here's what I have to do. 1. drop two foreign keys from Users to Actions (in the previous example I gave). 2. expand INT to BIGINT on Users 3. expand INT to BIGINT on Actions 4. recreate two foreign keys from Users to Actions. That's four alter statements, which each require making temporary table copies, so I assumed dropping/recreating was faster. Each of your Alter statements will mean a temp table is created, the data is moved over, the changes are made, and the indexes are rebuilt. It will be 4x faster if you do it all in one Alter statement. Since the alter statement will rebuild the keys at the end, is there really a need to to drop the foreign keys or is this an InnoDb quirk? Try something like: alter table MyTable change column Users Users BigInt, change column Actions Actions BigInt; You normally would drop indexes to speed things up when loading a lot of data into the table, then rebuild the indexes after the data has been loaded. But since Alter table does this anyways, you're not accomplishing anything by doing it manually. Mike On Sat, Feb 23, 2008 at 2:42 PM, mos [EMAIL PROTECTED] wrote: At 05:55 AM 2/23/2008, Waynn Lue wrote: I have three or four different ALTER TABLE commands I need to run on a 9 million row table (related to the previous email I sent). I've tried running it before and it just takes way too long, so I was thinking the fastest way to get this done is to create new tables with the final schema, then drop the old tables and rename the new ones. There are a few ways to go about this. 1. Stop the reads/writes to the db. Use mysqldump, truncate the tables, drop the tables, recreate with the correct schema, then import it again. 2. Create a new temporary table, keep the reads and writes going, SELECT into that new table, when it catches up, turn off the reads/writes for a short period of time while I truncate/drop then rename the temporary table. 3. Use replication somehow to go from the old table to the new table (can I do that?). 4. Create a new temporary table, stop reads/writes to it, then do an INSERT INTO SELECT from the old to new table. One slight problem with choice 2 is that I don't know how to make sure that I know when the reads/writes are done. Not all the tables have an auto-increment id, so I can't just keep inserting in random ids. As an aside, if I do INSERT INTO SELECT, does it block any operations on the table that I'm SELECTing from? Thanks for any insights, Waynn Waynn, Why are you using 3 or 4 alter table commands on the same table? Each command means it will create a copy of the table, makes the changes to that, then it renames it to the correct table name and deletes the old table name. You should be able to add all 4 alter table commands in 1 Alter Table statement, just by putting a , between the alter specifications. See the syntax in the manual: http://dev.mysql.com/doc/refman/5.0/en/alter-table.html This means the table gets rebuilt only once and not 4 times! Mike -- 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]
Re: records ordered incorrectly
In the last episode (Feb 25), Saravanan said: Hi Lists, I have created a procedure to calculate and update a statistics. It works correctly. It updates daily. For a single day alone it shows records in reverse order. For other days it shows correctly. Will this happen? but the date with time shows the orders in revers check the order for 2008-02-22 mysql select * from stats; You haven't specified an order in your query, so MySQL is free to return results in any order at all. Most of the time that will be the oder the records were inserted, but if you have deleted rows and then inserted new ones, those records will be inserted into the gaps. Add an ORDER BY datecol to the end of your query if you want the records sorted by date. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
glabal and session variables
hi list I don't understand what happen in mysql 4.1.22 ! ! ! ! ! (the same in version 5.0) -bash-3.00$ mysql -e show variables like 'wait_timeout%' +---+---+ | Variable_name | Value | +---+---+ | wait_timeout | *30*| +---+---+ -bash-3.00$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 55 to server version: 4.1.22-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show variables like 'wait_timeout%'; +---+---+ | Variable_name | Value | +---+---+ | wait_timeout | *28800 *| +---+---+ 1 row in set (0.00 sec) mysql show global variables like 'wait_timeout%'; +---+---+ | Variable_name | Value | +---+---+ | wait_timeout | *30*| +---+---+ 1 row in set (0.00 sec) mysql
Bogus unsubscribe!
I just got an email from the list robot asking me to confirm my request to unsubscribe. The only problem is, I did not ask to unsubscribe! Is anybody else getting this? Thanks, Mike
records ordered incorrectly
Hi Lists, I have created a procedure to calculate and update a statistics. It works correctly. It updates daily. For a single day alone it shows records in reverse order. For other days it shows correctly. Will this happen? but the date with time shows the orders in revers check the order for 2008-02-22 mysql select * from stats; | 2008-02-21 | 0 |0 | 2008-02-21 01:25:01 | | 2008-02-21 | 1 | 58 | 2008-02-21 01:25:02 | | 2008-02-21 | 5 |0 | 2008-02-21 01:25:02 | | 2008-02-21 | 10 | 523 | 2008-02-21 01:25:14 | | 2008-02-21 | 20 |1 | 2008-02-21 01:25:14 | | 2008-02-21 | 21 |3 | 2008-02-21 01:25:14 | | 2008-02-21 | 22 |0 | 2008-02-21 01:25:14 | | 2008-02-21 | 23 |0 | 2008-02-21 01:25:14 | | 2008-02-21 | 24 |0 | 2008-02-21 01:25:15 | | 2008-02-21 | 40 |0 | 2008-02-21 01:25:15 | | 2008-02-21 | 50 |4 | 2008-02-21 01:25:16 | | 2008-02-21 | 51 |0 | 2008-02-21 01:25:16 | | 2008-02-21 | 52 | 27 | 2008-02-21 01:25:17 | | 2008-02-21 | 53 |0 | 2008-02-21 01:25:17 | | 2008-02-21 | 54 |0 | 2008-02-21 01:25:17 | | 2008-02-21 | 60 |0 | 2008-02-21 01:25:17 | | 2008-02-21 | 70 |0 | 2008-02-21 01:25:17 | | 2008-02-21 | 90 |0 | 2008-02-21 01:25:17 | | 2008-02-21 |100 |0 | 2008-02-21 01:25:17 | | 2008-02-22 |100 |0 | 2008-02-22 18:12:00 | | 2008-02-22 | 90 |0 | 2008-02-22 18:12:00 | | 2008-02-22 | 70 |0 | 2008-02-22 18:12:00 | | 2008-02-22 | 60 |0 | 2008-02-22 18:11:59 | | 2008-02-22 | 54 |0 | 2008-02-22 18:11:59 | | 2008-02-22 | 53 |0 | 2008-02-22 18:11:59 | | 2008-02-22 | 52 |0 | 2008-02-22 18:11:59 | | 2008-02-22 | 51 |0 | 2008-02-22 18:11:58 | | 2008-02-22 | 50 |0 | 2008-02-22 18:11:58 | | 2008-02-22 | 40 |0 | 2008-02-22 18:11:58 | | 2008-02-22 | 24 |0 | 2008-02-22 18:11:58 | | 2008-02-22 | 23 |0 | 2008-02-22 18:11:56 | | 2008-02-22 | 22 |0 | 2008-02-22 18:11:56 | | 2008-02-22 | 21 |0 | 2008-02-22 18:11:56 | | 2008-02-22 | 20 |0 | 2008-02-22 18:11:56 | | 2008-02-22 | 10 |0 | 2008-02-22 18:11:56 | | 2008-02-22 | 5 |0 | 2008-02-22 18:11:24 | | 2008-02-22 | 1 |0 | 2008-02-22 18:11:24 | | 2008-02-22 | 0 |0 | 2008-02-22 18:11:24 | | 2008-02-23 | 0 |0 | 2008-02-23 18:10:59 | | 2008-02-23 | 1 |0 | 2008-02-23 18:11:00 | | 2008-02-23 | 5 |0 | 2008-02-23 18:11:00 | | 2008-02-23 | 10 |0 | 2008-02-23 18:11:07 | | 2008-02-23 | 20 |0 | 2008-02-23 18:11:07 | | 2008-02-23 | 21 |0 | 2008-02-23 18:11:08 | | 2008-02-23 | 22 |0 | 2008-02-23 18:11:08 | | 2008-02-23 | 23 |0 | 2008-02-23 18:11:08 | | 2008-02-23 | 24 |0 | 2008-02-23 18:11:23 | | 2008-02-23 | 40 |0 | 2008-02-23 18:11:23 | | 2008-02-23 | 50 |0 | 2008-02-23 18:11:23 | | 2008-02-23 | 51 |0 | 2008-02-23 18:11:23 | | 2008-02-23 | 52 |0 | 2008-02-23 18:11:24 | | 2008-02-23 | 53 |0 | 2008-02-23 18:11:24 | | 2008-02-23 | 54 |0 | 2008-02-23 18:11:24 | | 2008-02-23 | 60 |0 | 2008-02-23 18:11:24 | | 2008-02-23 | 70 |0 | 2008-02-23 18:11:24 | | 2008-02-23 | 90 |0 | 2008-02-23 18:11:24 | | 2008-02-23 |100 |0 | 2008-02-23 18:11:24 | | 2008-02-24 | 0 |0 | 2008-02-24 18:10:35 | | 2008-02-24 | 1 |0 | 2008-02-24 18:10:36 | | 2008-02-24 | 5 |0 | 2008-02-24 18:10:36 | | 2008-02-24 | 10 |0 | 2008-02-24 18:10:42 | | 2008-02-24 | 20 |0 | 2008-02-24 18:10:42 | | 2008-02-24 | 21 |0 | 2008-02-24 18:10:42 | | 2008-02-24 | 22 |0 | 2008-02-24 18:10:43 | | 2008-02-24 | 23 |0 | 2008-02-24 18:10:43 | | 2008-02-24 | 24 |0 | 2008-02-24 18:10:53 | | 2008-02-24 | 40 |0 | 2008-02-24 18:10:53 | | 2008-02-24 | 50 |0 | 2008-02-24 18:10:53 | | 2008-02-24 | 51 |0 | 2008-02-24 18:10:53 | | 2008-02-24 | 52 |0 | 2008-02-24 18:10:54 | | 2008-02-24 | 53 |0 | 2008-02-24 18:10:54 | | 2008-02-24 | 54 |0 |
Re: Bogus unsubscribe!
I just got an email from the list robot asking me to confirm my request to unsubscribe. The only problem is, I did not ask to unsubscribe! Is anybody else getting this? It's possible that you get this because you didn't remove that particular part of the message when you replied. When a bot follows the links in these messages, it can trigger the unsubscribe code... Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle MS SQL Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Bogus unsubscribe!
I got this recently and haven't replied to the list in a while. I responded to the list owner. -Original Message- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: Monday, February 25, 2008 12:13 PM To: mysql@lists.mysql.com Subject: Re: Bogus unsubscribe! I just got an email from the list robot asking me to confirm my request to unsubscribe. The only problem is, I did not ask to unsubscribe! Is anybody else getting this? It's possible that you get this because you didn't remove that particular part of the message when you replied. When a bot follows the links in these messages, it can trigger the unsubscribe code... Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle MS SQL Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.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]
Re: Re-creating tables
The problem here though is that there is no MyTable. There are two separate tables, Users and Actions, and I can't alter both of them in the same statement, as far as I know. As a result, when I alter just Users, that fails because there's an FK between Users and Actions and the type of the two columns is now different. On Mon, Feb 25, 2008 at 7:50 AM, mos [EMAIL PROTECTED] wrote: At 05:16 PM 2/24/2008, Waynn Lue wrote: That's actually why I'm dropping/recreating, because I thought the changes I have to make require multiple statements. Let me know if that's a wrong assumption, here's what I have to do. 1. drop two foreign keys from Users to Actions (in the previous example I gave). 2. expand INT to BIGINT on Users 3. expand INT to BIGINT on Actions 4. recreate two foreign keys from Users to Actions. That's four alter statements, which each require making temporary table copies, so I assumed dropping/recreating was faster. Each of your Alter statements will mean a temp table is created, the data is moved over, the changes are made, and the indexes are rebuilt. It will be 4x faster if you do it all in one Alter statement. Since the alter statement will rebuild the keys at the end, is there really a need to to drop the foreign keys or is this an InnoDb quirk? Try something like: alter table MyTable change column Users Users BigInt, change column Actions Actions BigInt; You normally would drop indexes to speed things up when loading a lot of data into the table, then rebuild the indexes after the data has been loaded. But since Alter table does this anyways, you're not accomplishing anything by doing it manually. Mike On Sat, Feb 23, 2008 at 2:42 PM, mos [EMAIL PROTECTED] wrote: At 05:55 AM 2/23/2008, Waynn Lue wrote: I have three or four different ALTER TABLE commands I need to run on a 9 million row table (related to the previous email I sent). I've tried running it before and it just takes way too long, so I was thinking the fastest way to get this done is to create new tables with the final schema, then drop the old tables and rename the new ones. There are a few ways to go about this. 1. Stop the reads/writes to the db. Use mysqldump, truncate the tables, drop the tables, recreate with the correct schema, then import it again. 2. Create a new temporary table, keep the reads and writes going, SELECT into that new table, when it catches up, turn off the reads/writes for a short period of time while I truncate/drop then rename the temporary table. 3. Use replication somehow to go from the old table to the new table (can I do that?). 4. Create a new temporary table, stop reads/writes to it, then do an INSERT INTO SELECT from the old to new table. One slight problem with choice 2 is that I don't know how to make sure that I know when the reads/writes are done. Not all the tables have an auto-increment id, so I can't just keep inserting in random ids. As an aside, if I do INSERT INTO SELECT, does it block any operations on the table that I'm SELECTing from? Thanks for any insights, Waynn Waynn, Why are you using 3 or 4 alter table commands on the same table? Each command means it will create a copy of the table, makes the changes to that, then it renames it to the correct table name and deletes the old table name. You should be able to add all 4 alter table commands in 1 Alter Table statement, just by putting a , between the alter specifications. See the syntax in the manual: http://dev.mysql.com/doc/refman/5.0/en/alter-table.html This means the table gets rebuilt only once and not 4 times! Mike -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Setting Variables
Dear all.. Does anyone know how to set variables in MySQL ideal for the performance so the machine can run maximum which variable i should be notice? what is the value of each variable? how can i calculate to get the value? is there the formula? for example: max_allowed_packet =? max_binlog_size=? read_buffer_size=? etc. mysql version : v 5.1.22 InnoDB RAM 1GB OS : FreeBSD Thx before
Re: Help with running MySQL 5 on OS X Leopard
Yes, I did and what happens is that the 'xxx' becomes appended to the next line and the line after that asks the user for the password (which also fails). The way I got it working was this: mysql -u root -p Kindest regards, Unnsse On Feb 25, 2008, at 8:34 AM, fire9 wrote: Unnsse Khan 写道: Hello there, I am running OS X Leopard on an Intel based iMac machine... Followed the instructions to a T and everything works as described in: http://hivelogic.com/articles/installing-mysql-on-mac-os-x/ Now, after running MySQL using launchd, when I try to login using: mysql -u root I get the following error: Falcon:~ untz$ mysql -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) What am I possibly doing wrong? Many, many thanks! -Unnsse Unnsse, hi, you try mysql -uroot -pxxx(xxx is your password) done -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Setting Variables
Dear all.. Does anyone know how to set variables in MySQL ideal for the performance so the machine can run maximum which variable i should be notice? what is the value of each variable? how can i calculate to get the value? is there the formula? for example: max_allowed_packet =? max_binlog_size=? read_buffer_size=? etc. mysql version : v 5.1.22 InnoDB RAM 1GB OS : FreeBSD Thx before -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Apache log errors
Hi All, My web server log error is NULL::dba can't connect to mysql The above error shows occasionally in the error log file of apache. Every thing is fine on the mysql database server. It happens twice or thrice a day. I am not able to find out whats the issue. Please help me. Thanks, Prajapati
Apache log errors
Hi All, My web server log error is NULL::dba can't connect to mysql The above error shows occasionally in the error log file of apache. Every thing is fine on the mysql database server. It happens twice or thrice a day. I am not able to find out whats the issue. Please help me. Thanks, Krishna Chandra Prajapati
Re: Apache log errors
Krishna Chandra Prajapati 写道: Hi All, My web server log error is NULL::dba can't connect to mysql The above error shows occasionally in the error log file of apache. Every thing is fine on the mysql database server. It happens twice or thrice a day. I am not able to find out whats the issue. Please help me. Thanks, Krishna Chandra Prajapati pls check your mysql.err log and some detailes information. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]