I believe you could use CONCAT(firstname, ' ', lastname) LIKE
'%$searchname%'
if you leave the space out of the middle it probably won't work, and you
might want to trim firstname & lastname to make sure no leading or trailing
spaces exist.
Hope this helps,
P
--
Hello Listers,
Is it possible to run a query on one mysql server to another database on a
different server ?
eg creating an alias in database A on server A to table B on database B on
server B ?
Like a federated nickname on db2 udb or synonym on informix ?
Thanks
Pierre
fy if
this is what i'm running ?
Paul DuBois <[EMAIL PROTECTED]> wrote:
At 14:38 -0700 4/27/06, P. Evans wrote:
>Hello Listers,
> Is it possible to run a query on one mysql server to another
>database on a different server ?
> eg creating an alias in database A on se
Folks,
say I have a need to add multiple rows at the same time.
for instance, say I'm collecting customer information and I want to add 3
addresses and 3 phone numbers at the same time for a customer.
The above is quite straightforward to accomplish when there is only one set
of data to deal wit
Chris,
thank you for the response, but that was not my question.
My question is how do I send multiple sets of data into a stored procedure
without doing the things I had outlined.
On 7/17/06, Chris <[EMAIL PROTECTED]> wrote:
L P wrote:
> Folks,
> say I have a need to add multiple
Whenever I try to create a table using innodb, i get a 1266 warning that the
table has been created with myisam instead. I receive the error both at the
mysql command line and using the mysql query browser.
I've also tried alterring the table to change the engine , which says it
complet
Code | Message|
+-+--++
| Warning | 1266 | Using storage engine MyISAM for table 'petest' |
+-+--++
1 row in set (0.00 sec)
Jasper Bryant-Greene <[EMAIL PR
x27;s an option that turns off
support to that engine forcing it to elect a different method of storage.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"P. Evans" <[EMAIL PROTECTED]> wrote on 11/10/2005 10:10:44 AM:
> Here's an example :
> mysql
What gives ? How can I get the logfiles in synch ?
Pierre
Jasper Bryant-Greene <[EMAIL PROTECTED]> wrote:
P. Evans wrote:
> Shawn,
> as far as I can tell, no. Here's all my innodb options set in my.cnf :
Well, it's easy to check:
grep skip-innodb my.cnf
Is there a
Much thanks, that did the trick.
Pierre
Jasper Bryant-Greene <[EMAIL PROTECTED]> wrote:
P. Evans wrote:
> skip-innodb is commented out,thats why its not in the options I sent
> previously.
> The logs are showing something peculiar -
> InnoDB: Error: log file ./ib_logfil
Hello Listers,
Can anyone explain what are valid values for the 'debug options' on a
mysqlimport ? The manuals just say :
--debug[=debug_options], -# [debug_options]
Write a debugging log. The debug_options string often is 'd:t:o,file_name'.
What is d: ? t: ? o (ok,thats relative
Greetings,
I've got a retail operation with mysql 5.0.22 on linux pc's across the
country, and i need some input on setting up a backup strategy, preferrably
without purchasing a package. We're currently using MyISAM, with the databases
being dumped to a filesystem on a separate drive, in cas
Hello.
I get a rather strange error which I so far not been able to find the cause of:
---
/usr/bin/install: cannot stat `./t/*.disabled': No such file or directory
make[4]: [install-data-local] Error 1 (ignored)
---
I thought maybe it could be beacuse I run Debian Testing?
So far I have not bee
Hi,
I have one question regarding date column type in
MYSQL.
Can I use the column type for date as Integer instead
of DateTime or Date to store the date as
mmddhhmmss or mmdd?
As I know MYSQL accepts this format. But I am not too
sure about the column type.
What are the pros and cons fo
Hi,
But will the search be any faster using Integer or
BigInt column type compared to using Date or DateTime
columnd type.
Regards,
--- Nitin <[EMAIL PROTECTED]> wrote:
> no problems that i see.
>
> - Original Message -----
> From: "p shah" <[EMAIL PROT
I would like to connect MySQL to COBOL via ODBC, I
have installed MyODBC 2.50 in my localhost and I can
able to create the DSN for the MySQL Database in
remote server.
I am in need of an interface to connect MySQL to
COBOL. Is there any provision already exists with
MySQL? if so can you please exp
I am in a position to connect MySQL into COBOL. I have
properly downloaded the MyODBC from your website. I
have tried to Establish connection from COBOL through
the C API it have.
For that I have to link certain run time library for C
API given by MySQL. like 'mysqlclient.lib', ...
I want to clar
gt;
> [EMAIL PROTECTED]
> CocoNet Corporation
> SW Florida's First ISP
> 825 SE 47th Terrace
> Cape Coral, FL 33904
>
>
>
>
>
> - Original Message -
> From: "P Arunacha
gt;
> [EMAIL PROTECTED]
> CocoNet Corporation
> SW Florida's First ISP
> 825 SE 47th Terrace
> Cape Coral, FL 33904
>
>
>
>
>
> - Original Message -
> From: "P Arunacha
27;*'
c:\mysql\include\mysql.h(284) : error C2059: syntax
error : ')'
c:\mysql\include\mysql.h(285) : error C2143: syntax
error : missing ')' before '*'
c:\mysql\include\mysql.h(285) : error C2143: syntax
error : missing '{' befor
> added in the 'Object/library module' field separated
> by spaces (e.g.
> 'wsock32.lib mysqlclient.lib'). Don't forget to add
> the path to the
> mysqlclient library in the 'Additional library
> path:' field.
>
> Pat...
>
>
> - Or
Greetings all, I'm trying to grant a user the file privelege and am
getting error messages. Here's my SQL statement
mysql> GRANT file ON bs.table1 TO [EMAIL PROTECTED] IDENTIFIED BY
'password123';
It gets the following error:
ERROR 1144: Illegal GRANT/REVOKE command. Please consult the manual
When Mysql runs on machine with multiple NIC's. Mysql server takes the
IP Address that we specify in the configuration file. This IP Address
may or may not be a primary IP Address of that machine. So we specify
secondary IP Address for the Mysql server. It listens in that IP
Address.
When Mysql
>>> Paul DuBois <[EMAIL PROTECTED]> 7/10/2003 10:22:27 AM >>>
At 2:30 -0600 7/9/03, P Srinivasulu wrote:
>>When Mysql runs on machine with multiple NIC's. Mysql server takes
the
>>IP Address that we specify in the configuration file. This IP
Address
&g
Greetings all,
I recently upgraded from mysql 3.23 to 4.0 on a Fedora box. I moved
the old installation to a directory called old_mysql in my home
directory. I can start the new installation using mysqld_safe &.
Now, when I try to do something like:
/new/install/mysqladmin -u root -p ver
Okay, so what I did to solve this was:
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
That seems like a bit of a hack though. The my.cnf file has this line:
socket=/var/lib/mysql/mysql.sock
Anyone know why it's looking in /etc ?
On Jul 14, 2004, at 4:53 PM, Jough P wrote:
Greetings a
Greetings all,
I tried the PHP list with this one and can't seem to get an answer so I
thought I'd try here.
I upgraded from MySQL 3.23 to 4.0. I placed all the new mysql files in
/usr/local/mysql/bin, /usr/local/mysql/include and
/usr/local/mysql/lib. I compiled PHP5 and it is still using th
Hi All,
Has the MBREquals function been implemented in the latest 4.1.1-alpha
build. I am finding problems with that command. It says that problem is
there in sql syntax. If it has been implemented. Can you please help me
in the syntax of the command.
I am finding the same problems with the
Inter
Hi All,
The link below says that online backup functionality will be provided
in Mysql-5.1. I think its already there in the form of mysqlhotcopy. Is
Mysql going to extend the functionality of mysqlhotcopy so that it works
for Innodb tables also? or they are going to provide independent online
bac
I use it for backing up a 12 GB mail
database without problems.
Regards,
Chris
P.S. Keep up the great work over there at Novell! Tell us where to send
the expensive bottles of alcohol for when you help put SCO out of their
misery!
P Srinivasulu wrote:
>Hi All,
>
>The l
I have imported 1000s of records into a table and even spent some time
cleaning up characters which I messed up as I imported them (not the
fault of the DB layer, but the result of bringing things into a text
editor), but now I have the following problem.
I have a whole series of author and boo
Hi All,
I have some doubts regarding Mysqlbinlog. Does Mysqlbinlog support this
usage?
mysqlbinlog --user=root --host=127.0.0.1 master-bin.001.
I am repeatedly getting errors like master-bin.001 file not found in
Linux . When I give the full path of the master-bin.001 its working.
There is a m
>When end-user use MySQL with any non-GPL licensed program , he must
buy
>commercial MySQL license.
Nope. Only If you distribute Mysql with your non gpled commercial
application. Then you need to get commercial licenses for each copy you
sell.
You can use GPL Mysql with Non GPL program as far
installed mysql on gentoo linux.
[EMAIL PROTECTED] etc # mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
[EMAIL PROTECTED] etc # mysqladmin -p version
Enter password
Hi all,
Just noticed that a simple query that returns only 14 rows is 10X slower
when "ORDER .. DESC" is used compared to "ORDER .. ASC".
The table has about 700,000 records, indexed on the field the table is
being ordered by.
Is this expected behavior?
MySQL 4.0.18 running under OpenBSD 3.4
ssage -
From: Donny Simonton
To: 'Vadim P.' ; [EMAIL PROTECTED]
Sent: Monday, March 29, 2004 9:34 PM
Subject: RE: "ORDER DESC" vs. "ORDER ASC" exec time
Personally, it's an unexpected flaw that I hope one day will be fixed. But
I'm not holding my
Chris,
I would consider loading this script only once and establishing a single
connection to the DB server and then making it loop with a time delay
waiting for data to be inserted into the DB - that's pretty much what it
does, right?
The thing is that if you invoke the script every time you
h ASC/DESC on an equivalent query I just tried. So maybe
something is making DISTINCT + reverse index scan slow even if it's not
packed...
Matt
----- Original Message -
From: "Vadim P."
Sent: Monday, March 29, 2004 8:15 PM
Subject: "ORDER DESC" vs. "ORDER ASC&quo
Hi all,
Sorry to be so persistent, but I am bringing this up again since noone
from the MySQL development team commented on my previous post, and the
issue seems very serious, to the point I may start looking to switching
away from MySQL, so - please, please, shed some light on this issue!!!
T
adding an index improves SELECT .. ORDER BY .. ASC, but
slows down SELECT.. ORDER BY .. DESC at least by a factor of 10. If this
is not a bug, what is it?
----
Vadim P. wrote:
Hi all,
Sorry to be so persistent, but I am bringing this up again since noone
from the MySQL d
Start another Mysql shell session; then do "show processlist"; identify
the thread ID of the offending process, then do "kill ". Not sure
how graceful this method is, though. I use it to kill overlooked hanging
connections from time to time.
Cheers,
Vadim.
Scott Haneda wrote:
Every now and th
Hello all,
Could anyone comment on User Variable behavior in the example below?
Thanks,
Vadim.
=
mysql> SELECT
-> LEFT(CallTime,10) AS CallDate,
-> @a := SUM(Charge),
-> @b := SUM(Cost),
Sorry, the message got garbled, here is a more digestible look:
-Original Message-
Hello all,
Could anyone comment on User Variable behavior in the example below?
Thanks,
Vadim.
=
mysql> SELECT
-> LEFT(CallT
http://dev.mysql.com/doc/mysql/en/Variables.html
A little ways down the page...
"The general rule is to never assign and use the same
variable in the same statement."
-- Tripp
--- "Vadim P." <[EMAIL PROTECTED]> wrote:
Sorry, the message got garbled, here is a more
dige
Why when there is a figurae, figurae2 table does the follow give an error?
INSERT INTO figurae2 SET id = figurae.id;
The error is:
ERROR 1109 at line 35: Unknown table 'figurae' in field list
Line 35 is the Insert line shown. There are no following lines in the file.
I cut and pasted "figurae" fro
Victoria Reznichenko wrote:
"P. Hill" <[EMAIL PROTECTED]> wrote:
Why when there is a figurae, figurae2 table does the follow give an error?
INSERT INTO figurae2 SET id = figurae.id;
The error is:
ERROR 1109 at line 35: Unknown table 'figurae' in field list
>
Look
Garth Webb wrote:
I'm not asking for an alternative way to do it; I'm asking what
is wrong with what I did?
It looks like you want to copy over several or all values from a second
table. The INSERT .. SELECT syntax isn't an alternate way, its the only
way.
Okay, thanks for the clarification. I di
David Blomstrom wrote:
I just wondered if anyone on this list has worked with
counties in databases and is aware of a pre-existing
code system that's in fairly wide use. It would be
nice to make a database that's compatible with other
databases, if they share a common code for counties.
I don't kn
If "surname" is a field, then use it without the single quotes ('),
otherwise it is treated as a literal string and 0 is the correct result:
select locate(' ',surname,1) from advisers
andy thomas wrote:
Yes, this is the approach I was thinking of using but:
select locate(' ','sur
I want to upgrade my MySQL version (3.23.51) because of the recently
revealed exploit; the only binary dist on mysql.com for solaris 2.7 is
3.23.53; will there be a problem compiling from source on this platform or
should I wait for the binaries to be updated? There is a .54 release for 2.8
and 2.9
I have about 300 database tables that are mostly ISAM and some MyISAM
format. I would like to move them all into MyISAM - what's the
easiest/quickest way? I am running 3.23.54.
I was thinking of doing mysqldump, then using a search/replace in the file
CREATE TABLE .. TYPE=, then recreating the dat
SHOW STATUS (after 24 hrs uptime):
created_tmp_disk_tables = 597
created_tmp_tables = 8893.
SHOW VARIABLES:
tmp_table_size = 33554432.
Does this mean that 597 queries have created a result set in excess of 33MB?
How can I find these rogue queries and optimise them? I could increase the
tmp_table_
> If you are running close to the same setup with no problems then I feel a
> little better about it not being a issue of pure traffic.
Yes, we operate in a very similar way to you. (BTW, we have had very good
results with a PHP based cache facility that simply stores the db driven
pages over a se
1/03/2003 01:37:50 PM
To: [EMAIL PROTECTED]
cc:(bcc: Murali P/Satyam)
Subject: Different Table type between MASTER and SLAVE
Hello.
I'm build a system aka of Shopping mall.(I think most of queies will be SELECT)
For performance, MySQL will run on replication.
I need TRANSACTIONs to
1/03/2003 01:37:50 PM
To: [EMAIL PROTECTED]
cc:(bcc: Murali P/Satyam)
Subject: Different Table type between MASTER and SLAVE
Hello.
I'm build a system aka of Shopping mall.(I think most of queies will be SELECT)
For performance, MySQL will run on replication.
I need TRANSACTIONs to
Hi,
When I run "perl run-all-tests --server=mysql --cmp=mysql,pg,solid
--user=test --password=test --log" in the sql-bench direcotory. I
encountered following error messages:
" Can't locate DBI.pm in @INC (@INC contains:
/usr/lib/perl5/5.6.0/ia64-linux /usr/lib/perl5/5.6.0
/usr/lib
Hi ,
My aim is to avoid mysql connects to the DB & my application does
not run as a daemon .
But the parent of this program runs as a daemon , so can someone tell me
how I would make use of the same Mysql handler in the execed child also
assuming I connect to the Mysql Server in the parent ?
1
Hi,
It's not quite clear from the manual, but it appears that queries with
FULLTEXT search patterns like this:
MATCH (some_text_field) AGAINST ('("red pepper") ("green bean")')
don't produce the result desired, that is, multiple ".." elements are not
allowed, with or without parentheses...
Cou
Of course, I forgot to mention 'IN BOOLEAN MODE'.
...
MATCH (some_text_field) AGAINST ('("red pepper") ("green bean")' IN BOOLEAN
MODE)
...
>
"Vadim P." wrote:
>
> Hi,
>
> It's not quite clear from the manual,
Sergei, here:
RH7.2/2.4.9-31/Dual P-III 866MHz/MySQL4.0.2
A snapshot from a live database, sorry, couldn't prepare a more detailed
example:
--
select tdate, left(header,125) from archivel where match (header) against
('"donald rumsfeld"' in boolean m
hed) /usr/bin/cmp
checking for chmod... (cached) /bin/chmod
checking for hostname... (cached) /bin/hostname
checking for gnutar... (cached) gtar
checking for perl... (cached) /usr/bin/perl
checking for ps... (cached) /bin/ps
checking how to check if pid exists... /bin/ps p $$PID | grep mysqld
Just tried building Mysql-3.x.x cloned from the Development Tree on the same
machine - works like a charm. Still no luck with 4.0.2
Is there any known issue regarding building 4.0.2 under RedHat7.2?
Thanks,
Vadim.
"Vadim P." wrote:
>
> The Dev. Tree Source MySQL 4.0 no
a 2.96 compiler
>
> greetings
>
> Jurgen Campforts
> Meidoornlaan 2/1
> 2200 Herentals
> 0496/60.25.75
> http://www.scnoorderwijk.be
> http://crashke.no-ip.biz
>
> -Oorspronkelijk bericht-
> Van: Vadim P. [mailto:[EMAIL PROTECTED]]
> Verzonden: don
Mike, what kind of problem? What exactly goes wrong with PHP4?
Thanks,
Vadim
Mike Robinson wrote:
>
> I am able to reproduce this problem very easily, including on
> Redhat-7.2. Basically, any app using the libmysqlclient.so
> compiled with gcc-2.96 connecting to a server compiled with
> gcc-2
Mike,
BTW, have you been able to build Mysql 4.0 under RH7.x from the development
tree lately?
I keep getting some missing definitions messages as of last week, when I
performed a regular 'bk resync'. Prior to that, all had been just fine.
TIA,
Vadim P.
Mike Robinson wrote:
>
&
Sergei Golubchik wrote:
> rebuild your indexes (the proper way to do it is to issue
> REPAIR table_name USE_FRM
Sergei, would ALTER TABLE.. DROP INDEX.. ADD FULLTEXT... do the same trick?
TIA,
Vadim.
/* sql, mysql to satisfy the spam police */
" and match
(header) against ("reagan");
++
| 1988120101 |
| 19990610115359 |
| 2515123714 |
| 1988112201 |
| 1988112201 |
++
5 rows in set (0.08 sec)
Regards,
Vadim P.
Victoria Reznichenko wrote:
>
> Przemyslaw,
> Wednesday,
Hi,
Currently I am using "|" (pipe) (without quotes) to
separate values if they belong to the same user.
eg : If a user wants to receive an e-mail on Friday
and Saturday I will put in the required field 5|6.
And than retrieve that split/explode it with "|" and
check the value.
Is there any oth
Hi,
I want to start the autoincrement field in mysql
primary key from 1000 instead of 1.
Any ideas.
Thank You.
Piyush.
__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
--
Hi,
I am looking for help on writing stored procedures for
Mysql 4.0 and above.
Any examples or pointing to advanced tutorials
covering stored procedures for Mysql will be highly
appreciated.
Thanks in advance.
__
Do You Yahoo!?
Yahoo! - Officia
Hi,
I am looking for help on writing stored procedures
for
Mysql 4.0 and above.
Any examples or pointing to advanced tutorials
covering stored procedures for Mysql will be highly
appreciated.
Thanks in advance.
__
Do You Yahoo!?
Yahoo!
Hi,
OK - Here's plain text. I don't know anybody else that uses it, so let's see
if you accept it THIS time!
I have a network made up of two PCs, one is Win98 and the Server is Linux. I
am not using NIS, preferring to use "host" instead. I can ping each machine
at either end and Samba works just
Hi,
I want to know one thing about MYSQl,
Why does this software always give the unix-socket
problem when compiled and installed.
I am installing on redhat 7.1.
Is there a remedy to this or this will continue
forever.
Any help will be appreciated.
Thanks
_
Hi All
I keep getting a problem with our MySQL database, I know what error 127 is
('Record-file is crashed / Network is down'), it keeps occuring on several
tables that are frequently accessed by our website.
I can fix the problem by running OPTIMIZE TABLE on the offending tables but
it seems to
hi all,
i have a problem with "load data..." statement. i'm using MySQL 3.23.49 from
RedHat 7.3. i read Paul DuBois book about MySQL, and tried to load data to
my member table,
mysql> LOAD DATA INFILE "member.txt" INTO TABLE member;
but i didn't work.
i've tried by removing the 'local', but i
thanx 4 your reply:
this is the error message that i got when i tried using the full pathname.
mysql> LOAD DATA INFILE "/home/ihot/member.txt" INTO TABLE member;
ERROR 13: Can't get stat of '/home/ihot/member.txt' (Errcode: 13)
mysql>
i've tried using another user account (of course i've set a
Jose--
Are you running mysqld as 'root'?
Run it as 'mysql' and change the group membership of the data directory and
its contents to 'mysql'.
Vadim.
Jose de Leon wrote:
>
> Here are the perms on the mysql db files /var/lib/mysql/mysql
>
> Also, I was logged into mysql with a plain user 'jos
hi,
i recently downloaded mysql-3.23.32-hp-hpux10.20-hppa1.1.tar.gz ,
and tried writing a very simple code to start with .
i just made a call to mysql_init() and mysql_connect() in the
sample code .
i used aCC ( version : aCC: HP ANSI C++ B3910B A.01.21) on a
HPUX 10.2 machine .
hi,
basically i am reframing my earlier question.
i'm using aCC ( ansic C++ compiler from HP ) on HPUX10.2
to compile and link my small C code with libraries available
from mysql-3.23.32-hp-hpux10.20-hppa1.1 .
i get the following:
/usr/ccs/bin/ld: Unsatisfied symbols:
mysql_c
Hi,
I would like to find out if the Win2000 version of
mysql and myodbc support Win2000 clustering.
Thanks,
Sam
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
---
hey,
i'm running serveral mysql servers on powerful
machines - dual processor, 2 GB memory, etc... Most of
the databases store temporary data only. I need the
maximum performance from these servers and have a lot
of connections to the database.
My problem is this - whenever the number of qu
hey..
thanks for the info...
This is the my.cnf file that i'm using -
[mysqld]
skip-locking
set-variable= key_buffer=640M
set-variable= max_allowed_packet=10M
set-variable= table_cache=640
set-variable= sort_buffer=6M
set-variable= record_buffer=6M
set-variable= t
hi,
my mysql server restarts automatically when the
machine touches 100% CPU usage. any ideas why?
tx.
vinod.
Do You Yahoo!?
Get your free @yahoo.co.in address at http://mail.yahoo.co.in
--
=1
set-variable= back_log=2900
set-variable= connect_timeout=15
set-variable= wait_timeout=57600
set-variable= interactive_timeout=57600
Tx.
Vinod.
--- "Jeremy D. Zawodny" <[EMAIL PROTECTED]> wrote:
> On Mon, Mar 19, 2001 at 12:34:30AM +, vinod p
> wr
a 100-150 queries at that time.
Tx.
Vinod
--- "Gerald L. Clark"
<[EMAIL PROTECTED]> wrote: > You have
mysqld set for 2000 connections.
>
> How many threads do you have Linux configured for,
> and how many are open
> when
> Mysqld crashs?
>
>
> vinod
hey,
i've been observing a similar kind of a problem
with mysql 3.23.32 on a Linux 2.4.2 kernel. The
backtrace that i'm getting is different, but even that
fails a sanity check. When i resolved the incomplete
backtrace, it showed me thread creation functions and
something of that sort. The
Dear MySQL Team
first of all, excuse my English. Im from Argentina,
Im a java developer and use MySQL database.
I connect to MySQL to Type4 Driver JDBC fron Java.
I have one machine with Mysql server in port 3306 and
another machine with an application in Java.
I want to know how to start a cli
Just a thought - if your serial numbers have fixed format, then
programmatically remove the hyphen and store the number without it. Add it
back when displaying data on the screen. That way FULLTEXT will work on the
whole number without splitting it into two parts.
Vadim.
Marty McCoy wrote:
>
>
Dear Anyone
I am one of the Linux user. I use the
freebsd operating system.
I have one main problem. After installation
completed , I put the command "mysql" in #prompt.
But some error message will shows, I don't
know how to solve it.
The Error message is "
Hi,
I am new to MySQL. I installed it on Win 98 and trying
to invoke the mysqld. First it gave me a strange error
that innodb_data_file_path is not found. I copied the
following from manual (I dont really want to create
such 2GB files though !).
--
Hi all,
I'm looking for a posibility to count the datatraffic of a database at my
mysqldb-server.
The clients should got only select-rights on thier databases. And I need to
count the resultset datatraffic of their select-queries.
I'm using mysql version 3.23.39.
I was looking for some logfiles
> SHOW STATUS will give you an indication on how much
> traffic is moved between your server and the clients
> (look for "bytes sent" and "bytes received") - but
> only the totals for the server are displayed. I very
> much doubt you can get the data by client or connection.
>
> I'm curious as to
This morning our MySQL exited for no good reason!
mysql.err:
021020 17:25:53
021020 17:
021022 18:20:16 mysqld ended
mysql.log:
021022 18:20:09
243748 Connect mysql_user@localhost on
243748 Init DB mydb
243749 Connect [EMAIL PROTECTED] on
243749 Init DB mydb
243748 Quit
243749 Qu
> JP> 021022 18:20:16 mysqld ended
> JP> 243749 Query INSERT INTO IDRefs
> JP> VALUES('5136110c98b89de5d389df0754182ff2','','',NOW(),'Not
available','','')
> MySQL server always crashes on this query? What is the structure of
> the table IDRefs?
Not always, just a few times in the last fe
Another error!
PHP starts to output the error "Too many references: cannot splice - error
144"
When logging into mysql, I get:
"Didn't find any fields in table IDRefs"
started with -A, I get:
"cannot open file: IDRefs.MYD (error: 144)"
optimize table IDRefs;
"Can't open file: 'IDRefs.MYD'. (errn
> Error 144 that the table is crashed and the last repair failed. You should
> run a check and optimize on this table if possible. Error 13 indicates
that
> you do not have permission to access the file. If you are the System
> Administrator you may want to check the file permissions. Otherwise, yo
> $ perror 144
> 144 = Table is crashed and last repair failed
>
> Your table is corrupted, try to repair it with REPAIR TABLE or
> myisamchk:
> http://www.mysql.com/doc/en/Repair.html
Hmm. REPAIR TABLE gives
| mydb.IDRefs | repair | error| Can't create new tempfile:
'./mydb/IDRefs.T
frustrated trying to sort through the diff recommendations & in getting
new server install to work on redhat 7.2, w/ apache 1.3.26, php 4.2.2
source compiled. (ok so i'm new to the free world)
pls correct me if i'm wrong, but i understand don't use rpms (haven't
figured out why not tho), go for
I've made a few changes to my Solaris - MySQL setup, following some
instructions in the manual for tuning.
(512MB RAM - single SCSI disk - combined web/db server - about 150 db tables
all with small query returns / single updates / hardly any joins)
I have set
max-connections = 200
table-cache = 2
what mysql version is recommended for running w/apache 1.3.26 & php
4.2.2?
i'm having trouble getting mysql config'd w/these & wonder if i should
avoid/lean to any particular versions?
-
Before posting, please check:
http://ww
1 - 100 of 308 matches
Mail list logo
