MySQL doesn't work.
I tried to modified the line:
innodb_data_file_path = ibdata1:10M:autoextend
to
innodb_data_file_path = ibdata1:500M
or
innodb_data_file_path = ibdata1:500M:autoextend
or
innodb_data_file_path = ibdata1:500M;ibdata2:1000M:autoextend
they all gave me the same error below.
I
[EMAIL PROTECTED] wrote:
>
> I am having trouble creating temp tables. An error message keeps coming up
> saying that @localhost does not exist. (or something like that) can anyone
> help.
Could you show us exactly error message? Does user have CREATE TEMPORARY TABLES
privilege?
--
For te
Jason Joines <[EMAIL PROTECTED]> wrote:
> Table employees:
>
>
> | idnumber | email | phone | address |
>
>
> Table webusers:
> -
> | idnumber | userid | website |
> -
Hi All
Was wondering if someone could shef a bit of light on whats happening, as i keep
loosing the connection to the mysql server, and i get the following error:
mysqld dead but subsys locked
Thanks in advance
Cheers
Trevor
Hi Trevor,
I suggest you to compile and reinstall MySQL from the source distribution.
A suggested option is
CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions \
-fno-rtti" ./configure --prefix=/usr/local/mysql --enable-assembler \
--with-mysqld-ldflags=-all-sta
Hi,
I'm a newbie when it comes to mySQL.
I have the following command.
DELETE FROM tblTest2
USING tblTest2,tblTest
WHERE tblTest.Name = tblTest2.Name
AND tblTest.URL = tblTest2.URL
AND tblTest.Comment = tblTest2.Comment
I get the following error:
You have an error in your SQL sy
> 4) ALTER TABLE ENABLE KEYS -> Puts a full load on the CPU, but neither
> index nor table size seem to change, even after waiting for an hour.
> Based on smaller data sets, I'd expect the index to reach something
> close to 4 GB.
Update: After several hours, the index file started growing, althou
Sorry, but I disagree :/
I always used 250MB of key buffer, and MySQL never allocates more than
50MB, in my database.
Read buffer is only allocated when full scans are done.
Join buffer is allocated when there are joins without index use.
Sort buffer is allocated when needed, and etc...
Alexis
Bamelis,
The error message doesn't seem to match your SQL...
It only shows up to 'AND tblTest.URL = tblT'
but your SQL is 'AND tblTest.Comment = tblTest2.Comment'
Is that a problem??
An example from MySQL manual is 'DELETE FROM t1,t2 USING t1,t2,t3 WHERE
t1.id=t2.id AND t2.id=t3.id'
Leo
"Bamelis Steve" <[EMAIL PROTECTED]> wrote:
>
> I'm a newbie when it comes to mySQL.
>
> I have the following command.
>
> DELETE FROM tblTest2
>
> USING tblTest2,tblTest
>
> WHERE tblTest.Name = tblTest2.Name
>
> AND tblTest.URL = tblTest2.URL
>
> AND tblTest.Comment = tblTest2.Comment
>
I use an email-adress for this list only and since my first posting a few days
ago I got viruses, while I didn't before.
VIRUS FROM mamo @ hvd.healthnet.lu (W32/[EMAIL PROTECTED])
VIRUS FROM kawamoto @ wave.tky.plala.or.jp ([EMAIL PROTECTED])
VIRUS FROM sales @ vulcanford.ca (W32/[EMAIL PROTECTED
Hello everyone!
I have a table with a MEDIUMBLOB column:
CREATE TABLE mytab (
oid INTEGER ...
odata MEDIUMBLOB
);
in the mediumblob field i store an encoded string (bytes).
I would like to perform regular expression searches on this field
here is an example that works (p
Wednesday, November 05, 2003, 1:46:13 PM, Bamelis Steve wrote:
BS> Hi Victoria,
BS> I just found a manual for my version.
BS> Seems that 'USING' doesn't exist in this version.
BS> But I really need to be able to delete rows from my source table with
BS> specific criteria from my destination table
Al Bogner,
Thanks for you info.
Yes, I got quite a few as well. About Microsoft update stuff etc.
But I think emails with viruses are quite common, my mail server
captures around 2,000 emails with virus everyday. Also this is an old
virus(relatively speaking), so it should be fine, I think.
L
"Jon Miller" <[EMAIL PROTECTED]> wrote:
>
> I need a way to log every message that MySQL generates. I have the following in the
> /etc/my.cnf file:
> [mysqld]
> port=3309
> datadir=/var/lib/mysql
> socket=/var/lib/mysql/mysql.sock
> log-bin=/var/log/mysql.log
> bind-address=192.168.0.15
> log=/
Hi,
>From my experience, once you have created a datafile it doesn't work when
you try to make it larger.
If you dont care about the data thats already in it then delete the current
ibdata files and restart mysql.
If you do then put the size back to how it was, dump the data, shutdown the
server,
Hi,
What db type do u use? If I'm right InnoDB doesn't support Free text search...
bye
Hans
At 14:29 5-11-03, you wrote:
Hello everyone!
I have a table with a MEDIUMBLOB column:
CREATE TABLE mytab (
oid INTEGER ...
odata MEDIUMBLOB
);
in the mediumblob field i store an encoded s
Here is some additional information:
I tried with version 3.23 and version 4.0
And I am using MyISAM tables.
This is not a full text search an there is no index on the column.
any ideas?
George Moschovitis
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
Hi,
Since joining the list I'm getting about 6 virus emails a day. Fortunately
the firewall is stripping them for me and just sending me alerts telling me
the virus and the sender of the mail e.g.
The message senders were
[EMAIL PROTECTED]
[EMAIL PROTECTED]
The message title was latest
I have to convert names with characters greater than ASCII 122 - z to use it
in a select statement:
Is there a way to do it, like
select field, function(field) as converted
Examples:
não -> nao
você -> voce
cabeça -> cabeca
É Possibile -> E Possibile
N` Aniré -> N Anire
Sé Mañana -> Se Man
After a fruitless search for MySqlCC for Mac OS X, I downloaded and
built qt and MySqlCC. However, I ran into some errors on the CC build.
Am I duplicating effort here? I know that we are a small market but it
is a form of Unix and if I could get some assistance I would like to
give this a try.
Good Morning everyone:
I need help figuring out what is wrong with this query. I have tried to
use the LEFT JOIN, but it doesn't solve the purpose.
This is what I am trying to run:
SELECT group_id,name,'SELECTED' FROM groups WHERE group_id = (SELECT
group_id FROM user_groups WHERE use
Egor Egorov wrote:
Jason Joines <[EMAIL PROTECTED]> wrote:
Table employees:
| idnumber | email | phone | address |
Table webusers:
-
| idnumber | userid | website |
-
[EMAIL PROTECTED] wrote:
>After a fruitless search for MySqlCC for Mac OS X, I downloaded and
>built qt and MySqlCC. However, I ran into some errors on the CC build.
>Am I duplicating effort here? I know that we are a small market but it
>is a form of Unix and if I could get some assistance I woul
I have a large table which I like to store into memory .
Table looks like
Spid_1__0
(recordname varchar(20) primary key,
data blob not null
)
what is the best way todo this in mysql
Maybe look at using a HEAP table? Load it on startup from a datasource..
On Wed, 5 Nov 2003, Arnoldus Th.J. Koeleman wrote:
>
>
> I have a large table which I like to store into memory .
>
>
>
>
>
>
>
> Table looks like
>
>
>
> Spid_1__0
>
>
>
> (recordname varchar(20) primary key,
>
>
>
> dat
Hi,
Problem is, Mysql server in our production machine keeps spawning child
processes and it reaches to a level where mysql hangs and the only
solution is to restart our mysql server. I have checked all the
databases using "mysqlcheck" command and every table is OK now.
Recently, MySQL server suffe
I have a table called employees on a 3.23.48 server. One of it's
fields is an email address (email) and one is the userid. The primary
key is idnumber. I need to populate the userid field from the email
address field. I can get the userid using:
SELECT substring(per_email_address,1,instr(
Greetings,
I am a very new newbie to MySQL and to OOP, Delphi, ODBC, ADO, and Access,
etc & etc.
I have a very basic project using OOP, Delphi (6), ODBC, ADO & Data Aware
Components, Access and MySQL(4.1).
In fact I have two projects, identical except that one connects via odbc to
Access and the
Download http://cocoamysql.sourceforge.net/
It's really great. Painless install. I spent hours trying to get mysqlcc to install
and I was ending up playing the "one library short" game where it seems like if you
install just one more thing it will work, but then it never does. cocoamysql
in
update employees set userid=substring(.
Jason Joines wrote:
I have a table called employees on a 3.23.48 server. One of it's
fields is an email address (email) and one is the userid. The primary
key is idnumber. I need to populate the userid field from the email
address field. I can
Those are threads, not processes.
Each connection gets a thread.
Many connections waiting for disk space will give you this problem.
Jobs PHP Workshop wrote:
Hi,
Problem is, Mysql server in our production machine keeps spawning child
processes and it reaches to a level where mysql hangs and the on
IF I understand you correctly, you should be able to do this:
UPDATE employees SET
userid=substring(per_email_address,1,instr(per_email_address,'@')-1);
Chris
-Original Message-
From: news [mailto:[EMAIL PROTECTED] Behalf Of Jason Joines
Sent: Wednesday, November 05, 2003 9:14 AM
To: [EM
I've been on this list since 1997 and have probably received hundreds or
thousands of viruses in that time. The only impact I've ever noticed is that
people who use MUAs that allow viruses to interact with their OS will mention it
to the list when they occur.
If you have such an MUA, I agree wit
gerald_clark wrote:
update employees set userid=substring(.
Jason Joines wrote:
I have a table called employees on a 3.23.48 server. One of it's
fields is an email address (email) and one is the userid. The primary
key is idnumber. I need to populate the userid field from the email
ad
I don't think Sub queries like the = and != operators as groupid will never
equal the result of a multi row subquery, but it can be IN a list of
results. Just to check, you are using 4.1+ right? I think this alteration
would work:
SELECT group_id,name,'SELECTED' FROM groups WHERE group
Héctor Villafuerte D. wrote:
Hi all!
I need to perform what I've called an "additive UPDATE".
The logic is the next:
(1) There's a historic table (HISTORY) with two fields:
mysql> create table history (ID char(7) primary key, VAL int(12));
(2) There's a new table everyday (TODAY) with exactly the
Jason Joines wrote:
Egor Egorov wrote:
Jason Joines <[EMAIL PROTECTED]> wrote:
Table employees:
| idnumber | email | phone | address |
Table webusers:
-
| idnumber | userid | website |
-
No, files can be bigger than 2GB. In OSX prior to Panther there is a
2GB per-process memory limit though. Then again, on anything other than
the PowerMac G5 this doesn't matter because the G5 is the only Mac that
can hold more than 2GB of RAM.
- Gabriel
On Tuesday, November 4, 2003, at 04:42
Hello lists,
Hello list,
This is my third re-mail on this topic.
I am a very new newbie to MySQL and to OOP, Delphi, ODBC, ADO, and Access,
etc & etc.
I have a very basic project using OOP, Delphi (6), ODBC, ADO & Data Aware
Components, Access and MySQL(4.1).
In fact I have two projects, ident
If you are referring to the dbx database abstraction layer extension
for PHP, it is literally just a C-level wrapper for the database
extensions it supports. If PHP's MySQL extension supports
"asynchronous" table updates, then dbx will. What exactly are these
"asynchronous" table updates anyway
I've recently switched from GEMINI to INNODB, to be able to get
continued support and upgrades of MySQL.
I'm running into to some major performance issues. The section in the
MySQL manual is not very thorough on optimizing INNODB.
I'm getting two problems, either all my queries pile up, or a 'sho
Hi everyone,
I recently ran the MySQL benchmark suite on a Dual 1 GHz G4 running Mac
OS X Server 10.2.8, and an 800 MHz Intel machine running SuSE Linux 8.0.
Both installations used the same my.cnf file.
The results are comparable in all benchmarks except one: the 'insert'.
In that one, the Mac is
Hello lists,
This amends my third re-mail on this topic.
Sorry about that: A point to clarify is that the writes are done using the
update button of the DbNavigator.
I am a very new newbie to MySQL and to OOP, Delphi, ODBC, ADO, and Access,
etc & etc.
I have a very basic project using OOP, Del
I'm not entirely sure what to do about the slow insert results, they
are the slowest part no matter how you configure it, it seems. I've
attached some benchmark results I ran on a dual 2GHz G5 for comparison.
Both MyISAM and InnoDB.
Here are the insert results though:
MyISAM:
insert: Total tim
Christophe,
- Original Message -
From: "Christophe Lombart" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Tuesday, November 04, 2003 10:45 PM
Subject: Deadlock
> Hello,
>
> I'm using MySQL 4.0.15 standard - InnoDB and I got a deadlock. I don't
> see why !
> How Can I find
I'd be curious what the specs of the hard drives are. Using the stock
drives in the Mac means you are using a drive that's about average (2MB
cache, 7200RPM). I would assume they are both ATA/IDE drives. But I
would guess the bottleneck is the drive. Try running top when you are
running your t
Nihal,
> FILE I/O
...
> 223.89 reads/s, 72228 avg bytes/read
> --
> BUFFER POOL AND MEMORY
> --
...
> Pending reads 131
...
> 1923.08 reads/s, 0.00 creates/s, 0.00 writes/s
it is disk-read-bound. It is reading a whopping 1900 pages per second! That
is 30 M
On Wed, Nov 05, 2003 at 12:08:29PM +1100, Chris Nolan wrote:
> To my knowledge, ext2 does have the [2GB filesize] limitation but
> ext3 does not.
ext2 does not have this limitation. It was never a limitation of the
filesystem, only kernel/glibc. On 64bit architectures ext2 has been
handling larg
OK, I've got another quandary, thanks for the help on the last one, I'm
working on it.
| 15203 | root | web:36810 | ez2000 | Query | 137 | Sorting
result| SELECT from table_a |
| 15235 | root | web:36849 | ez2000 | Query | 67 | Sorting
result| SELECT from table_a |
| 152
Hi,
I have installed XFree86 4.3 and started xterm with
xterm -fn
"-Misc-Fixed-Medium-R-SemiCondensed--13-120-75-75-C-60-ISO10646-1"
Then started mysql with
mysql --default-character-set=utf8
Set LC_CTYPE to en_US.UTF-8 on my SuSE 8 machine.
Still I am not able to display Unicode characters.
I
Good day List,
I have just upgraded from 3.23 ->4.0.16
I downloaded all the RPM's and then ran
rpm -U *.rpm
It did all that it was supposed to do, and then told me to use the
/usr/bin/mysql_fix_privilege_tables script
which I did got horrid errors
ERROR 2002: Can't connect to local MySQL server
HI All
I was wondering if anyone could tell me how to get around this problems
Error: could not connect to the database.
It's possible the database itself is just not working at the moment.
The admin should also check that the database details have been correctly
specified in config.php
Database
If I recall correctly, the "G5", the mighty PowerPC 970, is used by
Apple just as Windows currently uses the mighty Hammer series from AMD -
as a souped up 32-bit processor.
Regards,
Chris
Gabriel Ricard wrote:
No, files can be bigger than 2GB. In OSX prior to Panther there is a
2GB per-proc
How about we just all agree that SCO's OSes can't handle large files,
and therefore should all be avoided in favour of completely superior
OSes, like FreeBSD, OpenBSD, Linux, NetBSD and DOS 2.11
Regards,
Chris
Pete Harlan wrote:
On Wed, Nov 05, 2003 at 12:08:29PM +1100, Chris Nolan wrote:
Andrew,
I had the same problem and had to stop and restart the servers. Give
that a shot.
brian
On Wed, 2003-11-05 at 17:19, Andrew wrote:
> Good day List,
> I have just upgraded from 3.23 ->4.0.16
>
> I downloaded all the RPM's and then ran
> rpm -U *.rpm
>
> It did all that it was supposed to
Hi guys,
I just was given the OK to play with a new server running
Mac OS X (Panther)
When I give the command (it is recommended to use mysqld_safe instead of mysqld in
some website)
*---
# /usr/bin/mysqld_safe
Starting mysqld daemon wi
If it's below 4.0 then you can't use subqueries at all, subqueries were
(will be) introduced in 4.1.
That query is just a standard query, but the third item will return the
value of 'SELECTED' if the userid is equal to 1 and ' ' otherwise.
Chris
-Original Message-
From: Geeta Rajaraman [
FYI, I've found 'iostat' to be quite useful in monitoring the drive
transfer rates while benchmarking in OSX. Then again, in Panther all
you really need to do is pop open Activity Monitor (formerly Process
Viewer) which now has some nifty graphing for system status: cpu, disk,
ram activity and
Are you using Panther client or server? my.cnf is usually in /etc. Have
you run mysql_install_db yet?
- Gabriel
On Wednesday, November 5, 2003, at 05:57 PM, Nestor Florez wrote:
Hi guys,
I just was given the OK to play with a new server running
Mac OS X (Panther)
When I give the command (it i
I've installed the latest MySQL from www.mysql.com to my computer, but
decided later to try the Complete series of web tools to get access to
Apache v2. Complete Apache v2 and Complete PHP is installed, but I
have to remove the original install of MySQL to install the Complete
MySQL package.
Hi Group,
Please forgive me if this has an obvious answer, but I couldn't find it
in the MySQL v4.1 manual --- how can I see what indexes (and which
columns are indexed) for a table?
Thanks!
Holly
G'day Brian
> I've installed the latest MySQL from www.mysql.com to my computer, but
> decided later to try the Complete series of web tools to get access to
> Apache v2. Complete Apache v2 and Complete PHP is installed, but I
> have to remove the original install of MySQL to install the Complete
Hi Holly,
SHOW INDEX FROM table;
or
SHOW CREATE TABLE table;
are 2 different ways to see indexes -- in different formats.
For reference: http://www.mysql.com/doc/en/Show_database_info.html
Hope that helps.
Matt
- Original Message -
From: "Holly Chamberlain"
To: <[EMAIL PROTECTED]
Hi George,
What are you actually trying to match with \017? As far as I know, it's
treating the \0 part as a NUL byte and trying to match that. Are you
trying to match a NUL byte? Or are you trying to match ASCII 17 or
something?
http://www.mysql.com/doc/en/String_syntax.html
Matt
- Origi
Hi,
In every instance I've seen, MySQL always allocates the amount you set
for key_buffer at server startup even if it never comes close to being
*used*. (It shouldn't be doing malloc()s or whatever for that on the
fly. :-)) Same thing for query_cache_size.
Now about join, read, and sort buffers,
Thank you! That's just what I was looking for.
-Original Message-
From: Matt W [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 5:34 PM
To: Holly Chamberlain; [EMAIL PROTECTED]
Subject: Re: how see list of a table's indexes?
Hi Holly,
SHOW INDEX FROM table;
or
SHOW CREATE
Hi,
HEAP tables don't currently support TEXT/BLOB columns.
My answer about storing the table "in memory": don't bother.
If you have enough free RAM to use to put the table "in memory," the OS
will already do it for you after it's accessed. Thus, reading the table
(after the first access) should
On Wed, Nov 05, 2003 at 11:30:46AM -, Alexis Guia wrote:
>
> Sorry, but I disagree :/
> I always used 250MB of key buffer, and MySQL never allocates more than
> 50MB, in my database.
> Read buffer is only allocated when full scans are done.
> Join buffer is allocated when there are joins witho
On Wed, Nov 05, 2003 at 10:38:05PM +0530, Jobs PHP Workshop wrote:
> Hi,
>
> Problem is, Mysql server in our production machine keeps spawning child
> processes and it reaches to a level where mysql hangs and the only
> solution is to restart our mysql server.
That sucks.
> I have checked all the
Hi,
Yes, in top, those are threads not processes, as Gerald already said.
Not that it really matters. :-)
Your connections in PROCESSLIST are sleeping (e.g. idle). What are the
clients? It looks like you may be using persistent connections with a
Web app.
If you want to get rid of the sleeping t
On Wed, Nov 05, 2003 at 07:10:41PM -0600, Matt W wrote:
> Hi,
>
> In every instance I've seen, MySQL always allocates the amount you set
> for key_buffer at server startup even if it never comes close to being
> *used*. (It shouldn't be doing malloc()s or whatever for that on the
> fly. :-)) Same
Any package that is installed in OSX leaves a receipt behind. Look in
/Library/Receipts/. Each package leaves a directory in there. In each
package's directory is a .bom file. Usually it's something like
/Library/Receipts/PackageName.pkg/Contents/Archive.bom or
/Library/Receipts/PackageName.pk
Hi,
I don't know what your previous problem was, but I don't think it
affects my answer. :-)
This isn't specific to InnoDB. Yes, when you FLUSH TABLES, all new
queries wait for that to complete (as indicated by "Waiting for table"
in PROCESSLIST). And the tables can't all be flushed (closed) unti
Hi Eric,
I think for ALTER TABLE ... ENABLE KEYS, myisam_sort_buffer_size is all
that matters. Not sure about key_buffer...
But myisam_sort_buffer is, AFAIK, only used during "Repair by sort" (in
PROCESSLIST), not "Repair with keycache." What did yours say during the
21 hours? It may change from
Hello, mysql,
I have set the slow query parameter in the my.cnf as the following.
[safe_mysqld]
err-log=/var/log/mysqld.log
log-slow-queries=/var/log/mysqlslow.log
pid-file=/var/run/mysqld/mysqld.pid
After I check the status of mysql today,we found 6 slow query occur.
Bu
Hello list,
(B
(BI'm writing a small utility in PHP to archive email messages in MySQL,
(Bso that I can search through them with full-text indexing. In order to
(Bhandle all the various charsets, I was simply converting all text to
(Butf8 (using mb_convert_encoding()) before storing it in t
Hello,
I'm having trouble with replication. The binary logs arrive in the
slave directory, but don't get inserted into the database.
I'm just a beginner at SQL & mysql, in case it isn't obvious from
the following.
The replication is limited to a database called mipradius by a slave config
're
> Briefly:
> The project connects with TADOConnection, TADOTable and TDataSource, and
> consists of two tab sheets, one with a DBGrid and DBNavigator1 (Read
only),
> and the other with an assortment of DBEdits, a DBMemo and a DbNavigator2,
> this with full read/write options.
>
> Attempts to write
79 matches
Mail list logo