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 innodb.
--
Marcin Lewandowski
[ mailto:[EMAIL PROTECTED] gg:188068 jid
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 jid:[EMAIL
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:[EMAIL PROTECTED] gg:188068 jid:[EMAIL PROTECTED
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 PROTECTED] ]
[ http
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://lists.mysql.com
mysql5242880 Apr 12 23:14 /data/mysql/ib_logfile0
-rw-rw 1 mysql mysql5242880 Apr 12 18:48 /data/mysql/ib_logfile1
-rw-rw 1 mysql mysql 1000341504 Apr 12 23:14 /data/mysql/ibdata1
innodb_buffer_pool_size or do some tweaks to the OS so it caches the
disk a little more.
--
Marcin
, 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/pl/m/intro/index.html ]
--
MySQL General Mailing List
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
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
using coff2omf tool
5. My app wasn't compiling succesfully without NO_CLIENT_LONG_LONG defined
6. Add .lib to your project
7. #include winsock.h before #include mysql.h
8. In future, use google
--
Marcin Lewandowski
[ mailto:[EMAIL PROTECTED] gg:188068 jid:[EMAIL PROTECTED] ]
[ http
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/intro/index.html ]
--
MySQL
, 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
13 matches
Mail list logo