Kaushal
There are two ways to approach this:
1.) Turn off name resolution in MySQL and only do the ACL by IP. This is
probably best as name resolution can slow the database and cause
outright app failure if DNS fails for any reason.
2.) Make absolutely certain the names resolve correctly in
Mike,
check the datadir (usually /var/lib/mysql). If it's empty, manually execute
mysql_install_db. This will place an initial db in place and mysql will start
from then on
On 02/18/2015 03:11 PM, mike wrote:
> Cameron Mann cybera.ca> writes:
>
>> Hi all,
>>
>> I've encountered a problem w
It worked before, when you manually had to execute the script... It worked when
the script was auto invoked. Now it's silently busted, causing problems for
people you think
that's OK.
Whatever.
Moving on
On 02/12/2015 03:45 PM, Reindl Harald wrote:
>
> Am 13.02.2015 um 00:
;just work"? Except when they don't.
What slobs!
On 02/12/2015 03:11 PM, Reindl Harald wrote:
>
>
> Am 13.02.2015 um 00:03 schrieb Bruce Ferrell:
>> If the datadir is empty. you have to execute a different utility
>> mysql_install_db. This will create a corr
If the datadir is empty. you have to execute a different utility
mysql_install_db. This will create a correct initial database.
Jesus! I HATE systemd. The sysV init script handled this correctly.
On 02/12/2015 02:06 PM, Cameron Mann wrote:
> Hi Robert,
>
> The value in my.cnf is datadir=/var
The mysql_upgrade errors look like the mysql command line client can't be
located by the script... some kind of path error induced by a security "fix"
I'm thinking
On 02/12/2015 12:37 PM, Cameron Mann wrote:
> Hi all,
>
> I've encountered a problem with MySQL 5.6.23 on CentOS 7.0 and would
>
he answers?
Inquiring minds want to know
Thanks in advance
Bruce Ferrell
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
On 07/30/2013 04:13 AM, Manivannan S. wrote:
Hi,
I've a table with 10 Million records in MySQL with INNODB engine. Using this
table I am doing some calculations in STORED PROCEDURE and getting the results.
In Stored Procedure I used the base table and trying to process all the records
in the
On 06/23/2013 11:18 AM, Rafael Valenzuela wrote:
Hi All,
I have a question about the materialized views , i remember in the DBA
course my trainer said me. In Mysql doesn't exist this type views like
Oracle. But My boss think the opposite.
In the new version has this type of view? and the difere
On 06/23/2013 11:18 AM, Rafael Valenzuela wrote:
Hi All,
I have a question about the materialized views , i remember in the DBA
course my trainer said me. In Mysql doesn't exist this type views like
Oracle. But My boss think the opposite.
In the new version has this type of view? and the difere
On 05/09/2013 03:25 PM, Robinson, Eric wrote:
-Original Message-
From: Robinson, Eric [mailto:eric.robin...@psmnv.com]
Sent: Thursday, May 09, 2013 1:58 PM
To: mysql@lists.mysql.com
Subject: Slow Response -- What Does This Sound Like to You?
We have a situation where users complain tha
I've long used mysqltuner.pl and have recently heard that it may not be the
best tool for the job. what are others using? What experiences have you had
with mysqltuner.pl
Inquiring minds want to know
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
ws, in this way is a significant contributor to the problem?
Bruce Ferrell
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Bravo Basil! I've been looking at this all day and wondering myself. Now that
I've said that.. And now for something terribly evil, is there an strace for
cygwin?
On 11/18/2011 03:30 PM, Basil Daoust wrote:
> Maybe this is the wrong place to ask, but why would you want to do this?
> Mysql has
The meaning is:
increase max_connections
reduce wait_timeout
-- 28800 is wait 8 hours before closing out dead connections
same for interactive_timeout
increase key_buffer_size (> 7.8G) increase join_buffer_size
-- This keeps mysql from having to run to disk constantly for keys
-- Key buffer siz
I'd suggest mysqltuner. You can get it by using:
wget http://mysqltuner.pl
See what suggestions that makes
On 10/02/2011 06:44 AM, Joey L wrote:
> I have having issues with mysql db - I am doing a "select count(*) from
> table" -- and it take 3 to 4 min.
> My table has about 9,000,000 recor
sman wrote:
- Original Message -
From: "Bruce Ferrell"
To: mysql@lists.mysql.com
Sent: Thursday, 8 September, 2011 3:10:16 AM
Subject: trying to change wait_timeout
I've read the documentation on MySQL for version 5.1 and it says all
I have to do is to place the followin
On 09/08/2011 02:56 AM, Johan De Meersman wrote:
- Original Message -
From: "Bruce Ferrell"
To: mysql@lists.mysql.com
Sent: Thursday, 8 September, 2011 3:10:16 AM
Subject: trying to change wait_timeout
I've read the documentation on MySQL for version 5.1 and it says all
at am I missing?
Thanks in advance,
Bruce Ferrell
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
On 01/31/2011 12:18 PM, Jørn Dahl-Stamnes wrote:
> On Monday 31 January 2011 21:12, Phillip Baker wrote:
>
>> Greetings All,
>>
>> I am looking for a little help in setting a where clause.
>> I have a dateAdded field that is a DATETIME field.
>> I am looking to pull records from Midnight to midn
On 01/14/2011 08:19 AM, Steve Meyers wrote:
> On 1/14/11 3:52 AM, Bruce Ferrell wrote:
>> select count(*) as count
>> from alerts where (unix_timestamp(stamp)> (unix_timestamp(now()) -
>> '300' ) )
>> and devid = '244';
>>
>
> Bruce
How would you rewrite the following SQL so that is doesn't do a full
table scan. It does in fact do a full scan in spite of the time
clause. It's been
making me nuts for months.
select count(*) as count
from alerts where (unix_timestamp(stamp) > (unix_timestamp(now()) -
'300' ) )
and devid = '
Mysql tuner is a very useful tool to pull metrics
http://blog.mysqltuner.com/
On 09/21/2010 05:48 AM, Jangita wrote:
> I find this quite good
>
> http://www.mysqlperformanceblog.com/
>
> Send your my.cnf and maybe we could look at it and pick anything that would
> help.
>
>
> Jangita | +254 76
l-recursive] Error 1
Any ideas on how I can get the libraries and headers to build DBD::mysql?
Thanks in advance
Bruce Ferrell
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
is script
>
>
> Thanks & Regards
> Jeetendra Ranjan
>
> - Original Message -
> From: "Bruce Ferrell"
> To:
> Cc:
> Sent: Thursday, October 15, 2009 12:20 PM
> Subject: Re: Req. suitable .cnf file for Server used by 2000 users daily
>
>
>&g
Have a look at mysqltuner. It reads the stats from a running mysql
instances and makes suggestions for what can be changed
http://blog.mysqltuner.com/
Gavin Towey wrote:
> Hi,
>
> This script might help with some tuning suggestions, run it after you have
> some production traffic running ag
I seem to recall a SQL select syntax along these lines:
SELECT col1, col2
WHERE col1 IN (set)
Is this or similar syntax in MySQL or is my dotage coming upon me
Thanks in advance,
Bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lis
Thanks all who replied.
After I posted I kept looking and found it... Also had folks point it
out to me.
Your suggestion is what I ended up doing.
Bruce
Gavin Towey wrote:
> Hi Bruce,
>
>
>
> SELECT … INTO OUTFILE always creates the file local to the database
> server. If you want to dum
I have a bit of perl code that ends with an error:
$sql="SELECT convert_tz( a.stamp,'GMT','$tz' ) as ts, a.status,
a.reason, a.tl
INTO OUTFILE '/application/result.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '\"'
LINES TERMINATED BY '\n'
FROM alerts a
Daniel Kasak wrote:
VeeJay wrote:
Hi
Where one can find Source Distribution of MySQL Server 5.0 Standard for
FreeBSD?
Not on the website, that's for sure.
Have you tried the usual warez sites, p2p networks, etc?
Actually the source tarball IS on the mysql download site.
--
One day at
5001
Australia
invent
---
-Original Message-
From: Bruce Ferrell [mailto:[EMAIL PROTECTED]
Sent: Thursday, 30 November 2006 11:17 AM
To:
Nope, That didn't fix it. I'd uses MySQl provided rpms but they don't
seem to have them got glib23 anymore.
Suggestions?
Bruce Ferrell wrote:
I think I found it. The system has zlib 1.1.4 the sources have zlib
1.2.3. Trying a static build now. Anyone wanna bet? :)
Bruc
I think I found it. The system has zlib 1.1.4 the sources have zlib
1.2.3. Trying a static build now. Anyone wanna bet? :)
Bruce Ferrell wrote:
Yes, built with SSL support the build seemed to go OK and sometimes it
works. I'm building on SuSE 9.2 using the src.rpm and the included
5001
Australia
invent
---
-Original Message-
From: Bruce Ferrell [mailto:[EMAIL PROTECTED]
Sent: Thursday, 30 November 2006 9:52 AM
To: Logan, David (SST - Adelaide)
Cc:
---
-Original Message-
From: Bruce Ferrell [mailto:[EMAIL PROTECTED]
Sent: Thursday, 30 November 2006 9:42 AM
To: mysql@lists.mysql.com
Subject: DROP DATABASE weirdness
I'm running MySQL 5.0.24a and I have a database I need to drop. W
I'm running MySQL 5.0.24a and I have a database I need to drop. When I
issue the command DROP DATABASE webdb the client seems to just hang. I
see the command hit the server in the full log but the database never
drops. Anyone have any suggestions?
--
One day at a time, one second if that'
I did a little shell script to do it. the key was the shell variable IFS:
Normally IFS=" "
to make it work right I set it as follows:
IFS="
"
Yes, thats a newline between the quotes
John Kopanas wrote:
I have a text file with over 500K rows of data in it. The problem is
that the data is
look in /var/lib/mysql for the error file. make sure /var/lib/mysql is
owned by mysql
Karl Larsen wrote:
I am trying to get mysql 5 to run on my Fedora Core 4 linux. I
installed both server and client RPM files. The info is good and using that
I am trying to do the post-install. I ran
Carlos Vasquez wrote:
How come this doesn't work?
Wp_photos.photo = IMG_1234.JPG
Pixelpost_pixelpost.headline = /this/path/to/directory/IMG_1234.JPG
So I need to just match the latter-bit of the file.
update pixelpost_pixelpost,wp_posts,wp_photos
set
pixelpost_pixelpost.headline=wp_post
d you should
be OK.
Bruce Ferrell
Logg, Connie A. wrote:
I have installed the following rpm's for mysql on my node
[EMAIL PROTECTED] mysql]# rpm -qa | grep -i mysql
MySQL-client-standard-5.0.15-0.rhel4
MySQL-server-standard-5.0.15-0.rhel4
MySQL-shared-standard-5.0.15-0.rhel4
MySQL-devel-standar
Paul DuBois wrote:
At 10:11 -0700 10/8/05, Bruce Ferrell wrote:
Hi All,
I'm bulkloading my instance and I'm getting a return message at the
end of the load like this:
mysql> \. vm_load.txt
Query OK, 164 rows affected, 113 warnings (0.01 sec)
Records: 164 Duplicates: 0 Warnin
Hi All,
I'm bulkloading my instance and I'm getting a return message at the end
of the load like this:
mysql> \. vm_load.txt
Query OK, 164 rows affected, 113 warnings (0.01 sec)
Records: 164 Duplicates: 0 Warnings: 113
When I load the data line by line, I get no warnings.
How can I see wha
enable the bin log in mysql. It doesn't log "transactions" i.e. what it
was, what it became, but the update will be logged
prathima rao wrote:
hi,
how to create a log file of the updates done on the data in visual basic or
in mysql for a particular record
for example
i have a purchase orde
Looks like it made it through to here
David Smithson wrote:
I have sent a couple of emails to the list, but I don't know if they
are posting or not, because I haven't received them back from the
list, which I assumed I would. Can someone just confirm that this
message is indeed being posted?
--
My
Hi all,
I got the following error during the configure phase:
configure: WARNING: term.h: present but cannot be compiled
configure: WARNING: term.h: check for missing prerequisite headers?
configure: WARNING: term.h: see the Autoconf documentation
configure: WARNING: term.h: section "Presen
How about
mysqldump > /dev/nst0
Tucker, Gabriel wrote:
Hello All
I have been searching the archives and was unable to find an answer.
I need the ability to backup MySQL instances directly to a tape device.
Currently, I run a mysqldump to disk and have legato pick up the file. As I get to
some l
Hi all,
I'm using 3.23.49a-max-log and as a temporary fix for a disk space
problem, I shut mysql down,, moved some database files to different
partitions on the system and symlinked them back into the datadir.
Everything seems to work ok... So far... Mysql came up with no errors,
selects and in
It works. It works very well. As Jeremy said, just make sure you are
very explicit in your configuration and startup
Jeremy Zawodny wrote:
On Tue, May 11, 2004 at 09:26:57AM +0700, Winner H Manurung wrote:
Dear All,
I was an Oracle dba, now my new company want to use Mysql 4.0.18. Does
anybod
you need a smeicolon at the end of the line
Don Matlock wrote:
Thank you very much for the prompt reply.
Yes you were correct, it was the fact that the password had not been
entered at all...I did the
mysql -u root -p
when prompted for the password I just hit enter and was able to get in.
Now I
I'm doing just that right now. I built from source and put mysql4 in
/usr/local/mysql and mysql5 in /usr/local/mysql5 with the my.cnf is
/usr/l.ocal/mysqlX/var. In the my.cnf file I put the local sockets into
/usr/local/mysqlX/tmp and mysql5 is using port 3305 with mysql4 on 3306.
The toughte
we have a bit of a debate going on at work. The gist of it is that
there is a a performance hit when using innodb tables vs myisam tables.
I understand the for a given dataload innodb will be larger, but is
there a performance hit as well? If so, as a rough comparison, how much
of a hit is it?
flush logs from the mysql command line works
Jesse Sheidlower wrote:
I recently restarted my MySQL server (4.0.10 in this case) with
the general query log enabled, to help out with some debugging and
optimization issues. After looking at a batch of these, I then
deleted the log file directly, wit
I just ran across mtop on freshmeat. Looks kind of nice to me.
--
Bruce
One day at a time... One second if that's what it takes
"Gorantla, Aruna" wrote:
>
> Hi All,
> Does anybody know if there are any monitoring tools for MySQL database?
>
> Thanks,
> Aruna.
>
> -
I've not used it yet, but I saw this on freshmeat:
Data Architect from the Kompany
http://www.thekompany.com/products/dataarchitect/
Won Lee wrote:
>
> Anyone know a good ERD program that will also interact with MySQL to write
> the CREATE scripts? As usual open source would be nice, also run
The message means that the databse files themselves have incorrect
permissions for the user mysql is running as.
ps -ef | grep mysql will show who mysqld is running as. Then check the
owership/permissions of the files to see if they are owned by that
user. I think you'll find they are not owne
How about a query something like this:
SELECT position, title FROM WHERE position1 IN (1...200) OR position2 IN
(1...200);
Caviats:
1.) I don't do this everyday so that query syntax could be all wet
(probably is in fact). You may have to programaticly generate the IN
clauses to make it work.
George,
At a minimum, you have to setup a user with permissions to access the
database. Once you have that done I think it might work
[EMAIL PROTECTED] wrote:
>
> Hi,
> I'm currently working on a project in which I am working with CGI scripts
> for a web based user interface, and MySQL for my
NOt supported... Yet. Rumor has it sub-selects will be in 4.1
John Morton wrote:
>
> Hi,
>
> Can someone tell me why this will not work, please
>
> SELECT * FROM tbl1 WHERE column =(SELECT * FROM tbl2 WHERE intcolumn =
> 15);
>
> (Table and column names changed to protect the innocent, "15"
I'm replying to the list because I got so many of these back:
Ya know gang... some days it just doesn't pay to get outta bed.
Yes, indeed, this is the exact reason my wife doesn't let me do arithmatic :)
Sorry and to the guy who replied with no spam please? what can I say, my face is ver
HTH mucho coolness
Steve West wrote:
>
> Bruce,
>
> Thanks for all the help so far! :)
>
> It finnally works.
>
> SW
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 16, 2001 10:20 PM
> To: [EMAIL PROTECTED]
> Subject: Re: auto startu
login as root. Use:
chkconfig --list mysql
to determin if it on, if it's not on issue:
chkconfig mysql on.
That will make sure that mysql starts at boot time. To start mysql
manually use:
service mysql start
Steve West wrote:
>
> I'm trying to figure out how to get mysql to startup au
TYou need to obtain and install the perl DBI (database interface) and
the DBD (DataBase Driver) for msql/MySQL, then it will work.
freelsq wrote:
>
> when I use mysqlhotcopy ,it say this:
>
> [root@my bin]# ./mysqlhotcopy
> Can't locate DBI.pm in @INC (@INC contains: /usr/lib/perl5/5.00503/i386
62 matches
Mail list logo
