Re: mysql logs query with indexes used to the slow-log and not logging if there is index in reverse order

ptimizer's choice. > > ** ** > > *From:* spameden [mailto:spame...@gmail.com] > *Sent:* Monday, October 15, 2012 3:29 PM > > *To:* Rick James > *Cc:* mysql@lists.mysql.com > *Subject:* Re: mysql logs query with indexes used to the slow-log and not > logging if

RE: mysql logs query with indexes used to the slow-log and not logging if there is index in reverse order

From: spameden [mailto:spame...@gmail.com] Sent: Monday, October 15, 2012 3:29 PM To: Rick James Cc: mysql@lists.mysql.com Subject: Re: mysql logs query with indexes used to the slow-log and not logging if there is index in reverse order Sorry, forgot to say: mysql> show variables lik

RE: mysql logs query with indexes used to the slow-log and not logging if there is index in reverse order

ber 15, 2012 3:23 PM To: Rick James Cc: mysql@lists.mysql.com Subject: Re: mysql logs query with indexes used to the slow-log and not logging if there is index in reverse order Sorry, my previous e-mail was a test on MySQL-5.5.28 on an empty table. Here is the MySQL-5.1 Percona testing table: mys

Re: mysql logs query with indexes used to the slow-log and not logging if there is index in reverse order

Sorry, forgot to say: mysql> show variables like 'long_query_time%'; +-+---+ | Variable_name | Value | +-+---+ | long_query_time | 10.00 | +-+---+ 1 row in set (0.00 sec) It's getting in the log only due: mysql> sh

Re: mysql logs query with indexes used to the slow-log and not logging if there is index in reverse order

Sorry, my previous e-mail was a test on MySQL-5.5.28 on an empty table. Here is the MySQL-5.1 Percona testing table: mysql> select count(*) from send_sms_test; +--+ | count(*) | +--+ | 143879 | +--+ 1 row in set (0.03 sec) Without LIMIT: mysql> desc select * from send_s

RE: mysql logs query with indexes used to the slow-log and not logging if there is index in reverse order

* Rows = 11 / 22 -- don't take the numbers too seriously; they are crude approximations based on estimated cardinality. * The 11 comes from the LIMIT -- therefore useless in judging the efficiency. (The 22 may be 2*11; I don't know.) * Run the EXPLAINs without LIMIT -- that will avoid the bogu

Re: mysql logs query with indexes used to the slow-log and not logging if there is index in reverse order

Hi, I've just checked on MySQL-5.5.28 it acts absolutely same. I need to use (priority,time) KEY instead of (time, priority) because query results in better performance. With first key used there is no need to sort at all, whilst if using latter: mysql> *desc select * from send_sms_test FORCE IN

RE: mysql 5.5.24/27 massive slow down since upgrade to solaris 10 u9 with 147440-19

Are you I/O bound? XFS What "elevator" strategy? Compare settings. Especially innodb_flush_log_at_trx_commit . > -Original Message- > From: Gael Martinez [mailto:gael.marti...@gmail.com] > Sent: Sunday, October 07, 2012 5:46 PM > To: mysql > Subject: mysql 5.5.24/27 massive slow down si

RE: Mysql cluster installation error

uebernehmen. > Date: Sun, 23 Sep 2012 12:40:17 -0500 > Subject: Re: Mysql cluster installation error > From: aast...@gmail.com > To: mdyk...@gmail.com > CC: mysql@lists.mysql.com > > Thanks! > And how do i connect the cluster from the remote host. > When i try to connect

Re: Mysql cluster installation error

If your remote host is not configured as a sql node to your cluster, you don't need to just to import the schema. Run mysqldump on any client machine specifying any of your configured sql nodes via -host=. On 2012-09-23 1:40 PM, "Aastha" wrote: Thanks! And how do i connect the cluster from th

Re: Mysql cluster installation error

Thanks! And how do i connect the cluster from the remote host. When i try to connect one of the SQL node through remote host it says access denied. WHile the same is working fine from local host. Kindly help. Thanks! On Sun, Sep 23, 2012 at 12:35 PM, Michael Dykman wrote: > If all you need to tr

Re: Mysql cluster installation error

If all you need to transfer is schema, do it the same way you would any other table type: use mysqldump with the - - no-data option. On 2012-09-23 1:29 PM, "Aastha" wrote: Thanks Nitin. I specied the location of my.ini while starting the SQL node and it worked fine. I have anothe rquestion : Ho

Re: Mysql cluster installation error

Thanks Nitin. I specied the location of my.ini while starting the SQL node and it worked fine. I have anothe rquestion : How to connect the cluster and reomte host. And i have to copy a schema from one Mysql clsuter to another. How do i do that. Regards, On Sun, Sep 23, 2012 at 3:13 AM, Nitin Me

Re: Mysql cluster installation error

Hi Aastha,   I'm not 100% sure but you could try defining the full connectstring using:   ndb-connectstring = localhost:1186   See if that helps.   Regards, From: Aastha To: mysql@lists.mysql.com Sent: Sunday, September 23, 2012 7:51 AM Subject: Mysql cluster

RE: mysql is eating up lot of CPU and memory

High CPU --> Find the worst query and let's optimize it. SHOW CREATE TABLE SHOW TABLE STATUS EXPLAIN SELECT ... It may be as simple as adding a 'compound' index. Or rewriting a WHERE clause. There are literally hundreds of possible issues and answers. The 3 things above are probably e

Re: mysql is eating up lot of CPU and memory

Hey Simon, You just performed the classic, "I have an issue, but I won't provide any info." Please elaborate on the issue. Provide hardware spec, config information. Tell us why you suspect the mysqld is consuming too much resource? We can attempt to assist with more info as there are no silver

Re: mysql replication

Hi , Can you paste the complete error log. Regards, KarthiK.P.R On Wed, Aug 29, 2012 at 7:04 AM, aaron zhang wrote: > Hi all > > i use mysql database,when i use mysql replication ,the slave host do not > replication,i check the error message,i found error message,it is 'row is > too large', i

Re: MySQL, UTF8 and collations

On 8/28/2012 4:49 AM, Johan De Meersman wrote: ... Guess I'll be fixing it manually (well, sed is my friend) in a mysqldump before syncing up the second node after it's been upgraded. There is another method you can use that doesn't require dump+sed+restore. Convert the column from it's cur

RE: MySQL, UTF8 and collations

e- > From: Johan De Meersman [mailto:vegiv...@tuxera.be] > Sent: Tuesday, August 28, 2012 1:49 AM > To: Rick James > Cc: mysql > Subject: Re: MySQL, UTF8 and collations > > - Original Message - > > From: "Rick James" > > > > There is a

Re: MySQL, UTF8 and collations

- Original Message - > From: "Rick James" > > There is a section on German Sharp-s in > http://mysql.rjweb.org/doc.php/charcoll > I agree with "dirty". Yes, seen it, but thank you. I'm not having character set issues, everything is nicely UTF8. I'm merely running into the scheiße bug,

RE: MySQL, UTF8 and collations

There is a section on German Sharp-s in http://mysql.rjweb.org/doc.php/charcoll I agree with "dirty". As I understand it, about 5.1.24, they said "Oops, sharp-s is collated wrong, let's fix it". The fix broke things, but they stuck by the "correct" sorting. Eventually they said "Oh, let's add a

Re: mysql Digest 23 Aug 2012 15:37:35 -0000 Issue 4963

I apologize for my assertion that system requirements do not appear on the website. In retrospect, that was silly of me to assert ANYTHING is not on ANY WEBSITE anywhere. What I should have said (hinted at in my last sentence) is that system requirements are not PROMINENTLY listed on the websi

Re: MySQL LDAP Authentication Plugin - Full example with source code

Hi Rick, The plugin does not need to access to /etc/passwd or /etc/shadow. It uses an LDAP Server to authenticate the user through "ldap_simple_bind_s" function. Best regards. On Mon, Aug 20, 2012 at 7:24 PM, Rick James wrote: > Does that depend on mysql running as "root" in order to see /etc

RE: MySQL LDAP Authentication Plugin - Full example with source code

Does that depend on mysql running as "root" in order to see /etc/shadow (or whatever)? If so, that is too big a security hole to do. > -Original Message- > From: Ignacio Ocampo [mailto:naf...@gmail.com] > Sent: Sunday, August 12, 2012 3:54 PM > To: mysql > Subject: MySQL LDAP Authenticat

RE: MySQL crashed..

rom: J M [mailto:jerom...@gmail.com] > Sent: Wednesday, July 11, 2012 7:11 AM > To: MySql > Subject: Re: MySQL crashed.. > > sorry.. im using 5.1 > > On Wed, Jul 11, 2012 at 10:09 AM, J M wrote: > > hi all, > > > > our DB crashed for some reason... any in

RE: mysql - uppoer limit for doing simultaneous red/writes..

elounge.net] > Sent: Saturday, July 14, 2012 11:19 AM > To: mysql@lists.mysql.com > Subject: Re: mysql - uppoer limit for doing simultaneous red/writes.. > > > > Am 14.07.2012 19:16, schrieb bruce: > > Hi. > > > > Considering a system, where I have a centraliz

Re: mysql failed login attempts

Hi Tim, The information you provided is not enough, do you have the error which you encountered. The configs you mentioned are not related to connection. Please provide the full error list may be trace from the application logs, the way you are trying to connect, plus the configs associated with c

Re: mysql - uppoer limit for doing simultaneous red/writes..

Am 14.07.2012 19:16, schrieb bruce: > Hi. > > Considering a system, where I have a centralized Mysql setup. I'm not > sure exactly what this should be called, single box, cluster, etc... > > But I'm looking to have a system of a a bunch of boxes, whihc run apps > that will access (read/write) t

Re: MySQL crashed..

sorry.. im using 5.1 On Wed, Jul 11, 2012 at 10:09 AM, J M wrote: > hi all, > > our DB crashed for some reason... any inputs would be greatly appreciated.. > > 120711 8:12:21 - mysqld got signal 11 ; > This could be because you hit a bug. It is also possible that this binary > or one of the li

Re: Mysql starts to die at 27 SQL processes

Don't you have any message? For the number of max connections, I suppose you are hitting the limit of file opened, there are no messages at error log? Check this: http://www.geeksww.com/tutorials/database_management_systems/mysql/configuration/mysql_open_files_limit_openfileslimit_vs_openfileslimi

RE: Mysql starts to die at 27 SQL processes

System to its knees! To see how bad it is, go to the WP directory and do time ls -l | wc (if you are on unix) > -Original Message- > From: J M [mailto:jerom...@gmail.com] > Sent: Thursday, May 31, 2012 11:17 AM > To: Baron Schwartz > Cc: MySql > Subject: Re: Mysql s

Re: Mysql starts to die at 27 SQL processes

Thank Baron, i want to see if there is something i can do from the DB end. and BTW, i've been using the plugin already. On Thu, May 31, 2012 at 1:01 PM, Baron Schwartz wrote: > In this case the solution is much easier outside of MySQL than inside. > http://ocaoimh.ie/wp-super-cache/ i

Re: Mysql starts to die at 27 SQL processes

In this case the solution is much easier outside of MySQL than inside. http://ocaoimh.ie/wp-super-cache/ is an excellent option. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

RE: MySQL Community Server 5.1.63 has been released

iven different constants. > -Original Message- > From: Johan De Meersman [mailto:vegiv...@tuxera.be] > Sent: Monday, May 14, 2012 9:17 AM > To: Reindl Harald > Cc: mysql@lists.mysql.com > Subject: Re: MySQL Community Server 5.1.63 has been released > > > >

RE: MySQL Community Server 5.1.63 has been released

What you do recommend in place of mysql_real_escape_string()? > -Original Message- > From: Govinda [mailto:govinda.webdnat...@gmail.com] > Sent: Monday, May 14, 2012 7:34 AM > To: Johan De Meersman > Cc: mysql@lists.mysql.com > Subject: Re: MySQL Community Server 5.1.63

Re: MySQL Community Server 5.1.63 has been released

- Original Message - > From: "Reindl Harald" > > but what about the dramatical reduced query-cache hits i see > in some peace of software switching to prepared statements? > > dbmail2 as example had around 300 sql-actions per second > dbmail3 using prepared statements currently around

RE: MySQL slowlog - only in file?

. David. -Original Message- From: Carsten Pedersen [mailto:cars...@bitbybit.dk] Sent: Monday, May 14, 2012 6:16 AM To: P.R.Karthik Cc: Nilnandan Joshi; Rafał Radecki; mysql@lists.mysql.com Subject: Re: MySQL slowlog - only in file? Alternatively, you can copy the data into another table

Re: MySQL Community Server 5.1.63 has been released

Am 14.05.2012 16:50, schrieb Johan De Meersman: > - Original Message - >> From: "Govinda" >> >> 1.) Is anyone *who knows what he is doing* still using >> mysql_real_escape_string()? Ever? > > I seem to vaguely remember someone showing me some code that would bypass > escaping; but I d

Re: Mysql is toying me... why sometimes an insert or update can be slow!? I getting bald cuz this

I used to have these issues in mysql version 5.0.41. On Mon, May 14, 2012 at 8:13 PM, Johan De Meersman wrote: > - Original Message - > > From: "Ananda Kumar" > > > > If numeric, then why are u using quotes. With quotes, mysql will > > ignore the index and do a full table scan > > Will

Re: MySQL Community Server 5.1.63 has been released

- Original Message - > From: "Govinda" > > 1.) Is anyone *who knows what he is doing* still using > mysql_real_escape_string()? Ever? I seem to vaguely remember someone showing me some code that would bypass escaping; but I didn't really pay a lot of attention, to be honest :-) Person

Re: Mysql is toying me... why sometimes an insert or update can be slow!? I getting bald cuz this

- Original Message - > From: "Ananda Kumar" > > If numeric, then why are u using quotes. With quotes, mysql will > ignore the index and do a full table scan Will it? Common sense dictates that it would convert to the column's native type before comparing; and a quick explain seems to co

Re: MySQL Community Server 5.1.63 has been released

Bugs Fixed * Security Fix: Bug #64884 was fixed. * Security Fix: Bug #59387 was fixed. >>> >>> Anyone want to elaborate on the nature or severity of the security >>> problem? Both are private / inaccessible to me. >> >> Bug #64884 was apparently also applicable to, and fixed

Re: Mysql is toying me... why sometimes an insert or update can be slow!? I getting bald cuz this

If numeric, then why are u using quotes. With quotes, mysql will ignore the index and do a full table scan On Mon, May 14, 2012 at 7:31 PM, Andrés Tello wrote: > > > Yes, I'm using indexes, accountid is the primary key, and is numeric and > autoincrement. The process doing the deadlock is no lo

Re: Mysql is toying me... why sometimes an insert or update can be slow!? I getting bald cuz this

Yes, I'm using indexes, accountid is the primary key, and is numeric and autoincrement. The process doing the deadlock is no longer done... The structure of the inserted database has changed. Originaly it was a single table with 219millions rows, now I partitioned the hable in... 60 tables, 1 for

Re: Mysql is toying me... why sometimes an insert or update can be slow!? I getting bald cuz this

is accountid a number or varchar column On Sat, May 12, 2012 at 7:38 PM, Andrés Tello wrote: > While doning a batch process... > > show full processlist show: > > | 544 | prod | 90.0.0.51:51262 | tmz2012 | Query |6 | > end | update `account` set `balance`= 0.00 + >

RE: MySQL slowlog - only in file?

- From: Carsten Pedersen [mailto:cars...@bitbybit.dk] Sent: Monday, May 14, 2012 6:16 AM To: P.R.Karthik Cc: Nilnandan Joshi; Rafał Radecki; mysql@lists.mysql.com Subject: Re: MySQL slowlog - only in file? Alternatively, you can copy the data into another table easily: http://www.bitbybit.dk

Re: MySQL Community Server 5.1.63 has been released

- Original Message - > > > From: "Baron Schwartz" > > > >> Bugs Fixed > >> * Security Fix: Bug #64884 was fixed. > >> * Security Fix: Bug #59387 was fixed. > > > > Anyone want to elaborate on the nature or severity of the security > > problem? Both are private / inaccessible t

RE: Mysql is toying me... why sometimes an insert or update can be slow!? I getting bald cuz this

> -Original Message- > From: Andrés Tello [mailto:mr.crip...@gmail.com] > Sent: May 12, 2012 10:08 AM > To: mysql > Subject: Mysql is toying me... why sometimes an insert or update can be > slow!? I getting bald cuz this > > While doning a batch process... > > show full processlist show:

Re: MySQL slowlog - only in file?

Alternatively, you can copy the data into another table easily: http://www.bitbybit.dk/carsten/blog/?p=115 Best, / Carsten On 14.05.2012 09:34, P.R.Karthik wrote: Hi Rafal, If there are more slow queries in your server and logging them into a table will increase the IO of the server. It is b

Re: MySQL slowlog - only in file?

Hi Rafal, If there are more slow queries in your server and logging them into a table will increase the IO of the server. It is better to be in a file. The slow query log file can be processed easily by pt-query-digest . Regard

Re: MySQL slowlog - only in file?

Hi Rafal, If you are using MySQL 5.1 and later version than you can enable the log tables and you can see slow queries in the log tables. Please check this post: http://nilinfobin.com/2012/03/slow_log-and-general_log-tables-in-mysql-5-1/ regards, Nilnandan On Fri, May 11, 2012 at 2:40 PM, Rafał

Re: MySQL Community Server 5.1.63 has been released

- Original Message - > From: "Baron Schwartz" > >> Bugs Fixed >> * Security Fix: Bug #64884 was fixed. >> * Security Fix: Bug #59387 was fixed. > > Anyone want to elaborate on the nature or severity of the security > problem? Both are private / inaccessible to me. Bug #64884

Re: MySQL Community Server 5.1.63 has been released

Hi, > D.1.1. Changes in MySQL 5.1.63 (7th May, 2012) > >   Bugs Fixed > >     * Security Fix: Bug #64884 was fixed. > >     * Security Fix: Bug #59387 was fixed. Anyone want to elaborate on the nature or severity of the security problem? Both are private / inaccessible to me. -- MySQL General Ma

Re: MySQL Crash when Open_files reach 128

On Wed, May 2, 2012 at 4:58 AM, vishesh kumar wrote: > I am getting following in error log > > > 120502 07:52:05  mysqld started > 120502

RE: MySQL Crash when Open_files reach 128

> Cc: mysql@lists.mysql.com > Subject: Re: MySQL Crash when Open_files reach 128 > > I am getting following in error log > > --- > --- >

Re: MySQL Crash when Open_files reach 128

Sever OS is CentOS 5 and limits.conf settings is unlimited for open files . Thanks ~Vishesh On Wed, May 2, 2012 at 5:37 PM, LinuxInfo wrote: > Hello, > > what is the Server OS? I know on my Ubuntu Server i have config the > /etc/limits.conf and the my.cnf > After the modification you have to r

Re: MySQL Crash when Open_files reach 128

Hello, what is the Server OS? I know on my Ubuntu Server i have config the /etc/limits.conf and the my.cnf After the modification you have to restart the Server. Am 02.05.2012 um 13:58 schrieb vishesh kumar : > I am getting following in error log > >

Re: MySQL Crash when Open_files reach 128

I am getting following in error log 120502 07:52:05 mysqld started 120502 7:52:05 [Warning] Asked for 196608 thread stack, but got 1269

Re: MySQL Crash when Open_files reach 128

Thanks for response . I didn't set any open_files limit in my.cnf . For testing i set open_files_limit to 300 but still MySQL crashing after 128. ~Vishesh On Wed, May 2, 2012 at 4:28 PM, Reindl Harald wrote: > > > Am 02.05.2012 12:52, schrieb vishesh kumar: > > Hi Members, > > > > I am using My

Re: MySQL Crash when Open_files reach 128

Am 02.05.2012 12:52, schrieb vishesh kumar: > Hi Members, > > I am using MySQL 5.0.67 . I am facing the problem of MySQL crashing > problem . MySQL Crash after every a few minutes . On investigation i > noticed that when the Open_files status variable reach 128 MySQL Crash and > i get followin

Re: mySQL Query and Report Builder

Hi Don, Have a look at Jasper Reports: http://jasperforge.org/ -NT Em 30-04-2012 17:53, Don Wieland escreveu: Hello, I have a client who needs the ability to do statistical reporting on their mySQL db data. Is there an app that provides an easy UI that will allow my client to build a line ite

Re: mySQL Query and Report Builder

On 30.04.2012 18:53, Don Wieland wrote: Hello, I have a client who needs the ability to do statistical reporting on their mySQL db data. Is there an app that provides an easy UI that will allow my client to build a line item query, specify fields to be include in the result of the query, and the

Re: mysql friendly dates

On 4/16/2012 3:04 PM, Haluk Karamete wrote: What's the right built in php date function formatting would be to take a simple date, that's in a format like 05/16/1960 and turn it into a mysql datetime datatype friendly format? I don't mind H M S to be as 00:00:00/ wrote my own: function US2ISODa

Re: MySQL Multi-Master Replication

NDB Cluster -- Not only can this use multiple machines in one cluster, but you can have multiple clusters each taking writes. This can lead to "conflicts" when writes go to multiple masters 'simultaneously'. NDB resolves them automatically, based on algorithms that _you_ pre-specify. (Eg, "tak

Re: MySQL on 64 bit Windows 7?

On Thu, Mar 1, 2012 at 23:13, Johnny Withers wrote: > I would imagine the installer is 32-bit only just so they don't have to > release two versions of it. > > I'm sure it'll allow you to download the 64-bit version of the server > though. > I see, thanks. I did not realise that a Windows install

Re: MySQL on 64 bit Windows 7?

I would imagine the installer is 32-bit only just so they don't have to release two versions of it. I'm sure it'll allow you to download the 64-bit version of the server though. JW On Thu, Mar 1, 2012 at 3:10 PM, Dotan Cohen wrote: > Although 74 bit Windows 7 is listed as supported [1], I do n

Re: mysql for os x 10.6 (64bit) cannot start service

On Wed, Feb 29, 2012 at 2:20 PM, Elim Qiu wrote: > I created (or activated) the root account and now I see the error log: > > sh-3.2# cat miniMac.local.err > 120229 10:36:09 mysqld_safe Starting mysqld daemon with databases from > /usr/local/mysql/data > 120229 10:36:09 [Warning] Setting lower_cas

Re: mysql for os x 10.6 (64bit) cannot start service

Looks like 5.1.61 mac installer messed up the privilege setting... But how to fix it? I remember the server account is mysql, not _mysql What do you got? And how to fix it? Thanks On Wed, Feb 29, 2012 at 2:20 PM, Elim Qiu wrote: > I created (or activated) the root account and now I see the erro

Re: mysql for os x 10.6 (64bit) cannot start service

I created (or activated) the root account and now I see the error log: sh-3.2# cat miniMac.local.err 120229 10:36:09 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 120229 10:36:09 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data

Re: mysql for os x 10.6 (64bit) cannot start service

If you are going to use "su" to officially switch to the root users just make sure you do "su -" with the dash. On Wed, Feb 29, 2012 at 2:10 PM, Reindl Harald wrote: > > > Am 29.02.2012 19:20, schrieb Larry Martell: >> Is the sudo succeeding? If it is, then there's no reason you shouldn't >> be

Re: mysql for os x 10.6 (64bit) cannot start service

On Wed, Feb 29, 2012 at 11:00 AM, Elim Qiu wrote: > > -rw-r--r--   1 root    wheel  17987 Dec 17 09:01 COPYING > -rw-r--r--   1 root    wheel   7371 Dec 17 09:01 INSTALL-BINARY > -rw-r--r--   1 root    wheel   2552 Dec 17 09:01 README > drwxr-xr-x  46 root    wheel   1564 Dec 17 09:01 bin > drwxr-

Re: mysql clustering -- any pitfalls ?

It sounds like you've been handed a mandate that's difficult to understand, but it could be because I don't understand the context, or you may not understand your manager's real intention. In any case, "everyone is doing clustering" is certainly not accurate. And every "clustering" technology is

Re: mysql for os x 10.6 (64bit) cannot start service

Are you looking in /usr/local/mysql/data ? You should see a username.err file. You might have to sudo to open the file just do "sudo tail -f FILENAME" or "sudo taill -f /path/to/filename/ ". On Wed, Feb 29, 2012 at 1:00 PM, Elim Qiu wrote: > -rw-r--r--   1 root    wheel  17987 Dec 17 09:01 COPYI

Re: mysql for os x 10.6 (64bit) cannot start service

-rw-r--r-- 1 rootwheel 17987 Dec 17 09:01 COPYING -rw-r--r-- 1 rootwheel 7371 Dec 17 09:01 INSTALL-BINARY -rw-r--r-- 1 rootwheel 2552 Dec 17 09:01 README drwxr-xr-x 46 rootwheel 1564 Dec 17 09:01 bin drwxr-x--- 8 _mysql wheel272 Feb 29 10:36 data drwxr-xr-x 4

Re: mysql for os x 10.6 (64bit) cannot start service

On Wed, Feb 29, 2012 at 10:17 AM, Elim Qiu wrote: > Thanks Larry and Darryle for your help > > Where the error log should be? http://dev.mysql.com/doc/refman/5.0/en/error-log.html > > On Wed, Feb 29, 2012 at 8:22 AM, Larry Martell > wrote: >> >> On Wed, Feb 29, 2012 at 7:46 AM, Elim Qiu wrote

Re: mysql for os x 10.6 (64bit) cannot start service

Thanks Larry and Darryle for your help Where the error log should be? On Wed, Feb 29, 2012 at 8:22 AM, Larry Martell wrote: > On Wed, Feb 29, 2012 at 7:46 AM, Elim Qiu wrote: > > Yes, there is an icon. I can open the preference but the start service > > button cannot do the job > > What is in t

Re: mysql for os x 10.6 (64bit) cannot start service

On Wed, Feb 29, 2012 at 7:46 AM, Elim Qiu wrote: > Yes, there is an icon. I can open the preference but the start service > button cannot do the job What is in the mysql error log? > > On Wed, Feb 29, 2012 at 7:20 AM, Darryle Steplight > wrote: > >> Do you see a MySql icon under  System Prefer

Re: mysql for os x 10.6 (64bit) cannot start service

I have version 5.5.17 MySQL Community Server (GPL) on my Mac. On Wed, Feb 29, 2012 at 9:36 AM, Elim Qiu wrote: > The vertion of MySQL that I cannot start is 5.1.61 (the only one for 5.1* > mac at mysql.com) > > On Wed, Feb 29, 2012 at 7:05 AM, Elim Qiu wrote: > >> *I downloaded **Mac OS X ver.

Re: mysql for os x 10.6 (64bit) cannot start service

Yes, there is an icon. I can open the preference but the start service button cannot do the job On Wed, Feb 29, 2012 at 7:20 AM, Darryle Steplight wrote: > Do you see a MySql icon under System Preferences > Other ? That's how > I start MySql on my Mac. > > ** > > > >

Re: mysql for os x 10.6 (64bit) cannot start service

The vertion of MySQL that I cannot start is 5.1.61 (the only one for 5.1* mac at mysql.com) On Wed, Feb 29, 2012 at 7:05 AM, Elim Qiu wrote: > *I downloaded **Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive, installed > to my pretty clean os x 10.6.8 (snow leopard) after (1st time) started > apach

Re: mysql for os x 10.6 (64bit) cannot start service

Do you see a MySql icon under System Preferences > Other ? That's how I start MySql on my Mac. On Wed, Feb 29, 2012 at 9:05 AM, Elim Qiu wrote: > *I downloaded **Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive, installed to > my pretty clean os x 10.6.8 (snow leopard) after (1st time) started apac

Re: mysql clustering -- any pitfalls ?

- Original Message - > From: "Charles Brown" > > Anyone out there with experience in Mysql Clustering. My management > requests that i migrate from replication to clustering. Why? Because > everyone is doing clustering and he would like to stay competitive. Your management has no clue w

Re: MySQL Session Variables with PHP

- Original Message - > From: "Steven Staples" You're asking the wrong question, though. WHY do you want to do that? You should never, ever ever rely on auto_increment for stuff like record insert order. Did I mention NEVER? Autoincrements can get reset for a variety of reasons. The onl

RE: MySQL Session Variables with PHP

> -Original Message- > From: Peter Brawley [mailto:peter.braw...@earthlink.net] > Sent: February 22, 2012 11:07 AM > To: Steven Staples; mysql@lists.mysql.com > Subject: Re: MySQL Session Variables with PHP > > On 2/22/2012 9:47 AM, Steven Staples wrote: > > Go

Re: MySQL Session Variables with PHP

On 2/22/2012 9:47 AM, Steven Staples wrote: Good [insert time of day here] all! I am trying to reorder my auto-inc field in my database, and I have successfully done it with my "front end" that I use (SQLYog) with the following code: SET @var_name = 0; UPDATE `my_database`.`my_table` SET `id` =

Re: mysql won't start with service, but starts with mysqld_safe

Larry, You are welcome. If you want to create the selinux policy from your audit.log, you can check the instruction from this post: http://www.lefred.be/?q=node/129 Cheers, On Mon, 2012-02-06 at 14:54 -0700, Larry Martell wrote: > 2012/2/6 Frédéric Descamps : > > Hi, > > > > check your audit.lo

Re: mysql won't start with service, but starts with mysqld_safe

2012/2/6 Frédéric Descamps : > Hi, > > check your audit.log if you have selinux enabled Ah, thanks for mentioning this. I didn't even think of that. Sure enough, if I disabled selinux, it worked. Now I have to figure out why it's failing under selinux. In the audit log I see these messages when I

Re: mysql won't start with service, but starts with mysqld_safe

Hi, check your audit.log if you have selinux enabled On Sat, 2012-02-04 at 17:57 -0700, Larry Martell wrote: > Just installed mysql on centos 6.2. When I try to start it with service I get: > > #service mysqld start > MySQL Daemon failed to start. > Starting mysqld:

Re: mysql won't start with service, but starts with mysqld_safe

On Mon, Feb 6, 2012 at 3:34 PM, Larry Martell wrote: > On Mon, Feb 6, 2012 at 1:26 PM, Shawn Green (MySQL) > wrote: >> On 2/4/2012 19:57, Larry Martell wrote: >>> >>> Just installed mysql on centos 6.2. When I try to start it with service I >>> get: >>> >>> #service mysqld start >>> MySQL Daemon

Re: mysql won't start with service, but starts with mysqld_safe

On Mon, Feb 6, 2012 at 1:26 PM, Shawn Green (MySQL) wrote: > On 2/4/2012 19:57, Larry Martell wrote: >> >> Just installed mysql on centos 6.2. When I try to start it with service I >> get: >> >> #service mysqld start >> MySQL Daemon failed to start. >> Starting mysqld:                            

Re: mysql won't start with service, but starts with mysqld_safe

On 2/4/2012 19:57, Larry Martell wrote: Just installed mysql on centos 6.2. When I try to start it with service I get: #service mysqld start MySQL Daemon failed to start. Starting mysqld: [FAILED] Nothing at all is written to the error log. But if I st

Re: mysql won't start with service, but starts with mysqld_safe

On Mon, Feb 6, 2012 at 7:42 AM, Chris Tate-Davies wrote: > On 06/02/12 14:34, Reindl Harald wrote: >> >> >> Am 06.02.2012 15:28, schrieb Chris Tate-Davies: >>> >>> On 06/02/12 13:33, Larry Martell wrote: On Mon, Feb 6, 2012 at 2:38 AM, Chris Tate-Davies   wrote: > > Have yo

Re: mysql won't start with service, but starts with mysqld_safe

On 06/02/12 14:34, Reindl Harald wrote: Am 06.02.2012 15:28, schrieb Chris Tate-Davies: On 06/02/12 13:33, Larry Martell wrote: On Mon, Feb 6, 2012 at 2:38 AM, Chris Tate-Davies wrote: Have you tried: mysql --verbose -u -p To output more information When would I use that? If I try to

Re: mysql won't start with service, but starts with mysqld_safe

On Mon, Feb 6, 2012 at 7:34 AM, Reindl Harald wrote: > > > Am 06.02.2012 15:28, schrieb Chris Tate-Davies: >> On 06/02/12 13:33, Larry Martell wrote: >>> On Mon, Feb 6, 2012 at 2:38 AM, Chris Tate-Davies >>>  wrote: Have you tried: mysql --verbose -u  -p To output more in

Re: mysql won't start with service, but starts with mysqld_safe

On Mon, Feb 6, 2012 at 7:28 AM, Chris Tate-Davies wrote: > On 06/02/12 13:33, Larry Martell wrote: >> >> On Mon, Feb 6, 2012 at 2:38 AM, Chris Tate-Davies >>  wrote: >>> >>> Have you tried: >>> >>> mysql --verbose -u  -p >>> >>> To output more information >> >> When would I use that? If I try to

Re: mysql won't start with service, but starts with mysqld_safe

Am 06.02.2012 15:28, schrieb Chris Tate-Davies: > On 06/02/12 13:33, Larry Martell wrote: >> On Mon, Feb 6, 2012 at 2:38 AM, Chris Tate-Davies >> wrote: >>> Have you tried: >>> >>> mysql --verbose -u -p >>> >>> To output more information >> When would I use that? If I try to start it with 'ser

Re: mysql won't start with service, but starts with mysqld_safe

On 06/02/12 13:33, Larry Martell wrote: On Mon, Feb 6, 2012 at 2:38 AM, Chris Tate-Davies wrote: Have you tried: mysql --verbose -u -p To output more information When would I use that? If I try to start it with 'service mysqld start' it fails to start. From terminal command... just try

Re: mysql won't start with service, but starts with mysqld_safe

On Mon, Feb 6, 2012 at 2:38 AM, Chris Tate-Davies wrote: > Have you tried: > > mysql --verbose -u -p > > To output more information When would I use that? If I try to start it with 'service mysqld start' it fails to start. > > On 05/02/12 00:57, Larry Martell wrote: >> >> Just installed mysql

Re: mysql won't start with service, but starts with mysqld_safe

Have you tried: mysql --verbose -u -p To output more information On 05/02/12 00:57, Larry Martell wrote: Just installed mysql on centos 6.2. When I try to start it with service I get: #service mysqld start MySQL Daemon failed to start. Starting mysqld:

Re: Mysql merge table and table comments.

- Original Message - > From: k...@inbox.lv > > I have some merged tables. Can I alter 1 table and change a table > comment? Is it legal? As long as you don't change the table structure or name that shouldn't be a problem, I think. -- Bier met grenadyn Is als mosterd by den wyn Sy die'

<    1   2   3   4   5   6   7   8   9   10   >