On Sun, 1/9/13, Reindl Harald wrote:
Subject: Re: Can't Connect Localhost
To: mysql@lists.mysql.com
Date: Sunday, 1 September, 2013, 2:44 PM
> > I looked in mysql.config.pl and no "localhost" :(
> "mysql.config.pl" from what software damned?
> "
On Sun, 1/9/13, Reindl Harald wrote:
Subject: Re: Can't Connect Localhost
To: mysql@lists.mysql.com
Date: Sunday, 1 September, 2013, 1:34 PM
where you can change this? typically
in the config file
of teh software without crystal balls we don't
n't Connect Localhost
To: mysql@lists.mysql.com
Cc: "John Smith"
Date: Sunday, 1 September, 2013, 3:33 AM
Hi John,
Starting over….
What is the "error message"?
Terry
___
Terry J Fundak
Systems Engineer
Network Design and
Hi;
How do I change my connection from localhost to 127.0.0.1 on a Win8 machine?
TIA,
John
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Hi,
here my table which stores multiple trees with nested sets:
CREATE TABLE `posts` (
`posting_id` int(11) unsigned NOT NULL auto_increment,
`root_id` int(11) unsigned NOT NULL,
`lft` int(11) unsigned NOT NULL,
`rgt` int(11) unsigned NOT NULL,
`subject` varchar(400) collate latin1_germ
nt five roots. That is clean, works great but lacks performance
(especially in mysql).
Is there another way?
Greets, John Smith
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Perrin Harkins wrote:
> Assuming you're using InnoDB tables, "SELECT...FOR UPDATE" will lock
> the rows as you describe. It can prevent other inserts and updates to
> neighboring rows as well, depending on what isolation level you're
> running (default is REPEATABLE READ).
Thanks, in fact it eve
Hi,
i'm currently experimenting with nested sets. To insert a new node,, I
need 1 SELECT, 2 UPDATE and 1 INSERT statement.
Of course all of this wii be packed into a transaction, because the table
could get corrupted if not all of the mentioned queries are executed.
Now here's the question: I nee
I know that having a fulltext index on a table slows inserts and updates
down (or I think I do...might have miss read something)
I have a large table that uses fulltext which I plan to update nearly
90% of the rows (400,00+) and add new ones.
It currently takes around 35 minutes to remove the ind
On Thu, 2004-11-11 at 14:59, Victor Pendleton wrote:
> If you build the composit indexes as suggested, does your performance
> improve?
Erm, do you think it would? Its just that with such a large table and it
being compressed it takes ages?
--
MySQL General Mailing List
For list archives: htt
On Thu, 2004-11-11 at 14:36, Philippe Poelvoorde wrote:
> Hi,
>
> could you try adding a key with
> ALTER TABLE properties ADD INDEX(countyid,old,price);
> It could maybe help getting less rows at a time.
I dropped the old and price for the where clause and the number of rows
scanned were the sam
On Thu, 2004-11-11 at 13:58, Victor Pendleton wrote:
> What does the explain plan look like?
>
id select_type table type possible_keys key key_len ref rows
Extra
1 SIMPLE properties ref old,price,countyid countyid 3 const 9233 Using where;
Using filesort
The filesort I know
Afternoon All,
I have the following table structure:
CREATE TABLE properties (
id int(11) NOT NULL auto_increment,
propid varchar(14) NOT NULL default '0',
townid varchar(255) NOT NULL default '',
countyid mediumint(5) NOT NULL default '0',
address text NOT NULL,
price int(14) NOT NUL
Right, I upgraded my version of MySQL last night after a lot of digging about, found a
few bugs to do with table coruption that possibly could have been the problem.
I am re-runing my script and its seems to be going fine this time.
I am now using 4.0.28, I was using an early version of 4 can't
Hi All,
I have built a search application in php/libcurl and I store its results in MySQL.
The problem is that I am not used to dealing with the sizes of tables my search
application produces, roughly around 400,000 rows in a table the last time I got ran
it correctly.
Right to my problem.
I
I'm getting this error in my log:
--
030618 15:08:24 mysqld started
030618 15:08:24 InnoDB: Started
030618 15:08:24 /usr/sbin/mysqld: Can't create/write
to file '/var/run/mysqld/mysqld.pid' (Errcode: 2)
/usr/sbin/mysqld: ready for connections.
Version: '4.0.12'
Hi!
I have redhat 7.3 with the mysql packages that came with it.
Since RHSA-2003:093-14 came out I upgraded mysql with
mysql-3.23.56-1.73.i386.rpm
mysql-devel-3.23.56-1.73.i386.rpm
mysql-server-3.23.56-1.73.i386.rpm
When I try to start mysqld I get the following error message
in the log:
Table 'my
I've searched many places and can't get a good answer .. i hope I can get
help here.
I'm trying to dump all the data in my database to separate files (per table)
and be able to specify a field separator character.
for example, I'd like to use || as my field separator, I did the following:
>my
I've searched manyh places and can't get a good answer .. i hope I can get
help here.
I'm trying to dump all the data in my database to separate files (per table)
and be able to specify a field separator character.
for example, I'd like to use || as my field separator, I did the following:
>m
19 matches
Mail list logo
