MySQL Packet Size

[R1Lover]

Where can I edit this. I can't seem to find the correct file to edit.

I need to change the

MySQL Packet Size
PHP Max Post Size

I have look forever...

Thanks for the help.

[Jeremy]

php -i|grep php.ini

So for me... its like

[root@gta3 ~]# php -i|grep php.ini
<tr><td class="e">Configuration File (php.ini) Path </td><td class="v">/usr/local/Zend/etc/php.ini </td></tr>
[root@gta3 ~]# grep -n post /usr/local/Zend/etc/php.ini
208:post_max_size = 55M ; Maximum size of POST data that PHP will accept.

Line 208 is the post_max_size

vi +208 /path/to/your/php.ini

restart apache

For the MySQL you need to modify my.cnf in /etc/my.cnf if it doesn't exist you will need to create one. I can suggest a default config if you need help.

[R1Lover]

yes, the my.cnf file doesn't exist... that would be great if you could recommend a setup.

Thank you for the help

[R1Lover]

I updated the php.ini -Thank you

If you can get me the config info that would be awesome. :)

[Jeremy]

This is a basic one.

Note this is for a system with dedicated 1GB to mysql so modify it to your needs.

[mysqld]
datadir=/var/lib/mysql
skip-locking
skip-innodb
skip-networking
safe-show-database
query_cache_limit=1M
query_cache_size=32M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=200
max_connections=500
interactive_timeout=10
wait_timeout=20
connect_timeout=20
thread_cache_size=128
key_buffer=128M ## 128MB for every 1GB of RAM
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=1M ## 1MB for every 1GB of RAM
read_buffer_size=1M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=1M ## 1MB for every 1GB of RAM
thread_concurrency=2 ## Number of CPUs x 2
myisam_sort_buffer_size=64M
server-id=1
collation-server=latin1_general_ci
old-passwords

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[mysqlhotcopy]
interactive-timeout

[R1Lover]

thank you

my vps specs are

xeon 2.8 x2
2048mb ram
80gb hd
Centos4
php4.4.4
mysql 1.3.37
perl 5.8.5

I will give this a try above.... and change according to the comments.

Thank you

[Jeremy]

nice vps...

sure its not a dedicated box? ;)

[R1Lover]

nice vps...

sure its not a dedicated box? ;)


Yep, it's a link 6 package at vpslink

So far I'm really happy with it.

;)

Is there an active plan on updating servercp to apache 2 ?

THX :)

[R1Lover]

oh ya, I used your specs above and so far it seems to be working great.

[Jeremy]

Good.

No idea about the apache 2, There might be a beta but i don't know.

I'm just a groupie ;)