We have an inaccessible MySQL v5.0.45 DB (w/Innodb) we really
need some help regaining access to. While attempting to
adjust/add remote user access, we accidentally did the
following:
use mysql;
update user set host = 'SomeBogusIP' where user = 'root';
Now, we can't get into the DB to fix
at flag, I only see the 'information_schema'
DB.
Any suggestions as to where I look from here?
On Tuesday 25 August 2009 @ 18:17, Walter Heck - OlinData.com
wrote:
> Hey Joe,
>
> stop the server, start it with --skip-grant-tables, change the
> root entry in mysql.user to y
I'm trying to get back to an earlier state where we started
mysqld withOUT --skip-grant-tables but the root user had no
password. Yes, insecure, but we're in restoration mode here.
How do I reset/revert the root password to no password without
running with --skip-grant-tables?
Thanks in advan
on what you had defined before.
>
> Backup first though!
>
> Walter
>
> On Wed, Aug 26, 2009 at 03:33, Joe
wrote:
> > I'm trying to get back to an earlier state where we started
> > mysqld withOUT --skip-grant-tables but the root user had no
> > password
U might want to try seting you index to calldate, disposition
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 25, 2007 10:03 PM
To: Edoardo Serra
Cc: mysql@lists.mysql.com
Subject: Re: MyISAM vs InnoDB - Index choice and Huge performance differ
Try it and see where the data goes. It amazing how much you learn by doing
it.
The first problem that you will see is the PK and unique keys in
partitioning have to have the partition key as part of the index. So your
PK would have to be CustomerID, TimeCreated
-Original Message-
From
--+-+
| CustomerID | TimeCreated |
++-+
| 4 | 1992-11-28 08:13:09 |
| 5 | 1987-11-28 08:13:09 |
++-+
-----Original Message-
From: gunwant walbe [mailto:[EMAIL PROTECTED]
S
Your missing your data type for the spdate_updated attribute
CREATE TABLE tbl_spdate(
spdate_ID int NOT NULL PRIMARY KEY AUTO_INCREMENT , spdate_date date NOT
NULL , spdate_notes varchar( 100 ) , spdate_created timestamp default 0,
spdate_updated timestamp default CURRENT_TIMESTAMP ON UPDATE
CURRE
Bubble bubble bubble
-Original Message-
From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 05, 2007 9:48 PM
To: Jeff Mckeon
Cc: MySql
Subject: Re: REPLICATION
Does any body has tried this
On Dec 6, 2007 10:08 AM, Krishna Chandra Prajapati <[EMAIL PROTEC
create table foo
(aa varchar(20),
id integer,
cc varchar(20));
delimiter |
create trigger foo_ins before insert on foo
for each row
begin
set new.aa = concat(new.cc,'-',new.id);
end; |
delimiter ;
insert into foo (cc,id) values ('www',1);
select * from foo;
-Original Message
>Description:
Every time I restart the database engine it loses grant entries, and I have
to manually reenter them by hand. Why aren't there rows finding their
way to disk?
>How-To-Repeat:
Add some grants, restart the database.
>Fix:
I don't know of a fix.
I'm a total newbie. If this issue does not belong here, please suggest a
more appropriate mailing list or fourm.
I have recently moved onto a new server. For a brief period after the move
I could access the mySQL database using GUI clients such as mysqlf and
sqlyog. And the web site that it sup
Note the single % by itself. Would this slow down the system
considerably, or would it be roughly the same amount of cpu usage as if i
had just left everything but the name LIKE phil out?
Thanks guys, i'm kinda new at sql so i'm hoping you might be able to help
:)
Joe
---
l it in the SQL statement instead of pulling a bunch of records
then sorting throught that.
Thanks,
JOE
Hello,
Hi, I need some help on something here. I need to know the best way to set
up this database.
I have a site with a bunch of images/reviews. What i want is for registered
users to rate and leave reviews themselves. I'm not sure how I should set
up this database though.
Now, I have a tab
Is there a query I can run to change the next autoindex to the next highest
integer in the column.
I mean I have my userIDs, and they are autoincrementing. But if I have say
9 users delete 5 of users, and then want to compact the table so that the
ids are all sequential. How can I make it so t
I was wondering if anyone knows of a way i can strip bad characters out
of a mysql database field namely the < > charators. These charactors are
causing havok for
me when I try and post data to the web. Thanks Alot.
-
Before po
Thanks alot
I truely appreciated the help in this matter.
both you guys are life savers :^)
-Original Message-
From: A. Chris Nichols [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 2:08 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Removing Bad Characters from Databas
I need to update a table with the contents of a CSV file regularly, I've
used mysqlimport to load all the initial data, but I have a problem with
using it for updates. The data in the CSV file does not contain all of the
data in the table, there is a field that is updated by another application
as
running stably. I
ran into some libc issues with Ubuntu already, as seen here:
http://bugzilla.ubuntu.com/show_bug.cgi?id=11730
However I've compiled my own replacement libc with patches applied to
fix the issues, which I will make available to all. Except for this
memory problem, the machi
NULL| Query | 0|
NULL | show processlist |
+-+--+---+-+-+--+--+---+
(obviously this was from a snapshot of the one that takes 4x as long to
run)
-Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ce for id(OG012), but vendor b has
minimal rating then vendor c.
Many thanks,
Joe.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ll me what I need to do to get MySQL to work?
Right now I am just trying to set things up so that I can start learning
PHP. Please help.
Thank you.
Joe Herman
New York City
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[
Thanks for your reply.
I've done what you said. Unfortunately I get the message in the CMD
Window:
'MYSQLADMIN' is not a recognized as an internal or external command.
Can you tell me what this means? I did run the installer earlier. Thank
you.
Joe.
-Original Message-
F
Hello, I am just starting with MySQL and PHP, but this discussion about
innodb has rather piqued my interest. Can someone please give a brief
explanation as to what it is.
Cheers,
Joe.
experience of users on this list, can anyone tell me what
they prefer and why? What do most people use here?
Joe.
Hello folks,
What is the best way to import an excel spreadsheet, or text file for
that matter into a table?
Is there a way to do this with PHPMyAdmin?
Thank you so much for your kind help.
Joe
lation? If it is special, where can it be found?
Thank you for your help.
Joe.
-Original Message-----
From: Joe Herman [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 27, 2005 12:21 AM
To: mysql@lists.mysql.com
Subject: Newbie question: How to import data into a table?
Hello folks,
e to be similar between versions. I thought originally that
performance may have suffered starting in 4.1 because of the
localization overhead, but 5.0 has a much more dramatic performance
drop. Are there any settings I should tweak? We do not have any plans
to use any of the new features in 4.1 or 5.0
I am trying to develop an db app w/ OO base as the front end to mysql
db that is running on the web in a shared hosting environment using
jdbc as the connector.
The problem is if I let OO base sit for a few minutes it looses the
connection to the db and I have to restart OO base to get it to
recon
On Fri, Jan 30, 2009 at 8:13 PM, will wrote:
> ok, cool. I was not sure if I could use logrotate with the mysql logs.
> Is it safe to delete what I have there at the moment? I need to free
> up some disk space.
>
this is what logrotate run before and after
[ -e /var/lock/subsys/mysqld ] && /bin/
Hello MySQL users,
My company is planning to upgrade from MySQL 5.0.51a to a more
recent version. Which version of MySQL offers the best balance between
stability and currency? Is there a discussion of the tradeoffs involved between
different recent version that I could be direc
Hello all,
My organization has a dedicated MySQL server. The system has
32Gb of memory, and is running CentOS 5.3. The default engine will be InnoDB.
Does anyone know how much space should be dedicated to swap?
Thanks!
Hello MySQL-users list,
We are having an issue with replication and binlog files and I was hoping that
this list could shed a little light on the issue for us. We have a pair of
5.1.41-community MySQL servers. We attempted to restore from the slave server,
and in the process I zeroed out the my
(table_old.country)
IN (SELECT DISTINCT (table_old2.`country) FROM table_old AS table_old2));
I know I can do this by creating two additional tables, but was
wondering if there was a direct way.
Best,
Joe.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Thanks, but I don't see how it will work. Am I missing something?
On Tue, Jun 7, 2011 at 5:24 PM, Willy Mularto wrote:
> Why not GROUP BY?
>
>
>
> On Jun 7, 2011, at 10:06 PM, joe j wrote:
>
>> Dear all,
>>
>> I wish to create a new table from a tabl
ok. here's what I am trying now. First create a table with the code
below with a list of countries that have the two person names I want.
CREATE TABLE `table_new` SELECT t1.country
FROM `table_old` as t1
JOIN
`table_old` as t2
USING(country)
JOIN
`table_old` as t3
USING(country)
WHERE (t2.`person_n
Thanks. I was looking for a loop--not to gain speed but to reduce the
length of my script file:) I'll try and hopefully it will work!
J
On Wed, Apr 4, 2012 at 12:16 PM, Johan De Meersman wrote:
> - Original Message -
>> From: "joe j"
>>
>> So what
Thanks to Rick I would go for a single table. I tried the following,
but hasn't been successful yet. First I created one 'master' table for
one country, with a country column (ctry) as Rick suggested, then I
tried to use the loop suggested by Johan to insert the records for
each of the remaining co
ange. Probably I could convert empty cells to NULL
and then use 'IS NOT NULL' condition as an alternative (this works
now).
Yes, I've now removed back ticks now, but it seems I need to use
single quotes for '${x}'-without the single quotes I get error
messages.
On Thu, Apr 5
>Jan Steinman wrote
>If not, how 'bout the best of both worlds: create a UNIX (or perl) script that
>loops
>through the country names and creates an SQL script? That would be fast
>entering AND fast
>performing!
Good suggestion. But I am a perl/unix illiterate. However I may learn
in them future
I tried the use mysql; for my session. Here is the result:
Terminal Saved Output 7
Description: Binary data
JoeBegin forwarded message:From: shawn green <shawn.l.gr...@oracle.com>Subject: Re: Fwd: mysql_tzinfo_to_sqlDate: April 5, 2013 1:58:01 PM EDTTo: Joe Kosinski <joj...@gmail.c
?
Here is the text from my last terminal where I tried to run the which command.
Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
info_to_sql previously nothing worked.
Terminal Saved Output 6
Description: Binary data
JoeBegin forwarded message:From: shawn green <shawn.l.gr...@oracle.com>Subject: Re: mysql_tzinfo_to_sqlDate: April 5, 2013 1:29:50 PM EDTTo: Joe Kosinski <joj...@gmail.com>Hi Joe,On 4/5/2013 1:26 PM, Joe
forwarded message:From: "Wm Mussatto" <mussa...@csz.com>Subject: Re: Fwd: mysql_tzinfo_to_sqlDate: April 5, 2013 5:09:15 PM EDTTo: mysql@lists.mysql.comOn Fri, April 5, 2013 13:19, Joe Kosinski wrote:I also tried mysql_tzinfo_to_sql /usr/share/zoneinfo > sqlLines with thefollow
the command drop down menu of the Shell menu.
Are there any other suggestions on what I should do to populated the tables?
Joe
>
>
> Joe
>
> Begin forwarded message:
>
>> From: shawn green
>> Subject: Re: Fwd: mysql_tzinfo_to_sql
>> Date: April 5, 201
I also tried mysql_tzinfo_to_sql /usr/share/zoneinfo > sqlLines with the following Terminal output:
Terminal Saved Output 10
Description: Binary data
-bash: sqlLines: Permission deniedJoeBegin forwarded message:From: Joe Kosinski <joj...@gmail.com>Subject: Fwd: mysql_tzinfo_t
your help and suggestions.
Joe
cated on a MacBook running OS X 10.8. The MySql Server is
running.
Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
n R.
R:
http://www.r-project.org/
PL/R:
http://www.joeconway.com/plr/
HTH,
Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-00|
| Mary | 2 | PA | 2007-01-15|
| Sally | 1 | OH | 2007-03-15|
+---+-+--+---+
Why am I getting the wrong location for Jim? It should be "PA".
This is on a Mac.
joe.
813.528.3859
My LinkedIn profile: http://www.linkedin.com
e max function are apparently being mixed up.
On Sat, Jun 21, 2008 at 12:00 AM, Perrin Harkins <[EMAIL PROTECTED]> wrote:
> On Fri, Jun 20, 2008 at 10:50 PM, Joe Pearl <[EMAIL PROTECTED]> wrote:
> > I want to get back only the most recent entry for each person and I don't
> &
Adam Gerson
Assistant Director of Technology
Apple Certified System Administrator (ACSA)
Columbia Grammar and Prep School
phone. 212-749-6200 ex. 321
fax. 212-428-6806
[EMAIL PROTECTED]
http://www.cgps.org
Public key - subkeys.pgp.net
--
Joe Auty
NetMusician: web publishing software for mus
UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
FLUSH PRIVILEGES ;
$ mysql -h mynewserver -u testuser -p
Enter password:
ERROR 1045 (28000): Access denied for user 'testuser'@'myoldserver'
(using password: YES)
On Sat, Oct 25, 2008 at 1:40 PM, Joe Auty <[EMAIL PROTECT
---+-+--++--++-+
5 rows in set (0.00 sec)
Any help or direction to bring this would be appreciated (even if it's,
hey! You sound like you've got a problem, open a support case)
Thanks,
-Joe
Server version 4.0.23-standard
--------+
135 rows in set (0.01 sec)
Thanks,
-Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
,
Joe Johnson
Airlink Systems
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
pollution');
> >+--+
> >| count(*) |
> >+--+
> >| 100 |
> >+--+
> >1 row in set (0.03 sec)
>
> How many do you get with
>
> SELECT COUNT(*) FROM Notices WHERE MATCH (Text) AGAINST
es about result changes relative to character set implementations.
--
Joe Rhett Chief Geek
[EMAIL PROTECTED] Isite Services, Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To uns
just that it's easier to separate out
changes that need to be made to production databases during the upgrade
versus changes that need to be made to code using the new system.
--
Joe Rhett Chief Geek
[EMAIL PROTECTED]
It looks like having a multiple-column index would help more than having
a number of individual indices, at least for the example query. An
index on (termid, docid, whichpara, offset) might work better than just
having one on termid.
joe
On Thu, 2004-01-15 at 10:53, Gregory Newby wrote:
>
, and before performing any inserts, either update the
corresponding row in the insert lock table or select it for an update.
joe
On Tue, 2004-01-20 at 10:01, Zeltser, Alex wrote:
> Hi Chris,
>
> Thanks for the response and the suggestions. Doesn't SERIALIZABLE level just add
>
tname
FROM `tree` AS t1
LEFT JOIN tree as t2
ON t1.parentname=t2.name
LEFT JOIN tree as t3
ON t2.parentname=t3.name
WHERE t3.name='AZ';
Gets me
MonumentApache
Statue Apache
But not the nodes with names Apache, Navajo, Mohawk
Can anyone tell me the correct syntax to pick a node in the tree and get
everything logically below that node in the heirarchy?
Thanks
Joe Mellon,
[EMAIL PROTECTED]
Can someone help with trying to remove a foreign key constraint from a
table. Each time I run the alter table statement to drop the foreign key I
get the following error:
Error Code : 1005
Can't create table
Here is the table structure and the alter table statement I am executing:
ALTER TABLE c
Hey Nils:
So that means exporting the data first, then dropping the table, recreating the new
table without the foreign key and then finally re-importing the data. Does that sound
about right?
Thanks,
Joe
-Original Message-
From: Nils Valentin [mailto:[EMAIL PROTECTED]
Sent
how to do that or the url of the manuel which
explains it.
thanks
joe baptista
Joe Baptista - only at www.baptista.god
"The Americans, they always depend on a method what I call ... stupid,
silly. All I ask is check yourself. Do not in fact repeat their lies."
... Muhammed Saeed al-Sa
f2`
field???=`echo "$line" | cut -f???`
echo "\"$field1\",\"$field2\",\"$field???\""
done
you can get fancy and write the shell script so you can pass in the number
of fields you want.
hope that helps
joe
Joe Baptist
ning
mysql 3.23.56 w/ redhat 7.3 and 2.4.20 kernel. Anybody have any
suggestions?
thanks,
joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hi,
We're pretty careful about preventing that. Also, no queries are moving
forward, no inserts, updates, or selects, even the ones on tables that
are only a mixture of inserts and selects.
joe
On Wed, 2003-07-23 at 12:02, Andrew Braithwaite wrote:
> Hi,
>
> I don'
Wed, 2003-07-23 at 12:56, Heikki Tuuri wrote:
> Joe,
>
> - Original Message -
> From: "Joe Shear" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.mysql
> Sent: Wednesday, July 23, 2003 10:40 PM
> Subject: RE: mysql stops processing
>
>
> >
ike this? What kind of backup solutions did
you use? We aren't too concerned about the CPU usage as our databases
tend to be i/o bound.
--
Joe Shear <[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Wed, 2003-07-23 at 13:11, Heikki Tuuri wrote:
> Joe,
>
> - Original Message -
> From: "Joe Shear" <[EMAIL PROTECTED]>
> To: "Heikki Tuuri" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Wednesday, J
version that would be great.
Thanks
/Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
p is
> being performed?
>
> Let me know and I think I'll be able to help :)
>
> Cheers,
>
> Andrew
>
>
> -Original Message-
> From: Joe Shear [mailto:[EMAIL PROTECTED]
> Sent: Wednesday 23 July 2003 21:08
> To: [EMAIL PROTECTED]
> Subj
you have UPS so that if the power fails
> you can get a clean shutdown. And ignore backups completely.
>
> Hope this helps,
>
> Andrew
>
>
>
> -Original Message-
> From: Joe Shear [mailto:[EMAIL PROTECTED]
> Sent: Wednesday 23 July 2003 21:50
> To: Andrew Braithwaite
find the lowest cost
> solution, with decent reliability.
>
> And I'm trying to find the secret of eternal youth :)
>
We're considering moving to a solution like EMC's -- do you or anybody
else have any experience with that?
> Cheers,
>
> Andrew
>
&g
f we see the
same problem, I'll grab some more diagnostics.
thanks for your help
joe
On Thu, 2003-07-24 at 12:49, Heikki Tuuri wrote:
> Joe,
>
> are you using LOCK TABLES? Or does your application program open two
> connections to MySQL and work based on the results from 2 connec
but in todays ID
sweatshops they are trying to squeeze me for all I got. My official
answer to the higher ups was "I know this can be done in Oracle" but at
thier licensing costs there's no way. If I get anything concrete going
I'll drop a note to the list.
/Joe
Gaspar Bakos wro
Excellent are there any doc pointers describing how to set this up?
/Joe
Jeremy Zawodny wrote:
On Wed, Jul 23, 2003 at 04:47:35PM -0400, Joe Gainey wrote:
Currently we have a web based application that is mostly reads (4:1
r/w). It is using a single MySQL database server. Is there any way
How about
select close_date, symbol, name
from TD
where symbol in () limit 1
ORDER BY close_date desc
Jeff Mathis <[EMAIL PROTECTED]> wrote:
hello query gurus.
we have a table TD with the following columns:
close_date
symbol
name
close_date is just a date field
there is a unique constr
>
+-++-+
| max(close_date) | symbol | name|
+-++-+
| 2004-10-05 | aa | cmptrhw |
| 2004-10-05 | bb | biotech |
| 2004-10-05 | cc | biotech |
+-++---
I put something out on the general forum. Perhaps I could try the
general list. Thanks for your help.
Joe Garry
Software Engineer
US Biometrics
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 02, 2005 4:09 PM
To: Joe Garry
Cc
Hi,
If it possible to limit the max value of an auto increment field to say, ,
and how to do it? I am using MySQL 4.0.18.
Regards,
-- Wong
EMAIL PROTECTED]>
Sent: Wednesday, June 23, 2004 4:10 PM
Subject: Re: question on auto increment field
> Scott Haneda <[EMAIL PROTECTED]> wrote:
> > on 06/23/2004 12:14 AM, Joe Wong at [EMAIL PROTECTED] wrote:
> >
> >> If it possible to limit the max value of an
ter-password=zzz
master-port=3306
set-variable = max_allowed_packet=16M
set-variable = max_connections=2000
set-variable = max_connect_errors=9
set-variable = table_cache=256
socket=/tmp/xyz-slave.sock
bind-address=yy.yy.yy.yy
Any help would be appreciated,
Thanks,
-Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ack up the entire slave, run it forward through the logs,
and restore the slave back exactly to it's previous point, and run it
through the logs again. See if it dies in the same places or if it's
somewhat random.
-Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
not seen the slave stop.
So I would believe that we are running into bug:
http://bugs.mysql.com/bug.php?id=1858
on the 3.53.57/3.53.58 line of code. The bug was already fixed on the
4.0.x line of code, but presumably a patch needs to be made to the
3.53.x line of code aswell.
As for the rest of my
Hi, may I know of the current MySQL python library supports MySQL cluster or not?
Regards,
- Wong
Hi, I use BK to download a snap shot of mysql-4.1. On make test, it said failed at
ps_2myisam. What am I doing wrong?
I am using the BUILD/compile-pentinum-max script to build mysql. I change the setting
to disable openssl and berkeley-db and change prefix to /usr/local/mysql-cluster
Best regar
major mysql release, how can I delete
these log files now? Even if I delete them off disk, they are still
referenced in the 'relay-bin.index' file. Presumably I'm not allowed to
update that file on a live slave...
Ideas?
-Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
InnoDb doesn't support full text indexes on text columns so if you need to search text
fields you may want ot use MyISAM. It is perfectly ok to have a mixture of InnoDB and
MyISAM in a single database so you can make your decision on a table by table basis.
Joe
Stuart Felenstein &l
_size=512M
set-variable= join_buffer_size=512M
set-variable= sort_buffer=512M
query_cache_size= 512M
The system has 4gigs of memory, recently reduced from 8 gigs to try to
work around a separate problem, and we're running the 2.4.26 linux
kernel on a quad cpu x86 machine.
Any thoughts? What kind of internal locks might be generated? Is there
another command I can run to get the status of those queries that are
hanging? It shows 'None' for the state (NULL), I've never seen a
process state be NULL if it was *doing* something. Would running show
processlist from the Mysql client work better than my python script? I
have cause to believe (but not proof!), that this 'INSERT' is the first
INSERT that table has seen since the batch inserts, but it is *not* the
first insert the entire database server nor that database has seen since
the overnight inserts. (and as mentioned before, it is NOT an insert
into the table that saw all the inserts earlier). This server is the
master in a master/slave configuration.
Any assistance would be appreciated!
-Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
;reset query cache', throughout the night? Is a query
cache of 512M beyond the recommended size? I wouldn't have expected it
to take 25 seconds to clear out a single table's query cache, is this
possible?
Thanks,
-Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MYSQL new feature
The aggregating functions std and variance calculate
the population standard deviations and variance. I
work extensively with datasets doing statistical
analysis. Many times it is faster and more efficient
to perform the basic univariate statistics on the
server but I need the
mp_option_short_max,count(if(lmp>0,lmp,null)) as Freq_plus,
count(if(lmp<0,lmp,null)) as minus
from DB1.t6
group by year, month, source, sink, class_type;
drop table if exists DB1.t6;
end;
I appreciate any suggestions.
Thank you
Joe
--
MySQL General Mailing List
For list archives
Hi,
Is this possible to set a timeout value for mysql_query() call?
Regards,
- Joe
If I perform a fulltext search for 'foo', it won't match text like
'foo, inc'.
Why?
Mysql 3.23.52
--
Joe McGuckin
ViaNet Communications
994 San Antonio Road
Palo Alto, CA 94303
Phone: 650-213-1302
Cell: 650-207-0372
Fax: 650-969-2124
--
MySQL Gene
Does the mysql server return to the client (DBI in this case) the query
execution time? If so, how do I retrieve it?
Thanks,
Joe
--
Joe McGuckin
ViaNet Communications
994 San Antonio Road
Palo Alto, CA 94303
Phone: 650-213-1302
Cell: 650-207-0372
Fax: 650-969-2124
--
MySQL General
connection string encrypted in a config file for your app
then decrypt it before you connect. You'd have to use an encryption that can be
decrypted with a key.
Checkout the System.Security.Cryptography.DESCryptoServiceProvider class
Hope that helps,
Joe Audette
Thomas Trutt <[EMAIL
y have a MySQL database on your network
that is lower version than 4 then how do the other apps connect to it securely? Or is
your app the only one that needs this level of security and other app can transmit to
the db in clear text?
Joe Audette
Thomas Trutt <[EMAIL PROTECTED]> wrote:
Thanks
1 - 100 of 282 matches
Mail list logo
