HI ALL
I study mysql, and I want to trace the source code.
Are there any documents that describe the data structure
and the relationships between function in MySQL?
Many thanks!
-
Before posting, please check:
I've been trying to figure this out for ages. I've compiled mysql with
the following options:
./configure --prefix=/usr/local/mysql --enable-assembler --with-mysqld-user=mysq
l --with-comment --without-readline "$@"
and the compile goes just fine. Then I do make test (as one is want to do)
and
I think a good soluthion it is to do a table for every thing and use MERGE
table for searching data in all the table (for MERGE see documentation at
pag. 271 "MySql table Type" chapter).
Il 16:24, mercoled 14 marzo 2001, abdelhamid bettache scrisse:
I want to ask you :
1- How many rows
I have to store data for Internet desining (10-20 Gb at Day)
so I have to use a data base very fast: MySql is fast?
I have to put 10-20 Gb of data every day: but I can have a table only of 2Gb
(I know that reading manual of Mysql).
How to do a table so big?
Thank you in advance, Rino.
If I order a table using myiasmchk then, when I put other row in the table,
this thable is still ordered or I have to reorder again?
Thank you in advance,Mario.
-
Before posting, please check:
http://www.mysql.com/manual.php
Thanks for help .,
I tried it but also got the same error
any other advice
"Gerald L. Clark" wrote:
Run isamchk on your tables.
mohamed Abd El-Samei Mohamed wrote:
Dear all i need help
i have mysql-3.22.26a over unix solairs 7
when i try to apply query from the console to
On 14.03.2001 22:33:13 Charles L Hagen wrote:
Has anyone found a GUI for MySQL on a Linux box? I found Webmin, but it
seems limited.
Is there an HTML GUI for MySQL?
phpMyAdmin - see freshmeat
-
Before posting, please
Hi, alexander.skwar,
Mysql has the type as the MSSQL BIT???
Regards,
Sunrise
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
I got a problem.. im using mySQL the newest release on a redhat 7.x for the server..
And im doing some programming.. on a win2k pro with delphi 5.0 ent ed. and im using
the myODBC driver in windows to connect to the db.
Tho when the db is empty
[mailboxes]
mailbox char 50
fullname
Hello Heikki,
Finally I was able to check the innobase tables included into mysql
3.23.34. Well first several times I was quite happy about them, but
later understud that this is because option --create-options is
broken :)
So now I must say On my system innobase seems to work as bad
Hello
I'm run a family/pedigree database with about 250.000 records of dogs.
The dogs are mostly (to 90%) searched by name.
To find similar records I have my own 'soundex' colums wich is searched
and ofcourse indexed.
table dog
id int4(indexed)
name varchar
soundex varchar
On Thu, Mar 15, 2001 at 09:54:18AM +0100, Mario Latens wrote:
If I order a table using myiasmchk then, when I put other row in the table,
this thable is still ordered or I have to reorder again?
You'll need to reorder again.
Ordering with myisamchk is meant to increase performance, not to
Hi
I run a database using mysql 2.23 by a webspace provider.
I would like to keep a 1to1 mirror of it at home.
Unluckiely I have no shell/ftp access to the tables directory.
The database-dump (with php) is far too big to download it every day.
- Any ideas how to backup it?
- I'm dreaming
On Tue, Mar 13, 2001 at 04:18:41PM +0100, Alessandro de Manzano wrote:
I'm planning to deploy MySQL for a project of my company but I've some
concern about real size limit of BLOBs.
I read on Paul DuBois' excellent book that longblob are 2^32-1 wide,
but actually the communication
Thu, 15 Mar 2001 11:09:14 +0100 SQL SQLDriverConnect
Thu, 15 Mar 2001 11:09:14 +0100 ERR [TCX][MyODBC]Access denied for user:
'root@ipaddress' (Using password: YES)
On 15.03.2001 10:23:19 Sunrise wrote:
Hi, alexander.skwar,
Mysql has the type as the MSSQL BIT???
Pardon me? What do you mean?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
On Thu, 15 Mar 2001, Eric Holmbom wrote:
Thu, 15 Mar 2001 11:09:14 +0100 SQL SQLDriverConnect
Thu, 15 Mar 2001 11:09:14 +0100 ERR [TCX][MyODBC]Access denied for
user: 'root@ipaddress' (Using password: YES)
It is saying (quite straightforwardly) that you either
a)
Hello,
I have just had a little problem with a SELECT query like this:
SELECT DATE_FORMAT(Day,"%e.%m.%Y") AS ftag,* from TheTable;
this query returns an SQL error: ERROR 1064: You have an error in your
SQL syntax near '* from TheTable' at line 1
BUT:
SELECT *,DATE_FORMAT(Day,"%e.%m.%Y") AS
On 15.03.2001 11:10:24 Eric Holmbom wrote:
Thu, 15 Mar 2001 11:09:14 +0100 SQL SQLDriverConnect
Thu, 15 Mar 2001 11:09:14 +0100 ERR [TCX][MyODBC]Access denied
for
user: 'root@ipaddress' (Using password: YES)
Wrong password, I'd say.
dear simon
hello
try mysqlman its the best tool to manage database remotely
naveed
- Original Message -
From: Simon Green [EMAIL PROTECTED]
To: Mysql [EMAIL PROTECTED]
Sent: Thursday, March 15, 2001 4:50 PM
Subject: Monitoring Database
Hi
I am trying to right a program to monitor
I am experiencing problems with record locking on database updates.
When I use an Access update query to modify a record subsequent updates
to the same records result an Access 97 message stating that the record
is in use by another user. This happens if I am the sole user of the
database. It
Hi,
I tried to build from source the latest MySQL 3.23.34a and I found the
following problems:
1) The Makefile in the 'pars' and 'mem' directory have missing ../include/
paths on some dependencies.
2) In the 'mem' directory, the file mem0mem.c tries to include mem0dbg.c,
but I think this
naveed wrote:
dear simon
hello
try mysqlman its the best tool to manage database remotely
naveed
- Original Message -
From: Simon Green [EMAIL PROTECTED]
To: Mysql [EMAIL PROTECTED]
Sent: Thursday, March 15, 2001 4:50 PM
Subject: Monitoring Database
Hi
I am trying to right
BigBrother (www.bb4.com) has a plugin for MySQL. It monitors the IP port of
the mysqlserver and sends you a message when it is down (or start a script
and do wahtever you want e.g. start up the slave).
Hugo Burm
[EMAIL PROTECTED]
-Original MessageH-
From: Simon Green [mailto:[EMAIL
Hi,
How do I put two or more hosts in a single user row? I have all them at
'localhost' but I'd like to set it to something like
'localhost,machine.domain.tld,machine2.domain.tld' without having to
repeat the line since I've got to manage a *bunch* of users.
Thanks...
Hi Greg,
If you are speaking about show tables returns blank lines, than thank you
very much and I hope you will find it! Please, keep us on track!
Best regards,
Lumberer.
On Mon, Mar 12, 2001 at 09:57:28PM +, Greg Cope wrote:
The following C and CXX flags will work (/usr/local/bin/gcc
Martyn Perring writes:
Hi,
Can anyone shed any light on this?
I'm trying to build mySQL V3.23.34a on Tru64 V4.0G using gcc2.95.2 and
GNU Make version 3.79.1.
The makefiles were created using ./configure --prefix=/nipweb/mysql. No
other configure paramaters were used.
Hi there,
i received the following message:
[TCX][MyODBC] Host 'XYZ' is not allowed to connect to this MySQL Server
(#1130)
any ideas
regards
denis
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Hi,
I have a table:
CREATE TABLE http_refer(
rid int unsigned auto_increment,
refer varchar(255),
unique index(rid),
unique index(refer)
);
It is filled with referrers from our webserver log and has 4138 rows.
Today I've tried to execute:
mysql select
I have been told you offer a service to convert ASP scripts that connect to
an access database to a mySQL database.
If this is the case could you send me the URL of this resource.
Many Thanks
Paris.
--
Paris Val Baker
I failed to mention that I used the RedHat Source RPM and I am using RedHat
6.2.
Rick
-Original Message-
From: Mehalick, Richard RE SSI-GRAX
Sent: Thursday, March 15, 2001 6:10 AM
To: 'Heikki Tuuri'
Cc: '[EMAIL PROTECTED]'
Subject: Innobase compile problems
Hi,
I tried to build from
Hi all,
I'm having problems getting reasonable speed
queries from a simple table.
First, a little info about my server
setup:
From mysqladmin version:
mysqladmin Ver 7.11 Distrib 3.22.27, for
I had two questions about table design and format.
I'm designing an application that has two tables.
The first table will have
-Many selects that return about 20 results on average.
-Few inserts
-Very few UPDATEs
For this table it is not important that the newest inserts show up in selects
Hi!
"Peter" == Peter Zaitsev [EMAIL PROTECTED] writes:
Peter Hello Heikki,
Peter Finally I was able to check the innobase tables included into mysql
Peter 3.23.34. Well first several times I was quite happy about them, but
Peter later understud that this is because option
hi
i am installing My Sql on Linux 7
i was trying it for the whole day..the only problem i
am facing since morning is that..
the SQL server starts during the booting of system
when i go in bin and give mysqladmin command it gives
error - Can't connect to server..
either the server is not running
Yes, make sure you shutdown the server before running isamchk.
mohamed Abd El-Samei Mohamed wrote:
Thanks for help .,
I tried it but also got the same error
any other advice
"Gerald L. Clark" wrote:
Run isamchk on your tables.
mohamed Abd El-Samei Mohamed wrote:
Dear all
On Fri, Mar 16, 2001 at 12:32:37AM +1030, Dan Makovec wrote:
Hi all,
I'm having problems getting reasonable speed queries from a simple table.
...
I've created a simple table that contains stock exchange data, as follows:
CREATE TABLE shares (
date date DEFAULT '-00-00' NOT NULL,
Description:
Compiling Mysql for aix. I receive an error saying char size is 0, I noticed
that another file is looked up and it is not present. "conftestval"
How-To-Repeat:
I have set my c compiler and c++ compiler to gcc, then entered the following,
you
You did not tell us what hardware and MySQL version you are using.
There is no Linux 7.
If you are refering to RedHat Linux Version 7.0, and you installed the
mysql found on the CD, then you have 3 choices.
1. chown -R mysql /var/lib/mysql
If the mysql data directories are not in
Did you read chapter 6 in the manual?
denis mettler wrote:
Hi there,
i received the following message:
[TCX][MyODBC] Host 'XYZ' is not allowed to connect to this MySQL Server
(#1130)
any ideas
regards
denis
-
No, it should not be.
Eric Morgan wrote:
Yes, The prefix path I used below is the path to the source
distribution. Should it not be?
Eric
Mohamad Ilhami wrote:
On Wed, 14 Mar 2001, Eric Morgan wrote:
I configured and compiled mysql-3.23.34a without even a warning:
Hello,
im trying to connect to mysql server from php but i cant do it.
i created the databases successfully!!
i put :
?php
$link = mysql_connect(host, user, password);
?
Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (111)
And I've filled this with a bit of data. Well, more than a bit - 5,791,651 rows
actually. Still, while this is large, it doesn't seem rediculously huge.
Let's say I want to perform a query to
Rick,
I tried to build from source the latest MySQL 3.23.34a and I found the
following problems:
1) The Makefile in the 'pars' and 'mem' directory have missing ../include/
paths on some dependencies.
Do you mean that when you compile, on the compiler line there is not the
flag -I../include?
Peter,
could you ftp your binary (compiled with -g option) to
support.mysql.com directory /pub/mysql/Incoming
I can then try to run the ATIS test on your binary on our SMP Linux.
One possible reason for the errors you get is that your version
of GCC is buggy in inlining of code, but that is
Hi
I have a long-running select that's basicly just summing a couple of columns
in a 1-2GB big table.
It lasts for 5-10 hours and I notice that the disc activity is *very* high:
vmstat 1 says:
5 0 0 30332 3068 5240 129260 0 0 10260 658 498 63 35 3
4 0 0 30332 3192 5244
Yes, there are a couple of methods such as mysqlimport. Please read the
manual for the others.
- Original Message -
From: "WANG_KING£¨Íõ¸Ö£©" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 15, 2001 10:30
Subject: Data tool
I want to load data to mysql.
Does mysql has
Hi Mario,
I think I had the same problem as you, and got som help...
You have three ways of doing this:
1. Switch to a FileSystem that supports bigger Files
2. Use MERGE, create a lot of small tables and use MERGE
in you select Querys, The manual is quit god at explaining
how to do this, but
I want to ask you :
1- How many rows does a mysql table can hold?
2- I have to design a database for all universities of my country , Is it
better to consider one database for each university or one database for
all
universities . Note that a query on a table "student" would be more quick
All,
I've got a quick question - In section 7.11 of the manual on
Optimize_Table it states that the table is "locked" during
optimization. It does not state however, if this is a
read-lock, a write-lock or both. Can you clarify?
Thanks
Since I'm not a member of this list, could any
responses
Hi
I am using Resin1.2.3 engine to run my servlet and
mysql database with mysql-jdbc driver to connect my
servlet with database but it gives me null pointer
exception when I run my servlet
500 servlet exception
java.lang.NullPointerException
I hope many of you might have face
Hi , i have the following method:
public Object getValueAt(int row, int column){
// in here i want to construct a SQL query which gives the object at a
certain
row and column
}
Do you know how to do it?
Thanks
Pawan
-
In the last episode (Mar 15), Mark Dombeck, Ph.D. said:
All,
I've got a quick question - In section 7.11 of the manual on
Optimize_Table it states that the table is "locked" during
optimization. It does not state however, if this is a
read-lock, a write-lock or both. Can you clarify?
Anyone know of a Source control system implemented in MySQL?
C. Duncan Hudson
Dynax Solutions, Inc.
Tel 216.292.8203
FAX 216.292.8273
EMail [EMAIL PROTECTED]
-
Before posting, please check:
Description:
Performing a "mysqldump --all-databases --opt" produces invalid
SQL for the "db" table i.e.:
KEY User(User)
Attempting to rebuild tables with the mysql client using this SQL fails
with a syntax error.
If the SQL is modified to:
KEY User (User)
then the mysql
I see. I added the timestamp field (I never knew there was a field type
of timestamp), relinked the table in Access 2000 and the darn thing
actually worked! Did this just become a requirement in MySQL 3.23? As I
mentioned in a previous post, the timestamp field was not required when I
was
Pawan Kanda wrote:
Hi , i have the following method:
public Object getValueAt(int row, int column){
// in here i want to construct a SQL query which gives the object at a
certain
row and column
}
Do you know how to do it?
Thanks
Pawan
Maybe make your sql statement read
sql =
I'm having a problem with REGEXP :
I have several rows that look like this :
Health : health services : safety : physical abuse : women
Health : health services : safety : rescue
Health : health services : safety : sexual abuse
Health : health services : safety : sexual abuse : children
Health
Does someone has an answer for this already done question ??
- Original Message -
From: "Jason Bell" [EMAIL PROTECTED]
To: "mysql list" [EMAIL PROTECTED]
Sent: Friday, March 09, 2001 5:58 PM
Subject: Postgres to MySQL Migration
Anyone know an easy way to migrate a Database from
I encountered a few problems with the genuine 1.7.8-1 binary RPM for
mysql++.
- If I compile:
Connection con("temp","localhost","root","temp",3306,0,60,1,"",0);
The linker complains: undefined reference to `MysqlConnection::MysqlConnection(char
const *, char const *, char const *, char
Hi,
I would like to tune the performance of my database.
The database is rather small about 80 MB altogether. (with 20 Mb indexes)
The most complex selections open 32 tables at ones.
The database is mostly readonly (99%).
What settings show I use to maximize the speed of the queries?
What
join
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL
I cant seem to find system requirements anywhere for MySQL, even inside the hundreds
of pages of the manual... I wish to run the latest stable release on MySQL on a
Windows NT Workstation PC, and will also use this PC to run ColdFusion Professional
4.5 server. Where could I find recommended
Does anybody know if this amount of memory usage is normal? (taken from *top*)
PID USER PRI NI SIZE SWAP RSS SHARE LC STAT %CPU %MEM TIME COMMAND
677 root 90 19228 0 18M 15801S 0.0
2.1 0:07 mysqld
679 root 9
I never found an answer. I plan to write a PHP page to help automate this, and
expect to have it done soon, time permitting.
--Jason Bell
Yurais Fernndez Leal wrote:
Does someone has an answer for this already done question ??
- Original Message -
From: "Jason Bell" [EMAIL
Cold Fusion 4.5 Server is a hog. If you can run that you probably have
enough memory for MySQL. I would not run them simultaneously with less
than 384 MB ram.
Charles Hagen
On Thu, 15 Mar 2001, Chris Peterson wrote:
I cant seem to find system requirements anywhere for MySQL, even inside the
I saw that someone already gave you some suggestions, but the reply seemed
to lack a bit of WHY you have that limitation, so I thought I would explain.
The 2Gb limitation is not in MySQL. It's in your operating system. If you
read some of your OS's docs, you can see how to get around this
Hi,
I have to mananage a very big table (about 20 Go)
A database correspond to a directory.
A table correspond to a file.
Is it possible to distribute the table on several physical partition (like
with Oracle that can use several table space to store one table) ?
Thanks,
--
Pascal Thivent
Friends.
people out in here are very afraid , when they hear Mysql does not support foreign
keys.
It really become difficult , why foreign keys are not enforced by mysql.
Anyways, can u please tell me does our favourite database support composite primary
keys as in Acess databse key...?
U
MySQLGui is a good option in graphical mode, there are other command line
clients too
At 19.40 14/3/01 +0100, you wrote:
can I manage mysql server 3.23 on red hat linux 6.1 using a win32 client on
win nt ?
thank you in advance.
regards.
Andrea GIGLIOTTI
GB Net S.n.c.
Via Bagni Caldi, 11
55021
I seem to remember that Microsoft SQL Server has the concept of a "covered index" that
worked something like this:
Suppose you have a table with a product_category, and a price. You query alot on
product_category, so you create an index on it. You're expression might look like
this:
select
Please see my comments below.
Do you mean that when you compile, on the compiler line there is not the
flag -I../include?
No, not really. I mean in the dependencies for a target.
If the flag is missing, there obviously is something wrong with our
Makefile.am's or configure.in's. You probably
Sunrise wrote:
Hi, alexander.skwar,
Mysql has the type as the MSSQL BIT???
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Yes and this is documented in manual.
--
MySQL Development Team
__
For some reason I cannot figure, mysqld is now leaving loads
of SQL.ISD/ISM files in /tmp/ .. perhaps 10 a minute..
there are no errors reported in the mysqld log file, other
than one or two connection aborted every hour.
the files are all owned by root, group root.
/tmp is rwx word with t
Rick,
have you downloaded version 3.23.34 and not 3.23.34a?
I downloaded 3.23.34a, untarred it, and mem0dbg.c was in innobase/mem
directory.
I have attached to this email a copy of mem0dbg.c.
Are your Makefile's such that they did not build all the
object files and libraries needed for linking
- Original Message -
From: walkiriocosta
To: Sérgio floripa
Cc: adrianovarig ; berg ; beto
; emilson ; fenix ; jacira ; junior ; marcelao ; vagno ; zeus
Sent: Sunday, March 11, 2001 6:43 PM
Subject: En:Fw: [BQ75] Fwd: Re: LER COM URGÊNCIA (fwd)
E-mail grátis BOL com antivírus!
Does MySQL allow either user or group quotas to be enforced per
database?
Thanks,
Jose
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
I have been getting this error quite a bit, and
keep losing my access to the database from my
persistent connection, it seems... any idea where
I should be looking to solve the problem?
Mysql 3.23.34 on Solaris 2.7
Error is:
010315 10:41:55 Aborted connection 27 to db: 'events' user:
I get the subject error when running the static or semi-static linux builds on
Mandrake 7.2. My database is working fine and I am able to use another client,
KMySQLAdmin, without problems.
Cal
__
Do You Yahoo!?
Yahoo! Auctions - Buy the things
I have 2 tables with a common field of Title.
Table 1 defined as:
Name;varchar(60)
Title;varchar(60)
Year;varchar(4)
Other;varchar(30)
Other2;varchar(30)
act_no;int(8) unsigned zerofill
Table 2 defined as:
MM;varchar(4)
Title;varchar(48)
Archive;varchar(4)
record_num;int(8) unsigned zerofill
Your two Title fields are not the same size.
This could prevent a match.
It will slow down joins in 3.22.
Carl Schrader wrote:
I have 2 tables with a common field of Title.
Table 1 defined as:
Name;varchar(60)
Title;varchar(60)
Year;varchar(4)
Other;varchar(30)
Other2;varchar(30)
Can someone tell me how to insert an selct back a directory into mysql using sql? I'm
trying to insert and reselect
c:\My Documents into a varchar field and I keep having a problem with the special
character \
Jeff
To whom it may concern:
When running, the /scripts/mysql_install_db, it starts off with preparing
the tables, and then it says it is Installing the tables. That is all it
does, it says the process is running and everything. Does it take a real
long time for it to install the tables? If so how
Somehow, our MySQL server just started giving the error:
Error writing file './mydb/mytable.frm' (Errcode: 28)
whenever I try to create a table using the following:
CREATE TABLE boundary ( id INTEGER UNSIGNED NOT NULL PRIMARY KEY
AUTO_INCREMENT);
Precisely where can I find the
use \\ combination
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 15, 2001 11:55 PM
Subject: Special Character \
Can someone tell me how to insert an selct back a directory into mysql using
sql? I'm trying to insert and reselect
c:\My
"Olivier, Dave" wrote:
To whom it may concern:
When running, the /scripts/mysql_install_db, it starts off with preparing
the tables, and then it says it is Installing the tables. That is all it
does, it says the process is running and everything. Does it take a real
long time for it
Ken Whitmore wrote:
Somehow, our MySQL server just started giving the error:
Error writing file './mydb/mytable.frm' (Errcode: 28)
whenever I try to create a table using the following:
CREATE TABLE boundary ( id INTEGER UNSIGNED NOT NULL PRIMARY KEY
AUTO_INCREMENT);
Precisely
Dear Software Manufacturer:
We can help you make it much easier to promote your software on the Internet.
Your company is invited to list its software products at no charge on BigSoftE, the
first Internet Software Search Engine. Launching this month, Bigsofte provides
detailed product
The problem with the \\ is that it inserts it into the database as \\ and
when it's retrieved it's a \\
- Original Message -
From: "Michail A.Baikov" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, March 15, 2001 2:08 PM
Subject: Re: Special Character \
use
Hi there
I have a problem with one mysql table and i don't know how to
solve it .. the table has some important stuff.
when i make a select this is what happens
mysql select * from imp_addr;
ERROR 1030: Got error 127 from table handler
mysql
and isamchk
isamchk
On Thu, Mar 15, 2001 at 08:50:01AM -0800, Mike DeWolfe wrote:
I'm having a problem with REGEXP :
I have several rows that look like this :
Health : health services : safety : physical abuse : women
Health : health services : safety : rescue
Health : health services : safety : sexual
Hi ,
I posted a few considerations about fialover implementation , to the list ,
but i don't recived any feed back , well lets see what we have :
But i write a bunch of perl scripts and now I use them in production and
very happy with the result .
Here what I have :
Baiscly what I want is an sql
Hi,
Try some of the more aggressive fixing options on isamchk - see the manual
for details.
Quentin
-Original Message-
From: Nuno Ferreira [mailto:[EMAIL PROTECTED]]
Sent: Friday, 16 March 2001 10:39 a.m.
To: [EMAIL PROTECTED]
Subject: problems with mysql table
Hi there
Hi Bogomolnyi,
I am really interested in your scripts. I don't have a use for them at this
time, but I am planning to use a fallback system myself in the next few
month.
5 pc , and I use it for a web cluster (10 pc) so I use 1 slave
for 2 httpds
Do you have a similar scheme for the web
# isamchk -a -d -e -f -i -l -o imp_addr.ISM
ISAM file: imp_addr.ISM
Data records: 1223 Deleted blocks: 0
Recordlength:25
Record format: Packed
table description:
Key Start Len Index Type
User time 0.00, System time 0.00
Maximum resident set
I'm trying to install mysql on my redhat 6.2 machine, i've done the
groupadd, useradd, etc. when i ./configure --prefix=/usr/local/src/mysql
it runs thru everything and then stops- just a blinking cursor, that
leaves 3 processes running, when i try to run 'make' it says no targets
and no
According to the changelog, there's a bug in ORDER BY that was recently
introduced but fixed in 3.23.35. 3.23.34 fixed a bug in bidirectional
replication though, so I'm wondering what the specifics of the bugs
were, since I want to do bidirectional replication, but don't want a
serious ORDER BY
I implemented a mysql based user tracker. On every visit
of a user I log some data to the DB.
Experimenting with INSERTs I used DELAYED and benchmarked
the page. An DELAYED insert takes aprox. 9 times more to
execute than an insert.
I am using PHP. When I call the query function it takes 9
Hi,
I've compiled mysql 3.23.33 but while doing a 'make test'
the merge test fails (it passes all others). Any common
reason for this?
Thanks in advance.
Sander
-
Before posting, please check:
I'm experiencing a problem where mysqld is crashing every time I run a
particular query.
The specific error from the client is:
ERROR 1015: Can't lock file (errno: -30989)
ERROR 2013: Lost connection to MySQL server during query
The server error log is reporting:
bdb: transaction has
1 - 100 of 117 matches
Mail list logo