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 cameron.mann at cybera.ca writes:
Hi all,
I've encountered a
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
!
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 correct initial database.
Jesus! I HATE systemd. The sysV init script handled this correctly
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:35 schrieb Bruce
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
?
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
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
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
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
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
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
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 records
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
That's the ticket! Thanks
On 09/08/2011 06:55 AM, Andrew Moore wrote:
Check that you're looking at the variable in the GLOBAL scope not the
SESSION scope.
SHOW GLOBAL VARIABLE ...
Andy
On Thu, Sep 8, 2011 at 11:34 AM, Bruce Ferrellbferr...@baywinds.orgwrote:
On 09/08/2011 02:56 AM, Johan
On 09/08/2011 02:56 AM, Johan De Meersman wrote:
- Original Message -
From: Bruce Ferrellbferr...@baywinds.org
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
?
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 midnight the
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 =
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 -
The problem is that the index is useless, because you're running
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 918383
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
: Bruce Ferrell bferr...@baywinds.org
To: jeetendra.ran...@sampatti.com
Cc: mysql@lists.mysql.com
Sent: Thursday, October 15, 2009 12:20 PM
Subject: Re: Req. suitable .cnf file for Server used by 2000 users daily
Have a look at mysqltuner. It reads the stats from a running mysql
instances
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
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:
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 dump
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
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
---
-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. When I
Australia
invent
---
-Original Message-
From: Bruce Ferrell [mailto:[EMAIL PROTECTED]
Sent: Thursday, 30 November 2006 9:52 AM
To: Logan, David (SST - Adelaide)
Cc: mysql
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 spec
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? :)
Bruce Ferrell wrote
Australia
invent
---
-Original Message-
From: Bruce Ferrell [mailto:[EMAIL PROTECTED]
Sent: Thursday, 30 November 2006 11:17 AM
To: mysql
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 no
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
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-standard-5.0.15-0
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
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 Warnings: 113
When
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 order
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?
--
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
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
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
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
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
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
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,
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
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
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 could be a
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
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
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 startup of mysql in
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:
62 matches
Mail list logo