could be reserved whole (type=hotel and whole_can=1) and
which could contain 100 person (person_min >= 100 and person_max >= 100)"
They could be more types of queries, but mostly which person_min/max and
type columns.
How I should create indexes to boost SELECT queries? My tables are i
rk only on copy of
database, is it possible to check if any other connection is not writing
to particular table? Would locking tables help? Or maybe I should do
something else then locking table when writing reservation?
Thanks,
--
Marcin Lewandowski
[ mailto:[EMAIL PROTECTED] gg:188068
work. phpmyadmin
show them as "in usage". I suppose, that could be caused by fact, that
when I'm shutting down windows, mysql is just killed, without proper
saving innodb logfiles. Or maybe there are other reason? How to
configure that?
--
Marcin Lewandowski
[ mailto:[EMA
Jocelyn Fournier napisał(a):
Hi,
What about using another forum ?
phpbb2 is well known to be far for what could be called "optimized" :)
I hate phpbb, but currently we can't change it :(
--
Marcin Lewandowski
[ mailto:[EMAIL PROTECTED] gg:188068 jid:[EMAIL PROTECT
uot;only" 2 to 3. But in my opinion, it's still to high,
and website is growing so in month or two there would be serious problem
if I don't fix that issue.
--
Marcin Lewandowski
[ mailto:[EMAIL PROTECTED] gg:188068 jid:[EMAIL PROTECTED] ]
[ http://www.nosoftwarepatents.com/
it caches the
disk a little more.
--
Marcin Lewandowski
[ mailto:[EMAIL PROTECTED] gg:188068 jid:[EMAIL PROTECTED] ]
[ http://www.nosoftwarepatents.com/pl/m/intro/index.html ]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I've tried many values in innodb_data_file_path = ibdata1:64M:autoextend
Thanks in advance
--
Marcin Lewandowski
[ mailto:[EMAIL PROTECTED] gg:188068 jid:[EMAIL PROTECTED] ]
[ http://www.nosoftwarepatents.com/pl/m/intro/index.html ]
--
MySQL General Mailing List
For list archives: http://
table1 etc. stands for names
of my tables in `name` database.
What I should do?
--
marcin lewandowski
gg# 188068
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I've got webserver with php and mysql-4.0.22
There I've got large phpbb2. Sometimes, server's system load rapidly
grows, and mysql are locked. Normally, there are 7-10 mysql processes,
at this strange situation, there are 30-40.
I don't know what can make such big system load in time of 1 mi
Hi,
I've got webserver with php and mysql-4.0.22
There I've got large phpbb2. Sometimes, server's system load rapidly
grows, and mysql are locked. Normally, there are 7-10 mysql processes,
at this strange situation, there are 30-40.
I don't know what can make such big system load in time of 1 mi
Convert libmysql.lib using coff2omf tool
5. My app wasn't compiling succesfully without NO_CLIENT_LONG_LONG defined
6. Add .lib to your project
7. #include before #include
8. In future, use google
--
Marcin Lewandowski
[ mailto:[EMAIL PROTECTED] gg:188068 jid:[EMAIL PROTECTED] ]
[ http://
account, could delete data of other users...
--
Marcin Lewandowski
[ mailto:[EMAIL PROTECTED] gg:188068 jid:[EMAIL PROTECTED] ]
[ http://www.nosoftwarepatents.com/pl/m/intro/index.html ]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
uld be good solution
but they don't have transactions and they have limitations.
What would be faster? MERGE tables or queries with 200-400 InnoDB tables
in FROM?
--
Marcin Lewandowski
[ mailto:[EMAIL PROTECTED] gg:188068 jid:[EMAIL PROTECTED] ]
[ http://www.nosoftwarepatents.com/pl/m
13 matches
Mail list logo
