RE: jdbc:mysql
Thanks for all, I have changed the user, and it runs correctly. Amaia From: Edwin Cruz [EMAIL PROTECTED] To: George Law [EMAIL PROTECTED] CC: Amaia Anabitarte [EMAIL PROTECTED], mysql@lists.mysql.com Subject: RE: jdbc:mysql Date: Tue, 28 Feb 2006 10:33:34 -0600 (CST) does the user that you're using has the enough privileges to connect from 192.xxx.xxx.xxx ??? Is your mysql server listening just on localhost (127.0.0.1)? That is differnet than 192.xxx.xxx.xxx -Original Message- From: Xiaobo Chen [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 28, 2006 11:27 AM To: Amaia Anabitarte Cc: mysql@lists.mysql.com Subject: Re: jdbc:mysql Not sure yet. Could it be that you're behind the router? And you might need to redirect the traffic to the model to the IP of your PC and you're PC's IP should be set static so that next time when you reboot, it won't change. Xiaobo Hi, I have a problem connecting to MySQL. I could connect to the database with this sentence: jdbc:mysql://localhost:3306/db but not with this sentence, with the same IP that the localhost: jdbc:mysql://192.xxx.xxx.xxx:3306/db What's wrong? Thanks for all, Amaia -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
puzzled by date functions (long)
Yesterday I was analyzing the behavior of the query optimizer, and I stumbled into a most curious case. I created two functions returning the extremes of a date range, and I wanted to see how many times those functions were called when used in a WHERE clause So I added log tracing instructions to both of them. The result was quite surprising. Let's set the environment first. create database if not exists test ; use test ; delimiter // drop function if exists today_start // CREATE FUNCTION today_start() RETURNS datetime begin insert into mylog (routine_name) values ('today_start'); -- return current_date(); return '2006-02-28 00:00:00'; end // drop function if exists today_end // CREATE FUNCTION today_end() RETURNS datetime begin insert into mylog (routine_name) values ('today_end'); -- return current_date() + interval 1 day - interval 1 second; return '2006-02-28 23:59:59'; end // delimiter ; drop table if exists t1; create table t1 ( id int(11) NOT NULL auto_increment, dt datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; drop table if exists mylog; create table mylog ( id int not null auto_increment primary key, routine_name varchar(20) not null, TS timestamp ); INSERT INTO `t1` VALUES (1,'2006-02-28 11:19:35'), (2,'2006-02-28 11:19:38'), (3,'2006-02-28 11:19:40'), (4,'2006-03-01 11:20:09'), (5,'2006-03-01 11:20:11'), (6,'2006-03-01 11:20:12'), (7,'2006-03-01 11:20:13'); select * from t1; ++-+ | id | dt | ++-+ | 1 | 2006-02-28 11:19:35 | | 2 | 2006-02-28 11:19:38 | | 3 | 2006-02-28 11:19:40 | | 4 | 2006-03-01 11:20:09 | | 5 | 2006-03-01 11:20:11 | | 6 | 2006-03-01 11:20:12 | | 7 | 2006-03-01 11:20:13 | ++-+ Now I select all today's rows from t1. select * from t1 where dt between today_start() and today_end(); ++-+ | id | dt | ++-+ | 1 | 2006-02-28 11:19:35 | | 2 | 2006-02-28 11:19:38 | | 3 | 2006-02-28 11:19:40 | ++-+ That's correct. Now, let's see how many times the function was called: select * from mylog; ++--+-+ | id | routine_name | TS | ++--+-+ | 1 | today_start | 2006-02-28 12:26:24 | | 2 | today_end| 2006-02-28 12:26:24 | ++--+-+ And that too was what I expected. But the story changes if I use a slightly different table. This one has the same columns as t1, but the primary key is the datetime column. drop table if exists t2; create table t2 ( id int not null, dt datetime NOT NULL, PRIMARY KEY (dt) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; insert into t2 (id, dt) select id, dt from t1; Now I did the same experiment with this table: truncate mylog; select * from t2 where dt between today_start() and today_end(); ++-+ | id | dt | ++-+ | 1 | 2006-02-28 11:19:35 | | 2 | 2006-02-28 11:19:38 | | 3 | 2006-02-28 11:19:40 | ++-+ The query finds the same records. Let's see what happens to mylog: select * from mylog; ++--+-+ | id | routine_name | TS | ++--+-+ | 1 | today_start | 2006-02-28 12:30:00 | | 2 | today_end| 2006-02-28 12:30:00 | | 3 | today_start | 2006-02-28 12:30:00 | | 4 | today_end| 2006-02-28 12:30:00 | ++--+-+ I can't imagine why this is happening. The only difference is that dt is now primary key. Instead of being called once, the routine is called twice. If I simply drop the primary key in t2, then the routine is called once per query, as expected. The result does not change if I use InnoDB tables instead of MyISAM. Can anyone explain what is happening here? Thanks Giuseppe -- _ _ _ _ (_|| | |(_| The Data Charmer _| http://datacharmer.blogspot.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MYSQL not starting
Hi, I am using MYSQL 4.1. But since yesterday I am not able to start the mysqld daemon. I am receiving these errors in /var/lib/mysql/*.err 060301 14:32:08 mysqld started 060301 14:32:08 [Warning] Asked for 196608 thread stack, but got 126976 InnoDB: Error: pthread_create returned 11 060301 14:32:08 mysqld ended And when I scroll through /var/log/messages I get these : Mar 1 14:32:12 moon kernel: audit(1141241528.781:45036): avc: denied { execmem } for pid=20857 comm=mysqld scontext=root:system_r:mysqld_t tcontext=root:system_r:mysqld_t tclass=process Can some one please help on an urgent basis as my neck is hanging as I was performing the backup when all this screw up took place. Till date I do not have any backup of mysql.
Problem with UNION
Hi, The following 3 queries on their own produce more rows than if I UNION them together: SELECT CONCAT('Y',DATE_FORMAT(Date,'%Y')) AS Booking_Year, CONCAT('M',DATE_FORMAT(Date,'%c')) AS Booking_Month, CONCAT('USR_', B.User_ID) AS User, Booking_Status, CONCAT('W_', Work_Type_ID) AS Day_Type, '1' AS Count FROM Bookings B, Booking_Dates BD WHERE B.Booking_ID = BD.Booking_ID AND B.Booking_Type = 'Booking' UNION SELECT CONCAT('Y',DATE_FORMAT(Date,'%Y')) AS Booking_Year, CONCAT('M',DATE_FORMAT(Date,'%c')) AS Booking_Month, CONCAT('USR_', B.User_ID) AS User, Booking_Status, CONCAT('T_', Task_ID) AS Day_Type, '1' AS Count FROM Bookings B, Booking_Dates BD WHERE B.Booking_ID = BD.Booking_ID AND B.Booking_Type = 'Task' UNION SELECT CONCAT('Y',DATE_FORMAT(Date,'%Y')) AS Booking_Year, CONCAT('M',DATE_FORMAT(Date,'%c')) AS Booking_Month, CONCAT('USR_', B.User_ID) AS User, Booking_Status, CONCAT('U_', Unavailability_ID) AS Day_Type, '1' AS Count FROM Bookings B, Booking_Dates BD WHERE B.Booking_ID = BD.Booking_ID AND B.Booking_Type = 'Unavailability' I am trying to get all types of bookings - unavailability, tasks and bookings into one result but am confused as to why the query produces less rows this way. Any tips here would be greatly appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with UNION
The UNION Syntax is: SELECT ... UNION [ALL | DISTINCT] SELECT ... [UNION [ALL | DISTINCT] SELECT ...] Lower in the manual it says: * A DISTINCT union can be produced explicitly by using UNION DISTINCT or implicitly by using UNION with no following DISTINCT or ALLkeyword. * ** So the thing is DISTINCT is implicit ! You will need to add after UNION the keyword ALL ! Good luck ! -- Gabriel PREDA Senior Web Developer
Re: Problem with UNION
Shaun [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi, The following 3 queries on their own produce more rows than if I UNION them together: SELECT CONCAT('Y',DATE_FORMAT(Date,'%Y')) AS Booking_Year, CONCAT('M',DATE_FORMAT(Date,'%c')) AS Booking_Month, CONCAT('USR_', B.User_ID) AS User, Booking_Status, CONCAT('W_', Work_Type_ID) AS Day_Type, '1' AS Count FROM Bookings B, Booking_Dates BD WHERE B.Booking_ID = BD.Booking_ID AND B.Booking_Type = 'Booking' UNION SELECT CONCAT('Y',DATE_FORMAT(Date,'%Y')) AS Booking_Year, CONCAT('M',DATE_FORMAT(Date,'%c')) AS Booking_Month, CONCAT('USR_', B.User_ID) AS User, Booking_Status, CONCAT('T_', Task_ID) AS Day_Type, '1' AS Count FROM Bookings B, Booking_Dates BD WHERE B.Booking_ID = BD.Booking_ID AND B.Booking_Type = 'Task' UNION SELECT CONCAT('Y',DATE_FORMAT(Date,'%Y')) AS Booking_Year, CONCAT('M',DATE_FORMAT(Date,'%c')) AS Booking_Month, CONCAT('USR_', B.User_ID) AS User, Booking_Status, CONCAT('U_', Unavailability_ID) AS Day_Type, '1' AS Count FROM Bookings B, Booking_Dates BD WHERE B.Booking_ID = BD.Booking_ID AND B.Booking_Type = 'Unavailability' I am trying to get all types of bookings - unavailability, tasks and bookings into one result but am confused as to why the query produces less rows this way. Any tips here would be greatly appreciated. UNION removes duplicate rows from the result set; in other words, if two identical rows are produced by two or more of the queries that have been UNIONed together, the duplicate rows are removed from the final result set. If you don't want to remove the duplicates, use UNION ALL instead of UNION. (I'm not sure if UNION ALL is supported in MySQL but it certainly is in DB2, my main database.) Perhaps that's why you have fewer rows in the UNION result than you do by summing up the row counts in the individual queries? By the way, I'm not sure how you posted your question but my copy of Outlook Express thinks it's a newsgroup post, not an email so I couldn't reply in the normal way. -- Rhino -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 268.1.1/271 - Release Date: 28/02/2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Alter table syntax question -
I am running MySql 4.1.6 in FC-4 Linux amd it is a huge learning exercise for me! I am using O'Reilly's MYSQL Cookbook, have gone through numerous pages of the reference manual and stuff on Google but still can get the proper commands and syntax to alter the following table T1. I would like Createdate to show the date the record was crated and remain that. I would like Workdate to show the current date unless changed by the user and remain there until the next time there was a change in the record. It would be good if these dates would come up immediately without re-opening the table as it seems to do now after my best efforts [which have never been completely successful] although that may well be a problem with Navicat which I am using as a GUI? My efforts at setting up the table have all been via the mysql command line. If someone could provide an example of a working ALTER TABLE T1 . command it would be greatly appreciated. Thank you. Bob Goodwin Zuni, Virginia # uname -a Linux box3 2.6.11-1.1369_FC4 #1 Thu Jun 2 22:55:56 EDT 2005 i686 athlon i386 GNU/Linux mysql select version(); +---+ | version() | +---+ | 4.1.16| +---+ 1 row in set (0.00 sec) mysql describe T1; ++--+--+-+-+ + | Field | Type | Null | Key | Default | Extra | ++--+--+-+-+ + | ID | int(6) | | PRI | NULL| auto_increment | | Createdate | timestamp| YES | | -00-00 00:00:00 | | | Lastname | varchar(75) | YES | | NULL | | | Firstname | varchar(75) | YES | | NULL | | | Address| varchar(75) | YES | | NULL | | | City | varchar(30) | YES | | NULL | | | Zip| varchar(15) | YES | | NULL | | | Area | varchar(20) | YES | | NULL | | | Tel01 | varchar(15) | YES | | NULL | | | Tel02 | varchar(15) | YES | | NULL | | | Tel03 | varchar(15) | YES | | NULL | | | Tel04 | varchar(15) | YES | | NULL | | | Category | varchar(20) | YES | | NULL | | | Workdate | timestamp| YES | | -00-00 00:00:00 | | | Notes | varchar(255) | YES | | NULL | | ++--+--+-+-+ + 15 rows in set (0.01 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: puzzled by date functions (long)
In the last episode (Mar 01), Giuseppe Maxia said: Yesterday I was analyzing the behavior of the query optimizer, and I stumbled into a most curious case. I created two functions returning the extremes of a date range, and I wanted to see how many times those functions were called when used in a WHERE clause So I added log tracing instructions to both of them. The result was quite surprising. Let's set the environment first. [..] I can't imagine why this is happening. The only difference is that dt is now primary key. Instead of being called once, the routine is called twice. If I simply drop the primary key in t2, then the routine is called once per query, as expected. The result does not change if I use InnoDB tables instead of MyISAM. My guess is that the query optimizer is comparing the range endpoints against the index to see whether it needs to do a full table scan, index range scan, or optimize the table away. Depending on what data is shared between the optimizer and the query enging itself, it may need to evaluate the WHERE clause multiple times. Just a guess though; examining the source, or replacing your stored procedure with a UDF function that printed its own stack trace to a text file, would tell you for certain. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
using replace() to remove tab chars
Hi all, I am trying to use the replace() function in MySQL 4.1.13a to find and remove tab characters. I'm not sure how to signify the tab char, however. I've tried, \t to no avail: update products_description set products_description = replace(`products_description`,\t, ) where products_id = 33; Does anyone have any suggestions? The mysql server [and client] are running under Linux. The products_description field is a 'text' type. If there's further info you need, please let me know. Thanks in advance, /vjl/ -- Vince J. LaMonica Knowledge is knowing a street is one way. [EMAIL PROTECTED] * Wisdom is still looking in both directions. When there's nothing else to read: http://w3log.vjl.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: using replace() to remove tab chars
[snip] Does anyone have any suggestions? The mysql server [and client] are running under Linux. The products_description field is a 'text' type. If there's further info you need, please let me know. [/snip] Are you using REPLACE(column_name, '\t', ' ') ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQL not starting
Mar 1 14:32:12 moon kernel: audit(1141241528.781:45036): avc: denied { execmem } for pid=20857 comm=mysqld scontext=root:system_r:mysqld_t tcontext=root:system_r:mysqld_t tclass=process you have enabled selinux disable it or learn how to use it correctly -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: using replace() to remove tab chars
On Wed, 1 Mar 2006 [EMAIL PROTECTED] wrote: } [snip] } Does anyone have any suggestions? The mysql server [and client] are } running under Linux. The products_description field is a 'text' type. If } } there's further info you need, please let me know. } [/snip] } } Are you using REPLACE(column_name, '\t', ' ') ? I thought I had put an example of the SQL syntax in my e.mail, but yes, I have tried it with both single and double quotes: update products_description set products_description = replace(`products_description`,\t, ) where products_id = 37; and update products_description set products_description = replace(`products_description`,'\t',' ') where products_id = 37; For right now, I am only doing this on one record, for testing, but when I get the syntax right, the where clause will be removed. Currently, mysql reports: Query OK, 0 rows affected (0.00 sec) Rows matched: 1 Changed: 0 Warnings: 0 regardless if I use single quotes or double quotes in the replace() call. Thanks for your quick reply! /vjl/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: using replace() to remove tab chars
On Wed, 1 Mar 2006, Vince LaMonica wrote: } update products_description set products_description = } replace(`products_description`,'\t',' ') where products_id = 37; [snip] I should have also stated that in the above example, both the table name and the column name are the same - that's not a typo. /vjl/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: using replace() to remove tab chars
Try the following: REPLACE(products_description, CHAR(9), ) Randall Price VT.SETI.IAD.MIG:Microsoft Implementation Group http://vtmig.vt.edu [EMAIL PROTECTED] -Original Message- From: Vince LaMonica [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 01, 2006 10:44 AM To: mysql@lists.mysql.com Subject: using replace() to remove tab chars Hi all, I am trying to use the replace() function in MySQL 4.1.13a to find and remove tab characters. I'm not sure how to signify the tab char, however. I've tried, \t to no avail: update products_description set products_description = replace(`products_description`,\t, ) where products_id = 33; Does anyone have any suggestions? The mysql server [and client] are running under Linux. The products_description field is a 'text' type. If there's further info you need, please let me know. Thanks in advance, /vjl/ -- Vince J. LaMonica Knowledge is knowing a street is one way. [EMAIL PROTECTED] * Wisdom is still looking in both directions. When there's nothing else to read: http://w3log.vjl.org/ -- 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]
Does MySQL have the ability to send resultsets from stored procedures?
Does MySQL have the ability to send resultsets from stored procedures? (similar to ref cursors in Oracle). _ FREE pop-up blocking with the new MSN Toolbar get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What is the rowsize limitation in MySQL?
What is the rowsize limitation in MySQL? _ Dont just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Support for temporary tables inside stored procedures?
Does MySQL have support for temporary tables inside stored procedures? _ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Does MySQL have the ability to send resultsets from stored procedures?
J A [EMAIL PROTECTED] wrote on 03/01/2006 11:04:50 AM: Does MySQL have the ability to send resultsets from stored procedures? (similar to ref cursors in Oracle). _ FREE pop-up blocking with the new MSN Toolbar – get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/ It depend on how you call the stored procedure if your client library can handle a resultset or not. If you treat it like a reqular query, most client libraries have little problem accepting the results of a SELECT statement called from within your SPROC. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: What is the rowsize limitation in MySQL?
J A [EMAIL PROTECTED] wrote on 03/01/2006 11:06:27 AM: What is the rowsize limitation in MySQL? _ Don’t just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/ I checked at: http://dev.mysql.com/doc/refman/5.0/en/table-size.html http://dev.mysql.com/doc/refman/5.0/en/legal-names.html http://dev.mysql.com/doc/refman/5.0/en/create-table.html but didn't see a definitive answer. Anyone else find one? It may be related to max_allowed_packet http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: What is the rowsize limitation in MySQL?
What is the rowsize limitation in MySQL? That depends on the table type, for example, take a look here: http://dev.mysql.com/doc/refman/5.0/en/innodb-restrictions.html Martijn Tonies Database Workbench - development tool for MySQL, and more! 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: Support for temporary tables inside stored procedures?
J A [EMAIL PROTECTED] wrote on 03/01/2006 11:08:10 AM: Does MySQL have support for temporary tables inside stored procedures? _ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ Yes, you can create and destroy temporary tables from within stored procedures. Remember that all temporary tables and user variables are connection-specific. You have to maintain the connection between SPROC executions to have the results of one SPROC be available to the next. Drop a connection and your user variables and temporary tables created by that connection go away (garbage collected by the server). The obverse situation is also true. Using a pooled connection may result in object carry-over from one process to another (because returning the connection to the pool does may not actually drop the connection). You should always destroy any temporary object when you are through using it and always initialize your variables before usage. That way you don't accidentally hand old data off to following threads and you don't inherit previous threads state values (unless you really want them). Shawn Green Database Administrator Unimin Corporation - Spruce Pine
RE: file permission
This function is great! Anyone know how to include the column names, table info, any extra miscellaneous info? I use SQLyog for exporting to csv and they do include the columns, my bet is its some SQL option. The manual doesn't specify, at least in the select syntax part. Ariel -Mensaje original- De: unplug [mailto:[EMAIL PROTECTED] Enviado el: martes, 28 de febrero de 2006 21:55 Para: mysql@lists.mysql.com Asunto: file permission Hi, When I use a query SELECT * into outfile '/tmp/report.csv' fields terminated by ',' lines terminated by '\n' FROM table;, it will create a file with the following permission and owner. -rw-rw-rw- 1 mysql mysql 2489 Mar 1 11:30 report.csv How can I change the default permission or the ownership of the file? Rgds, unplug -- 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: file permission
[snip] This function is great! Anyone know how to include the column names, table info, any extra miscellaneous info? I use SQLyog for exporting to csv and they do include the columns, my bet is its some SQL option. The manual doesn't specify, at least in the select syntax part. [/snip] Any select query will be handled properly. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: file permission
I didn't get it :( for example, I'm using: SELECT * INTO OUTFILE 'result_a.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY '\n' FROM lista_switches; But this only saves the rows of data, with no column name; I would like to store the column name so the .csv is easier to read. If MySQL has options for storing, for example, the date as the last row, first column, even better; although I think I see what you mean, it reallly depends on the sleect statement? I f I manage to display what I want with the select, I'll be able to store it? That should work... But I though there was a -include_column_names option or something :) Which way should I go? Ariel -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Enviado el: miércoles, 01 de marzo de 2006 10:58 Para: Ariel Sánchez Mora; mysql@lists.mysql.com Asunto: RE: file permission [snip] This function is great! Anyone know how to include the column names, table info, any extra miscellaneous info? I use SQLyog for exporting to csv and they do include the columns, my bet is its some SQL option. The manual doesn't specify, at least in the select syntax part. [/snip] Any select query will be handled properly. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: using replace() to remove tab chars
On Wed, 1 Mar 2006, Price, Randall wrote: } Try the following: } } REPLACE(products_description, CHAR(9), ) Thanks, Randall, that did it. And I feel quite stupid, as well, because I re-checked my two test entries [33 and 37] and both had had their tabs removed at some point. So it turns out that my original, replace(products_description, '\t', ' ') *did* work, I was just testing it on two rows that had multiple spaces in a row, but not tabs. But for the archives and future posts - the CHAR(9) worked as did the single quoted \t. Thanks for all your help, everyone. Much appreciated! /vjl/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQL not starting
I have disabled selinux but no luck [EMAIL PROTECTED] ~]# system-config-securitylevel Security Level (*) Disabled OK [EMAIL PROTECTED] ~]# /etc/init.d/mysql start Starting MySQL... [FAILED] [EMAIL PROTECTED] ~]# I am receiving these errors in /var/lib/mysql/*.err 060301 14:32:08 mysqld started 060301 14:32:08 [Warning] Asked for 196608 thread stack, but got 126976 InnoDB: Error: pthread_create returned 11 060301 14:32:08 mysqld ended And when I scroll through /var/log/messages I get these : Mar 1 14:32:12 moon kernel: audit(1141241528.781:45036): avc: denied { execmem } for pid=20857 comm=mysqld scontext=root:system_r:mysqld_t tcontext=root:system_r:mysqld_t tclass=process I have also tried running these commands : [EMAIL PROTECTED] sqlserver4.1]# rpm -Uvh MySQL-server-4.1.14-0.i386.rpm --force warning: MySQL-server-4.1.14-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f 5 Preparing...### [100%] Giving mysqld a couple of seconds to exit nicely 1:MySQL-server ### [100%] 060301 15:16:12 [Warning] Asked for 196608 thread stack, but got 126976 060301 15:16:12 [ERROR] Can't create interrupt-thread (error 11, errno: 4) Installation of system tables failed! Examine the logs in /var/lib/mysql for more information. You can also try to start the mysqld daemon with: /usr/sbin/mysqld --skip-grant You can use the command line tool /usr/bin/mysql to connect to the mysql database and look at the grant tables: shell /usr/bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /var/lib/mysql that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the /usr/bin/mysqlbug script! Starting MySQL...[FAILED] [EMAIL PROTECTED] sqlserver4.1]# [EMAIL PROTECTED] sqlserver4.1]# /usr/sbin/mysqld --skip-grant 060301 15:20:44 [Warning] Asked for 196608 thread stack, but got 126976 060301 15:20:44 [ERROR] Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 060301 15:20:44 [ERROR] Aborting 060301 15:20:44 [Note] /usr/sbin/mysqld: Shutdown complete [EMAIL PROTECTED] sqlserver4.1]# Can anyone Please HELP - Original Message - From: Tom Brown [EMAIL PROTECTED] To: Atul Aggarwal [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Wednesday, March 01, 2006 9:18 PM Subject: Re: MYSQL not starting Mar 1 14:32:12 moon kernel: audit(1141241528.781:45036): avc: denied { execmem } for pid=20857 comm=mysqld scontext=root:system_r:mysqld_t tcontext=root:system_r:mysqld_t tclass=process you have enabled selinux disable it or learn how to use it correctly -- 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: MYSQL not starting
I have disabled selinux but no luck how? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Not create homedir for user mysql in installation
Hi all. I've read the instructions at http://dev.mysql.com/doc/refman/5.0/en/installing-binary.html. It says The basic commands that you must execute to install and use a MySQL binary distribution are: shell groupadd mysql shell useradd -g mysql mysql shell cd /usr/local shell gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf - shell ln -s full-path-to-mysql-VERSION-OS mysql shell cd mysql shell scripts/mysql_install_db --user=mysql shell chown -R root . shell chown -R mysql data shell chgrp -R mysql . shell bin/mysqld_safe --user=mysql In step 2 says to create an user mysql associated to group mysl. Is more convenient to not create a home directory associated to mysql? Which was the suitable command: useradd -d /dev/null -g mysql mysql? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
manage multiple mysql servers on different hosts?
Hello everyone, We're running several mysql servers for different applications on different machines. Instead of connecting to each mysql server manually to find out basic information, e.g. versions, mostly like what 'show variables' returns, plus what databases exist on each server, are there any tools that can do that? Can phpMyAdmin manage multiple mysql servers? Thanks in advance for any ideas, Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: manage multiple mysql servers on different hosts?
[snip] We're running several mysql servers for different applications on different machines. Instead of connecting to each mysql server manually to find out basic information, e.g. versions, mostly like what 'show variables' returns, plus what databases exist on each server, are there any tools that can do that? Can phpMyAdmin manage multiple mysql servers? [/snip] I have used phpMyAdmin to manage up to 20 MySQL servers and hundreds of millions of records. It is easy to install and configure. It is robust and scalable. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Alter table syntax question -
bobgoodwin wrote: I am running MySql 4.1.6 in FC-4 Linux amd it is a huge learning exercise for me! I am using O'Reilly's MYSQL Cookbook, have gone through numerous pages of the reference manual and stuff on Google but still can get the proper commands and syntax to alter the following table T1. I would like Createdate to show the date the record was crated and remain that. I would like Workdate to show the current date unless changed by the user and remain there until the next time there was a change in the record. It would be good if these dates would come up immediately without re-opening the table as it seems to do now after my best efforts [which have never been completely successful] although that may well be a problem with Navicat which I am using as a GUI? My efforts at setting up the table have all been via the mysql command line. If someone could provide an example of a working ALTER TABLE T1 . command it would be greatly appreciated. Thank you. Bob Goodwin Zuni, Virginia # uname -a Linux box3 2.6.11-1.1369_FC4 #1 Thu Jun 2 22:55:56 EDT 2005 i686 athlon i386 GNU/Linux mysql select version(); +---+ | version() | +---+ | 4.1.16| +---+ 1 row in set (0.00 sec) mysql describe T1; ++--+--+-+-+ + | Field | Type | Null | Key | Default | Extra | ++--+--+-+-+ + | ID | int(6) | | PRI | NULL| auto_increment | | Createdate | timestamp| YES | | -00-00 00:00:00 | | | Lastname | varchar(75) | YES | | NULL | | | Firstname | varchar(75) | YES | | NULL | | | Address| varchar(75) | YES | | NULL | | | City | varchar(30) | YES | | NULL | | | Zip| varchar(15) | YES | | NULL | | | Area | varchar(20) | YES | | NULL | | | Tel01 | varchar(15) | YES | | NULL | | | Tel02 | varchar(15) | YES | | NULL | | | Tel03 | varchar(15) | YES | | NULL | | | Tel04 | varchar(15) | YES | | NULL | | | Category | varchar(20) | YES | | NULL | | | Workdate | timestamp| YES | | -00-00 00:00:00 | | | Notes | varchar(255) | YES | | NULL | | ++--+--+-+-+ + 15 rows in set (0.01 sec) You have Createdate and Workdate swapped. The first timestamp gets updated on every update to the record. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Replication from multiple masters?
Does anyone know if it's possible to replicate to a single slave from different databases on different masters? For instance: M1:dbAM2:dbB \ / rep rep \ / Slave Thanks, Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication from multiple masters?
On 3/1/06, Jeff [EMAIL PROTECTED] wrote: Does anyone know if it's possible to replicate to a single slave from different databases on different masters? For instance: M1:dbAM2:dbB \ / rep rep \ / Slave http://dev.mysql.com/doc/refman/5.1/en/replication-features.html snipMySQL only supports one master and many slaves./snip -- Greg Donald Zend Certified Engineer MySQL Core Certification http://destiney.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: manage multiple mysql servers on different hosts?
On 3/1/06, Bing Du [EMAIL PROTECTED] wrote: We're running several mysql servers for different applications on different machines. Instead of connecting to each mysql server manually to find out basic information, e.g. versions, mostly like what 'show variables' returns, plus what databases exist on each server, are there any tools that can do that? Can phpMyAdmin manage multiple mysql servers? Additional MySQL servers can be defined in phpMyAdmin's config.inc.php file. -- Greg Donald Zend Certified Engineer MySQL Core Certification http://destiney.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication from multiple masters?
That's not entirely true. You can have two instances of mysql running on the slave, and dbA connects to one instance, and dbB connects to the other. Jeff, when you say, different databases, do you mean that each master has a single mysql instance, and if you typed on M1, show databases you'd see (for example), dbA and if you did the same on M2, you'd see, dbB? If so, I wonder if there is another way to get around it: - create a virtual IP address that represents both masters. Use that virtual master in the my.cnf on the slave; each master has to have an identical replication account - put dbA and dbB on the slave - restrict replication from each master to their respective databases - dbA and dbB - ie don't replicate changes to the mysql database. The two masters appear as one (which overcomes the single-IP-address in the slave's my.cnf file), and each master has a different database inside the mysql instance, they aren't stepping on each others toes. Just my 2 cents. David. Greg Donald wrote: On 3/1/06, Jeff [EMAIL PROTECTED] wrote: Does anyone know if it's possible to replicate to a single slave from different databases on different masters? For instance: M1:dbAM2:dbB \ / rep rep \ / Slave http://dev.mysql.com/doc/refman/5.1/en/replication-features.html snipMySQL only supports one master and many slaves./snip -- Greg Donald Zend Certified Engineer MySQL Core Certification http://destiney.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication from multiple masters?
MySQL cannot handle more than one incoming binlog at a time. The facilities are just not in the code. You also run into a nightmare if a database exists on BOTH masters (same name on both systems) and the PK values of any tables (also with matching names) overlap. If both masters update the same row at appx the same time, we could run into deadlocking in the slave that didn't happen on either master. It also means that the slave and at least one of the masters will become out of sync (because the other master's changes remain in the database) and replication is considered broken at that point. It's a serious can of worms to handle multi-master replication. Your two instances on one matching replicating to two separate masters is not a multi-master replication (more than one master replicating with a single slave) it's two single-master slave setups running on the same machine. Close but not quite what the original post was looking for (I don't think). Shawn Green Database Administrator Unimin Corporation - Spruce Pine David Griffiths [EMAIL PROTECTED] wrote on 03/01/2006 04:34:26 PM: That's not entirely true. You can have two instances of mysql running on the slave, and dbA connects to one instance, and dbB connects to the other. Jeff, when you say, different databases, do you mean that each master has a single mysql instance, and if you typed on M1, show databases you'd see (for example), dbA and if you did the same on M2, you'd see, dbB? If so, I wonder if there is another way to get around it: - create a virtual IP address that represents both masters. Use that virtual master in the my.cnf on the slave; each master has to have an identical replication account - put dbA and dbB on the slave - restrict replication from each master to their respective databases - dbA and dbB - ie don't replicate changes to the mysql database. The two masters appear as one (which overcomes the single-IP-address in the slave's my.cnf file), and each master has a different database inside the mysql instance, they aren't stepping on each others toes. Just my 2 cents. David. Greg Donald wrote: On 3/1/06, Jeff [EMAIL PROTECTED] wrote: Does anyone know if it's possible to replicate to a single slave from different databases on different masters? For instance: M1:dbAM2:dbB \ / rep rep \ / Slave http://dev.mysql.com/doc/refman/5.1/en/replication-features.html snipMySQL only supports one master and many slaves./snip -- Greg Donald Zend Certified Engineer MySQL Core Certification http://destiney.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Enforcing Isolation in MySQL database
Hello , I suppose the InnoDB tables in Mysql have REPEATABLE-READ as the default isolation. Is the concurrency enforced automatically by the database or is there anything the application programmer has to do to make sure the data consistent. How does the REPEATABLE-READ resolve the following scenario. User1 opens a application and reads a row on the screen. User2 opens the same application and read the same row on the screen. User2 updates a field (and commits ,as the autocommit is on), User1 still is reading the non-updated row , and updates the same field updated by the User2 to different value. How does it affect the database when normal select , update queries are used. What should the application programmer to enforce database concurrency. Thank you, Vinay
Unknown column 'testcase_root.Test' in 'order clause'
I am receiving an error Unknown column 'testcase_root.Test' in 'order clause' I do not understand why the error is pointing to this as an error, nor if it means anything that the name of the column is correctly identified in the query below as testcase_root.TestID. I have checked the DB and the column is present. Can someone help point out what I am missing and or steps to debug the problem. SELECT testplans.SubTestCaseKey, testcase_root.ID, testplans.testcasesuffix_name_FK, testcase_root.TestID, testcase_root.TestDesc, testplans.FSAGA, testplans.Priority, testplans.tester_list_Name_FK FROM testcase_root LEFT JOIN testplans ON testcase_root.ID = testplans.testcase_root_ID_FK WHERE (((testplans.plantriggers_ID_FK)=76530)) OR (((testplans.plantriggers_ID_FK) Is Null)) ORDER BY testcase_root.TestID; Robert M. Bartis Lucent Technologies, Inc Tel: +1 732 949 4565 Mail: [EMAIL PROTECTED] Pgr: [EMAIL PROTECTED]
RE: Unknown column 'testcase_root.Test' in 'order clause'
Sorry:-\ Meant to say I do not understand why mySQL is pointing to this as an error Bob -Original Message- From: Bartis, Robert M (Bob) [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 01, 2006 5:30 PM To: 'mysql' Subject: Unknown column 'testcase_root.Test' in 'order clause' I am receiving an error Unknown column 'testcase_root.Test' in 'order clause' I do not understand why the error is pointing to this as an error, nor if it means anything that the name of the column is correctly identified in the query below as testcase_root.TestID. I have checked the DB and the column is present. Can someone help point out what I am missing and or steps to debug the problem. SELECT testplans.SubTestCaseKey, testcase_root.ID, testplans.testcasesuffix_name_FK, testcase_root.TestID, testcase_root.TestDesc, testplans.FSAGA, testplans.Priority, testplans.tester_list_Name_FK FROM testcase_root LEFT JOIN testplans ON testcase_root.ID = testplans.testcase_root_ID_FK WHERE (((testplans.plantriggers_ID_FK)=76530)) OR (((testplans.plantriggers_ID_FK) Is Null)) ORDER BY testcase_root.TestID; Robert M. Bartis Lucent Technologies, Inc Tel: +1 732 949 4565 Mail: [EMAIL PROTECTED] Pgr: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Enforcing Isolation in MySQL database
- Original Message - From: Vinay To: mysql@lists.mysql.com Sent: Wednesday, March 01, 2006 5:00 PM Subject: Enforcing Isolation in MySQL database Hello , I suppose the InnoDB tables in Mysql have REPEATABLE-READ as the default isolation. Is the concurrency enforced automatically by the database or is there anything the application programmer has to do to make sure the data consistent. How does the REPEATABLE-READ resolve the following scenario. User1 opens a application and reads a row on the screen. User2 opens the same application and read the same row on the screen. User2 updates a field (and commits ,as the autocommit is on), User1 still is reading the non-updated row , and updates the same field updated by the User2 to different value. How does it affect the database when normal select , update queries are used. What should the application programmer to enforce database concurrency. Thank you, Vinay
Re: Replication from multiple masters?
Good point about the bin-logs. Yup - that would sink it. If mysql used individual binary logs per master database, it would work. Ya, if someone was silly enough to have two different databases with the same name, it would be bad, even with separate binary logs for each database. If you have two mysql instances on a single slave, you'll need more memory, faster CPUs, more disk space, etc. But it could be a viable option if the machine is just being used to provide a hot-standby. David [EMAIL PROTECTED] wrote: MySQL cannot handle more than one incoming binlog at a time. The facilities are just not in the code. You also run into a nightmare if a database exists on BOTH masters (same name on both systems) and the PK values of any tables (also with matching names) overlap. If both masters update the same row at appx the same time, we could run into deadlocking in the slave that didn't happen on either master. It also means that the slave and at least one of the masters will become out of sync (because the other master's changes remain in the database) and replication is considered broken at that point. It's a serious can of worms to handle multi-master replication. Your two instances on one matching replicating to two separate masters is not a multi-master replication (more than one master replicating with a single slave) it's two single-master slave setups running on the same machine. Close but not quite what the original post was looking for (I don't think). Shawn Green Database Administrator Unimin Corporation - Spruce Pine David Griffiths [EMAIL PROTECTED] wrote on 03/01/2006 04:34:26 PM: That's not entirely true. You can have two instances of mysql running on the slave, and dbA connects to one instance, and dbB connects to the other. Jeff, when you say, different databases, do you mean that each master has a single mysql instance, and if you typed on M1, show databases you'd see (for example), dbA and if you did the same on M2, you'd see, dbB? If so, I wonder if there is another way to get around it: - create a virtual IP address that represents both masters. Use that virtual master in the my.cnf on the slave; each master has to have an identical replication account - put dbA and dbB on the slave - restrict replication from each master to their respective databases - dbA and dbB - ie don't replicate changes to the mysql database. The two masters appear as one (which overcomes the single-IP-address in the slave's my.cnf file), and each master has a different database inside the mysql instance, they aren't stepping on each others toes. Just my 2 cents. David. Greg Donald wrote: On 3/1/06, Jeff [EMAIL PROTECTED] wrote: Does anyone know if it's possible to replicate to a single slave from different databases on different masters? For instance: M1:dbAM2:dbB \ / rep rep \ / Slave http://dev.mysql.com/doc/refman/5.1/en/replication-features.html snipMySQL only supports one master and many slaves./snip -- Greg Donald Zend Certified Engineer MySQL Core Certification http://destiney.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]
/var/lib/mysql/ directory permission
I finally ended up removing and installing back my mysql since i have to success retrieving my mysql root password. Now I am putting my databases back. It shows an error something that it couldn't write unto file already exists. What I did I change the permission of the directory like this chmod -R 777 /vaar/lib/mysql/ database. After doing this my applications work perfectly. Now my question is how can I put that permission to the original permission of the that database that mysql will be able to write again I know it is not that fully permitted.? Thank you. :' ' ' ' ': Arnel G. Pastrana ::' : [EMAIL PROTECTED] . ` '` `- Debian - when you have better things to do than fixing a system. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL and Hyperthreading
Hi, We found a severe performance degradation when Hyperthreading is on and thread_concurrency=20. We are using OSDL DBT-1 as the benchmark and got about 200 to 250 BT (bogotransactions per second) HT is OFF normal case but 30 to 50 BT on HT is ON. innodb_thread_concurrency=20 So we did profile (using oprofile tool) and got the following profiling data. My impression is that mutex_spin_wait (and ut_delay) is something wrong if HT is ON. (Spin-wait loop is too expensive if it is hyperthreading.) I added the following code but it does not help it. $ diff -pu ut0ut.c.orig ut0ut.c --- ut0ut.c.orig2005-10-17 10:27:43.0 +0900 +++ ut0ut.c 2006-02-28 11:59:16.777840496 +0900 @@ -290,6 +290,13 @@ ut_delay( j = 0; for (i = 0; i delay * 50; i++) { + /* When executing a spin-wait loop on the Hyper-Threading + processor, the processor can suffer a severe performance + penalty. The pause instruction provides a hint to the + processor. Please refer IA-32 Intel Architecture + Software Developers Manual, Vol 3. */ + __asm__ __volatile__( + pause; \n); j += i; } What do you think? Is there any hints? HT is OFF CPU: P4 / Xeon, speed 2793.26 MHz (estimated) Counted GLOBAL_POWER_EVENTS events (time during which processor is not stopped) with a unit mask of 0x01 (mandatory) count 10 samples %image name app name symbol name 13159082 8.8445 libc-2.3.4.solibc-2.3.4.somemcpy 12565549 8.4456 libpthread-2.3.4.so libpthread-2.3.4.so pthread_mutex_trylock 11387363 7.6537 mysqld mysqld rec_get_offsets_func 9631916 6.4738 libpthread-2.3.4.so libpthread-2.3.4.so pthread_mutex_unlock 8794484 5.9110 mysqld mysqld btr_search_guess_on_hash 4949248 3.3265 mysqld mysqld row_search_for_mysql 4022481 2.7036 mysqld mysqld ut_delay 3754265 2.5233 mysqld mysqld cmp_dtuple_rec_with_match 2535190 1.7040 mysqld mysqld row_sel_store_mysql_rec 2520957 1.6944 mysqld mysqld btr_cur_search_to_nth_level HT is ON CPU: P4 / Xeon with 2 hyper-threads, speed 2793.26 MHz (estimated) Counted GLOBAL_POWER_EVENTS events (time during which processor is not stopped) with a unit mask of 0x01 (mandatory) count 10 samples %image name app name symbol name 53221317 21.4225 libpthread-2.3.4.so libpthread-2.3.4.so pthread_mutex_lock 25743323 10.3621 mysqld mysqld ut_delay 12345146 4.9691 vmlinux vmlinux do_futex 12066038 4.8568 mysqld mysqld mutex_spin_wait 10395391 4.1843 vmlinux vmlinux LKST_ETYPE_PROCESS_SCHED_ENTER_HEADER_hook 9247281 3.7222 libpthread-2.3.4.so libpthread-2.3.4.so pthread_mutex_unlock 7407229 2.9815 vmlinux vmlinux futex_requeue 5921454 2.3835 libpthread-2.3.4.so libpthread-2.3.4.so pthread_mutex_trylock 5484279 2.2075 vmlinux vmlinux LKST_ETYPE_PROCESS_WAKEUP_HEADER_hook 4846067 1.9506 vmlinux vmlinux __switch_to Regards, Hiro -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQL not starting
Thanks Tom! Ya it was a problem of SELinux but i had to turn it off from GUI not from CUI(system-config-securitylevel). It really did worked. Thanks Again :) - Original Message - From: Tom Brown [EMAIL PROTECTED] To: Atul Aggarwal [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Wednesday, March 01, 2006 11:04 PM Subject: Re: MYSQL not starting I have disabled selinux but no luck how? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] - Original Message - From: Atul Aggarwal [EMAIL PROTECTED] To: Tom Brown [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Wednesday, March 01, 2006 10:50 PM Subject: Re: MYSQL not starting I have disabled selinux but no luck [EMAIL PROTECTED] ~]# system-config-securitylevel Security Level (*) Disabled OK [EMAIL PROTECTED] ~]# /etc/init.d/mysql start Starting MySQL... [FAILED] [EMAIL PROTECTED] ~]# I am receiving these errors in /var/lib/mysql/*.err 060301 14:32:08 mysqld started 060301 14:32:08 [Warning] Asked for 196608 thread stack, but got 126976 InnoDB: Error: pthread_create returned 11 060301 14:32:08 mysqld ended And when I scroll through /var/log/messages I get these : Mar 1 14:32:12 moon kernel: audit(1141241528.781:45036): avc: denied { execmem } for pid=20857 comm=mysqld scontext=root:system_r:mysqld_t tcontext=root:system_r:mysqld_t tclass=process I have also tried running these commands : [EMAIL PROTECTED] sqlserver4.1]# rpm -Uvh MySQL-server-4.1.14-0.i386.rpm --force warning: MySQL-server-4.1.14-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f 5 Preparing...### [100%] Giving mysqld a couple of seconds to exit nicely 1:MySQL-server ### [100%] 060301 15:16:12 [Warning] Asked for 196608 thread stack, but got 126976 060301 15:16:12 [ERROR] Can't create interrupt-thread (error 11, errno: 4) Installation of system tables failed! Examine the logs in /var/lib/mysql for more information. You can also try to start the mysqld daemon with: /usr/sbin/mysqld --skip-grant You can use the command line tool /usr/bin/mysql to connect to the mysql database and look at the grant tables: shell /usr/bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /var/lib/mysql that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the /usr/bin/mysqlbug script! Starting MySQL...[FAILED] [EMAIL PROTECTED] sqlserver4.1]# [EMAIL PROTECTED] sqlserver4.1]# /usr/sbin/mysqld --skip-grant 060301 15:20:44 [Warning] Asked for 196608 thread stack, but got 126976 060301 15:20:44 [ERROR] Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 060301 15:20:44 [ERROR] Aborting 060301 15:20:44 [Note] /usr/sbin/mysqld: Shutdown complete [EMAIL PROTECTED] sqlserver4.1]# Can anyone Please HELP - Original Message - From: Tom Brown [EMAIL PROTECTED] To: Atul Aggarwal [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Wednesday, March 01, 2006 9:18 PM Subject: Re: MYSQL not starting Mar 1 14:32:12 moon kernel: audit(1141241528.781:45036): avc: denied { execmem } for pid=20857 comm=mysqld scontext=root:system_r:mysqld_t tcontext=root:system_r:mysqld_t tclass=process you have enabled selinux disable it or learn how to use it correctly -- 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]