* 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
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
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
@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:
mysql select count(*) from send_sms_test
[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 like 'long_query_time
...@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 like 'long_query_time
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 since
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 aast...@gmail.com
To: mysql@lists.mysql.com
Sent: Sunday, September 23, 2012 7:51 AM
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
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 aast...@gmail.com wrote:
Thanks Nitin.
I specied the location of my.ini while starting the SQL node and it worked
fine.
I have
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 mdyk...@gmail.com wrote:
If
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 aast...@gmail.com wrote:
Thanks!
And how do i connect the
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 one of the SQL node through remote host
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
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
- Original Message -
From: Rick James rja...@yahoo-inc.com
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
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 rja...@yahoo-inc.com
There is a section on German Sharp-s in
http://mysql.rjweb.org/doc.php/charcoll
I
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
Hi ,
Can you paste the complete error log.
Regards,
KarthiK.P.R
On Wed, Aug 29, 2012 at 7:04 AM, aaron zhang
aaron.zh...@embracesource.comwrote:
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
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
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
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 Authentication
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 rja...@yahoo-inc.com wrote:
Does that depend on mysql running as root in
rapidly enough so there may not be an issue.
Please estimate queries per second, and writes per second, not
simultaneous connections.
-Original Message-
From: Reindl Harald [mailto:h.rei...@thelounge.net]
Sent: Saturday, July 14, 2012 11:19 AM
To: mysql@lists.mysql.com
Subject: Re: mysql
: 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 jerom...@gmail.com wrote:
hi all,
our DB crashed for some reason... any inputs would be greatly
appreciated..
120711 8:12:21 - mysqld got signal 11
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
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) to the
sorry.. im using 5.1
On Wed, Jul 11, 2012 at 10:09 AM, J M jerom...@gmail.com 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
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
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 ba...@xaprb.com wrote:
In this case the solution is much easier outside of MySQL than inside.
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 starts to die at 27 SQL
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:
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-digesthttp://www.percona.com/doc/percona-toolkit/2.1/pt-query-digest.html
.
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
-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:
| 544
- Original Message -
From: Baron Schwartz ba...@xaprb.com
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.
-
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
is accountid a number or varchar column
On Sat, May 12, 2012 at 7:38 PM, Andrés Tello mr.crip...@gmail.com wrote:
While doning a batch process...
show full processlist show:
| 544 | prod | 90.0.0.51:51262 | tmz2012 | Query |6 |
end | update `account` set
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
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 mr.crip...@gmail.com wrote:
Yes, I'm using indexes, accountid is the primary key, and is numeric and
autoincrement. The process doing the
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 in 5.5.24 -
would be
- Original Message -
From: Ananda Kumar anan...@gmail.com
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
- Original Message -
From: Govinda govinda.webdnat...@gmail.com
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,
I used to have these issues in mysql version 5.0.41.
On Mon, May 14, 2012 at 8:13 PM, Johan De Meersman vegiv...@tuxera.bewrote:
- Original Message -
From: Ananda Kumar anan...@gmail.com
If numeric, then why are u using quotes. With quotes, mysql will
ignore the index and do a
Am 14.05.2012 16:50, schrieb Johan De Meersman:
- Original Message -
From: Govinda govinda.webdnat...@gmail.com
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
.
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
- Original Message -
From: Reindl Harald h.rei...@thelounge.net
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
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 has been released
.
-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
- Original Message -
From: Reindl Harald h.rei...@thelounge.net
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ł
- Original Message -
From: Baron Schwartz ba...@xaprb.com
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
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 Mailing
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 following
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 h.rei...@thelounge.netwrote:
Am 02.05.2012 12:52, schrieb vishesh kumar:
Hi Members,
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
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 linuxtovish...@gmail.com:
I am getting following in error log
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 linuxinf...@gmx.de 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
@lists.mysql.com
Subject: Re: MySQL Crash when Open_files reach 128
I am getting following in error log
---
---
--
120502 07:52:05 mysqld started
On Wed, May 2, 2012 at 4:58 AM, vishesh kumar linuxtovish...@gmail.com wrote:
I am getting following in error log
120502 07:52:05
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
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
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
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, take
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 dotanco...@gmail.com wrote:
Although 74 bit Windows 7 is listed as
On Thu, Mar 1, 2012 at 23:13, Johnny Withers joh...@pixelated.net 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
- Original Message -
From: Charles Brown cbr...@bmi.com
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
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 elim@gmail.com 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
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 elim@gmail.com 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
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 dstepli...@gmail.com
wrote:
Do you see a MySql icon under System Preferences Other ? That's how
I start MySql on my Mac.
**
I have version 5.5.17 MySQL Community Server (GPL) on my Mac.
On Wed, Feb 29, 2012 at 9:36 AM, Elim Qiu elim@gmail.com 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 elim@gmail.com wrote:
On Wed, Feb 29, 2012 at 7:46 AM, Elim Qiu elim@gmail.com 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 dstepli...@gmail.com
wrote:
Do you see a
Thanks Larry and Darryle for your help
Where the error log should be?
On Wed, Feb 29, 2012 at 8:22 AM, Larry Martell larry.mart...@gmail.comwrote:
On Wed, Feb 29, 2012 at 7:46 AM, Elim Qiu elim@gmail.com wrote:
Yes, there is an icon. I can open the preference but the start service
On Wed, Feb 29, 2012 at 10:17 AM, Elim Qiu elim@gmail.com 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 larry.mart...@gmail.com
wrote:
On Wed, Feb 29,
-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
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 elim@gmail.com wrote:
-rw-r--r-- 1 root wheel 17987 Dec
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
On Wed, Feb 29, 2012 at 11:00 AM, Elim Qiu elim@gmail.com 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
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 h.rei...@thelounge.net wrote:
Am 29.02.2012 19:20, schrieb Larry Martell:
Is the sudo succeeding? If it is, then there's no reason you
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
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 elim@gmail.com wrote:
I created (or activated) the root account and
On Wed, Feb 29, 2012 at 2:20 PM, Elim Qiu elim@gmail.com 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]
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` =
-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:
Good [insert time of day here] all
- Original Message -
From: Steven Staples sstap...@mnsi.net
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
Have you tried:
mysql --verbose -u username -ppassword
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:
On Mon, Feb 6, 2012 at 2:38 AM, Chris Tate-Davies
chris.tatedav...@inflightproductions.com wrote:
Have you tried:
mysql --verbose -u username -ppassword
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
On 06/02/12 13:33, Larry Martell wrote:
On Mon, Feb 6, 2012 at 2:38 AM, Chris Tate-Davies
chris.tatedav...@inflightproductions.com wrote:
Have you tried:
mysql --verbose -uusername -ppassword
To output more information
When would I use that? If I try to start it with 'service mysqld
start'
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
chris.tatedav...@inflightproductions.com wrote:
Have you tried:
mysql --verbose -uusername -ppassword
To output more information
When would I use
On Mon, Feb 6, 2012 at 7:28 AM, Chris Tate-Davies
chris.tatedav...@inflightproductions.com wrote:
On 06/02/12 13:33, Larry Martell wrote:
On Mon, Feb 6, 2012 at 2:38 AM, Chris Tate-Davies
chris.tatedav...@inflightproductions.com wrote:
Have you tried:
mysql --verbose -uusername
On Mon, Feb 6, 2012 at 7:34 AM, Reindl Harald h.rei...@thelounge.net 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
chris.tatedav...@inflightproductions.com wrote:
Have you tried:
mysql
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
chris.tatedav...@inflightproductions.com wrote:
Have you tried:
mysql --verbose -uusername -ppassword
To
On Mon, Feb 6, 2012 at 7:42 AM, Chris Tate-Davies
chris.tatedav...@inflightproductions.com 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
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
On Mon, Feb 6, 2012 at 1:26 PM, Shawn Green (MySQL)
shawn.l.gr...@oracle.com 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:
On Mon, Feb 6, 2012 at 3:34 PM, Larry Martell larry.mart...@gmail.com wrote:
On Mon, Feb 6, 2012 at 1:26 PM, Shawn Green (MySQL)
shawn.l.gr...@oracle.com 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
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:
2012/2/6 Frédéric Descamps lef...@percona.com:
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
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 lef...@percona.com:
Hi,
check
- 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't
; 2012/01/31 10:52 +0100, Johan De Meersman
Not *entirely* accurate: MySQL does include a CSV engine that you can use in
the same way you would use InnoDB or any other engine.
If you create a table a with engine=CSV and then go look at the data
dictionary, you'll find the files a.frm and a.CSV
301 - 400 of 9139 matches
Mail list logo