What I'm confused by though, is this line.
"Note that INSERT DELAYED is slower than a normal INSERT if the table is not
otherwise in use." What's the definition of "in use"? Does a logging table
do that given that it's pretty much append-only/write-only?
Waynn
On Mon, Nov 29, 2010 at 10:19 PM,
On Tue, Nov 30, 2010 at 7:26 AM, Jorg W Young
> wrote:
> 2010/11/30 Johan De Meersman :
> > Yep, it's definitely an apparmor issue. Are you using your distribution's
> > packages ? I would say this is more a thing for their support - I for one
> > keep as far away from apparmor as I can :-)
> >
>
2010/11/30 Johan De Meersman :
> Yep, it's definitely an apparmor issue. Are you using your distribution's
> packages ? I would say this is more a thing for their support - I for one
> keep as far away from apparmor as I can :-)
>
yep I 'm using the distribution packages all from apt-get.
--
MyS
Yep, it's definitely an apparmor issue. Are you using your distribution's
packages ? I would say this is more a thing for their support - I for one
keep as far away from apparmor as I can :-)
On Tue, Nov 30, 2010 at 3:54 AM, Jorg W Young
> wrote:
> Hi,
>
> I'm running mysql 5.1.37 for ubuntu 9.
No, I think it's a good idea to do INSERT DELAYED here - it's only logging
application, and it's generally more important to not slow down the
application for that. It's only ever into a single table, so there's only
going to be a single delay thread for it anyway.
Archive tables are a good idea,
Hi,
I'm running mysql 5.1.37 for ubuntu 9.10 (64 bits OS).
I installed mysqld with apt-get, and going with /etc/init.d/mysql for
start/stop the server.
I can start mysql server successfully, but can't stop the server with
/etc/init.d/mysql stop. The error message is:
Nov 30 10:46:05 kickseed k
Well, analyze if you need to create an excessive overhead into the MySQL
Server because a simple INSERT. What you must have a look is it:
- How much data this connection is delivering to MySQL's handlers?
- A word DELAYED in this case is making MySQL surfer?
Perhaps, you are sophisticating
I'm adding a table to our site that logs all page loads. In the past, when
I built this, I used MyISAM and INSERT DELAYED. I went back to look at the
documentation to see if I should still do this, and saw this (taken from
http://dev.mysql.com/doc/refman/5.1/en/insert-delayed.html):
Note that IN
Hi mysql@lists.mysql.com ,
I just light a candle for 26/11.
It is time to show that we have neither forgiven nor forgotten 26/11.
It is time to remember those who paid with their lives for the fanaticism of
a few, to salute those who gave up their lives trying to shield others, and
to honor thos
This is the general list. If your problem is with MySQL and queries, let us
know.
Best regards.
--
WB
2010/11/29 Daniel P. Brown
> On Mon, Nov 29, 2010 at 14:35, Don Wieland
> wrote:
> > Hi all,
> >
> > Is there a list/form to get some help on compiling mySQL queries? I am
> > executing them
It will affect all users named root. If you need to limit it on a
per-host basis, first SELECT User, Host from mysql.user where User
='root' and qualify with the update with the Host names you find
there.
- md
On Mon, Nov 29, 2010 at 1:58 PM, Wagner Bianchi
wrote:
> Hi Michael,
>
> I am not su
On Mon, Nov 29, 2010 at 14:35, Don Wieland wrote:
> Hi all,
>
> Is there a list/form to get some help on compiling mySQL queries? I am
> executing them via PHP, but do not want to ask for help here if it is no the
> appropriate forum. Thanks ;-)
Yes.
For MySQL queries, write to the MySQL
without flags to tell it otherwise, nmap only scan ports 1-1024,
higher numbered ports would have to be specified via nmap -p 1-5000
but see how much longer it takes.
- michael dykman
On Mon, Nov 29, 2010 at 9:02 AM, Grant wrote:
> I've got a couple security questions for you guys.
>
> Is ther
Hi Michael,
I am not sure whether your UPDATE statement will affect all "root" users
password or only which one that will access from a localhost.
Best regards.
--
WB
2010/11/29 Michael Dykman
> as root, stop your mysql server in the normal way
> ie :$ service mysqld stop
>
> run mysql explici
as root, stop your mysql server in the normal way
ie :$ service mysqld stop
run mysql explicitly to skipp credentials
ie. (run it in the back ground)
$ /usr/libexec/mysqld --skip-grant-tables &
once the server starts, you should be able to:
$ mysql -u root
assming you get in (no reason you sh
Start mysqld with --skip-grant-tables option, give an update on the root
password, mentioning the new password the you want to put for your access
with root user and be happy.
Well, make some like this:
shell> mysqld --skip-grant-tables
Open another tty, terminal or prompt:
shell> mysql
mysql>
Dear Sirs, I would like to post the list:
Topic: mysql server installation, password problems
Dear Sirs, I downloaded the last MySQL server version some weeks ago,
then I forgot the root password. I disinstalled everything and
reinstalled from new, but I'm always asked for the old password in ord
To verify that root has a password, do the following:
1) service mysql restart --skip-grant-tables
2) In MySQL, SELECT CONCAT(,user,'''@''',host,) mysql_user,password
from mysql.user where user='root';
This will show every host that root can login as along with the PASSWORD
function-encr
>-Original Message-
>From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De
>Meersman
>Sent: Thursday, November 25, 2010 3:29 AM
>To: Jerry Schwartz
>Cc: Brent Clark; mysql mailing list
>Subject: Re: localhost vs domain for connection string
>
>On Wed, Nov 24, 2010 at 4:
I've got a couple security questions for you guys.
Is there a way to verify I've set a password for mysql's root?
I was previously running mysqld without --skip-networking until I
noticed port: 3306 was referenced in mysqld.err. The strange thing is
'nmap localhost' never found an open 3306 port
On Mon, Nov 29, 2010 at 2:21 PM, Peter Wang wrote:
> We had have a similar problem caused by broken network-card, use
> `/sbin/ifconfig | grep errors' to check errors/dropped counter. for
> example, broken network-card may cause many connections, since normal
> tcp connect open/close can't be co
>> I'm trying to run mysql_upgrade but I get:
>>
>> # mysql_upgrade
>> Looking for 'mysql' as: mysql
>> Looking for 'mysqlcheck' as: mysqlcheck
>> Running 'mysqlcheck' with connection arguments: '--port=3306'
>> '--socket=/var/run/mysqld/mysqld.sock'
>> mysqlcheck: Got error: 1045: Access denied fo
I have released MyQuery 3.4.1 today. MyQuery is a Windows based Ad-Hoc
query tool with some interesting features:
- Colour coded syntax - Based on Scintilla
- Code folding - Based on Scintilla
- Ability to strat a script run inside the script.
- Support for error/stop/continue script editing
- Hi
Johan De Meersman writes:
Hi,
You may check the network at that time.
We had have a similar problem caused by broken network-card, use
`/sbin/ifconfig | grep errors' to check errors/dropped counter. for
example, broken network-card may cause many connections, since normal
tcp connect open/cl
300 seconds is 5 minutes, while this whole thing happened probably under a
minute. I'm looking for possible causes, not workarounds :-)
On Fri, Nov 26, 2010 at 8:57 PM, Prabhat Kumar wrote:
> Hi,
>
> to avoid this change ur "wait_timeout" value to 300 Secs or less, along
> with this you can als
I have tables:
CREATE TABLE `tblNames` (
` IdName` int(11) NOT NULL AUTO_INCREMENT,
`Name` varchar(60) DEFAULT NULL,
PRIMARY KEY (`IdName`),
) ENGINE=MyISAM
CREATE TABLE `tblStatusy` (
`IdStatus` int(11) NOT NULL AUTO_INCREMENT,
`IdName` int(11) DEFAULT NULL,
`Status`
26 matches
Mail list logo
